OPIC_RDFH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 TRANSNO CHARACTER VARYING(8) 8
3 SEQ CHARACTER VARYING(4) 4
4 BETEXT1 CHARACTER VARYING(35) 35
5 BETEXT2 CHARACTER VARYING(35) 35
6 BETEXT3 CHARACTER VARYING(35) 35
7 BETEXT4 CHARACTER VARYING(35) 35
8 BESACCT CHARACTER VARYING(35) 35
9 BESBIC CHARACTER VARYING(11) 11
10 BRPRCINDTE TIMESTAMP 8
11 CCY CHARACTER VARYING(3) 3
12 CNO CHARACTER VARYING(11) 11
13 DR CHARACTER VARYING(1) 1
14 INITCOST NUMERIC(19,4) 19
15 INPUTDATE TIMESTAMP 8
16 IOPER CHARACTER VARYING(4) 4
17 INPUTTIME CHARACTER VARYING(8) 8
18 LINKDTRANSNO CHARACTER VARYING(8) 8
19 PRODUCT CHARACTER VARYING(6) 6
20 PRODTYPE CHARACTER VARYING(2) 2
21 QTY NUMERIC(19,4) 19
22 REVDATE TIMESTAMP 8
23 REVOPER CHARACTER VARYING(4) 4
24 REVREASON CHARACTER VARYING(2) 2
25 REVTEXT CHARACTER VARYING(70) 70
26 SECSACCT CHARACTER VARYING(15) 15
27 SECAUTHDATE TIMESTAMP 8
28 SECAUTHIND CHARACTER VARYING(1) 1
29 SECAUTHOPER CHARACTER VARYING(4) 4
30 SECID CHARACTER VARYING(20) 20
31 SETTDATE TIMESTAMP 8
32 TRANSDATE TIMESTAMP 8
33 TRANSTIME CHARACTER VARYING(8) 8
34 VERDATE TIMESTAMP 8
35 VEROPER CHARACTER VARYING(4) 4
36 VERIND CHARACTER VARYING(1) 1
37 CLEARDATE TIMESTAMP 8
38 CLEARINPUTDATE TIMESTAMP 8
39 CLEAROPER CHARACTER VARYING(4) 4
40 FAILDATE TIMESTAMP 8
41 FAILINPUTDATE TIMESTAMP 8
42 FAILINPUTOPER CHARACTER VARYING(4) 4
43 SUPPCONFIND CHARACTER VARYING(1) 1
44 FREEPAYCASH CHARACTER VARYING(1) 1
45 CCYAMT NUMERIC(19,4) 19
46 VATAMT NUMERIC(19,4) 19
47 WHTAMT NUMERIC(19,4) 19
48 PROCEEDS NUMERIC(19,4) 19
49 FEECODE1 CHARACTER VARYING(5) 5
50 FEEAMT1 NUMERIC(19,4) 19
51 FEECODE2 CHARACTER VARYING(5) 5
52 FEEAMT2 NUMERIC(19,4) 19
53 FEECODE3 CHARACTER VARYING(5) 5
54 FEEAMT3 NUMERIC(19,4) 19
55 CUSTCCYSMEANS CHARACTER VARYING(7) 7
56 CUSTCCYSACCT CHARACTER VARYING(15) 15
57 CCYSMEANS CHARACTER VARYING(7) 7
58 CCYSACCT CHARACTER VARYING(15) 15
59 BROK CHARACTER VARYING(11) 11
60 DEALDATE TIMESTAMP 8
61 DEALTEXT CHARACTER VARYING(70) 70
62 COST CHARACTER VARYING(10) 10
63 TRANREF CHARACTER VARYING(16) 16
64 RFUPRICE_8 NUMERIC(18,8) 19
65 PORT CHARACTER VARYING(4) 4
66 INVTYPE CHARACTER VARYING(1) 1
67 SENDRECNO CHARACTER VARYING(10) 10
68 INSTRREQIND CHARACTER VARYING(1) 1
69 CCYAUTHDATE TIMESTAMP 8
70 CCYAUTHIND CHARACTER VARYING(1) 1
71 CCYAUTHOPER CHARACTER VARYING(4) 4
72 USUALID CHARACTER VARYING(15) 15
73 CCPIND CHARACTER VARYING(1) 1
74 SETTCCY CHARACTER VARYING(3) 3
75 SETTEXCHRATE_8 NUMERIC(18,8) 19
76 SETTTERMS CHARACTER VARYING(1) 1
77 SETTAMT NUMERIC(19,4) 19
78 SETTBASEEXCHRATE_8 NUMERIC(18,8) 19
79 SETTBASETERMS CHARACTER VARYING(1) 1
80 SETTBASEAMT NUMERIC(19,4) 19
81 CCYBASEAMT NUMERIC(19,4) 19
82 DIVNO CHARACTER VARYING(8) 8
83 VSECSACCT CHARACTER VARYING(15) 15
84 INITPURCHDATE TIMESTAMP 8
85 CONVIND CHARACTER VARYING(1) 1
86 EXTBSKTID CHARACTER VARYING(20) 20
87 EXTCONVID CHARACTER VARYING(15) 15
88 AGREENO CHARACTER VARYING(8) 8
89 PLGTYPE CHARACTER VARYING(1) 1
90 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
91 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
92 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
93 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8