After your sourcing process in Fairmarkit, you'll create purchase orders for the items and services that you've sourced. Then, you can import the purchase order information into Fairmarkit. By providing your purchase orders, you will continue to improve your supplier recommendations.
Purchase order data
The following table outlines the column headers you will need to create when you import your purchase orders into Fairmarkit. The *required fields are marked.
Template: Make sure you have the latest version of the flat file template (view | download CSV file).
| Fairmarkit field | Header | Description | |
|---|---|---|---|
|
* |
Purchase Order ID | po_id |
Purchase requisition ID in your purchasing application. Data type: Text Example: S1000 |
|
* |
Line Item ID | line_item_id |
Unique identifier of the line item in your purchasing application. Data type: Text Example: G123 |
|
|
Purchased At |
purchased_at |
Purchase order purchasing date. Data type: Text Example: 2022-07-28 |
|
|
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 |
|
* |
Item Description |
item_description |
Item description. Data type: Text Example: coffee beans |
|
* |
Unit of Measure |
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. |
|
* |
Quantity |
quantity |
Item quantity. Data type: Text Example: 1 |
|
* |
Unit Price |
unit_price |
Unit price of line item Data type: Text Example: 8.00 |
|
|
Extended Price |
extended_price |
Total cost of the line item. Data type: Text Example: 8.00 |
|
* |
Currency |
currency |
Unit price currency. This should be the three letter currency code. Data type: Text Example: USD |
|
* |
Supplier Title |
supplier_name |
Supplier name. Data type: Text Example: Catherine's Coffee Shop |
|
|
Supplier ID |
supplier_id |
Supplier ID in your purchasing application. Data type: Text Example: S1000 |
|
|
Supplier URI |
supplier_uri |
Supplier's email or domain. This is useful for reporting and when multiple emails have the same supplier_id. Data type: Text Example: cdw.com |
|
|
Fairmarkit Line Item ID |
fm_line_item_id |
Fairmarkit Line Item ID. # pandas code PO_HASH_COLUMNS - list of columns for the cache (usually PO_ID and PO_LINE_ID po['FM_PO_ID'] = po.apply(lambda row: hashlib.md5('|'.join([str(row[x]) for x in PO_HASH_COLUMNS]).encode('utf-8')).hexdigest(),axis=1 ) Data type: Text Example: 0065f967671d5d960e02253ada162502 |
|
|
UNSPSC |
unspsc |
Standard 8 digit UNSPSC code for the item or requested service. Data type: Text Example: 50201706 |
|
|
Manufacturer |
manufacturer |
Manufacturer of the line item. Data type: Text Example: Local Co |
|
|
SKU |
sku |
Supplier or manufacturer part number. Data type: Text Example: S12094 |
|
|
Category |
category |
Category as defined in your purchasing application. Data type: Text Example: Supplies |
|
|
Category ID |
category_id |
Category ID. Data type: Text Example: 1001 |
|
|
Subcategory |
subcategory_1 subcategory_2 subcategory_3 |
Subcategory. Data type: Text Example: Coffee |
|
|
Subcategory ID |
subcategory_1_id subcategory_2_id subcategory_3_id |
Subcategory ID. Data type: Text Example: 23 |
|
|
Notes |
notes |
Notes about the requisition, request for quote event, purchase order, etc. Data type: Text Example: Buying some coffee |
|
|
Requisition ID |
requisition_id |
Purchase requisition ID from your purchasing application Data type: Text Example: R1000 |
|
|
Status |
status |
Purchase order status. Default: PURCHASED Data type: Text Example: PURCHASED |
|
|
Ordered At |
ordered_at |
Purchase order date. Data type: Text Example: 2022-07-28 |
|
|
Global Ledger ID |
global_ledger_id |
Global ledger ID. Data type: Text Example: 650666 |
|
|
Global Ledger |
global_ledger |
Global ledger. Similar to category, this value can be used for supplier recommendations. E.g., Tools & Fixtures, Calibrations, and Chemicals. Data type: Text Example: Repairs & Maintenance |
|
|
Plant ID |
plant_id |
Plant ID. Data type: Text Example: 1002 |
|
|
Plant |
plant |
Plant or branch. This value is related to the shipping information. Data type: Text Example: US Plant |
|
|
Cost Center ID |
cost_center_id |
Cost Center ID. Data type: Text Example: 11MDO501 |
|
|
Cost Center |
cost_center |
Cost center. Similar to category, this value can be used for supplier recommendations. E.g., Braid & Cable, R&D, HR. Data type: Text Example: Braid & Cable |
|
|
Funds Center ID |
funds_center_id |
Funds Center ID. Data type: Text Example: 55665 |
|
|
Funds Center |
funds_center |
Funds Center. Data type: Text Example: Marketing |
|
|
Department ID |
department_id |
Department ID. Data type: Text Example: 11010 |
|
|
Department |
department |
The department within your organization that purchased the items or services. Data type: Text Example: HR |
|
|
Buyer ID |
buyer_id |
Buyer ID Data type: Text Example: buyer.example |
|
|
Buyer |
buyer |
Buyer Data type: Text Example: Buyer Example |
|
|
ERP System |
erp |
Your purchasing application. When entered, it will override the system level settings. Data type: Text Example: SAP Ariba |
|
|
ERP System Id |
erp_system_id |
ERP System Id |
|
|
Purchase Order Description |
po_description |
Purchase Order Description. Data type: Text Example: Coffee Beans Order |
|
|
Manufacturer Part Number |
manufacturer_pn |
Manufacturer part number of the line item. Data type: Text Example: 900 |
|
|
Language |
language |
Purchase order language. Default: en Data type: Text Example: en Accepted values: See list of ISO 639-1 codes. |
|
|
Shipping City |
shipping_city |
Shipping address city. Data type: Text Example: Boston |
|
|
Shipping State |
shipping_state |
Shipping address state. Data type: Text Example: MA |
|
|
Shipping Zip |
shipping_zip |
Shipping address zip code. Data type: Text Example: 02108 |
|
|
Shipping Country |
shipping_country |
Shipping address country. Data type: Text Example: US |
|
|
Shipping Address |
shipping_address |
Shipping address - first line. Data type: Text Example: 27 School St |
|
|
Shipping Notes |
shipping_notes |
Shipping notes. Data type: Text Example: Leave at doorstep |
Accepted values