| 1 |
ARRANGEMENT_CODE |
CHARACTER VARYING(50) |
50 |
| 2 |
SUBMISSION_ID |
CHARACTER VARYING(50) |
50 |
| 3 |
FACILITY_ID |
CHARACTER VARYING(40) |
40 |
| 4 |
CHANNEL |
CHARACTER VARYING(14) |
14 |
| 5 |
REGION |
CHARACTER VARYING(240) |
240 |
| 6 |
ADD_LOAN_FLAG |
CHARACTER VARYING(1) |
1 |
| 7 |
PURPOSE_DESCRIPTION |
CHARACTER VARYING(400) |
400 |
| 8 |
PRODUCT_CODE |
CHARACTER VARYING(30) |
30 |
| 9 |
PRODUCT_DESCRIPTION |
CHARACTER VARYING(120) |
120 |
| 10 |
OFFER_ID |
CHARACTER VARYING(40) |
40 |
| 11 |
OFFER_DESCRIPTION |
CHARACTER VARYING(120) |
120 |
| 12 |
FACILITY_REPORTING_AMOUNT |
DOUBLE PRECISION |
8 |
| 13 |
TOTAL_CUSTOMER_EXPOSURE_AMOUNT |
CHARACTER VARYING(1) |
1 |
| 14 |
LVR |
DOUBLE PRECISION |
8 |
| 15 |
ARRANGEMENT_CREATION_DATE |
TIMESTAMP |
8 |
| 16 |
ARRANGEMENT_CONDITIONAL_APPROVAL_DATE |
TIMESTAMP |
8 |
| 17 |
ARRANGEMENT_UNCONDITIONAL_APPROVAL_DATE |
TIMESTAMP |
8 |
| 18 |
FACILITY_SETTLEMENT_DATE |
TIMESTAMP |
8 |
| 19 |
ACCOUNT_ID |
CHARACTER VARYING(40) |
40 |
| 20 |
LATEST_EVENT_TYPE |
CHARACTER VARYING(50) |
50 |
| 21 |
LATEST_EVENT_DATE_OCCURRED |
TIMESTAMP |
8 |