OPIC_HST_SCHD

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 PRODUCT CHARACTER VARYING(6) 6
5 PRODTYPE CHARACTER VARYING(2) 2
6 INTENDDTE TIMESTAMP 8
7 SCHDSEQ CHARACTER VARYING(4) 4
8 SCHDTYPE CHARACTER VARYING(1) 1
9 CCY CHARACTER VARYING(3) 3
10 COMPOUND CHARACTER VARYING(1) 1
11 TOTPAYAMT NUMERIC(19,4) 19
12 PRINAMT NUMERIC(19,4) 19
13 INTAMT NUMERIC(19,4) 19
14 POSNINTAMT NUMERIC(19,4) 19
15 INTSTRTDTE TIMESTAMP 8
16 IPAYDATE TIMESTAMP 8
17 AUTOMANPAY CHARACTER VARYING(1) 1
18 RATEREVDTE TIMESTAMP 8
19 RATEFIXDTE TIMESTAMP 8
20 SMEANS CHARACTER VARYING(7) 7
21 SACCT CHARACTER VARYING(15) 15
22 RATECODE CHARACTER VARYING(7) 7
23 INTRATE_8 NUMERIC(18,8) 19
24 BASIS CHARACTER VARYING(6) 6
25 SPREAD_8 NUMERIC(18,8) 19
26 REVDATE TIMESTAMP 8
27 VERDATE TIMESTAMP 8
28 MANPAYDTE TIMESTAMP 8
29 PPAYAMT NUMERIC(19,4) 19
30 AL CHARACTER VARYING(1) 1
31 LSTMNTDATE TIMESTAMP 8
32 BRPRCINDTE TIMESTAMP 8
33 NOTPRIN NUMERIC(19,4) 19
34 WHTRATE_8 NUMERIC(18,8) 19
35 WHTBASIS CHARACTER VARYING(6) 6
36 WHTAMT NUMERIC(19,4) 19
37 WHTIND CHARACTER VARYING(1) 1
38 VATAMT NUMERIC(19,4) 19
39 VATRATE_8 NUMERIC(18,8) 19
40 FUNDRATE_8 NUMERIC(18,8) 19
41 FUNDBASIS CHARACTER VARYING(6) 6
42 FUNDAMT NUMERIC(19,4) 19
43 PPAYDATE TIMESTAMP 8
44 PAYAUTHDTE TIMESTAMP 8
45 PAYAUTHIND CHARACTER VARYING(1) 1
46 INTCCY CHARACTER VARYING(3) 3
47 INTEXCHARATE_8 NUMERIC(18,8) 19
48 TERMS CHARACTER VARYING(1) 1
49 POSNFUNDAMT NUMERIC(19,4) 19
50 INTSMEANS CHARACTER VARYING(7) 7
51 INTSACCT CHARACTER VARYING(15) 15
52 INTAUTHIND CHARACTER VARYING(1) 1
53 INTAUTHOPER CHARACTER VARYING(4) 4
54 INTAUTHDATE TIMESTAMP 8
55 CAPINTIND CHARACTER VARYING(1) 1
56 CAPINTAMT NUMERIC(19,4) 19
57 CAPTAXAMT NUMERIC(19,4) 19
58 APPLIEDMONTHALL NUMERIC(19,4) 19
59 POSNPRINAMT NUMERIC(19,4) 19
60 RATEAMTINT CHARACTER VARYING(1) 1
61 RATEAMTFUND CHARACTER VARYING(1) 1
62 RATEAMTTAX1 CHARACTER VARYING(1) 1
63 RATEAMTTAX2 CHARACTER VARYING(1) 1
64 RATEAMTTAX3 CHARACTER VARYING(1) 1
65 TEXT1 CHARACTER VARYING(35) 35
66 TEXT2 CHARACTER VARYING(35) 35
67 DATE1 TIMESTAMP 8
68 DATE2 TIMESTAMP 8
69 NEXTAPPMONTHALL NUMERIC(19,4) 19
70 AMOUNT2 NUMERIC(19,4) 19
71 INTOPER CHARACTER VARYING(4) 4
72 PRINOPER CHARACTER VARYING(4) 4
73 PRINAUTHOPER CHARACTER VARYING(4) 4
74 NETSIIND CHARACTER VARYING(1) 1
75 NETDEALNO CHARACTER VARYING(8) 8
76 NETSEQ CHARACTER VARYING(4) 4
77 CORPNETIND CHARACTER VARYING(1) 1
78 PRINUSUALID CHARACTER VARYING(4) 4
79 INTUSUALID CHARACTER VARYING(4) 4
80 AMOUNT1 NUMERIC(19,4) 19
81 RATE1 NUMERIC(18,8) 19
82 RATE2 NUMERIC(18,8) 19
83 TAXSTATUSIND CHARACTER VARYING(1) 1
84 STEPUPCORRRATE_8 NUMERIC(18,8) 19
85 STEPUPCORRINTAMT NUMERIC(19,4) 19
86 INTADJAMT NUMERIC(19,4) 19
87 FAILDATE TIMESTAMP 8
88 ORIGPAYDATE TIMESTAMP 8
89 ORIGPPAYAMT NUMERIC(19,4) 19
90 ORIGINTPAYAMT NUMERIC(19,4) 19
91 FAILPAIDDATE TIMESTAMP 8
92 FAILINTPAIDAMT NUMERIC(19,4) 19
93 FAILPRINPAIDAMT NUMERIC(19,4) 19
94 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
95 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
96 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
97 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8