FCT_BNK_QRM_DAILY_MASTER_TD

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACTION_CODE CHARACTER VARYING(1) 1
2 KEY_COID CHARACTER VARYING(10) 10
3 KEY_PROD CHARACTER VARYING(30) 30
4 KEY_ACCT CHARACTER VARYING(40) 40
5 DEPOSIT_NUMBER DOUBLE PRECISION 8
6 ACCT_STATUS CHARACTER VARYING(40) 40
7 BRANCH_NO CHARACTER VARYING(10) 10
8 COST_CENTER CHARACTER VARYING(150) 150
9 DT_CLOSED CHARACTER VARYING(200) 200
10 DT_OPENED CHARACTER VARYING(200) 200
11 TERM INTEGER 4
12 TERM_CODE CHARACTER VARYING(1) 1
13 CURRENT_MATURITY_DATE CHARACTER VARYING(200) 200
14 FINAL_MATURITY_DATE CHARACTER VARYING(200) 200
15 OFFICER CHARACTER VARYING(254) 254
16 ORIGINAL_BRANCH CHARACTER VARYING(10) 10
17 SALE_OFF_CD CHARACTER VARYING(254) 254
18 SECONDARY_OFFICER CHARACTER VARYING(1) 1
19 SHORT_NAME CHARACTER VARYING(500) 500
20 SIC_OCCUPATION_CD CHARACTER VARYING(5) 5
21 SUB_PRDCT_CD CHARACTER VARYING(30) 30
22 OF_PRODUCT_CODE CHARACTER VARYING(150) 150
23 CURR_BAL DOUBLE PRECISION 8
24 UNCOLLECTED_BALANCE DOUBLE PRECISION 8
25 DATE_OD CHARACTER VARYING(10) 10
26 INTEREST_RATE_ANNUAL DOUBLE PRECISION 8
27 AVG_BAL_MTD DOUBLE PRECISION 8
28 AGG_PLUS_BAL_MTD DOUBLE PRECISION 8
29 AGG_PLUS_DAYS_MTD BIGINT 8
30 AGG_OD_DAYS_MTD INTEGER 4
31 INT_PAY_CYCLE_CD CHARACTER VARYING(40) 40
32 INT_PAY_METHOD CHARACTER VARYING(6) 6
33 INT_XFER_ACCT CHARACTER VARYING(73) 73
34 XFER_BSB CHARACTER VARYING(32) 32
35 PRINC_XFER_ACCT CHARACTER VARYING(40) 40
36 REN_CDE CHARACTER VARYING(1) 1
37 REN_TERM INTEGER 4
38 REN_ADD_AMT DOUBLE PRECISION 8
39 REN_ADD_ACCT CHARACTER VARYING(40) 40
40 REN_PART_PAY_AMT INTEGER 4
41 BREAK_DATE CHARACTER VARYING(200) 200
42 CURRENT_ISSUE_DATE CHARACTER VARYING(200) 200
43 INT_CD CHARACTER VARYING(128) 128
44 FILE_DATE CHARACTER VARYING(200) 200