OPIC_FIND

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 INCEXPTYPE CHARACTER VARYING(1) 1
7 CCY CHARACTER VARYING(3) 3
8 TDYINCEXP NUMERIC(19,4) 19
9 YSTINCEXP NUMERIC(19,4) 19
10 MTDINCEXP NUMERIC(19,4) 19
11 YTDINCEXP NUMERIC(19,4) 19
12 MTDPINCEXP NUMERIC(19,4) 19
13 YTDPINCEXP NUMERIC(19,4) 19
14 ACCROUTST NUMERIC(19,4) 19
15 INTPAID NUMERIC(19,4) 19
16 LSTMNTDATE TIMESTAMP 8
17 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
18 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
19 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
20 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8