GPAU_SUPPLIER_3(SQL Table) |
Index Back |
|---|---|
Payment Summary ETFRecord 3 for layout of the Mangetic Media file to be sent to ATO - contains details of Payment Summary for employees |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPAU_PSM_REC_LEN | Character(3) | VARCHAR2(3) NOT NULL | Record Length |
| 2 | GPAU_PSM_IDENT | Character(14) | VARCHAR2(14) NOT NULL | Record Idenftifier |
| 3 | GPAU_ADDR1 | Character(38) | VARCHAR2(38) NOT NULL | Street Address - line 1 |
| 4 | GPAU_ADDR2 | Character(38) | VARCHAR2(38) NOT NULL | Street Address - line 2 |
| 5 | GPAU_CITY | Character(27) | VARCHAR2(27) NOT NULL | Suburb, town or city |
| 6 | GPAU_STATE | Character(3) | VARCHAR2(3) NOT NULL | State |
| 7 | GPAU_POSTCD | Character(4) | VARCHAR2(4) NOT NULL | Postcode |
| 8 | GPAU_CNTRY | Character(20) | VARCHAR2(20) NOT NULL | Country |
| 9 | GPAU_ADDR1_OTH | Character(38) | VARCHAR2(38) NOT NULL | Postal Address - line 1 |
| 10 | GPAU_ADDR2_OTH | Character(38) | VARCHAR2(38) NOT NULL | Postal Address - line 2 |
| 11 | GPAU_CITY_OTH | Character(27) | VARCHAR2(27) NOT NULL | Suburb, town or city |
| 12 | GPAU_STATE_OTH | Character(3) | VARCHAR2(3) NOT NULL | This contains the State or territory |
| 13 | GPAU_POSTCD_OTH | Character(4) | VARCHAR2(4) NOT NULL | This contains the Postcode |
| 14 | GPAU_CNTRY_OTH | Character(20) | VARCHAR2(20) NOT NULL | Country |
| 15 | GPAU_EMAIL_ADDR | Character(76) | VARCHAR2(76) NOT NULL | Supplier E-mail address |
| 16 | GPAU_FILLER | Character(200) | VARCHAR2(200) NOT NULL | Report filler |