OPIC_SCHH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 DEALNO CHARACTER VARYING(8) 8
3 SEQ CHARACTER VARYING(4) 4
4 AMENDDATE TIMESTAMP 8
5 AMENDTIME CHARACTER VARYING(8) 8
6 ACCOUNTIND CHARACTER VARYING(1) 1
7 PRODUCT CHARACTER VARYING(6) 6
8 PRODTYPE CHARACTER VARYING(2) 2
9 INTENDDTE TIMESTAMP 8
10 SCHDSEQ CHARACTER VARYING(4) 4
11 SCHDTYPE CHARACTER VARYING(1) 1
12 CCY CHARACTER VARYING(3) 3
13 COMPOUND CHARACTER VARYING(1) 1
14 TOTPAYAMT NUMERIC(19,4) 19
15 PRINAMT NUMERIC(19,4) 19
16 INTAMT NUMERIC(19,4) 19
17 POSNINTAMT NUMERIC(19,4) 19
18 INTSTRTDTE TIMESTAMP 8
19 IPAYDATE TIMESTAMP 8
20 AUTOMANPAY CHARACTER VARYING(1) 1
21 RATEREVDTE TIMESTAMP 8
22 RATEFIXDTE TIMESTAMP 8
23 SMEANS CHARACTER VARYING(7) 7
24 SACCT CHARACTER VARYING(15) 15
25 RATECODE CHARACTER VARYING(7) 7
26 INTRATE_8 NUMERIC(18,8) 19
27 BASIS CHARACTER VARYING(6) 6
28 SPREAD_8 NUMERIC(18,8) 19
29 REVDATE TIMESTAMP 8
30 VERDATE TIMESTAMP 8
31 MANPAYDTE TIMESTAMP 8
32 PPAYAMT NUMERIC(19,4) 19
33 AL CHARACTER VARYING(1) 1
34 LSTMNTDATE TIMESTAMP 8
35 BRPRCINDTE TIMESTAMP 8
36 NOTPRIN NUMERIC(19,4) 19
37 WHTRATE_8 NUMERIC(18,8) 19
38 WHTBASIS CHARACTER VARYING(6) 6
39 WHTAMT NUMERIC(19,4) 19
40 WHTIND CHARACTER VARYING(1) 1
41 VATAMT NUMERIC(19,4) 19
42 VATRATE_8 NUMERIC(18,8) 19
43 FUNDRATE_8 NUMERIC(18,8) 19
44 FUNDBASIS CHARACTER VARYING(6) 6
45 FUNDAMT NUMERIC(19,4) 19
46 PPAYDATE TIMESTAMP 8
47 PAYAUTHDTE TIMESTAMP 8
48 PAYAUTHIND CHARACTER VARYING(1) 1
49 INTCCY CHARACTER VARYING(3) 3
50 INTEXCHARATE_8 NUMERIC(18,8) 19
51 TERMS CHARACTER VARYING(1) 1
52 POSNFUNDAMT NUMERIC(19,4) 19
53 INTSMEANS CHARACTER VARYING(7) 7
54 INTSACCT CHARACTER VARYING(15) 15
55 INTAUTHIND CHARACTER VARYING(1) 1
56 INTAUTHOPER CHARACTER VARYING(4) 4
57 INTAUTHDATE TIMESTAMP 8
58 CAPINTIND CHARACTER VARYING(1) 1
59 CAPINTAMT NUMERIC(19,4) 19
60 CAPTAXAMT NUMERIC(19,4) 19
61 APPLIEDMONTHALL NUMERIC(19,4) 19
62 POSNPRINAMT NUMERIC(19,4) 19
63 RATEAMTINT CHARACTER VARYING(1) 1
64 RATEAMTFUND CHARACTER VARYING(1) 1
65 RATEAMTTAX1 CHARACTER VARYING(1) 1
66 RATEAMTTAX2 CHARACTER VARYING(1) 1
67 RATEAMTTAX3 CHARACTER VARYING(1) 1
68 TEXT1 CHARACTER VARYING(35) 35
69 TEXT2 CHARACTER VARYING(35) 35
70 DATE1 TIMESTAMP 8
71 DATE2 TIMESTAMP 8
72 NEXTAPPMONTHALL NUMERIC(19,4) 19
73 AMOUNT2 NUMERIC(19,4) 19
74 TAXSTATUSIND CHARACTER VARYING(1) 1
75 STEPUPCORRRATE_8 NUMERIC(18,8) 19
76 STEPUPCORRINTAMT NUMERIC(19,4) 19
77 INTADJAMT NUMERIC(19,4) 19
78 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
79 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
80 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
81 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8