FCT_BNK_DRS_DAILY_MASTER_TD_INSIGHT
Description
OBP extract with select Term Deposit details consumed by DRS system
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | COMPANYID | INTEGER | 4 |
| 2 | ACTION_CODE | CHARACTER VARYING(1) | 1 |
| 3 | PRODUCT_CODE | CHARACTER VARYING(30) | 30 |
| 4 | ACCOUNT_NO | CHARACTER VARYING(40) | 40 |
| 5 | DEPOSIT_NO | DOUBLE PRECISION | 8 |
| 6 | ACCTSTATUS | CHARACTER VARYING(40) | 40 |
| 7 | BRANCHNO | CHARACTER VARYING(10) | 10 |
| 8 | COSTCENTER | CHARACTER VARYING(150) | 150 |
| 9 | DTCLOSED | CHARACTER VARYING(200) | 200 |
| 10 | DTOPENED | CHARACTER VARYING(200) | 200 |
| 11 | TERM | INTEGER | 4 |
| 12 | TERM_CODE | CHARACTER VARYING(1) | 1 |
| 13 | CURRENTMATURITYDATE | CHARACTER VARYING(200) | 200 |
| 14 | FINALMATURITYDATE | CHARACTER VARYING(200) | 200 |
| 15 | OFFICER | CHARACTER VARYING(254) | 254 |
| 16 | ORIGINALBRANCH | CHARACTER VARYING(10) | 10 |
| 17 | SALEOFFCD | CHARACTER VARYING(254) | 254 |
| 18 | SECONDARY_OFFICER | CHARACTER VARYING(1) | 1 |
| 19 | SHORTNAME | CHARACTER VARYING(300) | 300 |
| 20 | SICOCCUPATIONCD | CHARACTER VARYING(5) | 5 |
| 21 | SUBPRDCTCD | CHARACTER VARYING(30) | 30 |
| 22 | CURRBALSTATUS | DOUBLE PRECISION | 8 |
| 23 | DATEOD | CHARACTER VARYING(10) | 10 |
| 24 | INTERESTRATEANNUAL | DOUBLE PRECISION | 8 |
| 25 | ARREARSDAYS | INTEGER | 4 |
| 26 | OVERDRAWNAMT | INTEGER | 4 |
| 27 | FILE_DATE | CHARACTER VARYING(200) | 200 |
| 28 | UNCOLLECTED_BALANCE | DOUBLE PRECISION | 8 |