GPAU_TFN_PAYER

(SQL Table)
Index Back

Payer Tax File Number

Payer Tax File No. details.

# 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_RPT_START_DT Date(10) DATE Period of report Start Date
4 GPAU_RPT_END_DT Date(10) DATE Period of report end date
5 GPAU_PSM_ABN Number(11,0) DECIMAL(11) NOT NULL Supplier ABN
6 GPAU_PSM_ABN_BR Character(3) VARCHAR2(3) NOT NULL Branch Number
7 GPAU_PAYENT_NM Character(200) VARCHAR2(200) NOT NULL Payer Name
8 GPAU_TRADE_NM Character(200) VARCHAR2(200) NOT NULL Payer Trading Name
9 GPAU_ADDR1 Character(38) VARCHAR2(38) NOT NULL Street Address - line 1
10 GPAU_ADDR2 Character(38) VARCHAR2(38) NOT NULL Street Address - line 2
11 GPAU_CITY Character(27) VARCHAR2(27) NOT NULL Suburb, town or city
12 GPAU_STATE Character(3) VARCHAR2(3) NOT NULL State
13 GPAU_POSTCD Character(4) VARCHAR2(4) NOT NULL Postcode
14 GPAU_CNTRY Character(20) VARCHAR2(20) NOT NULL Country
15 GPAU_CONTACT_NAME Character(38) VARCHAR2(38) NOT NULL Supplier Contact Name
16 GPAU_CONTACT_TEL Character(15) VARCHAR2(15) NOT NULL Supplier Contact Tel No
17 GPAU_CONTACT_FAX Character(15) VARCHAR2(15) NOT NULL Contact Fax No
18 GPAU_CONTACT_EMAIL Character(76) VARCHAR2(76) NOT NULL Contact's email address
19 GPAU_FILLER Character(200) VARCHAR2(200) NOT NULL Report filler