OPIC_SCHD_FATCA

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER(2) 2
2 DEALNO CHARACTER(8) 8
3 SEQ CHARACTER(4) 4
4 PRODUCT CHARACTER(6) 6
5 PRODTYPE CHARACTER(2) 2
6 INTENDDTE TIMESTAMP 8
7 SCHDSEQ CHARACTER(4) 4
8 SCHDTYPE CHARACTER(1) 1
9 CCY CHARACTER(3) 3
10 COMPOUND CHARACTER(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(1) 1
18 RATEREVDTE TIMESTAMP 8
19 RATEFIXDTE TIMESTAMP 8
20 SMEANS CHARACTER(7) 7
21 SACCT CHARACTER(15) 15
22 RATECODE CHARACTER(7) 7
23 INTRATE_8 NUMERIC(18,8) 19
24 BASIS CHARACTER(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(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(6) 6
36 WHTAMT NUMERIC(19,4) 19
37 WHTIND CHARACTER(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(6) 6
42 FUNDAMT NUMERIC(19,4) 19
43 PPAYDATE TIMESTAMP 8
44 PAYAUTHDTE TIMESTAMP 8
45 PAYAUTHIND CHARACTER(1) 1
46 INTCCY CHARACTER(3) 3
47 INTEXCHARATE_8 NUMERIC(18,8) 19
48 TERMS CHARACTER(1) 1
49 POSNFUNDAMT NUMERIC(19,4) 19
50 INTSMEANS CHARACTER(7) 7
51 INTSACCT CHARACTER(15) 15
52 INTAUTHIND CHARACTER(1) 1
53 INTAUTHOPER CHARACTER(4) 4
54 INTAUTHDATE TIMESTAMP 8
55 CAPINTIND CHARACTER(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(1) 1
61 RATEAMTFUND CHARACTER(1) 1
62 RATEAMTTAX1 CHARACTER(1) 1
63 RATEAMTTAX2 CHARACTER(1) 1
64 RATEAMTTAX3 CHARACTER(1) 1
65 TEXT1 CHARACTER(35) 35
66 TEXT2 CHARACTER(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(4) 4
72 PRINOPER CHARACTER(4) 4
73 PRINAUTHOPER CHARACTER(4) 4
74 NETSIIND CHARACTER(1) 1
75 NETDEALNO CHARACTER(8) 8
76 NETSEQ CHARACTER(4) 4
77 CORPNETIND CHARACTER(1) 1
78 PRINUSUALID CHARACTER(4) 4
79 INTUSUALID CHARACTER(4) 4
80 AMOUNT1 NUMERIC(19,4) 19
81 RATE1 NUMERIC(18,8) 19
82 RATE2 NUMERIC(18,8) 19
83 TAXSTATUSIND CHARACTER(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