DIM_BTTPS_REPORTING_PARTY_DATA_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 RECORD_LENGTH CHARACTER VARYING(4) 4
2 RECORD_IDENTIFIER CHARACTER VARYING(4) 4
3 REPORT_START_DATE CHARACTER VARYING(200) 200
4 REPORT_END_DATE CHARACTER VARYING(200) 200
5 ABN CHARACTER VARYING(11) 11
6 BRANCH_NUMBER CHARACTER VARYING(3) 3
7 REGISTERED_NAME CHARACTER VARYING(22) 22
8 TRADING_NAME CHARACTER VARYING(1) 1
9 STREET_ADDR_LINE_1 CHARACTER VARYING(26) 26
10 STREET_ADDR_LINE_2 CHARACTER VARYING(1) 1
11 STREET_SUBURB_TOWN_LOCALITY CHARACTER VARYING(8) 8
12 STREET_STATE_OR_TERRITORY CHARACTER VARYING(3) 3
13 STREET_ADDRESS_POSTCODE CHARACTER VARYING(4) 4
14 STREET_ADDRESS_COUNTRY CHARACTER VARYING(1) 1
15 POSTAL_ADDR_LINE_1 CHARACTER VARYING(12) 12
16 POSTAL_ADDR_LINE_2 CHARACTER VARYING(1) 1
17 POSTAL_SUBURB_TOWN_LOCALITY CHARACTER VARYING(8) 8
18 POSTAL_STATE_OR_TERRITORY CHARACTER VARYING(3) 3
19 POSTAL_ADDRESS_POSTCODE CHARACTER VARYING(4) 4
20 POSTAL_ADDRESS_COUNTRY CHARACTER VARYING(1) 1
21 CONTACT_NAME CHARACTER VARYING(12) 12
22 CONTACT_PH_AREA_CODE CHARACTER VARYING(2) 2
23 CONTACT_PHONE_NUMBER CHARACTER VARYING(8) 8
24 CONTACT_EMAIL CHARACTER VARYING(27) 27
25 SOFTWARE_PRODUCT_TYPE CHARACTER VARYING(64) 64
26 FILLER CHARACTER VARYING(1) 1
27 LEVEL1_RANK INTEGER 4
28 LEVEL2_RANK INTEGER 4
29 LEVEL3_RANK INTEGER 4