SDW_TSDWM_TRSR_IP_SHDW

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 IP_ID BIGINT 8
2 SHDW_RCRD_TP_ID BIGINT 8
3 SHDW_DT TIMESTAMP 8
4 LOAD_ST_F CHARACTER VARYING(1) 1
5 ISRT_RUN_AUDT_ID BIGINT 8
6 UDT_RUN_AUDT_ID BIGINT 8
7 CST_NBR CHARACTER VARYING(20) 20
8 CST_MNEMONIC CHARACTER VARYING(18) 18
9 BNK_IDENTN_CODE CHARACTER VARYING(12) 12
10 STE_CODE CHARACTER VARYING(64) 64
11 CTY_ID BIGINT 8
12 SHRT_NM CHARACTER VARYING(80) 80
13 ULT_RSK_CTY_ID BIGINT 8
14 BNK_IND CHARACTER VARYING(1) 1
15 TAX_EXMPT_CODE CHARACTER VARYING(2) 2
16 TAX_EXMPT_DT TIMESTAMP 8
17 SRC_CST_ST_CODE CHARACTER VARYING(2) 2
18 TAX_EXMPT_IND CHARACTER VARYING(2) 2
19 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
20 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
21 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
22 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8