|
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 |
0 |
|
|
Quantity Received |
Number |
(very large decimal) |
12 |
0 |
*** REQUIRED *** |
|
Item Number |
Text |
50 |
TestItem |
|
*** REQUIRED *** |
|
Supplier Item Number |
Text |
50 |
SupTestItem |
|
|
|
Item Description |
Text |
255 |
This item is a very good item. |
|
|
|
Unit Cost |
Currency |
15 |
$20.00 |
0 |
*** REQUIRED *** |
|
Date Item Expected |
Date |
15 |
8/2/06 |
|
|
|
Date Item Received |
Date |
8/2/06 |
8/2/06 |
|
|
|
Freight |
Currency |
15 |
$5.00 |
|
|
|
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. |
|
Manufacturer |
Text |
50 |
Yang Ming |
|
|
|
Container Number |
Text |
50 |
4455887XMC8 |
|
|
|
Country of Origin |
Text |
50 |
Japan |
|
|
