OPC_HST_BRCC

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 BR CHARACTER VARYING(2) 2
3 CCY CHARACTER VARYING(3) 3
4 TERMS CHARACTER VARYING(2) 2
5 RATETOL CHARACTER VARYING(4) 4
6 SPOTDAYS CHARACTER VARYING(3) 3
7 SETTLDAYS CHARACTER VARYING(3) 3
8 FXCASH NUMERIC(19,4) 19
9 LSTMNTDTE CHARACTER VARYING(10) 10
10 LIMIT NUMERIC(19,4) 19
11 SMEANS CHARACTER VARYING(6) 6
12 SACCT CHARACTER VARYING(15) 15
13 OPENPOSN NUMERIC(19,4) 19
14 BASIS CHARACTER VARYING(6) 6
15 DELTA_TYPE CHARACTER VARYING(1) 1
16 EFFECTIVE_STRT_DT TIMESTAMP 8
17 EFFECTIVE_END_DT TIMESTAMP 8
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8