DIM_OBP_TRANSACTIONS_TYP2

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..DIM_OBP_TRANSACTIONS_TYP2_V

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