<COLLATERAL> - Sub Element of <NLS>, <CIF>, or <LOAN>
| Attribute | Type | Size | REQ | Default | Comments |
|---|---|---|---|---|---|
UpdateFlag
|
Numeric | No | 0 | 0 = Insert1 = Update (specify CollateralID, CollateralCode, or VIN to find the record)2 = Delete (specify CollateralID)5.34+ |
|
CollateralCodeNo
CollateralCode
|
Numeric String |
9 ≤15 |
Yes | Must contain a valid collateral code as defined in the Collateral codes setup. CollateralCodeNo may be obtained by mousing over the Code column in Setup > Loan Setup > Collateral. |
|
CollateralID
|
Numeric | 9 | No | Also referenced as Collateral Ref#. | |
VIN
|
String | 17 | No | Only applicable if UpdateFlag = 1. |
|
DatePriced
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
AcquisitionDate5.37+
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
NumberOfUnits
|
Numeric | 9 | No | 0 | |
PricePerUnit
|
Numeric | 16,2 | No | 0.00 | |
PercentageValue
|
Numeric | 16,5 | No | 0 | |
NetValue
|
Numeric | 16,2 | No | 0.00 |
NetValue is not specified it will be calculated as:NumberOfUnits * PricePerUnit * PercentageValue / 100 |
Notes
|
String | < 2B | No | ||
CollateralDetail1 to CollateralDetail305.12- |
String | ≤ 25 | No | User-defined fields. | |
CollateralDetail1 to CollateralDetail305.13+ |
String | ≤ 100 | No | User-defined fields. | |
LocationCIFNO
LocationCIFNumber
|
Numeric String |
9 ≤25 |
No | ||
LocationContactName
|
String | ≤40 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationCompanyName
|
String | ≤40 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationStreetAddress1
|
String | ≤40 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationStreetAddress2
|
String | ≤40 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationCity
|
String | ≤25 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationState
|
String | ≤3 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationZip
|
String | ≤10 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationCounty5.27+
|
String | ≤30 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationCountry5.27+
|
String | ≤30 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationPhone1
|
String | ≤20 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationPhone2
|
String | ≤20 | No | Applicable only if LocationCIFNO/LocationCIFNumber is not set. |
|
LocationUDF1 to LocationUDF135.27- |
String | ≤25 | No | ||
LocationUDF1 to LocationUDF135.28+ |
String | ≤100 | No | ||
StoreRecordID
|
String | No | The value should be unique. The row id of this collateral can be dereferenced by using GetRecordID at RELATIONSHIPSCODES. |
