FCT_BNK_DRS_DAILY_MASTER_CS

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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