WMS Return Receipt Import Format

The following tables list the format for importing return receipt data from a WMS. Each record is a caret-delimited row in the import file.

Header Record

Position	Field Name	Required	Description
1	RTNHDR	Yes	This is RTNHDR to indicate the record is a header record.
2	Location Prefix	Yes	This is the location prefix for the location of the receipt.
3	Reference Number	Yes	This is the return order number for the receipt.
4	As Is Option	No	If this is YES, receive as is.
5	Bin Option	No	This is one of the following to indicate the bin in which the product is received: Primary Putaway Bin %BLANK%
6	Default Bin	No	This is the default bin if Bin is entered for the Bin Option field (position 5).
7	Disposition Code	No	This is the default disposition code.
8	Adjust Option	No	If this is YES, inventory is adjusted for the return receipt.
9	Invoice Option	No	If this is YES, the invoice is created for the return receipt.
10	WMS Transaction Date	No	This is the date the transaction occurred in the WMS. This defaults to the current date.
11	WMS Transaction Time	No	This is the time the transaction occurred in the WMS. This defaults to the current time.
12	WMS Import Key	No	This is a key value used to differentiate between WMS transactions. If this is imported, it must be a unique value that was not previously associated with a WMS transaction.

Position	Field Name	Required	Description
1	RTNTRL	Yes	This is RTNTRL to indicate the record is a trailer record.
2	Return Order Line Number	Yes	This is the return order line number for the receipt.
3	Product Code	Yes	This is the product code for the return order line.
4	Kit Product Code	No	This is the kit product code for the return order line if the line is a fixed kit product.
5	Receipt Quantity	Yes	This is the quantity received.
6	Confirmed Quantity	Yes	This is the confirmed quantity.
7	Unit of Measure	Yes	This is the confirmed unit of measure.
8	Bin	No	This is the bin in which the product is received.
9	Lot	No	This is the lot for the received product if it is tracked by lot.
10	Serial Number	No	This is the serial number for the received product if it is tracked by serial number.
11	Expiration Date	No	This is the lot expiration date if the product is tracked by lot.
12	Disposition Code	No	This is the return disposition code. This is required only if the disposition code is blank in the header record.
13	Additional Item	No	This indicates if it is an additional line item.
14	Return Reason Code	No	This is the return reason code if it is an additional line item.