|
Field Mapping Spreadsheet
Column Name |
OneSource Field type |
Field length or Numeric Range |
Sample value |
Default Value |
Additional Notes |
|
|
|
|
|
|
|
|
Invoice Number |
Text |
20 |
ABC123 |
|
*** REQUIRED *** This field is the unique identifier (Primary Key) for the Invoice table. This value cannot be left blank and must be a unique value. |
|
Sales Order Number |
Text |
22 |
12345 or ABC12345 |
Null |
|
|
Invoice or Credit Memo |
Text |
1 |
I or C |
I |
*** REQUIRED *** I=Invoice; C=Credit Memo |
|
Total Amount Still Due |
Currency |
15 |
100.00 |
0 |
*** REQUIRED *** This is the amount that is still due on the invoice. This total will be the difference of the original Invoice amount less any payments to the Invoice. |
|
Bill to Customer Number |
Text |
15 |
12345 or ABC12345 |
|
*** REQUIRED *** This is the Bill To Customer Number from your legacy system. If this number will be a newly assigned number in OneSource, this will be the Customer Number in OneSource. |
|
Ship to Customer Number |
Text |
15 |
ADA145 |
|
*** REQUIRED *** This is the Ship To Customer Number from your legacy system. If necessary, this can be the same as the Bill To Customer Number. |
|
Invoice Date |
Date |
N/A |
08/01/2007
or 8/1/07 |
Date of Import |
This text field is populated with the date that the Invoice was created. |
|
Customer PO Number |
Text |
50 |
ABC123 |
|
|
|
Source of Order |
Text |
50 |
Referral |
|
|
|
Payment Terms |
Text |
20 |
1% 10 Net 30 |
|
|
|
Salesperson |
Text |
30 |
John Doe |
|
|
|
Shipped Via |
Text |
20 |
UPS Ground |
|
This is how the Item {s} were sent ie FedEx USPS etc. |
|
Comments |
Text |
255 |
|
|
Any Comments printed on the Invoice. |
|
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. |
|
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. |
