GPAU_PAYER_IDEN

(SQL Table)
Index Back

Payer Identification

Payer Identification record for Payment Summary Electronic file.

# 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_PSM_ABN Number(11,0) DECIMAL(11) NOT NULL Supplier ABN
4 GPAU_PSM_ABN_BR Character(3) VARCHAR2(3) NOT NULL Branch Number
5 GPAU_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing
6 GPAU_PAYENT_NM Character(200) VARCHAR2(200) NOT NULL Payer Name
7 GPAU_TRADE_NM Character(200) VARCHAR2(200) NOT NULL Payer Trading Name
8 GPAU_ADDR1 Character(38) VARCHAR2(38) NOT NULL Street Address - line 1
9 GPAU_ADDR2 Character(38) VARCHAR2(38) NOT NULL Street Address - line 2
10 GPAU_CITY Character(27) VARCHAR2(27) NOT NULL Suburb, town or city
11 GPAU_STATE Character(3) VARCHAR2(3) NOT NULL State
12 GPAU_POSTCD Character(4) VARCHAR2(4) NOT NULL Postcode
13 GPAU_CNTRY Character(20) VARCHAR2(20) NOT NULL Country
14 GPAU_CONTACT_NAME Character(38) VARCHAR2(38) NOT NULL Supplier Contact Name
15 GPAU_CONTACT_TEL Character(15) VARCHAR2(15) NOT NULL Supplier Contact Tel No
16 GPAU_CONTACT_FAX Character(15) VARCHAR2(15) NOT NULL Contact Fax No
17 GPAU_ETP_TYPE Character(1) VARCHAR2(1) NOT NULL ETP Payer Type