INT_BTTPS_BPAY_TRANSACTIONS_V

Database

SDSNZP02_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_CUST_REF NUMERIC(10,0) 19
4 TRAN_SUMM_PAYMENT_SYSTEM CHARACTER VARYING(11) 11
5 TRAN_SUMM_PAYMENT_SYSTEM_ACCT_NBR CHARACTER VARYING(23) 23
6 TRAN_SUMM_SETTLEMENT_BANK_ACCOUNT_NAME CHARACTER(160) 160
7 TRAN_SUMM_SETTLEMENT_BSB_NBR CHARACTER(6) 6
8 TRAN_SUMM_SETTLEMENT_ACCT_NBR CHARACTER(23) 23
9 TRANSACTION_PERIOD_ST_DATE CHARACTER VARYING(8) 8
10 TRANSACTION_PERIOD_END_DATE CHARACTER VARYING(200) 200
11 TRANSACTION_CURRENCY CHARACTER(20) 20
12 GROSS_PAYMENT_AMOUNT NUMERIC(38,2) 19
13 GROSS_PAYMENT_COUNT BIGINT 8
14 REFUND_PAYMENT_AMOUNT NUMERIC(38,2) 19
15 REFUND_PAYMENT_COUNT NUMERIC(38,0) 19
16 CASH_ONLY_AMOUNT NUMERIC(38,2) 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