Table: Payment Reversed Transaction Snapshot

Table: Payment Reversed Transaction Snapshot

Holds transaction snapshot information for reversed payments.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
mod_idint(11)The id of the associated loan modification
payment_idbigint(21)Associated payment id
datedatetimetransaction date
periodint(11)transaction period
period_startdateTransaction period start
period_enddateTransaction period end
titlevarchar(255)The name/title of the entity instance
payment_amountdecimal(10,2)payment amount
payment_idecimal(10,2)payment interest amount
payment_pdecimal(10,2)payment principal amount
payment_ddecimal(10,2)payment discount amount
payment_fdecimal(10,2)Fees Paid
payment_edecimal(10,2)payment escrow amount
payment_e_breakdownvarchar(2000)payment escrow breakdown
fees_paid_detailsvarchar(2000)payment fees paid detalis
futuretinyint(4)whether or not the payment applies ot the future1 - yes, 0 - no
principalonlytinyint(4)whether or not the payment is principal only1 - yes, 0 - no
charge_offtinyint(4)whether or not the payment is a charge off1 - yes, 0 - no
payment_typeint(11)Payment type ID
adb_daysint(11)Average Daily Balance Days
adbdecimal(10,2)Average Daily Balance
principal_balancedecimal(10,2)principal balance
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List