OPIC_MBCF

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SECID CHARACTER VARYING(20) 20
2 SEQ CHARACTER VARYING(4) 4
3 IPAYDATE TIMESTAMP 8
4 CASHFLOW_8 NUMERIC(18,8) 19
5 INTRATE_8 NUMERIC(18,8) 19
6 EXDIVDATE TIMESTAMP 8
7 INTPAYAMT_8 NUMERIC(18,8) 19
8 INTENDDTE TIMESTAMP 8
9 INTSTRTDTE TIMESTAMP 8
10 LSTMNTDATE TIMESTAMP 8
11 PRINAMT_8 NUMERIC(18,8) 19
12 PRINPAYAMT_8 NUMERIC(18,8) 19
13 NOTPRINAMT_8 NUMERIC(18,8) 19
14 NOTPRINPAYAMT_8 NUMERIC(18,8) 19
15 NOTINTPAYAMT_8 NUMERIC(18,8) 19
16 STATUS CHARACTER VARYING(1) 1
17 PRININTIND CHARACTER VARYING(4) 4
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8