| # |
Name |
Data Type |
Length |
| 1 |
MASTER_KEY |
CHARACTER VARYING(50) |
50 |
| 2 |
SUBMISSION_ID |
CHARACTER VARYING(20) |
20 |
| 3 |
APPLICATION_ID |
CHARACTER VARYING(20) |
20 |
| 4 |
NUM_OF_APPLICANTS |
NUMERIC(20,0) |
19 |
| 5 |
NUM_OF_FACILITIES |
NUMERIC(20,0) |
19 |
| 6 |
NUM_OF_COLLATERALS |
NUMERIC(20,0) |
19 |
| 7 |
VERSION_NO |
CHARACTER VARYING(5) |
5 |
| 8 |
USER_GROUP |
CHARACTER VARYING(30) |
30 |
| 9 |
FRONTEND_ID |
CHARACTER VARYING(10) |
10 |
| 10 |
CHANNEL_ID |
CHARACTER VARYING(20) |
20 |
| 11 |
COUNTRY_CODE |
CHARACTER VARYING(2) |
2 |
| 12 |
GROUP_MEMBER |
CHARACTER VARYING(4) |
4 |
| 13 |
OPERATION_UNIT |
CHARACTER VARYING(30) |
30 |
| 14 |
ORGANISATION_NAME |
CHARACTER VARYING(20) |
20 |
| 15 |
APPLICATION_DATE |
CHARACTER VARYING(30) |
30 |
| 16 |
APPLICATION_TYPE |
CHARACTER VARYING(4) |
4 |
| 17 |
SERVICING_AMT |
NUMERIC(20,2) |
19 |
| 18 |
SPARE_S1 |
CHARACTER VARYING(30) |
30 |
| 19 |
SPARE_S2 |
CHARACTER VARYING(30) |
30 |
| 20 |
SPARE_S3 |
CHARACTER VARYING(30) |
30 |
| 21 |
SPARE_S4 |
CHARACTER VARYING(30) |
30 |
| 22 |
SPARE_S5 |
CHARACTER VARYING(30) |
30 |
| 23 |
SPARE_S6 |
CHARACTER VARYING(30) |
30 |
| 24 |
SPARE_S7 |
CHARACTER VARYING(30) |
30 |
| 25 |
SPARE_S8 |
CHARACTER VARYING(30) |
30 |
| 26 |
SPARE_S9 |
CHARACTER VARYING(30) |
30 |
| 27 |
SPARE_S10 |
CHARACTER VARYING(30) |
30 |
| 28 |
SPARE_F1 |
NUMERIC(20,2) |
19 |
| 29 |
SPARE_F2 |
NUMERIC(20,2) |
19 |
| 30 |
SPARE_F3 |
NUMERIC(20,2) |
19 |
| 31 |
SPARE_F4 |
NUMERIC(20,2) |
19 |
| 32 |
SPARE_F5 |
NUMERIC(20,2) |
19 |
| 33 |
SPARE_F6 |
NUMERIC(20,2) |
19 |
| 34 |
SPARE_F7 |
NUMERIC(20,2) |
19 |
| 35 |
SPARE_F8 |
NUMERIC(20,2) |
19 |
| 36 |
SPARE_F9 |
NUMERIC(20,2) |
19 |
| 37 |
SPARE_F10 |
NUMERIC(20,2) |
19 |
| 38 |
TOTAL_AGG_LMT_ML_TERM |
NUMERIC(20,0) |
19 |
| 39 |
TOTAL_AGG_LMT_ML_OD |
NUMERIC(20,0) |
19 |
| 40 |
TOTAL_AGG_LMT_PL |
NUMERIC(20,0) |
19 |
| 41 |
TOTAL_AGG_LMT_CC |
NUMERIC(20,0) |
19 |
| 42 |
TOTAL_AGG_LMT_LEASE |
NUMERIC(20,0) |
19 |
| 43 |
COUNT_AGG_ML_TERM |
NUMERIC(20,0) |
19 |
| 44 |
COUNT_AGG_ML_OD |
NUMERIC(20,0) |
19 |
| 45 |
COUNT_AGG_PL |
NUMERIC(20,0) |
19 |
| 46 |
COUNT_AGG_CC |
NUMERIC(20,0) |
19 |
| 47 |
COUNT_AGG_LEASE |
NUMERIC(20,0) |
19 |