OPIC_GLTH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 GLNO CHARACTER VARYING(15) 15
3 COST CHARACTER VARYING(10) 10
4 CCY CHARACTER VARYING(3) 3
5 PMEXLATIONAMT NUMERIC(19,4) 19
6 PYEXLATIONAMT NUMERIC(19,4) 19
7 TDYXLATIONAMT NUMERIC(19,4) 19
8 YSTXLATIONAMT NUMERIC(19,4) 19
9 TDYAMCLSGBE NUMERIC(19,4) 19
10 YSTAMCLSGBE NUMERIC(19,4) 19
11 PMEAMCLSGBE NUMERIC(19,4) 19
12 PYEAMCLSGBE NUMERIC(19,4) 19
13 TDYAMCLSGCCY NUMERIC(19,4) 19
14 YSTAMCLSGCCY NUMERIC(19,4) 19
15 PMEAMCLSGCCY NUMERIC(19,4) 19
16 PYEAMCLSGCCY NUMERIC(19,4) 19
17 TDYDLYACTIVITY NUMERIC(19,4) 19
18 YSTDLYACTIVITY NUMERIC(19,4) 19
19 PMEDLYACTIVITY NUMERIC(19,4) 19
20 PYEDLYACTIVITY NUMERIC(19,4) 19
21 TDYBVACTIVITY NUMERIC(19,4) 19
22 YSTBVACTIVITY NUMERIC(19,4) 19
23 PMEBVACTIVITY NUMERIC(19,4) 19
24 PYEBVACTIVITY NUMERIC(19,4) 19
25 UPDATECOUNTER BIGINT 8
26 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
28 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
29 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8