Import file format

This table shows the format that is required for the CSV file. The file must contain a header row that contains the header names in the order that is shown in the table. The header names must be spelled correctly. Subsequent rows must contain 10 commas that separate the 11 data elements. If a line does not have a value for an element, the file must contain a placeholder, which is a comma, for that element. You can use a text editor such as Notepad or Excel to edit the CSV file.

Element number	Header name	Data	Required element	Example
1	runKey	Run number	Yes	945
2	ticketNbr	Line number	Yes	1
3	warehouse	Warehouse number	Yes	SR01
4	erpItemKey	ERP (Distribution SX.e) product number	No	1-001
5	customerItemKey	Customer product number	Yes	sr-1-001
6	binLocation	Bin location	No	2
7	qtyExpected	Count quantity that was expected	No	10
8	qtyCounted	Quantity that was counted	Yes	10
9	inventoryType	(C)ustomer or (D)istributor inventory type	Yes	c
10	uom	Unit of measure	No	ea
11	userTicketNbr	User ticket number	No	3