FCT_BNK_AML_TRANSACTIONS_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_BNK_AML_TRANSACTIONS

Columns
# Name Data Type Length
1 RUN_DATE CHARACTER VARYING(200) 200
2 SOURCE_TXN_UNIQUE_ID CHARACTER VARYING(50) 50
3 SOURCE_TXN_NUM CHARACTER VARYING(50) 50
4 ACCOUNT_SOURCE_UNIQUE_ID BIGINT 8
5 CUSTOMER_SOURCE_UNIQUE_ID BIGINT 8
6 BRANCH_ID CHARACTER VARYING(10) 10
7 TXN_SOURCE_TYPE_CODE BIGINT 8
8 OWN_ACCOUNT_TRANSFER CHARACTER VARYING(1) 1
9 CURRENCY_CODE CHARACTER VARYING(3) 3
10 ORIGINATION_DATE CHARACTER VARYING(200) 200
11 POSTING_DATE CHARACTER VARYING(200) 200
12 VALUE_DATE CHARACTER VARYING(200) 200
13 SYSTEM_TIMESTAMP CHARACTER VARYING(1) 1
14 LOCAL_TIMESTAMP CHARACTER VARYING(1) 1
15 PRODUCT_SOURCE_TYPE_CODE BIGINT 8
16 TXN_VOLUME INTEGER 4
17 DEVICE_ID BIGINT 8
18 TXN_AMOUNT_FX NUMERIC(18,2) 19
19 TXN_AMOUNT_TOTAL NUMERIC(18,2) 19
20 TXN_AMOUNT_CASH NUMERIC(18,2) 19
21 TXN_AMOUNT_CHQ NUMERIC(18,2) 19
22 TXN_AMOUNT_TFR NUMERIC(18,2) 19
23 TXN_AMOUNT_OTH INTEGER 4
24 CREDIT_DEBIT_CODE CHARACTER VARYING(50) 50
25 TRANS_REF_DESC CHARACTER VARYING(500) 500
26 TRANS_REF_DESC_2 CHARACTER VARYING(1) 1
27 TRANS_REF_DESC_3 CHARACTER VARYING(1) 1
28 TRANS_REF_DESC_4 CHARACTER VARYING(1) 1
29 TRANS_REF_DESC_5 CHARACTER VARYING(1) 1
30 TRANS_REF_DESC_6 CHARACTER VARYING(1) 1
31 CLIENT_DE_PASSAGE CHARACTER VARYING(1) 1
32 TXN_STATUS_CODE CHARACTER VARYING(1) 1
33 TXN_CHANNEL_CODE CHARACTER VARYING(1) 1
34 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
35 ERROR_CORRECT_FLAG CHARACTER VARYING(1) 1
36 TRANSACTION_LOCATION CHARACTER VARYING(1) 1
37 ORG_UNIT_CODE CHARACTER VARYING(10) 10
38 TXN_USR_DTLS CHARACTER VARYING(1) 1
39 POS_ENTRY_MODE CHARACTER VARYING(1) 1
40 PIN_VERIFY_CD CHARACTER VARYING(1) 1
41 CVV_VERIFY CHARACTER VARYING(1) 1
42 CARD_SOURCE_REF_ID CHARACTER VARYING(1) 1
43 DEBIT_PARTY_NAME CHARACTER VARYING(1) 1
44 DEBIT_PARTY_ADDRESS CHARACTER VARYING(1) 1
45 DEBIT_PARTY_COUNTRY CHARACTER VARYING(1) 1
46 DEBIT_PARTY_ACC_NUM CHARACTER VARYING(1) 1
47 CREDIT_PARTY CHARACTER VARYING(1) 1
48 CREDIT_PARTY_ADDRESS CHARACTER VARYING(1) 1
49 CREDIT_PARTY_COUNTRY CHARACTER VARYING(1) 1
50 CREDIT_PARTY_ACC_NUM CHARACTER VARYING(1) 1
51 ORIGINATOR CHARACTER VARYING(1) 1
52 ORIGINATOR_PARTY_ADDRESS CHARACTER VARYING(1) 1
53 ORIGINATOR_PARTY_COUNTRY CHARACTER VARYING(1) 1
54 ORIGINATOR_PARTY_ACC_NUM CHARACTER VARYING(1) 1
55 BENEFICIARY CHARACTER VARYING(1) 1
56 BENEFICIARY_PARTY_ADDRESS CHARACTER VARYING(1) 1
57 BENEFICIARY_PARTY_COUNTRY CHARACTER VARYING(1) 1
58 BENEFICIARY_PARTY_ACC_NUM CHARACTER VARYING(1) 1
59 BENEFICIARY_BANK_NAME CHARACTER VARYING(1) 1
60 BENEFICIARY_BANK_ADDRESS CHARACTER VARYING(1) 1
61 BENEFICIARY_BANK_COUNTRY CHARACTER VARYING(1) 1
62 BENEFICIARY_BANK_ACC_NUM CHARACTER VARYING(1) 1
63 COUNTER_PARTY_ACCOUNT_ID CHARACTER VARYING(1) 1
64 COUNTER_PARTY_ACCOUNT_NAME CHARACTER VARYING(1) 1
65 COUNTER_PARTY_ACCOUNT_IBAN CHARACTER VARYING(1) 1
66 COUNTER_PARTY_ACCOUNT_BIC CHARACTER VARYING(1) 1
67 COUNTER_PARTY_COUNTRY_CODE CHARACTER VARYING(1) 1
68 ACCOUNT_BALANCE NUMERIC(18,2) 19
69 SEGMENT CHARACTER(3) 3
70 CHQ_NUMBER CHARACTER VARYING(50) 50
71 AF_PST_BAL NUMERIC(18,2) 19
72 PREV_ACCT_BAL CHARACTER VARYING(1) 1
73 CORRESPONDENCE_CODE CHARACTER VARYING(1) 1
74 TRACE_ID CHARACTER VARYING(50) 50