OPIC_PMTQ

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 PRODUCT CHARACTER VARYING(6) 6
3 TYPE CHARACTER VARYING(2) 2
4 DEALNO CHARACTER VARYING(8) 8
5 SEQ CHARACTER VARYING(4) 4
6 CDATE TIMESTAMP 8
7 CTIME CHARACTER VARYING(8) 8
8 PAYRECIND CHARACTER VARYING(1) 1
9 VDATE TIMESTAMP 8
10 PAYTYPE CHARACTER VARYING(2) 2
11 STATUS CHARACTER VARYING(2) 2
12 CCY CHARACTER VARYING(3) 3
13 AMOUNT NUMERIC(19,4) 19
14 CNO CHARACTER VARYING(11) 11
15 MSGPRTY CHARACTER VARYING(11) 11
16 SWIFTFMT CHARACTER VARYING(4) 4
17 RELDTE TIMESTAMP 8
18 RELTIME CHARACTER VARYING(8) 8
19 LSTMNTDTE TIMESTAMP 8
20 SETMEANS CHARACTER VARYING(7) 7
21 SETACCT CHARACTER VARYING(15) 15
22 COMREFNO CHARACTER VARYING(16) 16
23 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
24 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
25 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
26 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8