OPIC_TAXD

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 TAXPAYDATE TIMESTAMP 8
7 INTENDDATE TIMESTAMP 8
8 TAXSEQ CHARACTER VARYING(4) 4
9 VDATE TIMESTAMP 8
10 CCY CHARACTER VARYING(3) 3
11 TAXABLEAMT NUMERIC(19,4) 19
12 TAXAMT NUMERIC(19,4) 19
13 TAXAUTHORITY CHARACTER VARYING(10) 10
14 TAXCHGDESC CHARACTER VARYING(25) 25
15 CNO CHARACTER VARYING(10) 10
16 TENOR CHARACTER VARYING(2) 2
17 SECID CHARACTER VARYING(20) 20
18 ACCOUNTNO CHARACTER VARYING(15) 15
19 DEALCCYAMT NUMERIC(19,4) 19
20 PAYRECIND CHARACTER VARYING(1) 1
21 PIIND CHARACTER VARYING(1) 1
22 WHTBASIS CHARACTER VARYING(6) 6
23 MONDEALALLOWAMT NUMERIC(19,4) 19
24 MINTAXAMT NUMERIC(19,4) 19
25 MINTAXOPT CHARACTER VARYING(1) 1
26 ACCTGMETHOD CHARACTER VARYING(1) 1
27 TAXTYPE CHARACTER VARYING(1) 1
28 TAXRATE_8 NUMERIC(18,8) 19
29 INTSTRTDTE TIMESTAMP 8
30 TDYINCEXP NUMERIC(19,4) 19
31 YSTINCEXP NUMERIC(19,4) 19
32 MTDINCEXP NUMERIC(19,4) 19
33 YTDINCEXP NUMERIC(19,4) 19
34 MTDPINCEXP NUMERIC(19,4) 19
35 YTDPINCEXP NUMERIC(19,4) 19
36 ACCROUTST NUMERIC(19,4) 19
37 TAXPRODUCT CHARACTER VARYING(6) 6
38 TAXPRODTYPE CHARACTER VARYING(2) 2
39 BRPRCINDTE TIMESTAMP 8
40 VERDATE TIMESTAMP 8
41 REVDATE TIMESTAMP 8
42 TAXCERTDATE TIMESTAMP 8
43 LSTMNTDATE TIMESTAMP 8
44 TEXT1 CHARACTER VARYING(35) 35
45 TEXT2 CHARACTER VARYING(35) 35
46 DATE1 TIMESTAMP 8
47 DATE2 TIMESTAMP 8
48 LOCALCCYEQUIV NUMERIC(19,4) 19
49 BASECCYEQUIV NUMERIC(19,4) 19
50 FIDIND CHARACTER VARYING(1) 1
51 TOTTAXADJAMT NUMERIC(19,4) 19
52 TAXPAIDAMT NUMERIC(19,4) 19
53 TAXPAIDDATE TIMESTAMP 8
54 CNINTDEALNO CHARACTER VARYING(8) 8
55 SMEANS CHARACTER VARYING(7) 7
56 SACCT CHARACTER VARYING(15) 15
57 AMOUNT1 NUMERIC(19,4) 19
58 AMOUNT2 NUMERIC(19,4) 19
59 RATE1_8 NUMERIC(18,8) 19
60 RATE2_8 NUMERIC(18,8) 19
61 AL CHARACTER VARYING(1) 1
62 COST CHARACTER VARYING(10) 10
63 CAPINTIND CHARACTER VARYING(1) 1
64 TAXEXCHRATEBASE_8 NUMERIC(18,8) 19
65 TAXTERMSBASEIND CHARACTER VARYING(1) 1
66 TAXEXCHRATELOCAL_8 NUMERIC(18,8) 19
67 TAXTERMSLOCALIND CHARACTER VARYING(1) 1
68 TAXSOURCE CHARACTER VARYING(1) 1
69 TAXEVENTCODE CHARACTER VARYING(20) 20
70 TAXEVENTPROCESSIND CHARACTER VARYING(1) 1
71 TAXCALCDATE TIMESTAMP 8
72 STATUSIND CHARACTER VARYING(1) 1
73 SCHEDSEQ CHARACTER VARYING(4) 4
74 INFLADJSTARTDATE TIMESTAMP 8
75 INFLADJENDDATE TIMESTAMP 8
76 INFLFACTORSTARTRATE_8 NUMERIC(18,8) 19
77 INFLFACTORENDRATE_8 NUMERIC(18,8) 19
78 INFLFACTORADJAMT NUMERIC(19,4) 19
79 UNAMORTBALSTART NUMERIC(19,4) 19
80 AMORTPERIODSTARTDATE TIMESTAMP 8
81 AMORTPERIODENDDATE TIMESTAMP 8
82 AMORTENDDATE TIMESTAMP 8
83 AMORTPERIODAMT NUMERIC(19,4) 19
84 TAXABLEBASEAMT NUMERIC(19,4) 19
85 UNDDEALSETTIND CHARACTER VARYING(1) 1
86 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
87 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
88 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
89 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8