Database – Defaults Autopay (defaults_autopay)
This holds tenant-wide default options for new autopays.
Column | Data Type | Column Info | Value Notes | Other |
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 hourse | 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 |