OBP24_FLX_OR_TD_PRD_GRP_XREF

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 APPLICATION_ID CHARACTER VARYING(50) 50
2 PROD_GRP_SERIAL_NO BYTEINT 1
3 REQUEST_AMOUNT DOUBLE PRECISION 8
4 REQUEST_AMOUNT_CURRENCY CHARACTER VARYING(3) 3
5 TENOR_YEARS DOUBLE PRECISION 8
6 TENOR_MONTHS DOUBLE PRECISION 8
7 TENOR_DAYS DOUBLE PRECISION 8
8 PAYOUT_FREQUENCY CHARACTER VARYING(50) 50
9 MATURITY_FACTOR CHARACTER VARYING(50) 50
10 MATURITY_DATE TIMESTAMP 8
11 STATE_TYPE CHARACTER VARYING(20) 20
12 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
13 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
14 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
15 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8