bpay_billerdetails

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 biller_id numeric 10
2 biller_abn character varying 45
3 address_line character varying 450
4 postcode character varying 30
5 state character varying 30
6 suburb character varying 192
7 audit_created_date character varying 90
8 audit_updated_date character varying 90
9 audit_created_user character varying 30
10 audit_updated_user character varying 30
11 bpay_type_ind character varying 765
12 email_address character varying 750
13 contact_fax character varying 45
14 contact_name character varying 60
15 contact_phone character varying 45
16 fee_acct_bsb character varying 18
17 fee_acct_name character varying 480
18 fee_acct_no character varying 69
19 gst_status_ind character varying 765
20 long_name character varying 150
21 activation_date character varying 90
22 anzsic_code character varying 30
23 chk_dgt_rule_name character varying 150
24 cis_ref_no character varying 60
25 crn_length_desc character varying 300
26 crn_location_ind character varying 60
27 crn_validation_routine_desc character varying 300
28 customer_reference_name character varying 300
29 fee_review_date character varying 90
30 fin_package_desc character varying 60
31 fixed_digit_masks character varying 150
32 max_credit_trans_amt numeric 9
33 max_debit_trans_amt numeric 9
34 merchant_ctgy_code character varying 12
35 min_trans_amt numeric 9
36 referrer_ind character varying 150
37 override_receiver_code character varying 765
38 remitter_naming_ind character varying 60
39 row_version_id numeric 19
40 sales_person_username character varying 21
41 settlement_acct_bsb character varying 18
42 settlement_acct_name character varying 480
43 settlement_acct_no character varying 69
44 short_name character varying 60
45 biller_status_ind character varying 60