CFD_TCFDD_DEPOSIT_PH

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DPTS_PRDT_HOLDNG_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 PRDT_HOLDNG_ID BIGINT 8
5 CMPY_CODE CHARACTER VARYING(10) 10
6 PRDT_SYS_PRDT_CODE CHARACTER VARYING(20) 20
7 PRDT_SYS_ACCT_NUM CHARACTER VARYING(20) 20
8 PRDT_ID BIGINT 8
9 PRDT_GRP_CODE CHARACTER VARYING(20) 20
10 PRDT_TYP_CODE CHARACTER VARYING(20) 20
11 PRDT_BRND_ID BIGINT 8
12 PRDT_BRND_CODE CHARACTER VARYING(20) 20
13 CHNL_ID BIGINT 8
14 CHNL_TYP_CODE CHARACTER VARYING(20) 20
15 CHNL_CODE CHARACTER VARYING(10) 10
16 SERV_BRCH_ID BIGINT 8
17 SERV_BRCH_CODE CHARACTER VARYING(20) 20
18 ACCT_STAT_ID BIGINT 8
19 ACCT_STAT_CODE CHARACTER VARYING(20) 20
20 INT_CALC_METH_ID BIGINT 8
21 INT_CALC_METH_CODE CHARACTER VARYING(20) 20
22 INT_WAIVE_RSN_ID BIGINT 8
23 INT_WAIVE_RSN_CODE CHARACTER VARYING(20) 20
24 STMT_CYC_ID BIGINT 8
25 STMT_CYC_CODE CHARACTER VARYING(10) 10
26 PAYT_METH_ID BIGINT 8
27 PAYT_METH_CODE CHARACTER VARYING(10) 10
28 INT_PAY_CYC_ID BIGINT 8
29 INT_PAY_CYC_CODE CHARACTER VARYING(10) 10
30 CNTL_BRCH_ID BIGINT 8
31 CNTL_BRCH_CODE CHARACTER VARYING(20) 20
32 SCND_OFCR_ID BIGINT 8
33 SCND_OFCR_CODE CHARACTER VARYING(20) 20
34 ANZSIC_TYP_ID BIGINT 8
35 ANZSIC_TYP_CODE CHARACTER VARYING(20) 20
36 DPTS_OPENING_DATE TIMESTAMP 8
37 DPTS_OPENING_AMT NUMERIC(18,6) 19
38 DPTS_CLSD_DATE TIMESTAMP 8
39 CLOSING_RSN_ID BIGINT 8
40 CLOSING_RSN_CODE CHARACTER VARYING(10) 10
41 ORG_BRCH_ID BIGINT 8
42 ORG_BRCH_CODE CHARACTER VARYING(20) 20
43 COST_CENTRE_CODE CHARACTER VARYING(20) 20
44 BRKR_ID BIGINT 8
45 BRKR_CODE CHARACTER VARYING(10) 10
46 SALES_OFCR_ID BIGINT 8
47 SALES_OFCR_CODE CHARACTER VARYING(20) 20
48 APRVL_OFCR_ID BIGINT 8
49 APRVL_OFCR_CODE CHARACTER VARYING(10) 10
50 PACKAGE_CODE CHARACTER VARYING(20) 20
51 TAX_WITHHOLDING_ID BIGINT 8
52 TAX_WITHHOLDING_CODE CHARACTER VARYING(4) 4
53 OVERDRAWN_DATE TIMESTAMP 8
54 EFF_STRT_DATE TIMESTAMP 8
55 EFF_END_DATE TIMESTAMP 8
56 DATA_LOAD_DATE TIMESTAMP 8
57 SNPSHT_DATE TIMESTAMP 8
58 SRC_SYS_ID CHARACTER VARYING(5) 5
59 LOAD_ID BIGINT 8
60 AGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
61 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
62 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
63 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
64 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8