DIM_OBP_TRANSACTIONS

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..DIM_OBP_TRANSACTIONS_V

Columns
# Name Data Type Length
1 TRANSACTION_DIM_ID BIGINT 8
2 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
3 SOURCE_COMPANY_CODE CHARACTER VARYING(3) 3
4 SOURCE_PCS_ENVIRONMENT_CODE CHARACTER VARYING(3) 3
5 SOURCE_PCS_SOURCE_CODE CHARACTER VARYING(3) 3
6 SOURCE_PCS_APPLICATION_CODE CHARACTER VARYING(3) 3
7 SOURCE_PRODUCT_TYPE_CODE CHARACTER VARYING(30) 30
8 SOURCE_CALCULATION_TYPE_CODE CHARACTER VARYING(1) 1
9 SOURCE_TRANSACTION_CODE CHARACTER VARYING(50) 50
10 LOAD_STATUS_FLAG CHARACTER VARYING(1) 1
11 INSERT_RUN_AUDIT_ID NUMERIC(38,0) 19
12 UPDATE_RUN_AUDIT_ID INTEGER 4
13 TRANSACTION_DESCRIPTION CHARACTER VARYING(100) 100
14 CUSTOMER_INITIATED_FLAG CHARACTER VARYING(10) 10
15 MATCHED_REVERSAL_FLAG CHARACTER VARYING(1) 1
16 MONETARY_INDICATOR_FLAG CHARACTER VARYING(10) 10
17 TXN_CLASS_TYPE CHARACTER VARYING(50) 50
18 TXN_SUB_CLASS_TYPE CHARACTER VARYING(50) 50
19 TXN_HONOURED_TYPE CHARACTER VARYING(50) 50
20 TXN_INBOUND_FUND_TYPE CHARACTER VARYING(50) 50
21 TXN_CUSTOMER_INITIATED_FLAG CHARACTER VARYING(10) 10
22 TXN_MATCHED_REVERSAL_FLAG CHARACTER VARYING(1) 1
23 TXN_MONETARY_INDICATOR_FLAG CHARACTER VARYING(10) 10
24 TXN_FINANCIAL_CRIME_TYPE CHARACTER VARYING(1) 1
25 TXN_FINANCIAL_CRIME_SCOPE CHARACTER VARYING(1) 1
26 TXN_FINANCIAL_CRIME_INSTRUMENT CHARACTER VARYING(1) 1
27 TXN_FINANCIAL_CRIME_CHANNEL CHARACTER VARYING(1) 1
28 TXN_FINANCIAL_CRIME_REGION CHARACTER VARYING(1) 1
29 TXN_FINANCIAL_CRIME_USE_IN_SRC CHARACTER VARYING(1) 1
30 INFORM_CLASSIFICATION CHARACTER VARYING(50) 50
31 INFORM_CATEGORY CHARACTER VARYING(50) 50
32 INFORM_CATEGORY_GROUP CHARACTER VARYING(50) 50
33 CPR_CATEGORY_GROUP CHARACTER VARYING(50) 50
34 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
35 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
36 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
37 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8