Purchase Order Line Export
What the Purchase Order Line export contains and the meaning of each field.
Overview
The Purchase Order Line export contains the individual lines of purchase orders that have been sent to you by your customers. Each row represents one purchase order line addressed to your supplier team, including the ordered item, quantities, pricing, delivery and shipping addresses, and the status of the parent purchase order.
Use this export for order fulfilment, delivery planning, and reconciling purchase order lines against your own order management or ERP systems.
Generating the Export
Navigate to Settings → Files → Exports and create a new export with the type Purchase Order Line.
You can optionally set a row limit to cap the size of the export.
Fields
The export includes Client Id, Client Name, Store Id and Store Name because it is generated for your supplier team. The same export requested by a client for a specific store contains Supplier Id and Supplier Name in their place.
| Column | Description |
|---|---|
Header Link | Identifier of the purchase order this line belongs to. |
Human Po Identifier | Human-readable purchase order number of the parent purchase order. |
Unique Line Primary Key | Unique identifier of the purchase order line. |
Line Reference On Po | Line reference (line number) of this line within the purchase order. |
Item Polymorphic Type | Type of the record the ordered item refers to. |
Item Id | Identifier of the ordered item record. |
Ordered Qty | Quantity ordered on this line. |
Price Per Unit | Price per unit, as a decimal in the currency shown in Currency Code. |
Tax Total Per Line | Total tax amount for the line, as a decimal in the currency shown in Currency Code. |
Line Grand Total | Total price of the line including tax, as a decimal in the currency shown in Currency Code. |
Currency Code | Currency code of the line's monetary values. |
Requested Delivery | Date and time the customer requested delivery by (ISO 8601), or empty if not set. |
Upstream Order Reference | Identifier of the order the parent purchase order was created from. |
Client Id | Identifier of the customer (client) the purchase order line came from. |
Client Name | Name of the customer (client) the purchase order line came from. |
Store Id | Identifier of the store the purchase order line was placed through. |
Store Name | Name of the store the purchase order line was placed through. |
Cross-Po Link | Identifier of a related purchase order this line is linked to, if any. |
External Line Item Id | External line item identifier for the line, if any. |
Deliver To Address Name | Name on the deliver-to address. |
Deliver To Address Line One | First line of the deliver-to address. |
Deliver To Address Line Two | Second line of the deliver-to address. |
Deliver To Address City | City of the deliver-to address. |
Deliver To Address Province | Province or state of the deliver-to address. |
Deliver To Address Postal Code | Postal code of the deliver-to address. |
Deliver To Address Country Code | Country code of the deliver-to address. |
Ship To Address Name | Name on the ship-to address. |
Ship To Address Line One | First line of the ship-to address. |
Ship To Address Line Two | Second line of the ship-to address. |
Ship To Address City | City of the ship-to address. |
Ship To Address Province | Province or state of the ship-to address. |
Ship To Address Postal Code | Postal code of the ship-to address. |
Ship To Address Country Code | Country code of the ship-to address. |
Ship From Address Name | Name on the ship-from address. |
Ship From Address Line One | First line of the ship-from address. |
Ship From Address Line Two | Second line of the ship-from address. |
Ship From Address City | City of the ship-from address. |
Ship From Address Province | Province or state of the ship-from address. |
Ship From Address Postal Code | Postal code of the ship-from address. |
Ship From Address Country Code | Country code of the ship-from address. |
Convenience Name | Name of the ordered item, taken from the line's item details. |
Convenience Description | Description of the ordered item, taken from the line's item details. |
Free-Form Metadata | Additional free-form data stored against the line, as a JSON object. |
Item Details Payload | Full details of the ordered item, as a JSON object. |
Header Status | Status of the parent purchase order. One of draft, sent, acknowledged, confirmed, invoiced, rejected, cancelled. |
Line Created Timestamp | Date and time when the line was created (ISO 8601). |
Line Updated Timestamp | Date and time when the line was last updated (ISO 8601). |