WMS Pick Demand Export Format

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

Header Record

Position	Field Name	Format	Maximum Length
1	PICKHDR	-	-
2	Customer Code	Character	12
3	Customer Name	Character	25
4	Customer Division	Character	12
5	Customer Key	Character	8
6	Customer User Defined 1	Character	400
7	Customer User Defined 2	Character	400
8	Customer User Defined 3	Character	400
9	Customer User Defined 4	Character	400
10	Customer User Defined 5	Character	400
11	Customer User Defined 6	Character	400
12	Customer User Defined 7	Character	400
13	Customer User Defined 8	Character	400
14	Customer User Defined 9	Character	400
15	Customer User Defined 10	Character	400
16	Customer User Defined 11	Character	400
17	Customer User Defined 12	Character	400
18	Customer User Defined 13	Character	400
19	Customer User Defined 14	Character	400
20	Customer User Defined 15	Character	400
21	Customer User Defined 16	Character	400
22	Customer User Defined 17	Character	400
23	Customer User Defined 18	Character	400
24	Customer User Defined 19	Character	400
25	Customer User Defined 20	Character	400
26	Pick Demand Number	Character	12
27	Total Lines	Integer	>>>>>9
28	Total Weight	Decimal	->>>,>>>,>>9.99<<
29	Weight Unit of Measure Code	Character	8
30	Total Cube	Decimal	>>>,>>>,>>>,>>9.99
31	Shipment Number	Character	12
32	Zone Name	Character	20
33	Wave Number	Character	12
34	Route Number	Character	12
35	Stop Number	Integer	99999999
36	Batch Number	Character	12
37	Batch Sequence Number	Integer	>>>9
38	Door Number	Character	8
39	Work Orders	Character	12
40	Transfer Location Name	Character	20
41	Transfer Location Prefix	Character	3
42	Ship Via	Character	12
43	Shipper Name	Character	25
44	Payment Terms	Character	12
45	Location Name	Character	20
46	Customer Purchase Order Number	Character	20
47	Order Date	99/99/9999	10
48	Order Created Date	99/99/9999	10
49	Order Created Time	00:00.000	9
50	Order Created By	Character	60
51	Order Placer	Character	30
52	Order Number	Character	12
53	Required Date	99/99/9999	10
54	Printed Date	99/99/9999	10
55	Reprint	Yes/No	3
56	Number of Packages	Integer	>,>>>,>>9
57	Kit Product	Yes/No	3
58	Freight Collection Terms	Character	26
59	Freight Free	Yes/No	3
60	Updated By	Character	60
61	Updated Date	99/99/9999	10
62	Updated Time	00:00.000	9
63	Created By	Character	60
64	Created Date	99/99/9999	10
65	Created Time	00:00.000	9
66	Bill of Lading Number	Character	17
67	Bill of Lading Trailer Number	Character	25
68	Print Sequence	Decimal	>>>,>>>,>>>,>>9.99
69	Master Bill of Lading Number	Character	17
70	PRO Number	Character	25
71	Task ID	Character	12
72	Report Form Name	Character	50
73	Picked By	Character	30
74	Packed By	Character	30
75	WMS Export Sequence	Character	8
76	WMS Export Batch Number	Character	12
77	WMS Export Date	99/99/9999	10
78	WMS Export Time	00:00.000	9
79	Has Related Pick Demands	Yes/No	3
80	Remarks Attached	Yes/No	3
81	Standard Remarks Attached	Yes/No	3
82	Pack Address Type	Character	10
83	Pack Name	Character	40
84	Pack Address 1	Character	30
85	Pack Address 2	Character	30
86	Pack Address 3	Character	30
87	Pack City	Character	40
88	Pack State	Character	3
89	Pack Postal Code	Character	12
90	Pack Country	Character	20
91	Pack Phone	Character	16
92	Pack Fax	Character	16
93	Pack Contact	Character	30
94	Pack Email Address	Character	254
95	Ship-To Address Type	Character	10
96	Ship-To Name	Character	40
97	Ship-To Address 1	Character	30
98	Ship-To Address 2	Character	30
99	Ship-To Address 3	Character	30
100	Ship-To City	Character	40
101	Ship-To State	Character	3
102	Ship-To Postal Code	Character	12
103	Ship-To Country	Character	20
104	Ship-To Phone	Character	16
105	Ship-To Fax	Character	16
106	Ship-To Contact	Character	30
107	Ship-To Email Address	Character	254
108	Bill-To Address Type	Character	10
109	Bill-To Name	Character	40
110	Bill-To Address 1	Character	30
111	Bill-To Address 2	Character	30
112	Bill-To Address 3	Character	30
113	Bill-To City	Character	40
114	Bill-To State	Character	3
115	Bill-To Postal Code	Character	12
116	Bill-To Country	Character	20
117	Bill-To Phone	Character	16
118	Bill-To Fax	Character	16
119	Bill-To Contact	Character	30
120	Bill-To Email Address	Character	254
121	Sales Representative	Character	12
122	Total Base Unit of Measure Quantity	Decimal	->>>,>>>,>>9.99<<
123	Warehouse Wave	Character	12
124	Sort Sequence	Character	>,>>>,>>9
125	Packslip Break	Yes/No	3
126	Packing List URL	Character	1000
127	Sold To Name	Character	40
128	Sold To-company	Character	40
129	Sold To Address1	Character	60
130	Sold To Address2	Character	60
131	Sold To Address3	Character	60
132	Sold To City	Character	40
133	Sold To State	Character	3
134	Sold To Postal Code	Character	30
135	Sold To Country	Character	20
136	Sold To Phone	Character	30
137	Billing Cust Code	Character	15
138	Billing Cust Name	Character	40
139	Order Class	Character	12
140	Ship-To Store Id	Character	20

Trailer Record (1+ Per Pick Demand)

Position	Field Name	Format	Maximum Length
1	PICKTRL	-	-
2	Product Code	Character	40
3	Product Code Unformatted	Character	40
4	Product Name	Character	40
5	Product Key	Character	8
6	Description	Character	30
7	Search Name	Character	400
8	Product User Defined 1	Character	400
9	Product User Defined 2	Character	400
10	Product User Defined 3	Character	400
11	Product User Defined 4	Character	400
12	Product User Defined 5	Character	400
13	Product User Defined 6	Character	400
14	Product User Defined 7	Character	400
15	Product User Defined 8	Character	400
16	Product User Defined 9	Character	400
17	Product User Defined 10	Character	400
18	Product User Defined 11	Character	400
19	Product User Defined 12	Character	400
20	Product User Defined 13	Character	400
21	Product User Defined 14	Character	400
22	Product User Defined 15	Character	400
23	Product User Defined 16	Character	400
24	Product User Defined 17	Character	400
25	Product User Defined 18	Character	400
26	Product User Defined 19	Character	400
27	Product User Defined 20	Character	400
28	Product Category Code	Character	12
29	Product Category Description	Character	240
30	Product Category Key	Character	8
31	Product Subcategory Code	Character	12
32	Product Subcategory Name	Character	30
33	Product Subcategory Key	Character	8
34	Size Code	Character	8
35	Size Name	Character	30
36	Size Sort Sequence	Integer	>,>>>,>>9
37	NRF Size Code	Integer	>>>>9
38	Color Code	Character	8
39	Color Name	Character	30
40	Color Sort Sequence	Integer	>,>>>,>>9
41	NRF Color Code	Integer	>>9
42	Product Style	Character	12
43	Product Style Name	Character	30
44	Product Style Sort Sequence	Integer	>,>>>,>>9
45	Product Line Code	Character	8
46	Product Line Name	Character	30
47	Product Line Sort Sequence	Integer	>,>>>,>>9
49	Bottle Size	Decimal	>>>,>>9.9999
49	Bottle Dimension Basis	Character	8
50	Pick Demand Number	Character	12
51	Type	Character	12
52	Sequence	Integer	99999999
53	Original Sequence	Integer	99999999
54	Recommended Quantity	Decimal	->>>,>>>,>>9.99<<
55	Quantity on Hand	Decimal	->>>,>>>,>>9.99<<
56	Recommended Unit of Measure	Character	8
57	Product Code Formatted	Character	40
58	Product Unit of Measure	Character	8
59	Bill of Material Quantity	Decimal	->>,>>9.99
60	Kit Product Code	Character	40
61	Quantity Backordered	Decimal	->>>,>>>,>>9.99<<
62	Quantity Ordered	Decimal	->>>,>>>,>>9.99<<
63	Packed Unit of Measure	Character	8
64	Total Picked Quantity	Decimal	->>>,>>>,>>9.99<<
65	Customer Product Name	Character	40
66	Customer Product Code	Character	40
67	Retail Price	Decimal	->>>,>>>,>>9.99<<
68	Hazard Code	Character	12
69	Hazard Code Description	Character	20
70	Hazard Code Detailed Description	Character	240
71	Bin	Character	20
72	Lot	Character	40
73	Serial Number	Character	40
74	Customer Requested	Yes/No	3
75	Broke Inventory	Yes/No	3
76	Break-From Unit of Measure	Character	8
77	Cancel-After Date	99/99/9999	10
78	Current Sequence	Character	8
79	Alpha Package Number	Character	21
80	Remark Attached	Yes/No	3
81	Standard Remark Attached	Yes/No	3
82	Order Number	Character	12
83	Customer Purchase Order Number	Character	20
84	Order Line Number	Integer	>>>9
85	Kit Product	Character	40
86	Product Alternate Search Name	Character	20
87	Unit Price	Decimal	->>>,>>>,>>9.99<<
88	Unit Weight	Decimal	>>>,>>>,>>9.9999
89	Unit Net Weight	Decimal	>>>,>>>,>>9.9999
90	Weight Unit of Measure Code	Character	8
91	Unit Volume	Decimal	>>>,>>>,>>9.9999
92	Volume Unit of Measure Code	Character	8
93	Price Adjustment	Decimal	->>>,>>>,>>9.99<<
94	Recommended Quantity in Ordered Unit of Measure	Decimal	->>>,>>>,>>9.99<<
95	Order Unit of Measure Code	Character	8
96	UPC	Character	25
97	SGTIN	Character	30
98	UCC128 Number	Character	36
99	List Price 1	Decimal	->>>,>>>,>>9.99<<
100	List Price 2	Decimal	->>>,>>>,>>9.99<<
101	List Price 3	Decimal	->>>,>>>,>>9.99<<
102	List Price 4	Decimal	->>>,>>>,>>9.99<<
103	Expiration Date	99/99/9999	10
104	Best Before Date	99/99/9999	10
105	Has Charges	Yes/No	3
106	Has Remarks	Yes/No	3
107	Has Standard Remarks	Yes/No	3
108	Product Key	Character	8
109	Product Description	Character	30
110	Product Code	Character	40
111	GTIN	Character	25
112	Package Number	Integer	99999999
113	Kit UPC	Character	25
114	Cartonization	Yes/No	3
115	Carton Code	Character	15
116	Updated By	Character	60
117	Updated Date	99/99/9999	10
118	Updated Time	00:00.000	9
119	Created By	Character	60
120	Created Date	99/99/9999	10
121	Created Time	00:00.000	9
122	Unit of Measure Status	Character	12
123	Order Number Line Number	Character	20
124	Product Package Unit of Measure	Character	8
125	Beverage Bottle Size	Character	11
126	Beverage Bottle Size Unit of Measure	Character	8
127	Warehouse Product Code	Character	40
128	Warehouse Product Name	Character	40
129	Order Line Item EDI Spare 1	Character	12
130	Order Line Item EDI Spare 2	Character	12
131	Order Line Item EDI Spare 3	Character	12
132	Order Line Item EDI Spare 4	Character	12
133	Order Line Item EDI Spare 5	Character	12
134	Order Line Item Miscellaneous Data 1	Character	60
135	Order Line Item Miscellaneous Data 2	Character	60
136	Order Line Item User Defined Field 1	Character	400
137	Order Line Item User Defined Field 2	Character	400
138	Order Line Item User Defined Field 3	Character	400
139	Order Line Item User Defined Field 4	Character	400
140	Order Line Item User Defined Field 5	Character	400
141	Order Line Item User Defined Field 6	Character	400
142	Order Line Item User Defined Field 7	Character	400
143	Order Line Item User Defined Field 8	Character	400
144	Order Line Item User Defined Field 9	Character	400
145	Order Line Item User Defined Field 10	Character	400
146	Order Line Item User Defined Field 11	Character	400
147	Order Line Item User Defined Field 12	Character	400
148	Order Line Item User Defined Field 13	Character	400
149	Order Line Item User Defined Field 14	Character	400
150	Order Line Item User Defined Field 15	Character	400
151	Order Line Item User Defined Field 16	Character	400
152	Order Line Item User Defined Field 17	Character	400
153	Order Line Item User Defined Field 18	Character	400
154	Order Line Item User Defined Field 19	Character	400
155	Order Line Item User Defined Field 20	Character	400
156	Bin Sequence	Integer	>,>>>,>>9
157	Package Unit of Measure Key	Character	8
158	Is Lot	Yes/No	3
159	Lot Code	Character	40
160	Lot Expiration Date	99/99/9999	10
161	Over Allocated Quantity	Decimal	->>>,>>>,>>9.99<<
162	Package Unit of Measure	Character	8
163	Pick Bin	Character	40
164	Conversion Factor 1	Decimal	->>>,>>>,>>9.99<<
165	Conversion Factor 2	Decimal	->>>,>>>,>>9.99<<
166	Conversion Factor 3	Decimal	->>>,>>>,>>9.99<<

Address Records (Ship-To and Bill-To)

Position	Field Name	Format	Maximum Length
1	PICKADDR	-	-
2	Pick Demand Number	Character	12
3	Address Type	Character	20
4	To Address Type	Character	20
5	Name	Character	40
6	Address 1	Character	30
7	Address 2	Character	30
8	Address 3	Character	30
9	City	Character	40
10	State	Character	3
11	Postal Code	Character	12
12	Country	Character	20
13	Phone	Character	16
14	Fax	Character	16
15	Contact	Character	30
16	Email Address	Character	254
17	Updated By	Character	60
18	Updated Date	99/99/9999	10
19	Updated Time	00:00.000	9
20	Created By	Character	60
21	Created Date	99/99/9999	10
22	Created Time	00:00.000	9
23	Company	Character	40
24	Store Id	Character	20

Bill of Material Instruction Record (0+ Per Pick Demand)

Position	Field Name	Format	Maximum Length
1	PICKBOM	-	-
2	Pick Demand Number	Character	12
3	Instruction	Character	10000
4	Updated By	Character	60
5	Updated Date	99/99/9999	10
6	Updated Time	00:00.000	9
7	Created By	Character	60
8	Created Date	99/99/9999	10
9	Created Time	00:00.000	9

Charge Record (0+ Per Pick Demand)

Position	Field Name	Format	Maximum Length
1	PICKCHRG	-	-
2	Pick Demand Number	Character	12
3	Order Number	Character	12
4	Line Number	Character	20
5	Updated By	Character	60
6	Updated Date	99/99/9999	10
7	Updated Time	00:00.000	9
8	Created By	Character	60
9	Created Date	99/99/9999	10
10	Created Time	00:00.000	9
11	Charge Amount	Decimal	>>>,>>>,>>9.9999
12	Use Percent	Yes/No	3
13	Percentage	Decimal	>>>,>>>,>>9.9999
14	Comment	Character	60
15	Type	Character	12
16	Original Sequence	Integer	99999999

Kit Record (0+ Per Pick Demand)

Position	Field Name	Format	Maximum Length
1	PICKKIT	-	-
2	Pick Demand Number	Character	12
3	Order Line Number	Integer	>>>9
4	Order Number	Character	12
5	Kit Product Name	Character	40
6	Kit Product Code	Character	40
7	Recommended Quantity	Decimal	>>>,>>>,>>9.9999
8	Unit of Measure	Character	8
9	Picked Quantity	Decimal	>>>,>>>,>>9.9999
10	Backordered Quantity	Decimal	>>>,>>>,>>9.9999
11	Updated By	Character	60
12	Updated Date	99/99/9999	10
13	Updated Time	00:00.000	9
14	Created By	Character	60
15	Created Date	99/99/9999	10
16	Created Time	00:00.000	9
17	Search Name	Character	400
18	UPC	Character	25
19	Size Code	Character	8
20	Size Name	Character	30
21	Size Sort Sequence	Integer	>,>>>,>>9
22	NRF Size Code	Integer	>>>>9
23	Color Code	Character	8
24	Color Name	Character	30
25	Color Sort Sequence	Integer	>,>>>,>>9
26	NRF Color Code	Integer	>>9
27	Product Style	Character	12
28	Product Style Name	Character	30
29	Product Style Sort Sequence	Integer	>,>>>,>>9
30	Product Line Code	Character	8
31	Product Line Name	Character	30
32	Product Line Sort Sequence	Integer	>,>>>,>>9

Order Record

Position	Field Name	Format	Maximum Length
1	PICKORD	-	-
2	Order Date	99/99/9999	10
3	Order Created Date	99/99/9999	10
4	Order Created Time	00:00.000	9
5	Order Created By	Character	60
6	Order Placer	Character	30
7	Order Number	Character	12
8	Ship-To Phone	Character	30
9	Pick Demand Number	Character	12
10	Shipping Account ID	Character	20
11	Updated By	Character	60
12	Updated Date	99/99/9999	10
13	Updated Time	00:00.000	9
14	Created By	Character	60
15	Created Date	99/99/9999	10
16	Created Time	00:00.000	9
17	Order User Defined Field 1	Character	400
18	Order User Defined Field 2	Character	400
19	Order User Defined Field 3	Character	400
20	Order User Defined Field 4	Character	400
21	Order User Defined Field 5	Character	400
22	Order User Defined Field 6	Character	400
23	Order User Defined Field 7	Character	400
24	Order User Defined Field 8	Character	400
25	Order User Defined Field 9	Character	400
26	Order User Defined Field 10	Character	400
27	Order User Defined Field 11	Character	400
28	Order User Defined Field 12	Character	400
29	Order User Defined Field 13	Character	400
30	Order User Defined Field 14	Character	400
31	Order User Defined Field 15	Character	400
32	Order User Defined Field 16	Character	400
33	Order User Defined Field 17	Character	400
34	Order User Defined Field 18	Character	400
35	Order User Defined Field 19	Character	400
36	Order User Defined Field 20	Character	400
37	User Date 1	99/99/9999	10
38	User Date 2	99/99/9999	10
39	User Date 3	99/99/9999	10
40	User Date 4	99/99/9999	10
41	User Date 5	99/99/9999	10
42	User Date 6	99/99/9999	10
43	User Date 7	99/99/9999	10
44	User Date 8	99/99/9999	10
45	User Date 9	99/99/9999	10
46	User Date 10	99/99/9999	10
47	Earliest Ship Date	99/99/9999	10
48	Latest Ship Date	99/99/9999	10
49	Order EDI Spare 1	Character	12
50	Order EDI Spare 2	Character	12
51	Order EDI Spare 3	Character	12
52	Order EDI Spare 4	Character	12
53	Order EDI Spare 5	Character	12
54	Order Miscellaneous Data 1	Character	60
55	Order Miscellaneous Data 2	Character	60
56	Alternate Purchase Order	Character	60
57	Import Miscellaneous Data 1	Character	200
58	EDI Trading Partner	Character	25
59	Department Number	Character	30
60	Internal Vendor Number	Character	20
61	EDI Release Date	99/99/9999	10
62	EDI Release Time	00:00.000	9
63	EDI Release User	Character	60
64	Order Priority	Integer	>>>9
65	Return To Address Name	Character	40
66	Return To Address Company	Character	40
67	Return To Address 1	Character	60
68	Return To Address 2	Character	60
69	Return To Address 3	Character	60
70	Return To City	Character	40
71	Return To State	Character	3
72	Return To Postal Code	Character	30
73	Return To Country	Character	20
74	Return To Phone	Character	16

Remark Record (0+ Per Pick Demand)

Position	Field Name	Format	Maximum Length
1	PICKREM	-	-
2	Pick Demand Number	Character	12
3	Order Number	Character	12
4	Sequence	Character	99999999
5	Type	Character	12
6	Remark Sequence	Integer	>>>9
7	Remarks	Character	10000
8	Updated By	Character	60
9	Updated Date	99/99/9999	10
10	Updated Time	00:00.000	9
11	Created By	Character	60
12	Created Date	99/99/9999	10
13	Created Time	00:00.000	9

Return Record (0+ Per Pick Demand)

Position	Field Name	Format	Maximum Length
1	PICKRTN	-	-
2	Pick Demand Number	Character	12
3	Related Pick Demand Number	Character	12
4	Zone	Character	20
5	Updated By	Character	60
6	Updated Date	99/99/9999	10
7	Updated Time	00:00.000	9
8	Created By	Character	60
9	Created Date	99/99/9999	10
10	Created Time	00:00.000	9

Track Record (0+ Per Pick Demand)

Position	Field Name	Format	Maximum Length
1	PICKTRK	-	-
2	Pick Demand Number	Character	12
3	Tracking Number	Character	100
4	Updated By	Character	60
5	Updated Date	99/99/9999	10
6	Updated Time	00:00.000	9
7	Created By	Character	60
8	Created Date	99/99/9999	10
9	Created Time	00:00.000	9