CFD_TCFDD_CMPY_CUST_CUST_RSHIP

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CMPY_CODE CHARACTER VARYING(20) 20
2 CMPY_CUST_NUM CHARACTER VARYING(20) 20
3 REL_CMPY_CUST_NUM CHARACTER VARYING(20) 20
4 CUST_RSHIP_TYP_CODE CHARACTER VARYING(50) 50
5 EFF_STRT_DATE TIMESTAMP 8
6 SITE_CODE CHARACTER VARYING(10) 10
7 CMPY_ID BIGINT 8
8 CMNT_TEXT CHARACTER VARYING(500) 500
9 CUST_RSHIP_TYP_ID BIGINT 8
10 RECORD_STAT_CODE INTEGER 4
11 INSERT_UID CHARACTER VARYING(300) 300
12 INSERT_DATE TIMESTAMP 8
13 UPD_UID CHARACTER VARYING(300) 300
14 UPD_DATE TIMESTAMP 8
15 EFF_END_DATE TIMESTAMP 8
16 DATA_LOAD_DATE TIMESTAMP 8
17 SNPSHT_DATE TIMESTAMP 8
18 SRC_SYS_ID CHARACTER VARYING(5) 5
19 LOAD_ID BIGINT 8
20 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
23 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8