INT_HOG_NROD_HTDA_ODS_TRANSACTIONS_1

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..INT_HOG_NROD_HTDA_ODS_TRANSACTIONS_1_V

Columns
# Name Data Type Length
1 RUN_TIMESTAMP CHARACTER VARYING(200) 200
2 SOURCE_TXN_UNIQUE_ID CHARACTER VARYING(26) 26
3 SOURCE_TXN_NUM BIGINT 8
4 ACCOUNT_SOURCE_UNIQUE_ID CHARACTER VARYING(26) 26
5 ACCOUNT_SOURCE_REF_ID BIGINT 8
6 CUSTOMER_SOURCE_UNIQUE_ID INTEGER 4
7 PRIMARY_CUST_SRCE_REF_ID INTEGER 4
8 BRANCH_ID CHARACTER VARYING(36) 36
9 OWN_ACCOUNT_TRANSFER CHARACTER VARYING(1) 1
10 CURRENCY_CODE_ORIG CHARACTER VARYING(3) 3
11 CURRENCY_CODE_BASE CHARACTER VARYING(3) 3
12 ORIGINATION_DATE CHARACTER VARYING(200) 200
13 POSTING_DATE CHARACTER VARYING(200) 200
14 VALUE_DATE CHARACTER VARYING(200) 200
15 SYSTEM_TIMESTAMP CHARACTER VARYING(18) 18
16 LOCAL_TIMESTAMP CHARACTER VARYING(1) 1
17 PRODUCT_SOURCE_TYPE_CODE CHARACTER VARYING(10) 10
18 TXN_VOLUME INTEGER 4
19 DEVICE_ID CHARACTER VARYING(8) 8
20 TXN_AMOUNT_ORIG CHARACTER VARYING(1) 1
21 TXN_AMOUNT_BASE DOUBLE PRECISION 8
22 CREDIT_DEBIT_CODE CHARACTER VARYING(1) 1
23 TRANS_REF_DESC CHARACTER VARYING(47) 47
24 TRANS_REF_DESC_2 CHARACTER VARYING(1) 1
25 TRANS_REF_DESC_3 CHARACTER VARYING(1) 1
26 TRANS_REF_DESC_4 CHARACTER VARYING(1) 1
27 TRANS_REF_DESC_5 CHARACTER VARYING(1) 1
28 TRANS_REF_DESC_6 CHARACTER VARYING(1) 1
29 CLIENT_DE_PASSAGE CHARACTER VARYING(1) 1
30 TXN_STATUS_CODE CHARACTER VARYING(1) 1
31 SOURCE_SYSTEM_CODE CHARACTER VARYING(9) 9
32 ERROR_CORRECT_FLAG CHARACTER VARYING(1) 1
33 TRANSACTION_LOCATION CHARACTER VARYING(1) 1
34 ORG_UNIT_CODE CHARACTER VARYING(7) 7
35 TXN_USR_DTLS CHARACTER VARYING(20) 20
36 DVC_POS_ENTRY_MODE CHARACTER VARYING(1) 1
37 PIN_VERIFY_CD CHARACTER VARYING(1) 1
38 CARD_ID CHARACTER VARYING(1) 1
39 EMPLOYEE_ID CHARACTER VARYING(32) 32
40 COUNTER_PARTY_NAME CHARACTER VARYING(1) 1
41 COUNTER_PARTY_ADDRESS CHARACTER VARYING(1) 1
42 COUNTER_PARTY_ZONE CHARACTER VARYING(1) 1
43 COUNTER_PARTY_POSTAL_CODE CHARACTER VARYING(1) 1
44 COUNTER_PARTY_CITY CHARACTER VARYING(1) 1
45 COUNTER_PARTY_COUNTRY_CODE CHARACTER VARYING(1) 1
46 COUNTER_PARTY_ACCOUNT_NUM CHARACTER VARYING(1) 1
47 COUNTER_PARTY_ACCOUNT_NAME CHARACTER VARYING(1) 1
48 COUNTER_PARTY_ACCOUNT_TYPE CHARACTER VARYING(1) 1
49 COUNTER_PARTY_ACCOUNT_IBAN CHARACTER VARYING(1) 1
50 COUNTER_PARTY_ACCOUNT_BIC CHARACTER VARYING(1) 1
51 COUNTER_PARTY_BANK_NAME CHARACTER VARYING(1) 1
52 COUNTER_PARTY_BANK_CODE CHARACTER VARYING(1) 1
53 COUNTER_PARTY_BANK_ADDRESS CHARACTER VARYING(1) 1
54 COUNTER_PARTY_BANK_CITY CHARACTER VARYING(1) 1
55 COUNTER_PARTY_BANK_ZONE CHARACTER VARYING(1) 1
56 COUNTER_PARTY_BANK_POSTAL_CODE CHARACTER VARYING(1) 1
57 COUNTER_PARTY_BNK_CNTRY_CD CHARACTER VARYING(1) 1
58 ORIGINATOR_NAME CHARACTER VARYING(20) 20
59 BENEFICIARY_NAME CHARACTER VARYING(20) 20
60 ORIGINATOR_BANK_NAME CHARACTER VARYING(1) 1
61 BENEFICIARY_BANK_NAME CHARACTER VARYING(1) 1
62 TELLER_ID CHARACTER VARYING(1) 1
63 CARD_SOURCE_REF_ID CHARACTER VARYING(1) 1
64 CHECK_NUMBER BIGINT 8
65 CHECK_ACCOUNT_NUMBER CHARACTER VARYING(1) 1
66 CHECK_AMOUNT DOUBLE PRECISION 8
67 CASHBACK_AMT DOUBLE PRECISION 8
68 NEW_TXN_CODE CHARACTER VARYING(28) 28
69 TXN_CHANNEL_CODE CHARACTER VARYING(4) 4