# Export requests for quote

\*

At different stages of your request for quote events, you can use generic flat files to export event data from Fairmarkit to your purchasing application. Fairmarkit currently supports export for events in Closed, Awarded, Canceled, and Archived status.

### Requests for quote data <a href="#requestsforquotedata" id="requestsforquotedata"></a>

The following table outlines the column headers you will need to create when you export your request for quote events out of Fairmarkit. The \*required fields are marked.

Template: Make sure you have the latest version of the flat file template ([view](https://docs.google.com/spreadsheets/d/1INb94RFKXMIBECHJ0DEpPo4EiY7iUvetkmloNSABD8o/edit#gid=0) | [download CSV file](https://docs.google.com/spreadsheets/d/e/2PACX-1vSsskPZC9mulbFftbuowuzDwLg43wu2SiFVbOWLulELeU0Pvr61n9e0LgwQ-jyt7KJEdnaRNtBt8wBq/pub?gid=0\&single=true\&output=csv)).

Note: This template is on the line level. Group items are at the group item level.

| [Fairmarkit field](https://docs.fairmarkit.com/content/integrations/flat-file/export-rfq.htm#) | [Header](https://docs.fairmarkit.com/content/integrations/flat-file/export-rfq.htm#) | [Description](https://docs.fairmarkit.com/content/integrations/flat-file/export-rfq.htm#) |                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| ---------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ | ----------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| \*                                                                                             | Requisition ID                                                                       | requisition\_id                                                                           | <p>Purchase requisition ID from your purchasing application</p><p>Data type: Text</p><p>Example: R1000</p>                                                                                                                                                                                                                                                                                                                                   |
|                                                                                                | Requisition Title                                                                    | requisition\_title                                                                        | <p>Purchase requisition title. This title will display in Fairmarkit and defaults to the first line item title.</p><p>Data type: Text</p><p>Example: Req for FMKT</p>                                                                                                                                                                                                                                                                        |
| \*                                                                                             | Fairmarkit RFQ ID                                                                    | fairmarkit\_rfq\_id                                                                       | <p>Fairmarkit request for quote event ID.</p><p>Data type: Text</p><p>Example: 41298</p>                                                                                                                                                                                                                                                                                                                                                     |
|                                                                                                | Line Number                                                                          | line\_number                                                                              | <p>Line number or order of the line item.</p><p>Data type: Text</p><p>Example: 1</p>                                                                                                                                                                                                                                                                                                                                                         |
| \*                                                                                             | Item Title                                                                           | item\_title                                                                               | <p>Item name.</p><p>Data type: Text</p><p>Example: coffee beans</p>                                                                                                                                                                                                                                                                                                                                                                          |
|                                                                                                | Item Identifier                                                                      | item\_identifier                                                                          | <p>Unique identifier for the line item in your purchasing application, if it exists.</p><p>Data type: Text</p><p>Example: G123</p><p>Note: This data is preserved when imported into Fairmarkit.</p>                                                                                                                                                                                                                                         |
|                                                                                                | Buyer Email                                                                          | buyer\_email                                                                              | <p>Buyer's email. Fairmarkit does not validate the email. This value is used to assign request for quote events in Fairmarkit.</p><p>Data type: Text</p><p>Example: <buyer@example.com></p>                                                                                                                                                                                                                                                  |
| \*                                                                                             | Status                                                                               | status                                                                                    | <p>Fairmarkit request for quote event status. Fairmarkit automatically sets the status. Typically, the event will be in Awarded, Canceled, or Archived statues, but other end statues can be supported.</p><p>Data type: Text</p><p>Example: Awarded</p>                                                                                                                                                                                     |
|                                                                                                | Status Date                                                                          | status\_date                                                                              | <p>Date that Fairmarkit automatically set the status. It may display as "Archived on status\_date".</p><p>Data type: Text</p><p>Example: 2022-07-14</p>                                                                                                                                                                                                                                                                                      |
|                                                                                                | Status Note                                                                          | status\_note                                                                              | <p>Status note. These are useful when comments on a line item are important for your purchasing application. For example, “Item awarded to XX at YY.”</p><p>Data type: Text</p><p>Example: Awarded to Catherine's Coffee Shop</p>                                                                                                                                                                                                            |
|                                                                                                | Price (Per Unit)                                                                     | price\_per\_unit                                                                          | <p>Price per unit. This value is generated in your company currency based on the quoted price per unit (if awarded).</p><p>Data type: Text</p><p>Example: 8.00</p>                                                                                                                                                                                                                                                                           |
|                                                                                                | Currency                                                                             | currency                                                                                  | <p>Event currency when awarding. This should be the three letter currency code.</p><p>Data type: Text</p><p>Example: MXN</p>                                                                                                                                                                                                                                                                                                                 |
|                                                                                                | Quantity                                                                             | quantity                                                                                  | <p>Awarded item quantity. This is assumed to be an integer.</p><p>Data type: Text</p><p>Example: 1</p>                                                                                                                                                                                                                                                                                                                                       |
|                                                                                                | UOM                                                                                  | uom                                                                                       | <p>Unit of measure of awarded item.</p><p>Default: Each</p><p>Data type: Text</p><p>Example: Each</p><p>Accepted values: Fairmarkit defined values; <a href="https://docs.fairmarkit.com/content/glossaries/uom.htm">For more information, see Available UOMs.</a></p><p>Note: Custom mapping is available. For more information, contact your technical architect.</p><p>Note: This may be different than the quote\_uom.</p>               |
|                                                                                                | Supplier ID                                                                          | supplier\_id                                                                              | <p>Supplier ID. This should match the Supplier ID provided in your Supplier syncs where applicable. <a href="https://docs.fairmarkit.com/content/integrations/flat-file/import-suppliers.htm">For more information, see Import suppliers.</a></p><p>Data type: Text</p><p>Example: S1000</p>                                                                                                                                                 |
|                                                                                                | Supplier Title                                                                       | supplier\_title                                                                           | <p>Name or title of the supplier.</p><p>Data type: Text</p><p>Example: Catherine's Coffee Shop</p>                                                                                                                                                                                                                                                                                                                                           |
| \*                                                                                             | Supplier Email                                                                       | supplier\_email                                                                           | <p>Supplier's email. Fairmarkit does not validate the email.</p><p>Data type: Text</p><p>Example: <catherine@example.com></p>                                                                                                                                                                                                                                                                                                                |
|                                                                                                | Fairmarkit Supplier ID                                                               | fairmarkit\_supplier\_id                                                                  | <p>Fairmarkit Supplier ID.</p><p>Data type: Text</p><p>Example: 23908</p>                                                                                                                                                                                                                                                                                                                                                                    |
|                                                                                                | Quote Id                                                                             | quote\_id                                                                                 | <p>Fairmarkit Quote ID. This value is entered by the supplier.</p><p>Data type: Text</p><p>Example: Q123</p>                                                                                                                                                                                                                                                                                                                                 |
|                                                                                                | Quote Price (Per Unit)                                                               | quote\_price\_per\_unit                                                                   | <p>Quoted price per unit. This value is in the Quote Currency and based on the Quote UOM.</p><p>Data type: Text</p><p>Example: 160.00</p>                                                                                                                                                                                                                                                                                                    |
|                                                                                                | Quote Currency                                                                       | quote\_currency                                                                           | <p>Quote currency. This should be the three letter currency code.</p><p>Data type: Text</p><p>Example: MXN</p>                                                                                                                                                                                                                                                                                                                               |
|                                                                                                | Quote Quantity                                                                       | quote\_quantity                                                                           | <p>Quote item quantity. This is assumed to be an integer.</p><p>Data type: Text</p><p>Example: 1</p>                                                                                                                                                                                                                                                                                                                                         |
|                                                                                                | Quote UOM                                                                            | quote\_uom                                                                                | <p>Unit of measure of the item.</p><p>Data type: Text</p><p>Example: Each</p><p>Accepted values: Fairmarkit defined values; <a href="https://docs.fairmarkit.com/content/glossaries/uom.htm">For more information, see Available UOMs.</a></p><p>Note: Custom mapping is available. For more information, contact your technical architect.</p>                                                                                              |
|                                                                                                | Quote Valid For                                                                      | quote\_valid\_for                                                                         | <p>Number of days before the quote expires.</p><p>Data type: Text</p><p>Example: 30</p>                                                                                                                                                                                                                                                                                                                                                      |
|                                                                                                | Quote Delivery Days                                                                  | quote\_delivery\_days                                                                     | <p>Number of days to deliver the line item. This should be used to calculate the actual delivery date.</p><p>Data type: Text</p><p>Example: 5</p>                                                                                                                                                                                                                                                                                            |
|                                                                                                | Quote SKU                                                                            | quote\_sku                                                                                | <p>Item SKU. This value is entered by the supplier.</p><p>Data type: Text</p><p>Example: S12094</p>                                                                                                                                                                                                                                                                                                                                          |
|                                                                                                | Quote Country of Origin                                                              | quote\_country\_of\_origin                                                                | <p>Line item's country of origin. This value is entered by the supplier.</p><p>Data type: Text</p><p>Example: MX</p>                                                                                                                                                                                                                                                                                                                         |
|                                                                                                | Quote Minimum Order Quantity                                                         | quote\_minimum\_order\_quantity                                                           | <p>Minimum order quantity (integer) for the quote. The supplier enters this value. This value is sent for accounting purposes.</p><p>Data type: Text</p><p>Example: 1</p>                                                                                                                                                                                                                                                                    |
|                                                                                                | Quote Line Comment                                                                   | quote\_line\_comment                                                                      | <p>Line item comment. This value is entered by the supplier. This value correlates with the user interface.</p><p>Data type: Text</p><p>Example: Will leave on doorstep</p>                                                                                                                                                                                                                                                                  |
|                                                                                                | Quote Notes About Bid                                                                | quote\_notes\_about\_bid                                                                  | <p>Notes about the quote. This value is entered by the supplier. This value correlates with the user interface.</p><p>Data type: Text</p><p>Example: This is the best coffee in town</p>                                                                                                                                                                                                                                                     |
|                                                                                                | Benchmark Supplier ID                                                                | benchmark\_supplier\_id                                                                   | <p>Benchmark supplier ID.</p><p>Data type: Text</p><p>Example: S1002</p>                                                                                                                                                                                                                                                                                                                                                                     |
|                                                                                                | Benchmark Supplier Title                                                             | benchmark\_supplier\_title                                                                | <p>Benchmark supplier name. This can be a name, title, entity, or description.</p><p>Data type: Text</p><p>Example: Charlie's Convenience Store</p>                                                                                                                                                                                                                                                                                          |
|                                                                                                | Benchmark Price (Per Unit)                                                           | benchmark\_price\_per\_unit                                                               | <p>Benchmark price per unit. This is internal to your company. Presumably in your currency and UOM for the item.</p><p>Data type: Text</p><p>Example: 10.00</p>                                                                                                                                                                                                                                                                              |
|                                                                                                | Internal Part Number                                                                 | internal\_part\_number                                                                    | <p>Your organization's part number for the item. This value is entered at your discretion.</p><p>Data type: Text</p><p>Example: IPN100</p>                                                                                                                                                                                                                                                                                                   |
|                                                                                                | Manufacturer                                                                         | manufacturer                                                                              | <p>Manufacturer of the line item.</p><p>Data type: Text</p><p>Example: Local Co</p>                                                                                                                                                                                                                                                                                                                                                          |
|                                                                                                | Manufacturer Part Number                                                             | manufacturer\_part\_number                                                                | <p>Manufacturer part number of the line item.</p><p>Data type: Text</p><p>Example: 900</p>                                                                                                                                                                                                                                                                                                                                                   |
|                                                                                                | UNSPSC                                                                               | unspsc                                                                                    | <p>Standard 8 digit UNSPSC code for the item or requested service.</p><p>Data type: Text</p><p>Example: 50201706</p>                                                                                                                                                                                                                                                                                                                         |
|                                                                                                | Start Date                                                                           | start\_date                                                                               | <p>Start date for the line item. Typically used for services, leases, and software subscriptions and licenses.</p><p>Data type: Text</p><p>Example: 2022-07-20</p>                                                                                                                                                                                                                                                                           |
|                                                                                                | End Date                                                                             | end\_date                                                                                 | <p>End date for the line item. Typically used for services, leases, and software subscriptions and licenses.</p><p>Data type: Text</p><p>Example: 2022-07-27</p>                                                                                                                                                                                                                                                                             |
|                                                                                                | Buyer Line Comment                                                                   | buyer\_line\_comment                                                                      | <p>Line item comments from you (buyer) to the suppliers.</p><p>Data type: Text</p><p>Example: We'll need your best coffee</p>                                                                                                                                                                                                                                                                                                                |
|                                                                                                | Item Kind                                                                            | item\_kind                                                                                | <p>Line item type. <a href="https://docs.fairmarkit.com/content/buyers/rfq/create-rfq.htm#Add">For more information, see 3. Add items or services.</a></p><p>Default: Item</p><p>Data type: Text</p><p>Example: Item</p><p><a href="https://docs.fairmarkit.com/content/integrations/flat-file/export-rfq.htm#"><img src="https://docs.fairmarkit.com/Skins/Default/Stylesheets/Images/transparent.gif" alt="Closed">Accepted values</a></p> |
|                                                                                                | Group Item Title                                                                     | group\_item\_title                                                                        | <p>When Item Kind is Group, the name of the group.</p><p>Data type: Text</p><p>Example: Coffee Supplies</p>                                                                                                                                                                                                                                                                                                                                  |
|                                                                                                | Requester                                                                            | requester                                                                                 | <p>Requester name. This value can also be an entity. This value is entered at your discretion.</p><p>Data type: Text</p><p>Example: John Smith</p>                                                                                                                                                                                                                                                                                           |
|                                                                                                | Preferred Delivery Date                                                              | preferred\_delivery\_date                                                                 | <p>The date when the line items are needed. This date is the preference used when defining shipping time lines and scheduling services.</p><p>Data type: Text</p><p>Example: 2022-07-20</p>                                                                                                                                                                                                                                                  |
|                                                                                                | Shipping Type                                                                        | shipping\_type                                                                            | <p>Preferred shipping method. This value is selected from a list and does not default.</p><p>Data type: Text</p><p>Example: Ground</p>                                                                                                                                                                                                                                                                                                       |
|                                                                                                | Shipping Carrier                                                                     | shipping\_carrier                                                                         | <p>Preferred shipping carrier. This value is selected from a list and does not default.</p><p>Data type: Text</p><p>Example: USPS</p>                                                                                                                                                                                                                                                                                                        |
|                                                                                                | Address1                                                                             | shipping\_address\_address1                                                               | <p>Shipping address - first line.</p><p>Data type: Text</p><p>Example: 27 School St</p>                                                                                                                                                                                                                                                                                                                                                      |
|                                                                                                | Address2                                                                             | shipping\_address\_address2                                                               | <p>Shipping address - second line.</p><p>Data type: Text</p><p>Example: STE 400</p>                                                                                                                                                                                                                                                                                                                                                          |
|                                                                                                | City                                                                                 | shipping\_address\_city                                                                   | <p>Shipping address city.</p><p>Data type: Text</p><p>Example: Boston</p>                                                                                                                                                                                                                                                                                                                                                                    |
|                                                                                                | State                                                                                | shipping\_address\_state                                                                  | <p>Shipping address state.</p><p>Data type: Text</p><p>Example: MA</p>                                                                                                                                                                                                                                                                                                                                                                       |
|                                                                                                | Zip                                                                                  | shipping\_address\_zip                                                                    | <p>Shipping address zip code.</p><p>Data type: Text</p><p>Example: 02108</p>                                                                                                                                                                                                                                                                                                                                                                 |
|                                                                                                | Country                                                                              | shipping\_address\_country                                                                | <p>Shipping address country.</p><p>Data type: Text</p><p>Example: US</p>                                                                                                                                                                                                                                                                                                                                                                     |
|                                                                                                | Internal Notes                                                                       | internal\_notes                                                                           | <p>Notes about the event. This is internal to your company. Multiple notes are concatenated into a long string. This correlates to the Internal Notes in the Fairmarkit user interface.</p><p>Data type: Text</p><p>Example: Get medium roast</p>                                                                                                                                                                                            |
|                                                                                                | Note to Supplier                                                                     | note\_to\_supplier                                                                        | <p>Add additional information and communication about the event with all invited suppliers. This correlates to the Notes to Suppliers in the Fairmarkit user interface.</p><p>Data type: Text</p><p>Example: Please leave on doorstep</p>                                                                                                                                                                                                    |
|                                                                                                | ERP System                                                                           | erp\_system                                                                               | <p>Your purchasing application. When entered, it will override the system level settings.</p><p>Data type: Text</p><p>Example: SAP Ariba</p>                                                                                                                                                                                                                                                                                                 |
|                                                                                                | Additional Information                                                               | additional\_info\_XXX                                                                     | <p>Space for additional information.</p><p>Data type: Text</p><p>Example: Boston</p>                                                                                                                                                                                                                                                                                                                                                         |

&#x20;

[© 2025 Fairmarkit. All rights reserved.](http://fairmarkit.com/)

<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fairmarkit.com/buyers/integrations/flat-file-integration/export-data/export-requests-for-quote.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.