FCT_BNK_DRS_DAILY_MASTER_CS_INSIGHT
Description
OBP extract with select CASA 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 | ACCTSTATUS | CHARACTER VARYING(20) | 20 |
| 6 | APPROVALOFFCD | CHARACTER VARYING(1) | 1 |
| 7 | BRANCHNO | CHARACTER VARYING(10) | 10 |
| 8 | BROKERCD | CHARACTER VARYING(1) | 1 |
| 9 | COSTCENTER | CHARACTER VARYING(150) | 150 |
| 10 | CURRBAL | DOUBLE PRECISION | 8 |
| 11 | DATEINEXCESS | CHARACTER VARYING(200) | 200 |
| 12 | DBAMTINTACCCTD | DOUBLE PRECISION | 8 |
| 13 | DTCLOSED | CHARACTER VARYING(200) | 200 |
| 14 | DTOPENED | CHARACTER VARYING(200) | 200 |
| 15 | INTERESTRATEDEBIT | CHARACTER VARYING(1) | 1 |
| 16 | LASTCUSTDEPDATE | CHARACTER VARYING(200) | 200 |
| 17 | ODAPPLBRANCH | CHARACTER VARYING(1) | 1 |
| 18 | ODDOCTYPE | CHARACTER VARYING(1) | 1 |
| 19 | ODLIMIT | CHARACTER VARYING(1) | 1 |
| 20 | ODREVIEWDATE | CHARACTER VARYING(1) | 1 |
| 21 | ODSTARTDATE | CHARACTER VARYING(1) | 1 |
| 22 | OFFICER | CHARACTER VARYING(40) | 40 |
| 23 | ORIGINALBRANCH | CHARACTER VARYING(10) | 10 |
| 24 | SALEOFFCD | CHARACTER VARYING(254) | 254 |
| 25 | SECONDARYOFFICIER | CHARACTER VARYING(1) | 1 |
| 26 | SHORTNAME | CHARACTER VARYING(500) | 500 |
| 27 | SICOCCUPATIONCD | CHARACTER VARYING(5) | 5 |
| 28 | SUBPRDCTCD | CHARACTER VARYING(40) | 40 |
| 29 | TEMPODEXPIRYDATE | CHARACTER VARYING(200) | 200 |
| 30 | TEMPODLIMIT | DOUBLE PRECISION | 8 |
| 31 | WRITEOFFCODE | CHARACTER VARYING(1) | 1 |
| 32 | WRITEOFFDATE | CHARACTER VARYING(1) | 1 |
| 33 | BALANCEBEFORECLOSING | DOUBLE PRECISION | 8 |
| 34 | ARREARSDAYS | INTEGER | 4 |
| 35 | EXCESSAMOUNT | INTEGER | 4 |
| 36 | CALCLIMIT | CHARACTER VARYING(1) | 1 |
| 37 | SECSTATUSCODE | CHARACTER VARYING(1) | 1 |
| 38 | SECPOOLID | CHARACTER VARYING(1) | 1 |
| 39 | SECSTARTDATE | CHARACTER VARYING(10) | 10 |
| 40 | REPURCHASEREASONCODE | CHARACTER VARYING(1) | 1 |
| 41 | REPURCHASEDATE | CHARACTER VARYING(10) | 10 |
| 42 | DAYSPASTDUE | CHARACTER VARYING(1) | 1 |
| 43 | PASTDUEAMT | CHARACTER VARYING(1) | 1 |
| 44 | INSEXPIRYDATE | CHARACTER VARYING(10) | 10 |
| 45 | INSTYPECODE | CHARACTER VARYING(1) | 1 |
| 46 | INSCOMPANYCODE | CHARACTER VARYING(1) | 1 |
| 47 | ODINSUREDIND | CHARACTER VARYING(1) | 1 |
| 48 | FILEDATE | CHARACTER VARYING(200) | 200 |