PeopleSoft purchase order numbers

The PeopleSoft ERP system uses a double key to identify a unique purchase order number in the PS_PO_HDR purchase order header table. This key consists of the purchase order number and the purchasing business unit.

The PeopleSoft ERP system uses the following unique keys.

  • PO_ID

  • BUSINESS_UNIT

PeopleSoft users a vendorID/site ID combination to identify a unique single vendor a single address. The PeopleSoft ERP table references for these are VENDOR_ID and Vndr_LOC.

Additionally, the purchase order header table does not contain a company code. The general PeopleSoft equivalent of the company code is the payables business unit. The payable business unit (company code) is set in one of the following ways:

  • Configured in the Settings > Invoice Processing > Global Settings > Import Settings.

  • Extracted using a database locator that is based on the bill-to details on the invoice.