CFD_TCFDD_PRODUCT_DIM

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_ID DOUBLE PRECISION 8
2 BUS_UNT_CODE CHARACTER VARYING(20) 20
3 BUS_UNT_DESC CHARACTER VARYING(50) 50
4 PRDT_BRND_CODE CHARACTER VARYING(20) 20
5 PRDT_BRND_DESC CHARACTER VARYING(50) 50
6 PRDT_SUB_TYP_CODE CHARACTER VARYING(20) 20
7 PRDT_SUB_TYP_DESC CHARACTER VARYING(50) 50
8 PRDT_SEGMENT_GRP_CODE CHARACTER VARYING(20) 20
9 PRDT_SEGMENT_GRP_DESC CHARACTER VARYING(150) 150
10 PRDT_CODE CHARACTER VARYING(100) 100
11 PRDT_SYS_CODE CHARACTER VARYING(10) 10
12 PRDT_GRP_CODE CHARACTER VARYING(20) 20
13 PRDT_TYP_CODE CHARACTER VARYING(20) 20
14 PRDT_DESC CHARACTER VARYING(100) 100
15 LOAD_ID DOUBLE PRECISION 8
16 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
17 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
18 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
19 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8