Table: Payment Entity

Table: Payment Entity

Holds core information about a logged payment.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
display_idint(11)payment display id
payment_info_idint(11)Payment info id
payment_type_idint(11)Payment type id
payment_processor_idint(11)Payment processor id
payment_method_idint(11)Payment method id
payment_account_idint(11)Payment account id
tx_snapshot_idint(11)Transaction snapshot id
amountdecimal(11,2)payment amount
apply_datedateDate of application
earlytinyint(1)Whether or not payment is early1 - yes, 0 - no
payoff_flagtinyint(1)Whether or not is a payoff payment1 - yes, 0 - no
payoff_diff_applychar(40)Whether or not should payoff difference be applied
payoff_optionsvarchar(500)Payoff options
custom_applicationvarchar(500)custom application
infovarchar(255)Extra information about an entity instance
extravarchar(100)Payment extra application
parentint(11)Parent payment id
childint(11)child paymen tid
charge_fee_typevarchar(20)Servicing fee typeloan.cardfees.type.*
charge_fee_amountdecimal(11,2)servicing fee amount
charge_fee_percentagedecimal(11,2)servicing fee percentage
echeck_auth_typevarchar(100)E-Check authorization typepayment.echeckauth.*
cash_drawer_idint(11)Cash drawer ID
cash_drawer_tx_idint(11)Cash drawer transactoin ID
statusvarchar(45)Status code of the entity
reverse_reasonvarchar(45)Payment reverse reason
reverse_datedatePayment reverse date
commentsvarchar(250)payment comments
source_companyint(11)associated source company id
loan_statusint(11)associated loan status id
loan_substatusint(11)associated loan sub status id
before_principal_balancedecimal(11,2)Principal balance before payment
before_payoffdecimal(11,2)payoff before payment
before_next_due_datedatenext due date before payment
before_next_due_amountdecimal(11,2)next due amount before payment
before_amount_past_duedecimal(11,2)Amount past due on the loan before the payment was applied
before_days_past_dueint(11)dpd before payment
after_principal_balancedecimal(11,2)principal balance after payment
after_payoffdecimal(11,2)payoff after payment
after_next_due_datedatenext due date after payment
after_next_due_amountdecimal(11,2)next due amount after payment
after_amount_past_duedecimal(11,2)apd after payment
after_days_past_dueint(11)dpd after payment
system_commentstextsystem comments
charge_off_recoverytinyint(1)charge off recovery1 - yes, 0 - no
reset_past_duetinyint(1)Whether or not to reset days past due1 - yes, 0 - no
apd_adjustment_idint(11)associated apd adjustment id
dpd_adjustment_idint(11)associated dpd adjustment id
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated
mod_idint(11)The id of the associated loan modification
entity_idint(11)ID of the associated entity
entity_typevarchar(100)Type of the associated entity
payment_method_optionvarchar(45)Payment method option
payment_method_namevarchar(255)payment method name
is_splittinyint(1)Whether or not is payment split1 - yes, 0 - no
split_idint(11)Split payment ID
nacha_return_codevarchar(255)NACHA Return Code
autopay_idint(11)Associated autopay ID
last_extravarchar(100)Encoded information about the last extra amount

< Back to List