|
|
Purchase order data files must be formatted specifically for upload to the Trade Services system. Following are guidelines for preparation of the data file:
Data in the file can be either delimited or fixed length; you define the data and file format in the PO definition used to upload the data file. If the file is delimited, the delimiter character can be a comma, semicolon, or tab character.
The following data fields are required in the data file to be uploaded: amount, ben_name (beneficiary name), currency, po_num (PO number) and line_num (line number). If data is missing for any of these fields, the file will not upload.
If the data fields are defined as delimited in the PO definition used to upload the file, then the maximum field length defined for each field in the PO definition must not be exceeded in the data file.
If the data fields are defined as fixed length in the PO definition used to upload the file, then the field length of each field must exactly match those in the PO definition.
The data file can have any name, but must be saved as an ASCII/Text Only file.
Most file format problems encountered by the system are logged in the PO upload log.