BPAY_BILLERDETAILS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BTTPS_BPAY_BILLERDETAILS

Columns
# Name Data Type Length
1 BILLER_ID NUMERIC(10,0) 19
2 BILLER_ABN CHARACTER(15) 15
3 ADDRESS_LINE CHARACTER(150) 150
4 POSTCODE CHARACTER(10) 10
5 STATE CHARACTER(10) 10
6 SUBURB CHARACTER(64) 64
7 AUDIT_CREATED_DATE CHARACTER(30) 30
8 AUDIT_UPDATED_DATE CHARACTER(30) 30
9 AUDIT_CREATED_USER CHARACTER(10) 10
10 AUDIT_UPDATED_USER CHARACTER(10) 10
11 BPAY_TYPE_IND CHARACTER(255) 255
12 EMAIL_ADDRESS CHARACTER(250) 250
13 CONTACT_FAX CHARACTER(15) 15
14 CONTACT_NAME CHARACTER(20) 20
15 CONTACT_PHONE CHARACTER(15) 15
16 FEE_ACCT_BSB CHARACTER(6) 6
17 FEE_ACCT_NAME CHARACTER(160) 160
18 FEE_ACCT_NO CHARACTER(23) 23
19 GST_STATUS_IND CHARACTER(255) 255
20 LONG_NAME CHARACTER(50) 50
21 ACTIVATION_DATE CHARACTER(30) 30
22 ANZSIC_CODE CHARACTER(10) 10
23 CHK_DGT_RULE_NAME CHARACTER(50) 50
24 CIS_REF_NO CHARACTER(20) 20
25 CRN_LENGTH_DESC CHARACTER(100) 100
26 CRN_LOCATION_IND CHARACTER(20) 20
27 CRN_VALIDATION_ROUTINE_DESC CHARACTER(100) 100
28 CUSTOMER_REFERENCE_NAME CHARACTER(100) 100
29 FEE_REVIEW_DATE CHARACTER(30) 30
30 FIN_PACKAGE_DESC CHARACTER(20) 20
31 FIXED_DIGIT_MASKS CHARACTER(50) 50
32 MAX_CREDIT_TRANS_AMT NUMERIC(9,2) 19
33 MAX_DEBIT_TRANS_AMT NUMERIC(9,2) 19
34 MERCHANT_CTGY_CODE CHARACTER(4) 4
35 MIN_TRANS_AMT NUMERIC(9,2) 19
36 REFERRER_IND CHARACTER(50) 50
37 OVERRIDE_RECEIVER_CODE CHARACTER(255) 255
38 REMITTER_NAMING_IND CHARACTER(20) 20
39 ROW_VERSION_ID NUMERIC(19,0) 19
40 SALES_PERSON_USERNAME CHARACTER(7) 7
41 SETTLEMENT_ACCT_BSB CHARACTER(6) 6
42 SETTLEMENT_ACCT_NAME CHARACTER(160) 160
43 SETTLEMENT_ACCT_NO CHARACTER(23) 23
44 SHORT_NAME CHARACTER(20) 20
45 BILLER_STATUS_IND CHARACTER(20) 20
46 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
47 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
48 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
49 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8