| 1 |
RUN_TIMESTAMP |
CHARACTER VARYING(200) |
200 |
| 2 |
SOURCE_SYSTEM_CODE |
CHARACTER VARYING(5) |
5 |
| 3 |
EXTRACT_NAME |
CHARACTER VARYING(100) |
100 |
| 4 |
SOURCE_SYSTEM_CUSTOMER_ID |
CHARACTER VARYING(50) |
50 |
| 5 |
SOURCE_SYSTEM_ACCOUNT_NUMBER |
CHARACTER VARYING(50) |
50 |
| 6 |
SOURCE_SYSTEM_PRODUCT_CODE |
CHARACTER VARYING(10) |
10 |
| 7 |
CUSTOMER_NAME |
CHARACTER VARYING(200) |
200 |
| 8 |
SOURCE_TXN_REF_ID |
CHARACTER VARYING(26) |
26 |
| 9 |
TXN_TYPE_CODE |
CHARACTER VARYING(28) |
28 |
| 10 |
AMOUNT |
NUMERIC(18,2) |
19 |
| 11 |
CR_DR_CODE |
CHARACTER VARYING(3) |
3 |
| 12 |
REMARKS |
CHARACTER VARYING(200) |
200 |