OPIC_PMTO

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 PAYORDERDATE TIMESTAMP 8
10 PAYORDERTIME CHARACTER VARYING(8) 8
11 CNO CHARACTER VARYING(10) 10
12 BLOCKIND CHARACTER VARYING(1) 1
13 BLOCKTEXT CHARACTER VARYING(35) 35
14 LIENIND CHARACTER VARYING(1) 1
15 TAXIND CHARACTER VARYING(1) 1
16 IOPER CHARACTER VARYING(4) 4
17 INPUTDATE TIMESTAMP 8
18 VOPER CHARACTER VARYING(4) 4
19 VERDATE TIMESTAMP 8
20 REVOPER CHARACTER VARYING(4) 4
21 REVDATE TIMESTAMP 8
22 IND1 CHARACTER VARYING(1) 1
23 IND2 CHARACTER VARYING(1) 1
24 DATE1 TIMESTAMP 8
25 DATE2 TIMESTAMP 8
26 AMT1 NUMERIC(19,4) 19
27 AMT2 NUMERIC(19,4) 19
28 TEXT CHARACTER VARYING(35) 35
29 LSTMNTDATE TIMESTAMP 8
30 ORIGSTATUS CHARACTER VARYING(2) 2
31 NEWSTATUS CHARACTER VARYING(2) 2
32 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
35 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8