AMORTIZATION_SCHEDULE_ITEM |
EntityType | Dependent |
Logical Entity Name | AMORTIZATION_SCHEDULE_ITEM |
Default Table Name | DEAL/SERVICES/SERVICE/CREDIT/CREDIT_RESPONSE/LOANS/LOAN/AMORTIZATION/AMORTIZATION_SCHEDULE_ITEMS/AMORTIZATION_SCHEDULE_ITEM |
Definition | |
Note |
AMORTIZATION_SCHEDULE_ITEM Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
AmortizationScheduleEndingBalanceAmount | MISMOAmount | DECIMAL(0, 2) | NO | The remaining balance due on the loan as calculated after application of the payment amount reflected on the Amortization Schedule for the loan. |
SequenceNumber | XSD:Integer | INTEGER | YES | An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. |
AmortizationScheduleInterestPortionAmount | MISMOAmount | DECIMAL(0, 2) | NO | The dollar amount of the portion of the total payment amount which is applied to the interest due on the loan as reflected on the Amortization Schedule for the loan. |
AmortizationScheduleInterestRatePercent | MISMOPercent | DECIMAL(0, 2) | NO | The interest rate percent of the loan used to calculate the principal and interest or dollar amount of the payment reflected on the Amortization Schedule for the loan. |
AmortizationScheduleLoanToValuePercent | MISMOPercent | DECIMAL(0, 2) | NO | The loan to value percent resulting from the application of the payment reflected on the Amortization Schedule for the loan. |
AmortizationScheduleMIPaymentAmount | MISMOAmount | DECIMAL(0, 2) | NO | The dollar amount of the MI payment due in addition to the payment amount reflected on the Amortization Schedule for the loan. |
AmortizationSchedulePaymentAmount | MISMOAmount | DECIMAL(0, 2) | NO | The dollar amount of a single payment reflected on the Amortization Schedule for the loan. |
AmortizationSchedulePaymentDueDate | MISMODate | DATE | NO | The due date of a single payment reflected on the Amortization Schedule for the loan. |
AmortizationSchedulePaymentNumber | MISMONumeric | DECIMAL(0, 2) | NO | The number used to identify a single payment within a sequence of payments reflected on the Amortization Schedule for the loan. |
AmortizationSchedulePrincipalPortionAmount | MISMOAmount | DECIMAL(0, 2) | NO | The dollar amount of the portion of the payment amount which is applied to the principal due on the loan as reflected on the Amortization Schedule for the loan. |
AMORTIZATION_SCHEDULE_ITEM Keys |
Key Name | Key Type | Keys |
AMORTIZATION_SCHEDULE_ITEM Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
AMORTIZATION_SCHEDULE_ITEMS | Identifying | One To Zero or More | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
AMORTIZATION_SCHEDULE_ITEM Check Constraints |
Check Constraint Name | CheckConstraint |
AMORTIZATION_SCHEDULE_ITEM Bound Attachments |
Name | Current Value |
AMORTIZATION_SCHEDULE_ITEM User-Defined Mappings |
Model | Name | Description |
AMORTIZATION_SCHEDULE_ITEM Data Movement Rules |
Name | Type | Rule Text/Value |