Table: Loan AutoPay entity

Table: Loan AutoPay entity

Holds autopay information for loans.

Column Data Type Column Info Value Notes Other
idint(10)The id of the entity
loan_idint(10)The id of the associated loan account
namevarchar(255)Entity name
typechar(100)Identifier for the entity typeautopay.type.*
statuschar(100)Status code of the entity
apply_datedateDate of application
process_datetimedatetimeprocess date time
original_process_datetimedatetimeoriginal process date time
original_apply_datedateoriginal application date
amount_typechar(100)autopay amount typeautopay.amountType.*
amountdecimal(10,2)Autopay amount
payment_type_idint(11)payment type id
process_currenttinyint(4)Whether or not to process if current1 - yes, 0 - no
charge_service_feetinyint(4)Whether or not to charge a service fee1 - yes, 0 - no
retry_daystinyint(4)days to retry1 - yes, 0 - no
retry_countint(11)number of retries
post_payment_update_apply_datetinyint(4)change apply date after successful process1 - yes, 0 - no
recurring_frequencychar(100)Recurring frequency typeautopay.recurringFrequency.*
recurring_periodsint(11)recurring periods
recurring_date_optionchar(64)recurring date optionautopay.recurringDate.*
scheduling_typechar(64)scheduling typeautopay.schedulingType.*
last_dom_enabledtinyint(4)process on the last day of month1 - yes, 0 - no
days_in_periodchar(100)Days in a period
payment_extra_towardschar(100)extra payment amount application methodpayment.extra.*
payment_feedecimal(6,2)payment fee
primary_payment_method_idint(11)primary payment method id
secondary_payment_method_idint(11)secondary payment method id
additional_payment_method_idint(11)additional payment method id
payment_method_auth_typechar(100)payment method authorization type
payoff_adjustmenttinyint(1)Whether or not should adjust for payoff amount1 - yes, 0 - no
process_zero_or_negative_balancetinyint(1)Whether or not to process if balance is less than or equal to zero1 - yes, 0 - no
charge_off_recoverytinyint(1)charge off recovery1 - yes, 0 - no
mc_processorvarchar(255)PCI Wallet processor id
cc_processorint(11)ID of associated credit card processor
ba_processorint(11)ID of associated bank account processor
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
last_updateddatetimeTimestamp of when the entity was last updated
activetinyint(4)Whether or not the entity is active1 - yes, 0 - no
queuedtinyint(1)Whether or not the entity is queued1 - yes, 0 - no

< Back to List