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
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 | download CSV file).
Note: This template is on the line level. Group items are at the group item level.
| Fairmarkit field | Header | Description | |
|---|---|---|---|
|
* |
Requisition ID |
requisition_id |
Purchase requisition ID from your purchasing application Data type: Text Example: R1000 |
|
|
Requisition Title |
requisition_title |
Purchase requisition title. This title will display in Fairmarkit and defaults to the first line item title. Data type: Text Example: Req for FMKT |
|
* |
Fairmarkit RFQ ID |
fairmarkit_rfq_id |
Fairmarkit request for quote event ID. Data type: Text Example: 41298 |
|
|
Line Number |
line_number |
Line number or order of the line item. Data type: Text Example: 1 |
|
* |
Item Title |
item_title |
Item name. Data type: Text Example: coffee beans |
|
|
Item Identifier |
item_identifier |
Unique identifier for the line item in your purchasing application, if it exists. Data type: Text Example: G123 Note: This data is preserved when imported into Fairmarkit. |
|
|
Buyer Email |
buyer_email |
Buyer's email. Fairmarkit does not validate the email. This value is used to assign request for quote events in Fairmarkit. Data type: Text Example: buyer@example.com |
|
* |
Status |
status |
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. Data type: Text Example: Awarded |
|
|
Status Date |
status_date |
Date that Fairmarkit automatically set the status. It may display as "Archived on status_date". Data type: Text Example: 2022-07-14 |
|
|
Status Note |
status_note |
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.” Data type: Text Example: Awarded to Catherine's Coffee Shop |
|
|
Price (Per Unit) |
price_per_unit |
Price per unit. This value is generated in your company currency based on the quoted price per unit (if awarded). Data type: Text Example: 8.00 |
|
|
Currency |
currency |
Event currency when awarding. This should be the three letter currency code. Data type: Text Example: MXN |
|
|
Quantity |
quantity |
Awarded item quantity. This is assumed to be an integer. Data type: Text Example: 1 |
|
|
UOM |
uom |
Unit of measure of awarded item. Default: Each Data type: Text Example: Each Accepted values: Fairmarkit defined values; For more information, see Available UOMs. Note: Custom mapping is available. For more information, contact your technical architect. Note: This may be different than the quote_uom. |
|
|
Supplier ID |
supplier_id |
Supplier ID. This should match the Supplier ID provided in your Supplier syncs where applicable. For more information, see Import suppliers. Data type: Text Example: S1000 |
|
|
Supplier Title |
supplier_title |
Name or title of the supplier. Data type: Text Example: Catherine's Coffee Shop |
|
* |
Supplier Email |
supplier_email |
Supplier's email. Fairmarkit does not validate the email. Data type: Text Example: catherine@example.com |
|
|
Fairmarkit Supplier ID |
fairmarkit_supplier_id |
Fairmarkit Supplier ID. Data type: Text Example: 23908 |
|
|
Quote Id |
quote_id |
Fairmarkit Quote ID. This value is entered by the supplier. Data type: Text Example: Q123 |
|
|
Quote Price (Per Unit) |
quote_price_per_unit |
Quoted price per unit. This value is in the Quote Currency and based on the Quote UOM. Data type: Text Example: 160.00 |
|
|
Quote Currency |
quote_currency |
Quote currency. This should be the three letter currency code. Data type: Text Example: MXN |
|
|
Quote Quantity |
quote_quantity |
Quote item quantity. This is assumed to be an integer. Data type: Text Example: 1 |
|
|
Quote UOM |
quote_uom |
Unit of measure of the item. Data type: Text Example: Each Accepted values: Fairmarkit defined values; For more information, see Available UOMs. Note: Custom mapping is available. For more information, contact your technical architect. |
|
|
Quote Valid For |
quote_valid_for |
Number of days before the quote expires. Data type: Text Example: 30 |
|
|
Quote Delivery Days |
quote_delivery_days |
Number of days to deliver the line item. This should be used to calculate the actual delivery date. Data type: Text Example: 5 |
|
|
Quote SKU |
quote_sku |
Item SKU. This value is entered by the supplier. Data type: Text Example: S12094 |
|
|
Quote Country of Origin |
quote_country_of_origin |
Line item's country of origin. This value is entered by the supplier. Data type: Text Example: MX |
|
|
Quote Minimum Order Quantity |
quote_minimum_order_quantity |
Minimum order quantity (integer) for the quote. The supplier enters this value. This value is sent for accounting purposes. Data type: Text Example: 1 |
|
|
Quote Line Comment |
quote_line_comment |
Line item comment. This value is entered by the supplier. This value correlates with the user interface. Data type: Text Example: Will leave on doorstep |
|
|
Quote Notes About Bid |
quote_notes_about_bid |
Notes about the quote. This value is entered by the supplier. This value correlates with the user interface. Data type: Text Example: This is the best coffee in town |
|
|
Benchmark Supplier ID |
benchmark_supplier_id |
Benchmark supplier ID. Data type: Text Example: S1002 |
|
|
Benchmark Supplier Title |
benchmark_supplier_title |
Benchmark supplier name. This can be a name, title, entity, or description. Data type: Text Example: Charlie's Convenience Store |
|
|
Benchmark Price (Per Unit) |
benchmark_price_per_unit |
Benchmark price per unit. This is internal to your company. Presumably in your currency and UOM for the item. Data type: Text Example: 10.00 |
|
|
Internal Part Number |
internal_part_number |
Your organization's part number for the item. This value is entered at your discretion. Data type: Text Example: IPN100 |
|
|
Manufacturer |
manufacturer |
Manufacturer of the line item. Data type: Text Example: Local Co |
|
|
Manufacturer Part Number |
manufacturer_part_number |
Manufacturer part number of the line item. Data type: Text Example: 900 |
|
|
UNSPSC |
unspsc |
Standard 8 digit UNSPSC code for the item or requested service. Data type: Text Example: 50201706 |
|
|
Start Date |
start_date |
Start date for the line item. Typically used for services, leases, and software subscriptions and licenses. Data type: Text Example: 2022-07-20 |
|
|
End Date |
end_date |
End date for the line item. Typically used for services, leases, and software subscriptions and licenses. Data type: Text Example: 2022-07-27 |
|
|
Buyer Line Comment |
buyer_line_comment |
Line item comments from you (buyer) to the suppliers. Data type: Text Example: We'll need your best coffee |
|
|
Item Kind |
item_kind |
Line item type. For more information, see 3. Add items or services. Default: Item Data type: Text Example: Item |
|
|
Group Item Title |
group_item_title |
When Item Kind is Group, the name of the group. Data type: Text Example: Coffee Supplies |
|
|
Requester |
requester |
Requester name. This value can also be an entity. This value is entered at your discretion. Data type: Text Example: John Smith |
|
|
Preferred Delivery Date |
preferred_delivery_date |
The date when the line items are needed. This date is the preference used when defining shipping time lines and scheduling services. Data type: Text Example: 2022-07-20 |
|
|
Shipping Type |
shipping_type |
Preferred shipping method. This value is selected from a list and does not default. Data type: Text Example: Ground |
|
|
Shipping Carrier |
shipping_carrier |
Preferred shipping carrier. This value is selected from a list and does not default. Data type: Text Example: USPS |
|
|
Address1 |
shipping_address_address1 |
Shipping address - first line. Data type: Text Example: 27 School St |
|
|
Address2 |
shipping_address_address2 |
Shipping address - second line. Data type: Text Example: STE 400 |
|
|
City |
shipping_address_city |
Shipping address city. Data type: Text Example: Boston |
|
|
State |
shipping_address_state |
Shipping address state. Data type: Text Example: MA |
|
|
Zip |
shipping_address_zip |
Shipping address zip code. Data type: Text Example: 02108 |
|
|
Country |
shipping_address_country |
Shipping address country. Data type: Text Example: US |
|
|
Internal Notes |
internal_notes |
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. Data type: Text Example: Get medium roast |
|
|
Note to Supplier |
note_to_supplier |
Add additional information and communication about the event with all invited suppliers. This correlates to the Notes to Suppliers in the Fairmarkit user interface. Data type: Text Example: Please leave on doorstep |
|
|
ERP System |
erp_system |
Your purchasing application. When entered, it will override the system level settings. Data type: Text Example: SAP Ariba |
|
|
Additional Information |
additional_info_XXX |
Space for additional information. Data type: Text Example: Boston |
Accepted values