SDW_PCD_36001

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMP_ID CHARACTER VARYING(10) 10
2 EFF_DATE TIMESTAMP 8
3 KEY CHARACTER VARYING(20) 20
4 PROD CHARACTER VARYING(5) 5
5 SUB_PROD CHARACTER VARYING(8) 8
6 GL_ACT CHARACTER VARYING(20) 20
7 ACT_DESC CHARACTER VARYING(43) 43
8 MAINT_DATE TIMESTAMP 8
9 CC_NUMBER CHARACTER VARYING(20) 20
10 COMP CHARACTER VARYING(10) 10
11 AP_ACCT CHARACTER VARYING(20) 20
12 APOLLO_DESC CHARACTER VARYING(80) 80
13 CONTENTS CHARACTER VARYING(4) 4
14 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
16 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8