Tools

Field Mapping-AR Aging

Author: Reference Number: AA-01345 Created: 2011-03-01 09:47 Last Updated: 2011-11-03 16:01

0 Rating/ Voters

Field Mapping Notes (for the OneSource Field Mapping Spreadsheet – AR Aging file)

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.