INT_OBP_TRANSACTIONS

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_OBP_TRANSACTIONS_V

Columns
# Name Data Type Length
1 TRANSACTION_DATE TIMESTAMP 8
2 VALUE_DATE TIMESTAMP 8
3 PROCESS_DATE TIMESTAMP 8
4 ACCOUNT_CODE CHARACTER VARYING(50) 50
5 EVENT_ID CHARACTER VARYING(50) 50
6 ACCOUNT_DIM_ID BIGINT 8
7 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
8 ACCOUNT_STATUS_DIM_ID BIGINT 8
9 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
10 BRANCH_CODE CHARACTER VARYING(10) 10
11 BANK_CODE CHARACTER VARYING(10) 10
12 PRODUCT_ID CHARACTER VARYING(30) 30
13 PARTY_ID CHARACTER VARYING(40) 40
14 BDM_DIM_ID BIGINT 8
15 RUNNING_BAL DOUBLE PRECISION 8
16 RPA_OR_ALL_ARREAR_AMT DOUBLE PRECISION 8
17 TXN_AMOUNT_TCY DOUBLE PRECISION 8
18 PAYOUT_REASON_DIM_ID BIGINT 8
19 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
20 GL_ACCOUNT_DIM_ID BIGINT 8
21 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
22 LN_DISB_TXN_AMT NUMERIC(38,5) 19
23 TXN_REF_NO CHARACTER VARYING(50) 50
24 SUB_SEQ_NO DOUBLE PRECISION 8
25 TXN_CHANNEL CHARACTER VARYING(50) 50
26 TXN_BRANCH CHARACTER VARYING(10) 10
27 USER_NO CHARACTER VARYING(50) 50
28 AUTHORIZER_CODE CHARACTER VARYING(50) 50
29 NARRATION CHARACTER VARYING(500) 500
30 CARD_REF_NO CHARACTER VARYING(50) 50
31 CHEQUE_NO CHARACTER VARYING(50) 50
32 USER_REF_NO CHARACTER VARYING(50) 50
33 POSTING_DATE TIMESTAMP 8
34 TXN_TYPE CHARACTER VARYING(50) 50
35 TRANSACTION_TIME_DATE DATE 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
39 PROCESS_DATE_INT INTEGER 4
40 30DAYS_START_CLOSURE_RANGE DATE 4
41 START_CLOSURE_RANGE TIMESTAMP 8
42 END_CLOSURE_RANGE DATE 4
43 PAYOUT_CLASSIFICATION_DIM_ID BIGINT 8