OBP24_HST_FLX_PR_PRICING_TRANS_DETAILS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TICKET_CODE CHARACTER VARYING(128) 128
2 ARRANGEMENT_CODE CHARACTER VARYING(128) 128
3 EVENT_CODE CHARACTER VARYING(50) 50
4 EXTERNAL_REFERENCE_NUM CHARACTER VARYING(128) 128
5 EVALUATION_DATE TIMESTAMP 8
6 IS_BULKING_FLAG CHARACTER(1) 1
7 TRANSACTION_TYPE CHARACTER VARYING(50) 50
8 IS_TRANSACTION_COMPLETE_FLAG CHARACTER(1) 1
9 IS_TRANSACTION_REVERSED CHARACTER(1) 1
10 TXN_AMT DOUBLE PRECISION 8
11 TXN_AMT_CCY_CODE CHARACTER VARYING(10) 10
12 DOMAIN_CATEGORY CHARACTER VARYING(50) 50
13 BASE_PRICE_TYPE CHARACTER VARYING(20) 20
14 TXN_MODE CHARACTER VARYING(50) 50
15 TRANSACTION_COMPLETION_DATE TIMESTAMP 8
16 CREATED_BY CHARACTER VARYING(254) 254
17 CREATION_DATE TIMESTAMP 8
18 LAST_UPDATED_BY CHARACTER VARYING(254) 254
19 LAST_UPDATE_DATE TIMESTAMP 8
20 VERSION_NUM SMALLINT 2
21 BULKING_FREQUENCY CHARACTER VARYING(50) 50
22 NSF_TREATMENT CHARACTER VARYING(50) 50
23 SINGLE_CHARGE_DATE_REQUIRED CHARACTER(1) 1
24 CHARGE_BASIS CHARACTER VARYING(50) 50
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