| # |
Name |
Data Type |
Length |
| 1 |
CUSTOMER_NUMBER |
CHARACTER VARYING(40) |
40 |
| 2 |
ACCOUNT_NUMBER |
CHARACTER VARYING(128) |
128 |
| 3 |
LOAN_TYPE |
CHARACTER VARYING(120) |
120 |
| 4 |
PRODUCT_CODE |
CHARACTER VARYING(65) |
65 |
| 5 |
PRODUCT_DESCRIPTION |
CHARACTER VARYING(358) |
358 |
| 6 |
ACCOUNT_OPEN_DATE |
CHARACTER VARYING(200) |
200 |
| 7 |
ACCOUNT_CLOSE_DATE |
CHARACTER VARYING(200) |
200 |
| 8 |
BROKER |
CHARACTER VARYING(20) |
20 |
| 9 |
ACCREDITED_BROKER |
CHARACTER VARYING(20) |
20 |
| 10 |
PROPERT_RIGHTS |
CHARACTER VARYING(14) |
14 |
| 11 |
LOAN_PURPOSE |
CHARACTER VARYING(200) |
200 |
| 12 |
FACILITY_ID |
CHARACTER VARYING(40) |
40 |
| 13 |
BALANCE |
DOUBLE PRECISION |
8 |
| 14 |
DISBURSED_AMT |
DOUBLE PRECISION |
8 |
| 15 |
APPROVED_AMOUNT |
DOUBLE PRECISION |
8 |
| 16 |
OF_ACCOUNT_CODE |
CHARACTER VARYING(240) |
240 |
| 17 |
OF_PRODUCT_CODE |
CHARACTER VARYING(240) |
240 |
| 18 |
OF_ENTITY_CODE |
CHARACTER VARYING(150) |
150 |
| 19 |
OF_COST_CENTRE_CODE |
CHARACTER VARYING(240) |
240 |
| 20 |
LEVEL_2_DESCRIPTION |
CHARACTER VARYING(100) |
100 |
| 21 |
LEVEL_3_DESCRIPTION |
CHARACTER VARYING(100) |
100 |
| 22 |
SOURCE |
CHARACTER VARYING(3) |
3 |