<LOANBALANCERECORD> - Sub Element of <LOAN>
This record is required when loan is a conversion.
| Attribute | Type | Size | REQ | Default | Comments |
|---|---|---|---|---|---|
CurrentPrincipalAmount
|
Numeric | 16,2 | No | ||
CurrentInterestAmount
|
Numeric | 16,2 | No | ||
CurrentLateCharges
|
Numeric | 16,2 | No | ||
CurrentAverageDailyBalance
|
Numeric | 16,2 | No | ||
TotalPrincipalAdvanced
|
Numeric | 16,2 | No | ||
YTDPrincipalAdvanced
|
Numeric | 16,2 | No | ||
TotalPrincipalPaid
|
Numeric | 16,2 | No | ||
YTDPrincipalPaid
|
Numeric | 16,2 | No | ||
TotalInterestPaid
|
Numeric | 16,2 | No | ||
YTDInterestPaid
|
Numeric | 16,2 | No | ||
TotalLateChargesPaid
|
Numeric | 16,2 | No | ||
YTDLateChargesPaid
|
Numeric | 16,2 | No | ||
LastPaymentAmount
|
Numeric | 16,2 | No | ||
LastPaymentDate
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
TotalPastDueInterest
|
Numeric | 16,2 | No | ||
TotalPastDuePrincipal
|
Numeric | 16,2 | No | ||
TotalPastDueLateCharges
|
Numeric | 16,2 | No | ||
TotalRuleOf78ActuarialInterestEarned
|
Numeric | 16,2 | No | ||
PastDue10DaysCounter
|
Numeric | 9 | No | 10 days past due life-to-date counter. | |
PastDue30DaysCounter
|
Numeric | 9 | No | 30 days past due life-to-date counter. | |
PastDue60DaysCounter
|
Numeric | 9 | No | 60 days past due life-to-date counter. | |
PastDue90DaysCounter
|
Numeric | 9 | No | 90 days past due life-to-date counter. | |
PastDue120DaysCounter
|
Numeric | 9 | No | 120 days past due life-to-date counter. | |
PastDue10DaysYTDCounter5.18+
|
Numeric | 9 | No | 10 days past due year-to-date counter. | |
PastDue30DaysYTDCounter5.18+
|
Numeric | 9 | No | 30 days past due year-to-date counter. | |
PastDue60DaysYTDCounter5.18+
|
Numeric | 9 | No | 60 days past due year-to-date counter. | |
PastDue90DaysYTDCounter5.18+
|
Numeric | 9 | No | 90 days past due year-to-date counter. | |
PastDue120DaysYTDCounter5.18+
|
Numeric | 9 | No | 120 days past due year-to-date counter. | |
PrincipalPaymentsPaidCount
|
Numeric | 9 | No | 0 | |
InterestPaymentsPaidCount
|
Numeric | 9 | No | 0 | |
TotalPaymentsPaidCount
|
Numeric | 9 | No | 0 | |
AmortizationSchedulePerDiemPrincipalAmountOverride
|
Numeric | 16,2 | No | If this value is greater than zero it will override the amortization schedule’s principal per diem figure. | |
AmortizationSchedulePerDiemPrincipalCounter
|
Numeric | 9 | No | If this value is greater than zero it will override the amortization schedule’s principal per diem counter. | |
AmortizationSchedulePerDiemThroughDateOverride
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. If this value is set, the amortization schedule’s principal per diem through date will be overridden. |
||
AmortizationSchedulePaymentPrincipalAmountOverride
|
Numeric | 16,2 | No | If this value is greater than zero it will override the amortization schedule’s principal payment figure. | |
AmortizationSchedulePaymentCounterOverride
|
Numeric | 9 | No | If this value is greater than zero it will override the amortization schedule’s principal payment counter. | |
AmortizationSchedulePaymentThroughDateOverride
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. If this value is set, the amortization schedules principal payment through date will be overridden. |
||
PreComputeInterestOverride5.4+
|
Numeric | No | Only applicable to rule of 78 loans and fixed amortization loans where the pre-compute option is set. When set, the pre-compute interest (transaction code 110) will be derived from this value. |
||
Suspense
|
Numeric | 16,2 | No | ||
FaceValueOverride5.18+
|
Numeric | 16,2 | No | Face value for GILA. | |
AccruedInterestBeforeNonAccrual5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL NON ACCRUAL" /> |
|
AccruedInterestAfterNonAccrual5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL NON ACCRUAL" /> |
|
TotalInterestPaidBeforeNonAccrual5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL NON ACCRUAL" /> |
|
TotalInterestPaidAfterNonAccrual5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL NON ACCRUAL" /> |
|
LateChargesAddedBeforeNonAccrual5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL NON ACCRUAL" /> |
|
LateChargesAddedAfterNonAccrual5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL NON ACCRUAL" /> |
|
TotalLateChargesPaidBeforeNonAccrual5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL NON ACCRUAL" /> |
|
TotalLateChargesPaidAfterNonAccrual5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL NON ACCRUAL" /> |
|
AccruedInterestBeforeChargeOff5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL CHARGE OFF" /> |
|
AccruedInterestAfterChargeOff5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL CHARGE OFF" /> |
|
TotalInterestPaidBeforeChargeOff5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL CHARGE OFF" /> |
|
TotalInterestPaidAfterChargeOff5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL CHARGE OFF" /> |
|
LateChargesAddedBeforeChargeOff5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL CHARGE OFF" /> |
|
LateChargesAddedAfterChargeOff5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL CHARGE OFF" /> |
|
TotalLateChargesPaidBeforeChargeOff5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL CHARGE OFF" /> |
|
TotalLateChargesPaidAfterChargeOff5.24+
|
Numeric | 16,2 | No* | *Required when adding a loan with <LOANSTATUSES LoanStatusCode="GL CHARGE OFF" /> |
