Database – Defaults AutoPay (defaults_autopay)
Description
This table holds records of tenant-wide default options for new AutoPays.
Table Fields
Field | Data Type | Column Info | Value Notes |
id | char(100) | The id of the entity | payment.methods.debit, payment.methods.echeck, payment.methods.eft |
autopay_type | char(100) | Autopay type code | autopay.type.multiple, autopay.type.single, autopay.type.recurring, autopay.type.recurringMatch |
autopay_time | tinyint(4) | Autopay processing time in hours | 0 - 23 |
application_date_diff | tinyint(4) | Number of days between processing and applying to loan | 1 - yes, 0 - no |
application_date_diff_in_bank_days | tinyint(1) | Number of banking days between processing and applying to loan | 1 - yes, 0 - no |
post_payment_update_apply_date | tinyint(3) | change apply date after successful process | |
process_current | tinyint(3) | Whether or not to process if current | 1 - yes, 0 - no |
retry_days | tinyint(3) | days to retry | |
schedule_next_if_fail | tinyint(1) | If one payment fails, the next will still be scheduled. | |
charge_service_fee | tinyint(3) | Whether or not to charge a service fee | 1 - yes, 0 - no |
payment_type_id | int(11) | payment type id | |
payment_method_auth_type | char(64) | payment method authorization type | payment.echeckauth.WEB, payment.echeckauth.PPD, payment.echeckauth.CCD, payment.echeckauth.TEL |
pay_extra_towards_tx | char(64) | Pay extra towards transaction code | payment.extra.tx.* |
pay_extra_towards_periods | char(64) | Pay extra towards periods code | payment.extra.periods.* |
payoff_adjustment | tinyint(4) | Whether or not should adjust for payoff amount | 1 - yes, 0 - no |
process_zero_or_negative_balance | tinyint(1) | Whether or not to process if balance is less than or equal to zero | 1 - yes, 0 - no |
recurring_date_option | char(64) | recurring date option | autopay.recurringDate.* |
scheduling_type | char(64) | scheduling type | autopay.schedulingType.* |
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no |
lastUpdated | timestamp | Timestamp of when the entity was last updated |