> For the complete documentation index, see [llms.txt](https://docs.eu-pactum.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.eu-pactum.com/procurement-product/exporting.md).

# Exporting results

When exporting results from Pactum, you will obtain a table with the results.

The table contains one line item per row; if one negotiation contains multiple line items, values which don't differ between line items are duplicated.

Below you'll find a description of all columns that may be present in the export file. Please note that if a particular term is not in use for your [workspace](https://docs.eu-pactum.com/essentials/workspace.md), that column will be omitted from the export.

### Requisition and item data

<table data-full-width="true"><thead><tr><th width="224">Column name</th><th width="206">Example value</th><th>Description</th></tr></thead><tbody><tr><td>pr_id</td><td>PR1</td><td>Purchase Request identifier</td></tr><tr><td>suite_status</td><td>Draft</td><td>Status of the requisition, as shown in Suite</td></tr><tr><td>pr_title</td><td>Coke</td><td>Title of the PR</td></tr><tr><td>buyer_name</td><td>John Smith</td><td>Name of the buyer that created the PR</td></tr><tr><td>buyer_email</td><td>buyer@client.com</td><td>Email address of the buyer</td></tr><tr><td>quote_id</td><td>RA44123Z</td><td>Quote identifier, shown to suppliers for referencing the correct quote</td></tr><tr><td>delivery_location</td><td>Tarrytown Plant, Austin, TX, USA</td><td>Delivery location</td></tr><tr><td>currency</td><td>USD</td><td>Currency used</td></tr><tr><td>line_item_id</td><td>1</td><td>Identifier for the line item within the PR</td></tr><tr><td>item_name</td><td>Cola drink</td><td>Name of the item</td></tr><tr><td>item_description</td><td>Cola drink in 330ml glass bottles</td><td>Description of the item</td></tr><tr><td>material_group_code</td><td>Beverages</td><td>Material group code</td></tr><tr><td>quantity</td><td>10000</td><td>Quantity of the item</td></tr><tr><td>unit_measure</td><td>each</td><td>Unit of measurement</td></tr><tr><td>supplier_id</td><td>2987655</td><td>Supplier ID</td></tr><tr><td>supplier_company</td><td>General Soda Inc</td><td>Supplier company name</td></tr><tr><td>supplier_email</td><td>kevin.halborn@general-soda.com</td><td>Supplier contact that Pactum reaches out to for negotiation</td></tr><tr><td>supplier_name</td><td>Kevin Halborn</td><td>Supplier contact name</td></tr><tr><td>total_desired_price</td><td>150000</td><td>The total desired price of the event (if set)</td></tr></tbody></table>

### Negotiable terms

These columns describe negotiable term values before negotiation (`initial_*`, where `*` represents the term name). Every such column has a matching `agreed_*` column which shows the value of the term after negotiation.

<table data-full-width="true"><thead><tr><th width="224">Column name</th><th width="207">Example value</th><th>Description</th></tr></thead><tbody><tr><td>initial_delivery_date</td><td>26.05.2024</td><td>Delivery date</td></tr><tr><td>initial_payment_terms_discount</td><td>0.02</td><td>Early payment discount value as a proportion (e.g. 2% is represented as <code>0.02</code>)</td></tr><tr><td>initial_payment_terms_discount_days</td><td>30</td><td>Early payment days value. This field is filled only if early payment days are standard, not EOM or EOW.</td></tr><tr><td>initial_payment_terms_discount_eom_days</td><td>30</td><td>Early payment days value. This field is filled only if early payment days are end-of-month, not standard or EOW</td></tr><tr><td>initial_payment_terms_discount_eow_days</td><td>30</td><td>Early payment days value. This field is filled only if early payment days are end-of-week, not standard or EOM</td></tr><tr><td>initial_payment_terms_payment_days</td><td>30</td><td>Payment days value</td></tr><tr><td>initial_contract_length</td><td>12</td><td>Contract length in months</td></tr><tr><td>initial_warranty</td><td>18</td><td>Warranty period in months</td></tr><tr><td>initial_rebate</td><td>2.7</td><td>Rebate as a percent (e.g. 2.7% is represented as <code>2.7</code>)</td></tr><tr><td>initial_consignment_inventory</td><td>(see description)</td><td>Consignment inventory. The initial value can be one of <code>Not needed</code>, <code>Agreement needed</code>, <code>Existing agreement</code>. The agreed value can be one of <code>New agreement</code>, <code>No agreement</code>.</td></tr><tr><td>initial_incoterm</td><td>CIP</td><td>Incoterm <a href="https://www.trade.gov/know-your-incoterms">abbreviation</a></td></tr><tr><td>initial_minimum_order_quantity</td><td>1000</td><td>Minimum order quantity</td></tr><tr><td>initial_unit_price</td><td>0.801</td><td>Unit price</td></tr><tr><td>baseline_unit_price</td><td>0.733</td><td>Baseline supplier's price for this line item; if the negotiation is competitive, this can differ from <code>initial_unit_price</code></td></tr><tr><td>desired_unit_price</td><td>1.50</td><td>The desired unit price of the item (if configured)</td></tr></tbody></table>

For more details around how payment terms values can be configured, please read [Broken mention](broken://pages/wS9o8TmoIVWl4iUaKJvJ).

### Negotiation outcomes

These columns describe the progress and outcomes of the negotiation, excluding negotiable terms which are described in the previous section.

<table data-full-width="true"><thead><tr><th width="224">Column name</th><th width="206">Example value</th><th>Description</th></tr></thead><tbody><tr><td>total_savings_price</td><td>2674.88</td><td>Total savings on price</td></tr><tr><td>total_savings_working_capital</td><td>-22.33</td><td>Total savings on working capital</td></tr><tr><td>total_savings_rebate</td><td>148.22</td><td>Total savings from rebate</td></tr><tr><td>total_savings_incoterm</td><td>0.00</td><td>Total savings from Incoterm</td></tr><tr><td>total_savings_warranty</td><td>2000.00</td><td>Total savings from warranty</td></tr><tr><td>total_savings_contract_length</td><td>0.00</td><td>Total savings from contract length</td></tr><tr><td>negotiation_link_sent</td><td>20.03.2024, 13:05:36 +02</td><td>Date when negotiation link was sent to supplier via email</td></tr><tr><td>negotiation_started</td><td>21.03.2024, 18:13:32 +02</td><td>Date and time when negotiation was started (supplier entered the supplier portal by clicking the link)</td></tr><tr><td>negotiation_concluded</td><td>25.03.2024, 14:10:20 +02</td><td>Date and time when negotiation was concluded (successfully or unsuccessfully).</td></tr><tr><td>status</td><td>Withdrawn</td><td>Current status of the negotiation</td></tr><tr><td>feedback</td><td>UnsuitableDeliveryDate: Preferred delivery date : 12-12-2025 Unsuitable delivery date</td><td>Supplier open-text feedback, aggregated from various places the supplier can leave such feedback within the negotiation</td></tr></tbody></table>

### Notes

* All date formats and timezones match your workspace locale configuration.
* For details about Requisition and Negotiation statuses, see [here](https://docs.eu-pactum.com/procurement-product/negotiation-lifecycle.md#requisition-supplier-and-negotiation-lifecycle).
