|
Field Mapping Spreadsheet
Column Name |
OneSource Field Type |
Field Length or Numeric Range |
Sample value |
Default Value |
Additional Notes |
|
|
|
|
|
|
|
|
Bill To Customer Number |
Text |
15 |
ABC12345 |
|
*** REQUIRED *** This field must contain a valid Customer Number that will be stored in the Customers table in OneSource. |
|
Ship To Customer Number |
Text |
15 |
ABC12346 |
|
*** REQUIRED *** This field must contain a valid Customer Number that will be stored in the Customers table in OneSource. |
|
Invoice Number |
Text |
20 |
Inv12345 |
|
*** REQUIRED *** This number is the Primary Key and MUST BE UNIQUE. |
|
Invoice Date |
Date |
N/A |
8/1/07 |
|
Cannot be null (empty). |
|
Customer PO Number |
Text |
20 |
334455 |
|
|
|
Salesperson |
Text |
30 |
John |
|
|
|
Quantity Ordered |
Number |
(very large decimal) |
10 |
|
Cannot be null (empty). |
|
Quantity Shipped |
Number |
(very large decimal) |
10 |
|
Cannot be null (empty). |
|
Item Number |
Text |
50 |
abc item |
|
Cannot be null (empty). |
|
Item Description |
Memo |
65,535 |
ABC Item Description |
|
|
|
Unit Price (Before Discount) |
Currency |
15 |
$20.00 |
$0.00 |
|
|
Discount |
Number |
(very large decimal) |
.50 |
0% |
|
|
Net Unit Price (Including Discount) |
Currency |
15 |
$10.00 |
$0.00 |
(This is not really an actual field in OneSource--since it is calculated from the Qty, Price, and Discount fields) |
|
Bill to Contact Name |
Text |
255 |
John Doe |
|
Contact Name printed on the Invoice Billing Address. |
|
Bill To Company Name |
Text |
255 |
ABC Company |
|
Company Name printed on the Invoice Billing Address. |
|
Bill to Address |
Text |
255 |
12345 Somewhere Street |
|
Street Address printed on the Invoice Billing Address. |
|
Bill to City State Zip |
Text |
255 |
Anaheim, CA 92806 |
|
City, State, and Zip printed on the Invoice Billing Address. |
|
Ship to Contact Name |
Text |
255 |
Mike Jones |
|
Contact Name printed on the Invoice Shipping Address. |
|
Ship to Company Name |
Text |
255 |
ABC Company |
|
Company Name printed on the Invoice Shipping Address. |
|
Ship to Address |
Text |
255 |
456 Ave |
|
Street Address printed on the Invoice Shipping Address. |
|
Ship to City State Zip |
Text |
255 |
City |
|
City, State, and Zip printed on the Invoice Shipping Address. |
|
Invoice Number |
Text |
50 |
R123456 |
|
If you have this enter the actual number. If you don't then make it the same number as the Sales Order Number (this will keep OS from thinking these past Sales Orders need to be Invoiced). |
|
Date Shipped |
Date |
N/A |
08/01/07 |
|
Date the items were shipped. |
|
Delivery Date |
Date |
N/A |
08/02/07 |
|
Date the items are scheduled for delivery. |
|
Due Date |
Date |
N/A |
08/21/07 |
|
Date the Invoice is due. |
| |
|
|
|
|
|
