FCT_BNK_DRS_ILP_DAILY_MASTER

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(1) 1
3 KEY_PROD CHARACTER VARYING(30) 30
4 KEY_ACCT CHARACTER VARYING(40) 40
5 ACCT_STATUS CHARACTER VARYING(50) 50
6 ANZSIC_CODE CHARACTER VARYING(4) 4
7 BILL_TYPE CHARACTER VARYING(128) 128
8 BILL_FREQUENCY CHARACTER VARYING(30) 30
9 BILL_PERIOD CHARACTER VARYING(30) 30
10 BILL_AMOUNT DOUBLE PRECISION 8
11 SUB_PRDCT_CD CHARACTER VARYING(30) 30
12 ORIG_BR CHARACTER VARYING(10) 10
13 SRVC_BR CHARACTER VARYING(240) 240
14 DT_OPENED CHARACTER VARYING(200) 200
15 DT_CLOSED CHARACTER VARYING(200) 200
16 SETTLEMENT_DATE CHARACTER VARYING(200) 200
17 DT_CURR_MAT CHARACTER VARYING(200) 200
18 DC_LOAN_TRM BIGINT 8
19 SECUR_STATUS CHARACTER VARYING(1) 1
20 SECUR_POOL CHARACTER VARYING(10) 10
21 SHORT_NAME CHARACTER VARYING(300) 300
22 COST_CENTER CHARACTER VARYING(240) 240
23 ACCRED_BRKR_CDE CHARACTER VARYING(20) 20
24 BROKER_CD CHARACTER VARYING(20) 20
25 PRIM_OFFICER CHARACTER VARYING(50) 50
26 SECONDARY_OFFICER CHARACTER VARYING(40) 40
27 APPROVAL_DATE TIMESTAMP 8
28 CURR_BAL DOUBLE PRECISION 8
29 CALC_AMT_DUE DOUBLE PRECISION 8
30 AVL_CASHBACK DOUBLE PRECISION 8
31 NBR_DAY_PDUE DOUBLE PRECISION 8
32 EFF_DT_LST_PYMT CHARACTER VARYING(200) 200
33 ANNUAL_RATE NUMERIC(8,5) 19
34 AMT_DEBIT_INT_ACCR_NOBL DOUBLE PRECISION 8
35 UNRND_PPMT_AMT DOUBLE PRECISION 8
36 CALC_AVAIL_BAL DOUBLE PRECISION 8
37 MORTGAGE_INS_INDICATOR CHARACTER VARYING(1) 1
38 INS_CMPY CHARACTER VARYING(50) 50
39 TOT_AMT_PDUE DOUBLE PRECISION 8
40 TOT_NBR_TM_PDUE BIGINT 8
41 LOAN_PUR CHARACTER VARYING(40) 40
42 LOAN_SUB_PUR CHARACTER VARYING(10) 10
43 LOW_DOC_FLAG CHARACTER VARYING(1) 1
44 OBP_F_V_FLAG CHARACTER VARYING(1) 1
45 OF_PRODUCT CHARACTER VARYING(240) 240