Database – Defaults AutoPay (defaults_autopay)

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