SDW_TSDMD_ACCT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCT_DIM_ID BIGINT 8
2 ACCT_PERM_DIM_ID BIGINT 8
3 ACCT_AR_ID BIGINT 8
4 EFF_PERIOD_ID BIGINT 8
5 END_PERIOD_ID BIGINT 8
6 CURR_FL CHARACTER VARYING(1) 1
7 SRC_SYS_CD CHARACTER VARYING(12) 12
8 SRC_CO_CD CHARACTER VARYING(6) 6
9 SRC_PROD_TP_CD CHARACTER VARYING(6) 6
10 SRC_ACCT_NBR_CD CHARACTER VARYING(20) 20
11 LCS_TP_CD CHARACTER VARYING(24) 24
12 LCS_TP_NM CHARACTER VARYING(256) 256
13 LCS_TP_STD_CD CHARACTER VARYING(24) 24
14 OPN_DT TIMESTAMP 8
15 CLS_DT TIMESTAMP 8
16 CRT_DT TIMESTAMP 8
17 SRC_PROD_CD CHARACTER VARYING(6) 6
18 ORIG_LEAD_NBR CHARACTER VARYING(20) 20
19 ORIG_LEAD_FCY_NBR CHARACTER VARYING(20) 20
20 LATEST_LEAD_NBR CHARACTER VARYING(20) 20
21 LATEST_LEAD_FCY_NBR CHARACTER VARYING(20) 20
22 BDM_SRC_CD CHARACTER VARYING(6) 6
23 ORIG_BRANCH_CD CHARACTER VARYING(6) 6
24 SALE_BRANCH_CD CHARACTER VARYING(20) 20
25 MGN_BRANCH_CD CHARACTER VARYING(20) 20
26 MGN_BRANCH_PS_GL_COSTCTR_CD CHARACTER VARYING(20) 20
27 MGN_BRANCH_SRC_GL_COSTCTR_CD CHARACTER VARYING(20) 20
28 SOURCE_SRC_CD CHARACTER VARYING(20) 20
29 CLS_REASON_TP_CD CHARACTER VARYING(24) 24
30 CLS_REASON_TP_NM CHARACTER VARYING(256) 256
31 CLS_REASON_STD_TP_CD CHARACTER VARYING(24) 24
32 CLS_REASON_STD_TP_NM CHARACTER VARYING(256) 256
33 PROD_ID BIGINT 8
34 MGN_BRANCH_IP_ID BIGINT 8
35 ORIG_LEAD_AR_ID BIGINT 8
36 LATEST_LEAD_AR_ID BIGINT 8
37 BDM_IP_ID BIGINT 8
38 SOURCE_IP_ID BIGINT 8
39 BROKER_IP_ID BIGINT 8
40 BROKER_SRC_CD CHARACTER VARYING(20) 20
41 ORIG_BRANCH_ID BIGINT 8
42 SALE_BRANCH_ID BIGINT 8
43 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
44 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
45 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
46 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8