| # |
Name |
Data Type |
Length |
| 1 |
AS_OF_DATE |
TIMESTAMP |
8 |
| 2 |
GCIS_ID |
CHARACTER VARYING(30) |
30 |
| 3 |
CUST_NUM |
NUMERIC(19,0) |
19 |
| 4 |
ENTTYP_CODE |
CHARACTER VARYING(1) |
1 |
| 5 |
DP_TXN |
INTEGER |
4 |
| 6 |
CC_TXN |
INTEGER |
4 |
| 7 |
TXN_FREQ |
INTEGER |
4 |
| 8 |
GK_TXN |
NUMERIC(1,0) |
19 |
| 9 |
MFI |
NUMERIC(1,0) |
19 |
| 10 |
MFI_BUSINESS |
NUMERIC(1,0) |
19 |
| 11 |
BRND_CODE |
CHARACTER VARYING(3) |
3 |
| 12 |
ACTIVE |
NUMERIC(1,0) |
19 |
| 13 |
BUS_ACTIVE_MFI |
NUMERIC(1,0) |
19 |
| 14 |
TENURE |
NUMERIC(22,4) |
19 |
| 15 |
PRDT_SYS_CODE |
CHARACTER VARYING(3) |
3 |
| 16 |
BANK_IND |
NUMERIC(1,0) |
19 |
| 17 |
INT_BNK |
NUMERIC(1,0) |
19 |
| 18 |
SUPER_FOOTING |
NUMERIC(38,6) |
19 |
| 19 |
TXN_NEED |
NUMERIC(1,0) |
19 |
| 20 |
LEND_NEED |
NUMERIC(1,0) |
19 |
| 21 |
INV_NEED |
NUMERIC(1,0) |
19 |
| 22 |
INS_NEED |
NUMERIC(1,0) |
19 |
| 23 |
CONNECTED |
NUMERIC(1,0) |
19 |
| 24 |
TOTAL_PRODUCT_COUNT |
INTEGER |
4 |
| 25 |
TOTAL_PRODUCT_BAND |
CHARACTER VARYING(10) |
10 |