Exporting Purchase Order Line Items

The format of the Data

This export will allow you to export the data of a Purchase Order to a CSV file suitable for being imported as line items onto another system. This allows for easy, more reliable interaction between two companies. The exported data may also be manipulated for import into other applications that can import order information.

Since we are exporting to make it suitable for import as order information elsewhere the exported data is expressed in terms of the vendor of the purchase order. Specifically, the line items are exported using the VendorPartNumber instead of the internal part number.

This export only includes line item information. As such the only information is a PartNumber and a Quantity.

• Text - A textual value. May contain any character, but if it contains a line break, comma or double quote, it must be wrapped with double quotes on both ends. If a field is wrapped, all text must be inside the double quotes. Double quotes in the text value must be doubled to import properly
• Numeric - A decimal number greater than or equal to zero with up to four digits after the decimal point. The number must not have thousands' separators in it or dollar signs - 1234.56 is a valid number, while $1,234.56 is not.

Fields Describing the Purchase Order Line Items