Difference between revisions of "Loan Types & Products"
>Jeremyb |
>Jeremyb |
||
Line 1: | Line 1: | ||
+ | == Summary == | ||
+ | |||
+ | |||
+ | == Columns == | ||
+ | |||
'''LN_COLLATERAL''' | '''LN_COLLATERAL''' | ||
The loan collateral code from the core | The loan collateral code from the core |
Revision as of 21:38, 31 August 2012
Summary
Columns
LN_COLLATERAL
The loan collateral code from the core
LN_ATTR_NBR
If an attribute has been created in the ATTRFILE based on a member having this loan, that attribute number should be placed in this column
LN_PROD_NBR
If an attribute is also a countable product such as a vehicle loan, the Product Number from the ATTRFILE should be placed in this column
DESCRIPTION
The description of the loan that is displayed in Vital Signs
LN_SECURED
A yes/no entry to signify if the Loan is Secured or Not Note: for future development
LN_TYPE
The Loan Type is the master hierarchical grouping of loans, example : Mortgage
LN_TYPE_SORT
The Loan Type Sort is the sequential order that the Unique Loan Type groups will be displayed in Vital Signs
LN_PRODUCT
The Loan Product Sub group of the Loan Type grouping, example : First Mortgage
LN_PRODUCT_SORT
The Loan Product Sort is the sequential order that the Unique Share Product groups will be displayed in Vital Signs