GPAU_TFN_SPPLR(SQL Table) |
Index Back |
|---|---|
TFN Supplier - AustraliaThis table will be used to record the TFN Supplier Information that will be used for the TFN Declaration report required by the ATO. This table will not have any key fields. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT_OPR_VW |
| 2 | GPAU_ABN | Character(11) | VARCHAR2(11) NOT NULL | A unique number used by the ATO to identify a contractor. |
| 3 | GPAU_STP_TAN | Number(8,0) | INTEGER NOT NULL | Registered Agent Name - TFN Supplier Data |
| 4 | GPAU_ATO_SPECS_NO | Character(10) | VARCHAR2(10) NOT NULL | The ATO specification number that is included in the TFN Declaration Report. |
| 5 | GPAU_ATO_USER_ID | Character(10) | VARCHAR2(10) NOT NULL | The ATO Gateway User ID that is included in the TFN Declaration report. |
| 6 | GPAU_REGISTERED_NM | Character(200) | VARCHAR2(200) NOT NULL | This is the pay entity's registered name (company registered name). |
| 7 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |
| 8 | GPAU_ATO_REF_FILE | Character(16) | VARCHAR2(16) NOT NULL | The Supplier's File Reference that is included in the TFN Declaration report. |
| 9 | GPAU_SSP_NM | Character(200) | VARCHAR2(200) NOT NULL | GP Aus: STP Enhancements |
| 10 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 11 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 12 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 13 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 14 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 15 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 16 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 17 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 18 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 19 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 20 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 21 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 22 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 23 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 24 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 25 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 26 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 27 | COUNTRY_OTHER | Character(3) | VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
Prompt Table: COUNTRY_TBL |
| 28 | ADDRESS1_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 1 Other |
| 29 | ADDRESS2_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 2 Other |
| 30 | ADDRESS3_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 3 Other |
| 31 | ADDRESS4_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 4 Other |
| 32 | CITY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | City Other |
| 33 | COUNTY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | County Other |
| 34 | STATE_OTHER | Character(6) | VARCHAR2(6) NOT NULL |
State Other
Prompt Table: STATE_OTH |
| 35 | POSTAL_OTHER | Character(12) | VARCHAR2(12) NOT NULL | Postal Other |
| 36 | NUM1_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 1 Other |
| 37 | NUM2_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 2 Other |
| 38 | HOUSE_TYPE_OTHER | Character(2) | VARCHAR2(2) NOT NULL |
House Type Other
AB=House Boat Reference WW=House Trailer Reference |
| 39 | ADDR_FIELD1_OTHER | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 Other |
| 40 | ADDR_FIELD2_OTHER | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 Other |
| 41 | ADDR_FIELD3_OTHER | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 Other |
| 42 | IN_CITY_LMT_OTHER | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit Other
Y/N Table Edit |
| 43 | GEO_CODE_OTHER | Character(11) | VARCHAR2(11) NOT NULL | Geo Code Other |
| 44 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 45 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 46 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone number extension |
| 47 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
| 48 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |