WMS Work Order Export Format

The following tables list the format for exporting work order data to a WMS. Each record is a comma-delimited row in the export file.

Header Record

Position	Field Name
1	MFGHDR
2	Batch
3	Work Order Number
4	Goods Product Code
5	Goods Product Name
6	Goods Product Description
7	Goods UPC
8	Operation Sequence
9	Operation Code
10	Work Center Code
11	Next Operation Code
12	Next Work Center Code
13	Build Quantity
14	Unit of Measure
15	Printed Date
16	Expected Date
17	Has Instructions
18	Has Remarks
19	Backflushed Components
20	Warehouse Product Code
21	Warehouse Product Name
22	WMS Export Sequence Number
23	WMS Export Batch Number
24	WMS Export Date
25	WMS Export Time
26	Sales Order Number
27	Expected Start Date
28	Expected Finish Date
29	Expected Finish Time
30	Estimated Total Time
31	Estimated Total Time Unit of Measure
32	Billing Customer Code
33	Billing Customer Name
34	Work Order User Defined Field 1
35	Work Order User Defined Field 2
36	Work Order User Defined Field 3
37	Work Order User Defined Field 4
38	Work Order User Defined Field 5
39	Work Order User Defined Field 6
40	Work Order User Defined Field 7
41	Work Order User Defined Field 8
42	Work Order User Defined Field 9
43	Work Order User Defined Field 10
44	Work Order User Defined Field 11
45	Work Order User Defined Field 12
46	Work Order User Defined Field 13
47	Work Order User Defined Field 14
48	Work Order User Defined Field 15
49	Work Order User Defined Field 16
50	Work Order User Defined Field 17
51	Work Order User Defined Field 18
52	Work Order User Defined Field 19
53	Work Order User Defined Field 20

Position	Field Name
1	MFGTRL
2	Work Order Number
3	Operation Sequence
4	Line
5	Component Product Code
6	Component Product Name
7	Component Product Description
8	Component UPC
9	Must Backflush
10	Bin
11	Lot
12	Serial Number
13	Recommended Quantity
14	Issued Quantity
15	Recommended Unit of Measure
16	Break-From Unit of Measure
17	Assembly String
18	Break-From String
19	Per Unit Quantity
20	Backflush Report
21	Warehouse Product Code (Component)
22	Warehouse Product Name (Component)