OPIC_IGLT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 SERVER CHARACTER VARYING(15) 15
3 FEDEALNO CHARACTER VARYING(15) 15
4 SEQ CHARACTER VARYING(4) 4
5 INOUTIND CHARACTER VARYING(1) 1
6 PRODUCT CHARACTER VARYING(6) 6
7 TYPE CHARACTER VARYING(2) 2
8 ARGNO CHARACTER VARYING(3) 3
9 DEALNO CHARACTER VARYING(8) 8
10 GLNO CHARACTER VARYING(15) 15
11 COSTCENT CHARACTER VARYING(10) 10
12 CCY CHARACTER VARYING(3) 3
13 BEIND CHARACTER VARYING(1) 1
14 IOPER CHARACTER VARYING(4) 4
15 PORT CHARACTER VARYING(4) 4
16 VOPER CHARACTER VARYING(4) 4
17 VERIND CHARACTER VARYING(1) 1
18 VERDATE TIMESTAMP 8
19 REVOPER CHARACTER VARYING(4) 4
20 REVREASON CHARACTER VARYING(2) 2
21 REVDATE TIMESTAMP 8
22 CODE CHARACTER VARYING(4) 4
23 QUAL CHARACTER VARYING(1) 1
24 EFFDATE TIMESTAMP 8
25 POSTDATE TIMESTAMP 8
26 CMNE CHARACTER VARYING(10) 10
27 DRCRIND CHARACTER VARYING(2) 2
28 AMOUNT NUMERIC(19,4) 19
29 SMEANS CHARACTER VARYING(7) 7
30 SACCT CHARACTER VARYING(15) 15
31 DESCR CHARACTER VARYING(70) 70
32 POSTCLOSEIND CHARACTER VARYING(1) 1
33 DEALIND CHARACTER VARYING(1) 1
34 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
35 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
36 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
37 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8