Database – Payment Reversed Transaction Snapshot (payment_reversed_tx_snapshot)
Holds transaction snapshot information for reversed payments.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
mod_id | int(11) | The id of the associated loan modification | ||
payment_id | bigint(21) | Associated payment id | ||
date | datetime | transaction date | ||
period | int(11) | transaction period | ||
period_start | date | Transaction period start | ||
period_end | date | Transaction period end | ||
title | varchar(255) | The name/title of the entity instance | ||
payment_amount | decimal(10,2) | payment amount | ||
payment_i | decimal(10,2) | payment interest amount | ||
payment_p | decimal(10,2) | payment principal amount | ||
payment_d | decimal(10,2) | payment discount amount | ||
payment_f | decimal(10,2) | Fees Paid | ||
payment_e | decimal(10,2) | payment escrow amount | ||
payment_e_breakdown | varchar(2000) | payment escrow breakdown | ||
fees_paid_details | varchar(2000) | payment fees paid detalis | ||
future | tinyint(4) | whether or not the payment applies ot the future | 1 - yes, 0 - no | |
principalonly | tinyint(4) | whether or not the payment is principal only | 1 - yes, 0 - no | |
charge_off | tinyint(4) | whether or not the payment is a charge off | 1 - yes, 0 - no | |
payment_type | int(11) | Payment type ID | ||
adb_days | int(11) | Average Daily Balance Days | ||
adb | decimal(10,2) | Average Daily Balance | ||
principal_balance | decimal(10,2) | principal balance | ||
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |