PRT_GLMAP

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 SUBCOY SMALLINT 2
3 STATE SMALLINT 2
4 BRANCH SMALLINT 2
5 AREARESP SMALLINT 2
6 PRODUCT CHARACTER VARYING(3) 3
7 CLASS CHARACTER VARYING(3) 3
8 SUBCLASS CHARACTER VARYING(3) 3
9 AGTACCTYP CHARACTER VARYING(1) 1
10 REP SMALLINT 2
11 MISCTYPE CHARACTER VARYING(2) 2
12 MISCDATA CHARACTER VARYING(10) 10
13 ACTIVFROM INTEGER 4
14 ACTIVTO INTEGER 4
15 OGLENTITY CHARACTER VARYING(6) 6
16 OGLCENTRE CHARACTER VARYING(4) 4
17 OGLCATGORY CHARACTER VARYING(3) 3
18 OGLSTATE CHARACTER VARYING(1) 1
19 OGLPRODUCT CHARACTER VARYING(6) 6
20 OGLCLASS CHARACTER VARYING(2) 2
21 OGLCHANNEL CHARACTER VARYING(5) 5
22 OGLPROJECT CHARACTER VARYING(3) 3
23 OGLINTRCOY CHARACTER VARYING(6) 6
24 OGLSPARE CHARACTER VARYING(4) 4
25 TRANUSER CHARACTER VARYING(8) 8
26 TRANDATE INTEGER 4
27 DEFAULT CHARACTER VARYING(1) 1
28 LEVEL CHARACTER VARYING(2) 2
29 COMMENT CHARACTER VARYING(40) 40
30 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
31 RECORD_TYPE CHARACTER VARYING(16) 16
32 COMMIT_TIMESTAMP TIMESTAMP 8
33 EXTRACT_TIMESTAMP TIMESTAMP 8
34 CDC_ID BIGINT 8
35 COMPANY_CDC SMALLINT 2
36 ACTIVTO_CDC DATE 4
37 TRANDATE_CDC DATE 4
38 DW_TIMESTAMP TIMESTAMP 8