OPC_HST_SCHD

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_SCHD

SDSNZP02_BANK..NROD_OPC_HST_SCHD

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