payment_reversed_tx_snapshot - Payment Reversed Transaction 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


How did we do?


Powered by HelpDocs (opens in a new tab)