OPIC_RJDH

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 EFFDATE TIMESTAMP 8
4 CCY CHARACTER VARYING(3) 3
5 JRTYPE CHARACTER VARYING(1) 1
6 DRCRIND CHARACTER VARYING(2) 2
7 CRDRIND CHARACTER VARYING(2) 2
8 GLNO CHARACTER VARYING(15) 15
9 COSTCENT CHARACTER VARYING(11) 11
10 AMOUNT NUMERIC(19,4) 19
11 SMEANS CHARACTER VARYING(7) 7
12 SACCT CHARACTER VARYING(15) 15
13 SGL CHARACTER VARYING(15) 15
14 DRGLNO CHARACTER VARYING(15) 15
15 CRGLNO CHARACTER VARYING(15) 15
16 DRCOSTCENT CHARACTER VARYING(11) 11
17 CRCOSTCENT CHARACTER VARYING(11) 11
18 ACCTMETH CHARACTER VARYING(1) 1
19 STARTDATE TIMESTAMP 8
20 ENDDATE TIMESTAMP 8
21 ENDFLAG CHARACTER VARYING(1) 1
22 DESCR CHARACTER VARYING(70) 70
23 REVCODE CHARACTER VARYING(2) 2
24 REVREASON CHARACTER VARYING(70) 70
25 REVDATE TIMESTAMP 8
26 POSTDATE TIMESTAMP 8
27 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
28 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
29 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
30 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8