<AMORTIZEDFEES> - Sub Element of <LOAN>
| Attribute | Type | Size | REQ | Default | Comments |
|---|---|---|---|---|---|
Operation5.19 - 5.39
|
String | Valid values are ADD and CANCEL. |
|||
Operation5.39.1+
|
String | Valid values are ADD, UPDATE, and CANCEL. |
|||
Description
|
String | ≤50 | No | ||
AmortizedFeeTemplateNo
|
Numeric | 9 | No |
If set, the initial values of record will be copied from this template. To obtain this value, mouse over the Amortized Fee column in Setup > Loan Setup > Amortized Fees. |
|
AmortizedFeeID5.19+
|
Numeric | 10 | No | Required when Operation=CANCEL. |
|
Type
|
Numeric | 9 | Yes |
0 = Straight Line Periodic1 = Straight Line Custom
2 = Effective Interest Method5.26 - 5.422 = Effective Interest Method - On Payment5.43+3 = Effective Interest Method - Daily Accrual4 = Principal/Original Prorate Method5 = Rule of 786 = Average Rule of 78 Straight Line7 = Actuarial5.35+8 = Effective Interest Method - Scheduled5.43+ |
|
CancellationType
|
Numeric | 1 | No | 0 = None1 = Actuarial2 = Pro-Rata3 = Rule of 784 = Conditional Pro-Rata5.16+5 = Rule of Anticipation - A&H5.38+ |
|
CancellationTransCode
|
Numeric | 9 | No | ||
MinimumCancellation
|
Numeric | 16,2 | No | ||
CancelOnEarlyPayoff
|
Numeric | 1 | No | Valid values are: 0 or 1. | |
CancellationRebateRule
|
Numeric | 1 | No | Applicable only if CancellationType is 3.0 = Through end of period1 = Proportional2 = Nearest payment date3 = Through end of period from origination date5.28+if CancellationType = 1 and Type = 5 or 6 orif CancellationType = 2 and Type = 05.34+ |
|
CancellationRebateRuleCutoffDays
|
Numeric | 2 | Applicable only if CancellationType = 3 and CancellationRebateRule = 03 |
||
CancellationSetupExpireDate5.18+
|
Date | No | |||
CompleteRefundDate5.21+
|
Date | No | Complete refund expire date. | ||
CancellationMinAmortFee5.18+
|
Numeric | 16,2 | No | ||
NonRefundableAmount5.38+
|
Numeric | 5,2 | No | Applicable only when CancellationType = 2. |
|
CancellationEffectiveDate5.19+
|
Date | No | System Date | ||
CancellationUnpaidFeeHandling5.19+
|
String | No | RETAINPASTDUE | RETAINPASTDUE = Retain past due billing as isTRANSFERTONEXTBILLING = Transfer unpaid amortized fee to next billingSPREAD = Spread remaining unpaid amortized fee to the remaining life of this amortized fee. |
|
EffectiveDate
|
Date | No | System Date | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | |
GLDate
|
Date | No | System Date | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | |
UserReference
|
String | ≤100 | No | ||
StartDate
|
Date | Yes | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
StartDateDayValue
|
Numeric | 2 | No | ||
Balance
|
Numeric | 16,2 | Yes | ||
EstablishBalanceTransactionCode
|
Numeric | 9 | Yes | ||
Period
|
String | 2 | Yes | Valid if Type = 0DA = DaysWE = WeeklyBW = Bi-WeeklySM = Semi-MonthlyS4 = Semi-Monthly (14-day)28 = 28 DayMO = MonthlyBM = Bi-MonthlyQU = QuarterlySA = Semi-AnnuallyAN = Annual |
|
NumberOfPeriods
|
Numeric | 9 | Yes | Valid if Type = 0 |
|
AmortizationTransactionCode
|
Numeric | 9 | Yes | ||
PeriodicAmount
|
Numeric | 16,2 | Yes | Valid if Type = 0 or 1 |
|
AmortizationEffectiveDate
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. Valid if Type = 3 |
||
InterestOffset
|
Numeric | 16,2 | No | 0.00 | Valid if Type = 3 |
AllowNegativeEntries
|
Numeric | 1 | No | 0 | Valid if Type = 3 or 40 = False1 = True |
PrincipalOffset
|
Numeric | 16,2 | No | ||
IncreasePaymentAmountFlag5.12+
|
Numeric | 1 | 0 = False1 = True |
||
CancellationRebateFactorPercentage5.15+
|
Numeric | 5,2 | Applicable only if CancellationType = 2 (Pro-Rata) |
||
CancellationAmortizedFeeRateID5.38+
|
Numeric | 9 | Applicable only if CancellationType = 5 (Rule of Anticipation - A&H) |
||
CancellationComputation5.40+
|
Numeric | 1 | Applicable only when CancellationType = 4 (Conditional Pro-Rata).0 = Origination Date to Maturity Date1 = Custom |
||
DaysFromOriginationDate5.40+
|
Numeric | 10 | Applicable only when CancellationComputation = 1 (Custom).Must be > 0. |
||
TreatLongFirstPeriodAsStandardPeriodFlag5.20+
|
Numeric | 1 | No | 0 = False1 = TrueApplies only to Rule of 78 and Average Rule of 78 Straight Line. Defaults to and overrides the loan’s or loan template’s equivalent global setting. |
|
UseAdjustedMaturityTermInCalculation5.30+
|
Numeric | 1 | No | 0 | 0 = False1 = TrueApplies only to Rule of 78 and Average Rule of 78 Straight Line. |
AmortPremiumDiscountFlag5.26+
|
Numeric | 1 | No | 0 = Premium1 = Discount
Applicable only if Type = 2 (Effective Interest Method)
|
|
EffectiveInterestRate5.26+
|
Numeric | 9,5 | No |
Applicable only if
Type = 2 (Effective Interest Method)5.34-Applicable if
Type = 2 (Effective Interest Method) or 7 (Actuarial) 5.35+ |
|
UseLoanInformation5.26+
|
Numeric | 1 | No | 0 = False1 = TrueApplicable only if Type = 2 (Effective Interest Method) |
|
LoanPrincipalBalance5.26+
|
Numeric | 16,2 | No | Applicable only if Type = 2 (Effective Interest Method) and UseLoanInformation = 0 |
|
LoanPeriod5.26+
|
String | 2 | No | Valid values are:DA = DaysWE = WeeklyBW = Bi-WeeklySM = Semi-MonthlyS4 = Semi-Monthly (14-day)28 = 28 DayMO = MonthlyBM = Bi-MonthlyQU = QuarterlySA = Semi-AnnuallyAN = AnnualApplicable only if Type = 2 (Effective Interest Method) and UseLoanInformation = 0 |
|
LoanTerm5.26+
|
Numeric | 9 | No | Applicable only if Type = 2 (Effective Interest Method) and UseLoanInformation = 0 |
|
LoanTermChar5.26+
|
String | 1 | No | Valid values are:D = DaysM = MonthsP = PaymentApplicable only if Type = 2 (Effective Interest Method) and UseLoanInformation = 0 |
|
LoanPaymentAmount5.26+
|
Numeric | 16,2 | No | Applicable only if Type = 2 (Effective Interest Method) and UseLoanInformation = 0 |
|
LoanStartingDate5.26+
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. Applicable only if Type = 2 (Effective Interest Method) and UseLoanInformation = 0 |
||
UserDefined1 to UserDefined55.37.4+ |
String | No |
CancellationType=3or