GPAU_NABN_PAYEE(SQL Table) | 
Index Back | 
|---|---|
Payee details - No ABNPayee details - no ABN | 
| # | 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_EE_ABN | Character(11) | VARCHAR2(11) NOT NULL | Payee ABN | 
| 4 | GPAU_PAYENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Pay Entity Type | 
| 5 | GPAU_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Payee Surname | 
| 6 | GPAU_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Payee first name | 
| 7 | GPAU_MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Payee middle name | 
| 8 | GPAU_EE_NONIND_NM | Character(200) | VARCHAR2(200) NOT NULL | Non-individual payee name | 
| 9 | GPAU_PSM_TRADE_NM | Character(200) | VARCHAR2(200) NOT NULL | Payee Trading Name | 
| 10 | GPAU_ADDR1 | Character(38) | VARCHAR2(38) NOT NULL | Street Address - line 1 | 
| 11 | GPAU_ADDR2 | Character(38) | VARCHAR2(38) NOT NULL | Street Address - line 2 | 
| 12 | GPAU_CITY | Character(27) | VARCHAR2(27) NOT NULL | Suburb, town or city | 
| 13 | GPAU_STATE | Character(3) | VARCHAR2(3) NOT NULL | State | 
| 14 | GPAU_POSTCD | Character(4) | VARCHAR2(4) NOT NULL | Postcode | 
| 15 | GPAU_CNTRY | Character(20) | VARCHAR2(20) NOT NULL | Country | 
| 16 | GPAU_EE_TELNO | Character(15) | VARCHAR2(15) NOT NULL | Contact Tel No | 
| 17 | GPAU_EE_PAY_DT | Date(10) | DATE | Date of payment | 
| 18 | GPAU_PSM_GROSSPAY | Character(8) | VARCHAR2(8) NOT NULL | Gross Payments | 
| 19 | GPAU_PSM_TAXWHELD | Character(8) | VARCHAR2(8) NOT NULL | Total tax witheld | 
| 20 | GPAU_FILLER | Character(200) | VARCHAR2(200) NOT NULL | Report filler |