Par Location Count and Physical Accounting File Formats

PeopleSoft Inventory provides two transactions that can be processed using batch flat files that are downloaded and uploaded using SQR programs.

The system uses batch processes to generate a flat file containing the item to be counted for either of the transactions. The flat file is passed to a third-party electronic data collection system that performs the count. The flat file must then be returned to PeopleSoft in the same format.

The files that you download to and upload from electronic data collection devices must conform to these rules:

• The file name must be eight characters or less.

  An extension of .upl is automatically appended to upload file names. An extension of .dwn is automatically appended to download file names.

• The first field must start in column one.

• There must be a single blank space between each field.

• All fields must be left-justified.

• The system expects the file that is read by the upload process to have a .upl extension.