FCT_SNTA_AML_TRANSACTIONS_HIST_INSIGHT

Database

INSNZP01_WEALTH

Schema

WEALTHPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 RUN_DATE CHARACTER VARYING(200) 200
2 SOURCE_TXN_UNIQUE_ID CHARACTER VARYING(37) 37
3 SOURCE_TXN_NUM NUMERIC(10,0) 19
4 ACCOUNT_SOURCE_UNIQUE_ID CHARACTER VARYING(13) 13
5 CUSTOMER_SOURCE_UNIQUE_ID BIGINT 8
6 BRANCH_ID CHARACTER VARYING(1) 1
7 TXN_TYPE_CODE NUMERIC(11,0) 19
8 OWN_ACCOUNT_TRANSFER CHARACTER VARYING(1) 1
9 CURRENCY_CODE CHARACTER(3) 3
10 ORIGINATION_DATE CHARACTER VARYING(1) 1
11 PST_DT_TM 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 CHARACTER VARYING(13) 13
16 TXN_VOLUME CHARACTER VARYING(1) 1
17 DEVICE_ID CHARACTER VARYING(1) 1
18 TXN_AMOUNT_FX CHARACTER VARYING(1) 1
19 TXN_AMOUNT_TOTAL NUMERIC(13,2) 19
20 TXN_AMOUNT_CASH CHARACTER VARYING(1) 1
21 TXN_AMOUNT_CHQ CHARACTER VARYING(1) 1
22 TXN_AMOUNT_TFR CHARACTER VARYING(1) 1
23 TXN_AMOUNT_OTH CHARACTER VARYING(1) 1
24 CREDIT_DEBIT_CODE CHARACTER VARYING(1) 1
25 TRANS_REF_DESC CHARACTER VARYING(1) 1
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(6) 6
35 ERROR_CORRECT_FLAG CHARACTER VARYING(1) 1
36 TRANSACTION_LOCATION CHARACTER VARYING(1) 1
37 ORG_UNIT_CODE CHARACTER VARYING(7) 7
38 TXN_USR_DTLS CHARACTER VARYING(30) 30
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(38,12) 19
69 SEGMENT CHARACTER VARYING(6) 6
70 CHQ_NUMBER CHARACTER VARYING(1) 1
71 AF_PST_BAL NUMERIC(38,12) 19
72 PREV_ACCT_BAL CHARACTER VARYING(1) 1
73 CORRESPONDENCE_CODE CHARACTER VARYING(1) 1
74 TRACE_ID CHARACTER VARYING(1) 1
75 PROCESSED_DATE TIMESTAMP 8
76 ACCOUNT_TRANSACTION_ID NUMERIC(10,0) 19