OPC_HST_FIND

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_FIND

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACCROUTST NUMERIC(19,4) 19
3 BR CHARACTER VARYING(2) 2
4 DEALNO CHARACTER VARYING(8) 8
5 INCEXPTYPE CHARACTER VARYING(1) 1
6 PRODTYPE CHARACTER VARYING(2) 2
7 PRODUCT CHARACTER VARYING(6) 6
8 CCY CHARACTER VARYING(3) 3
9 SEQ CHARACTER VARYING(4) 4
10 TDYINCEXP NUMERIC(19,4) 19
11 LSTMNTDATE CHARACTER VARYING(10) 10
12 INTPAID NUMERIC(19,4) 19
13 MTDINCEXP NUMERIC(19,4) 19
14 MTDPINCEXP NUMERIC(19,4) 19
15 YSTINCEXP NUMERIC(19,4) 19
16 YTDINCEXP NUMERIC(19,4) 19
17 YTDPINCEXP NUMERIC(19,4) 19
18 DELTA_TYPE CHARACTER VARYING(1) 1
19 EFFECTIVE_STRT_DT TIMESTAMP 8
20 EFFECTIVE_END_DT TIMESTAMP 8
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8