WMS Work Order Confirmation Import Format

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

Header Record

Position	Field Name	Required	Description
1	WOHDR	Yes	This is WOHDR to indicate the record is a header record.
2	Location Prefix	Yes	This is the location prefix.
3	Work Order Number	Yes	This is the work order number.
4	Confirm Sequence	No	This is blank for a new confirmation.
5	Operation Sequence	No	This is blank for all sequences.
6	Product Code	No	This defaults from the work order.
7	Confirmed Date	No	This defaults to the current date.
8	Confirmed Quantity	Yes	This is the confirmed quantity of finished goods.
9	Confirmed Unit of Measure	No	This defaults to the unit of measure on the work order.
10	Confirmed Bin	Yes	This is the bin in which to put the finished goods.
11	Confirmed Lot	Yes, only for lot-tracked products	This is the lot for the finished goods if the product is tracked by lot.
12	Confirmed Serial Number	Yes, only for products tracked by serial number	This is the serial number for finished goods.
13	Expiration Date	Yes, only for products tracked by lot	This is the lot expiration date if the product is tracked by lot.
14	As Is Option	No	If this is YES, confirm as is.
15	Adjust Option	No	This indicates whether to adjust inventory. This defaults to NO.
16	Complete Option	No	This defaults to NO.
17	WMS Transaction Date	No	This is the date the transaction occurred in the WMS. This defaults to the current date.
18	WMS Transaction Time	No	This is the time the transaction occurred in the WMS. This defaults to the current time.
19	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.

Trailer Record

Position	Field Name	Required	Description
1	WOTRL	Yes	This is WOTRL to indicate the record is a trailer record.
2	Operation Sequence	Yes	This is the operation sequence number.
3	Product Code	Yes	This defaults to the product from the original sequence line.
4	Phantom Assembly Product Code	No	This is the phantom assembly product code.
5	Used Quantity	Yes	This is the used component quantity.
6	Scrap Quantity	No	This defaults to zero.
7	Returned Quantity	No	This defaults to zero.
8	Unit of Measure Code	No	This defaults to the product unit of measure.
9	Returned Bin	No	This is the bin into which to put returned components.
10	Returned Lot	No	This is the lot for returned components if the components are tracked by lot.
11	Returned Serial	No	This is the serial number for returned components if the components are tracked by serial number.
12	Returned Expiration Date	No	This is the lot expiration date for returned components if the components are tracked by lot.

Cost Record

Position	Field Name	Required	Description
1	WOCOST	Yes	This is WOCOST to indicate the record is a cost record.
2	Operation Sequence	Yes	This is the operation sequence number.
3	Cost Category Code	Yes	This is the cost category code.
4	Cost Time	No	This is the cost time.