GPAU_NABN_PAYEE

(SQL Table)
Index Back

Payee details - No ABN

Payee 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