Start now

Schedule a demo

  • Date Format: MM slash DD slash YYYY
  • This field is for validation purposes and should be left unchanged.
Field Mapping–Open Purchase Orders – OneSource : QuickBooks Online Inventory Management Field Mapping–Open Purchase Orders – OneSource : QuickBooks Online Inventory Management

Have a Question?

Field Mapping–Open Purchase Orders

You are here:
< All Topics

This document explains each column in the @OSImport_PurchaseOrderHistory_Template.xls file.  The @OSImport_PurchaseOrderHistory_Template.xls file is the file used by you (and your OneSource Data Conversion Manager) to properly map and identify each field of data that you plan to import into OneSource.  For additional help with this document please contact your OneSource Data Conversion Manager at 866-204-4997.

Field Mapping Spreadsheet

Column Name

OneSource Field Type Field Length or Numeric Range Sample value Default Value

Additional Notes

PO Number

Text 50 P334433-1 *** REQUIRED *** This is the Primary Key. This field must contain a unique value and cannot be left blank.

Supplier Number

Text 50 S23456 *** REQUIRED *** This is the Supplier Number that will be imported from your legacy system or a newly created Supplier Number in your OneSource Pilot database.

Bill To Company Warehouse

Text 15 CorpWarehouse

*** NOTE *** When you create a ‘warehouse’ in OneSource a ‘Location Number’ is created and stored in the Shipping Locations table.  The appropriate Location Number needs to be entered here.

Ship To Company Warehouse (or Customer Number)

Text 15 Warehouse10

*** NOTE *** If the Ship To location is a company ‘warehouse’ – please see the note above.  If the PO was drop shipped to a customer the Customer Number will need to be entered here AND the Drop Shipped? field for that record will need to marked as Yes.

Drop Shipped?

Yes/No Yes or No

-1 or 0

1 No

*** NOTE *** If the PO was dropped shipped to a Customer, this

PO Date

Date N/A 8/1/06

*** REQUIRED ***

Quantity Ordered

Number (very large decimal) 12


Quantity Received

Number (very large decimal) 12 0

*** REQUIRED ***

Item Number

Text 50 TestItem

*** REQUIRED ***

Supplier Item Number

Text 50


Item Description

Text 255 This item is a very good item.

Unit Cost

Currency 15 $20.00 0

*** REQUIRED ***

Date Item Expected

Date 15


Date Item Received

Date 8/2/06



Currency 15


Payment Terms

Text 50 Company Check

Ship Via

Text 50 Common Carrier

Reference Number

Text 50 X834HG337

If any other special reference numbers are associated with the PO record, this field can accommodate this information.


Text 50

Yang Ming

Container Number

Text 50


Country of Origin

Text 50


*** NOTE: In order to provide the most user friendly Field/Column names, the Field Mapping Spreadsheet Column Names do not always match with the actual table field names in OneSource.  ***

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Previous Which tables do I delete sample records from (just prior to going live)?
Table of Contents