FCT_BTTPS_TRANSACTION_SUMMARY_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 TRAN_SUMM_REC_LENGTH CHARACTER VARYING(4) 4
2 TRAN_SUMM_REC_IDENT CHARACTER VARYING(4) 4
3 TRAN_SUMM_CRN CHARACTER VARYING(23) 23
4 TRAN_SUMM_PAYMENT_SYSTEM CHARACTER VARYING(26) 26
5 TRAN_SUMM_PAYMENT_SYSTEM_ACCT_NBR CHARACTER VARYING(23) 23
6 TRAN_SUMM_SETTLEMENT_BANK_ACCOUNT_NAME CHARACTER VARYING(160) 160
7 TRAN_SUMM_SETTLEMENT_BSB_NBR CHARACTER VARYING(10) 10
8 TRAN_SUMM_SETTLEMENT_ACCT_NBR CHARACTER VARYING(23) 23
9 TRANSACTION_PERIOD_ST_DATE CHARACTER VARYING(200) 200
10 TRANSACTION_PERIOD_END_DATE CHARACTER VARYING(200) 200
11 TRANSACTION_CURRENCY CHARACTER VARYING(20) 20
12 GROSS_PAYMENT_AMOUNT NUMERIC(36,0) 19
13 GROSS_PAYMENT_COUNT NUMERIC(38,0) 19
14 REFUND_PAYMENT_AMOUNT NUMERIC(36,0) 19
15 REFUND_PAYMENT_COUNT NUMERIC(38,0) 19
16 CASH_ONLY_AMOUNT NUMERIC(36,0) 19
17 CASH_ONLY_COUNT NUMERIC(38,0) 19
18 CASH_OUT_COMPONENT NUMERIC(38,0) 19
19 TRANS_SUMMARY_FILLER CHARACTER VARYING(1) 1
20 LEVEL1_RANK INTEGER 4
21 LEVEL2_RANK BIGINT 8
22 LEVEL3_RANK BIGINT 8