OPIC_CHIS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 LIMITTYPE CHARACTER VARYING(1) 1
3 LIMITMEMBER CHARACTER VARYING(10) 10
4 PRODUCT CHARACTER VARYING(6) 6
5 PRODTYPE CHARACTER VARYING(2) 2
6 MTY CHARACTER VARYING(4) 4
7 BRPROCDATE TIMESTAMP 8
8 CCY CHARACTER VARYING(3) 3
9 CREQLIMAMT NUMERIC(19,4) 19
10 CREQCOMEXPOS NUMERIC(19,4) 19
11 CREQUTILEXPOS NUMERIC(19,4) 19
12 GRSLIMAMT NUMERIC(19,4) 19
13 GRSCOMEXPOS NUMERIC(19,4) 19
14 GRSUTILEXPOS NUMERIC(19,4) 19
15 DSLIMAMT NUMERIC(19,4) 19
16 DSEXPOS NUMERIC(19,4) 19
17 MTYDATE TIMESTAMP 8
18 LSTMNTDATE TIMESTAMP 8
19 MTM NUMERIC(19,4) 19
20 POSMTM NUMERIC(19,4) 19
21 ADDON NUMERIC(19,4) 19
22 NEWDEALIND CHARACTER VARYING(1) 1
23 SPOTCUSTIND CHARACTER VARYING(1) 1
24 PRODGROUPID CHARACTER VARYING(10) 10
25 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
26 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
27 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
28 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8