OPC_HST_ACUP

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 AMOUNT NUMERIC(19,4) 19
3 ARGNO CHARACTER VARYING(3) 3
4 BEIND CHARACTER VARYING(1) 1
5 BR CHARACTER VARYING(2) 2
6 CCY CHARACTER VARYING(3) 3
7 CMNE CHARACTER VARYING(20) 20
8 CODE CHARACTER VARYING(4) 4
9 COSTCENT CHARACTER VARYING(10) 10
10 DEALNO CHARACTER VARYING(8) 8
11 DESCR CHARACTER VARYING(70) 70
12 DRCRIND CHARACTER VARYING(2) 2
13 EFFDATE CHARACTER VARYING(10) 10
14 GLNO CHARACTER VARYING(15) 15
15 POSTDATE CHARACTER VARYING(10) 10
16 PRODUCT CHARACTER VARYING(6) 6
17 QUAL CHARACTER VARYING(1) 1
18 SACCT CHARACTER VARYING(15) 15
19 SEQ CHARACTER VARYING(4) 4
20 SMEANS CHARACTER VARYING(7) 7
21 TYPE CHARACTER VARYING(2) 2
22 DELTA_TYPE CHARACTER VARYING(1) 1
23 EFFECTIVE_STRT_DT TIMESTAMP 8
24 EFFECTIVE_END_DT TIMESTAMP 8
25 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
26 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
27 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
28 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8