INT_BTTPS_BPAY_DETAILS_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 BD_RECLENGTH CHARACTER VARYING(4) 4
2 BD_RECIDENT CHARACTER VARYING(4) 4
3 BILLER_ID CHARACTER VARYING(10) 10
4 BPAY_ACTIVATION_DATE CHARACTER VARYING(200) 200
5 ABN_NBR CHARACTER VARYING(200) 200
6 ACN CHARACTER VARYING(200) 200
7 REGISTERED_NAME CHARACTER VARYING(81) 81
8 TRADING_NAME CHARACTER VARYING(50) 50
9 BPAY_STREET_ADDRESS_1 CHARACTER VARYING(150) 150
10 BPAY_STREET_ADDRESS_2 CHARACTER VARYING(150) 150
11 BPAY_STREET_ADDRESS_CITY CHARACTER(64) 64
12 BPAY_STREET_ADDRESS_STATE CHARACTER VARYING(10) 10
13 BPAY_STREET_ADDRESS_PCODE CHARACTER VARYING(25) 25
14 BPAY_STREET_ADDRESS_CNTRY_CD CHARACTER VARYING(3) 3
15 BPAY_POSTAL_ADDRESS_1 CHARACTER VARYING(150) 150
16 BPAY_POSTAL_ADDRESS_2 CHARACTER VARYING(150) 150
17 BPAY_POSTAL_ADDRESS_CITY CHARACTER VARYING(64) 64
18 BPAY_POSTAL_ADDRESS_STATE CHARACTER VARYING(15) 15
19 BPAY_POSTAL_ADDRESS_PCODE CHARACTER VARYING(10) 10
20 BPAY_POSTAL_ADDRESS_CNTRY_CD CHARACTER VARYING(2) 2
21 CONTACT_NAME CHARACTER(25) 25
22 CONTACT_PHONE CHARACTER VARYING(15) 15
23 BPAY_CONTACT_PH_AREA_CODE CHARACTER VARYING(2) 2
24 BPAY_CONTACT_PH_NBR CHARACTER VARYING(8) 8
25 EMAIL_ADDRESS CHARACTER VARYING(250) 250
26 BPAY_GRP_LVL_ID CHARACTER VARYING(1) 1
27 BPAY_BUS_CATEGORY_DESC CHARACTER VARYING(40) 40
28 LODGEMENT_TYPE CHARACTER VARYING(1) 1
29 MERCHANT_FILLER CHARACTER VARYING(1) 1
30 LEVEL1_RANK INTEGER 4
31 LEVEL2_RANK BIGINT 8
32 LEVEL3_RANK INTEGER 4