OPIC_DLUP

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 DEALNO CHARACTER VARYING(10) 10
3 DEALSEQNO CHARACTER VARYING(3) 3
4 SEQNO CHARACTER VARYING(3) 3
5 CCYSMEANS CHARACTER VARYING(7) 7
6 CCYSACCT CHARACTER VARYING(15) 15
7 REVOPER CHARACTER VARYING(4) 4
8 REVDATE TIMESTAMP 8
9 REVREASON CHARACTER VARYING(2) 2
10 PAYAMT NUMERIC(19,4) 19
11 INTAMT NUMERIC(19,4) 19
12 PRINAMT NUMERIC(19,4) 19
13 PENAMT NUMERIC(19,4) 19
14 CAPINT_FLAG CHARACTER VARYING(1) 1
15 PRININCDEC_IND CHARACTER VARYING(1) 1
16 SUPPRESSPMTQ_FLAG CHARACTER VARYING(1) 1
17 PRORATE_IND CHARACTER VARYING(1) 1
18 IOPER CHARACTER VARYING(4) 4
19 INPUTDATE TIMESTAMP 8
20 BRPINPUTDATE TIMESTAMP 8
21 DUEDATE TIMESTAMP 8
22 SETTDATE TIMESTAMP 8
23 PAYRECAUTHIND CHARACTER VARYING(1) 1
24 PAYRECAUTHDATE TIMESTAMP 8
25 PAYRECAUTHOPER CHARACTER VARYING(4) 4
26 SCHDSTRTDTE TIMESTAMP 8
27 SCHDENDDTE TIMESTAMP 8
28 INSERT_ENDDTE TIMESTAMP 8
29 WHTAMT NUMERIC(19,4) 19
30 VOPER CHARACTER VARYING(4) 4
31 VERIND CHARACTER VARYING(1) 1
32 VERDATE TIMESTAMP 8
33 TAXSTATUSIND CHARACTER VARYING(1) 1
34 USUALID CHARACTER VARYING(15) 15
35 INTADJAMT NUMERIC(19,4) 19
36 FAILDUEDATE TIMESTAMP 8
37 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8