WMS Purchase Order Export Format

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

Header Record

Position	Field Name	Format	Maximum Length
1	POHDR	-	-
2	System ID	Character	12
3	Printer Key	Character	90
4	Purchase Order Number	Character	12
5	Purchase Order Sequence	Integer	>>>9
6	Updated By	Character	60
7	Updated Date	99/99/9999	10
8	Updated Time	00:00.000	9
9	Created By	Character	60
10	Created Date	99/99/9999	10
11	Created Time	00:00.000	9
12	Supplier's Confirming Order Number	Character	20
13	Requisition Number	Character	12
14	Entered Currency	Character	8
15	Terms	Character	12
16	Payment Method	Character	30
17	Ship Via	Character	12
18	Shipper Name	Character	25
19	FOB	Character	12
20	FOB Name	Character	30
21	Originator	Character	60
22	Buyer	Character	12
23	Purchase Order Date	99/99/9999	10
24	Delivery Date	99/99/9999	10
25	Ship Date	99/99/9999	10
26	Required Date	99/99/9999	10
27	Merchandise Amount	Decimal	->,>>>,>>>,>>9.99<<
28	Charge Amount	Decimal	->>,>>>,>>9.9999
29	Total Amount	Decimal	->>,>>>,>>9.9999
30	Purchase Order Type	Character	20
31	Purchase Order Class	Character	10
32	Purchase Order Status	Character	20
33	Voucher Status	Character	20
34	Supplier Key	Character	8
35	Supplier Code	Character	15
36	Supplier Name	Character	20
37	Contact	Character	30
38	Bill-To Location Name	Character	20
39	Ship-To Location Name	Character	20
40	Total Weight	Decimal	->,>>>,>>>,>>9.99<<
41	Total Volume	Decimal	->,>>>,>>>,>>9.99<<
42	Total Units	Decimal	->>,>>>,>>9.9999
43	Weight Unit of Measure Key	Character	8
44	Volume Unit of Measure Key	Character	8
45	Invoiced	Yes/No	3
46	Invoiced Complete	Yes/No	3
47	Project Number	Character	15
48	Finalized	Yes/No	3
49	Authorized	Yes/No	3
50	Ordered	Yes/No	3
51	Purchase Order Number	Character	12
52	Release Number	Integer	>>>9
53	Release Date	99/99/9999	10
54	Amendment Code	Character	2
55	Total VAT Amount	Decimal	>>,>>>,>>9.99
56	Total Amount with VAT	Decimal	>>,>>>,>>9.99
57	VAT ID	Character	30
58	Allowed to View Costs	Yes/No	3
59	Sales Contract Code	Character	20
60	WMS Export Sequence Number	Character	8
61	WMS Export Batch Number	Character	12
62	WMS Export Date	99/99/9999	10
63	WMS Export Time	00:00.000	9
64	Purchase Order User Defined 1	Character	400
65	Purchase Order User Defined 2	Character	400
66	Purchase Order User Defined 3	Character	400
67	Purchase Order User Defined 4	Character	400
68	Purchase Order User Defined 5	Character	400
69	Purchase Order User Defined 6	Character	400
70	Purchase Order User Defined 7	Character	400
71	Purchase Order User Defined 8	Character	400
72	Purchase Order User Defined 9	Character	400
73	Purchase Order User Defined 10	Character	400
74	Purchase Order User Defined 11	Character	400
75	Purchase Order User Defined 12	Character	400
76	Purchase Order User Defined 13	Character	400
77	Purchase Order User Defined 14	Character	400
78	Purchase Order User Defined 15	Character	400
79	Purchase Order User Defined 16	Character	400
80	Purchase Order User Defined 17	Character	400
81	Purchase Order User Defined 18	Character	400
82	Purchase Order User Defined 19	Character	400
83	Purchase Order User Defined 20	Character	400
84	Customer Code	Character	12
85	Customer Name	Character	25
86	Customer Purchase Order Number	Character	20
87	Order Number	Character	12
88	Order Number Truncated	Character	12
89	Reviewed By	Character	60
90	Reviewed Date	99/99/9999	10
91	Approved	Character	10
92	Rush	Yes/No	3
93	Expedite	Yes/No	3
94	Bill-To Location prefix	Character	3
95	Ship-To Location prefix	Character	3

Line Item Record (1+ Per Purchase Order)

Position	Field Name	Format	Maximum Length
1	POITM	-	-
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	Category Code	Character	12
29	Category Description	Character	240
30	Category Key	Character	8
31	Subcategory Code	Character	12
32	Subcategory Name	Character	30
33	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	Style Name	Character	30
44	Style Sort Sequence	Integer	>,>>>,>>9
45	Product Line Code	Character	8
46	Product Line Name	Character	30
47	Product Line Sort Sequence	Integer	>,>>>,>>9
48	Bottle Size	Decimal	>>>,>>9.9999
49	Bottle Dimension Basis	Character	8
50	System ID	Character	12
51	Printer Key	Character	90
52	Purchase Order Number	Character	12
53	Purchase Order Sequence	Integer	>>>9
54	Updated By	Character	60
55	Updated Date	99/99/9999	10
56	Updated Time	00:00.000	9
57	Created By	Character	60
58	Created Date	99/99/9999	10
59	Created Time	00:00.000	9
60	Line Number	Integer	>>>9
61	Quantity Ordered	Decimal	->>,>>>,>>9.99
62	Open Quantity	Decimal	->>,>>>,>>9.99
63	Unit of Measure	Character	8
64	Unit Cost	Decimal	->,>>>,>>9.9999
65	Cost Adjustment	Decimal	->,>>>,>>9.9999
66	Extended Cost	Decimal	->>>,>>>,>>9.9999
67	Charge Amount	Decimal	->>,>>>,>>9.99
68	Total Amount	Decimal	->>,>>>,>>9.99
69	Purchase Order Product Name	Character	40
70	Purchase Order Type	Character	20
71	Ship-To Location Name	Character	20
72	Unit Weight	Decimal	>>>,>>>,>>9.9999
73	Weight Unit of Measure	Character	8
74	Unit Volume	Decimal	>>>,>>>,>>9.9999
75	Volume Unit of Measure	Character	8
76	Cost Source	Character	20
77	Invoiced	Yes/No	3
78	Quantity Invoiced	Decimal	>,>>>,>>9.99
79	Invoiced Complete	Yes/No	3
80	Delivery Date	99/99/9999	10
81	Ship Date	99/99/9999	10
82	Ship Via	Character	12
83	Shipper Name	Character	25
84	FOB	Character	12
85	FOB Name	Character	30
86	Project Number	Character	15
87	Quantity Received	Decimal	>,>>>,>>9.99
88	Receipt Complete	Yes/No	3
89	Receipt Complete Date	99/99/9999	10
90	Transfer Order Line Number	Integer	>,>>>,>>9
91	Required Date	99/99/9999	10
92	Freight Free	Yes/No	3
93	Temporary Product	Yes/No	3
94	Entered in Warehouse	Yes/No	3
95	Receipt Number	Character	12
96	Product Key	Character	8
97	Product Description	Character	30
98	Display Product Code	Character	40
99	Display Product Name	Character	40
100	Release Number	Integer	>>>9
101	Release Line Number	Integer	>>>9
102	Rewards Customer	Character	8
103	Has Charges	Yes/No	3
104	Pack Quantity	Decimal	>>>,>>>,>>9.9999
105	Has Remarks	Yes/No	3
106	List Price 1	Decimal	>>>,>>>,>>9.9999
107	List Price 2	Decimal	>>>,>>>,>>9.9999
108	List Price 3	Decimal	>>>,>>>,>>9.9999
109	List Price 4	Decimal	>>>,>>>,>>9.9999
110	Has Standard Remarks	Yes/No	3
111	UPC	Character	30
112	GTIN	Character	30
113	Customer Product Code	Character	40
114	Customer Product Name	Character	40
115	VAT Rate	Decimal	>>>,>>>,>>9.9999
116	VAT Amount	Decimal	>>>,>>>,>>9.9999
117	VAT-Inclusive Cost	Decimal	>>>,>>>,>>9.9999
118	Extended VAT	Decimal	>>>,>>>,>>9.9999
119	VAT-Inclusive Extended Cost	Decimal	>>>,>>>,>>9.9999
120	Product Unit of Measure Quantity Ordered	Decimal	>>>,>>>,>>9.9999
121	Product Unit of Measure	Character	8
122	Harmonization Code	Character	20
123	Allowed to View Costs	Yes/No	3
124	Sales Contract Code	Character	20
125	Sales Contract Stage ID	Character	20
126	Sales Contract Line Number	Integer	>>>9
127	Group	Character	10000
128	Product Detail Description	Character	16959
129	Bottle Dimension Unit of Measure	Character	8
130	Product Created Date	99/99/9999	10
131	Purchase Order Item User Defined 1	Character	400
132	Purchase Order Item User Defined 2	Character	400
133	Purchase Order Item User Defined 3	Character	400
134	Purchase Order Item User Defined 4	Character	400
135	Purchase Order Item User Defined 5	Character	400
136	Purchase Order Item User Defined 6	Character	400
137	Purchase Order Item User Defined 7	Character	400
138	Purchase Order Item User Defined 8	Character	400
139	Purchase Order Item User Defined 9	Character	400
140	Purchase Order Item User Defined 10	Character	400
141	Purchase Order Item User Defined 11	Character	400
142	Purchase Order Item User Defined 12	Character	400
143	Purchase Order Item User Defined 13	Character	400
144	Purchase Order Item User Defined 14	Character	400
145	Purchase Order Item User Defined 15	Character	400
146	Purchase Order Item User Defined 16	Character	400
147	Purchase Order Item User Defined 17	Character	400
148	Purchase Order Item User Defined 18	Character	400
149	Purchase Order Item User Defined 19	Character	400
150	Purchase Order Item User Defined 20	Character	400
151	Beverage Bottle Size	Character	12
152	Beverage Bottle Size Unit of Measure	Character	8
153	Excise Tax Category	Character	20
154	Sales Tax Code	Character	20
155	Ship to location prefix	Character	3

Charge Record (0+ Per Purchase Order)

Position	Field Name	Format	Maximum Length
1	POCHRG	-	-
2	System ID	Character	12
3	Printer Key	Character	90
4	Purchase Order Number	Character	12
5	Purchase Order Sequence	Integer	>>>9
6	Updated By	Character	60
7	Updated Date	99/99/9999	10
8	Updated Time	00:00.000	9
9	Created By	Character	60
10	Created Date	99/99/9999	10
11	Created Time	00:00.000	9
12	Kind	Character	8
13	Line Number	Integer	>>>>>>>9
14	Type	Character	10
15	Description	Character	60
16	Amount Type	Character	15
17	Amount	Decimal	>>>,>>>,>>9.9999
18	Base Quantity	Decimal	>>,>>>,>>9.99
19	Unit of Measure	Character	8
20	Total Amount	Decimal	>>>,>>>,>>9.9999
21	Comment	Character	68
22	Supplier Key	Character	8
23	Supplier Type	Character	10
24	Entered in Warehouse	Yes/No	3
25	Receipt Number	Character	12
26	Invoiced Amount	Yes/No	3
27	Invoiced Complete	Yes/No	3
28	Shipment Number	Character	25
29	Release Number	Integer	>>>9
30	Release Line Number	Integer	>>>9
31	VAT Rate	Decimal	>>>,>>>,>>9.9999
32	VAT Amount	Decimal	>>>,>>>,>>9.9999
33	VAT-Inclusive Amount	Decimal	>>>,>>>,>>9.9999
34	Allowed to View Costs	Yes/No	3
35	Group	Character	10000

Address Record (Supplier, Ship-From, Ship-To, and Bill-To)

Position	Field Name	Format	Maximum Length
1	POADDR	-	-
2	System ID	Character	12
3	Printer Key	Character	90
4	Purchase Order Number	Character	12
5	Purchase Order Sequence	Integer	>>>9
6	Address Type	Character	20
7	Name	Character	40
8	Supplier Code	Character	15
9	Supplier Name	Character	20
10	Address 1	Character	30
11	Address 2	Character	30
12	Address 3	Character	30
13	City	Character	40
14	State	Character	3
15	Postal Code	Character	12
16	Country	Character	20
17	Phone	Character	16
18	Fax	Character	16
19	Contact	Character	30
20	Email Address	Character	254
21	Updated By	Character	60
22	Updated Date	99/99/9999	10
23	Updated Time	00:00.000	9
24	Created By	Character	60
25	Created Date	99/99/9999	10
26	Created Time	00:00.000	9
27	Release Number	Integer	>>>9
28	Release Line Number	Integer	>>>9
29	Message	Character	125

Remark Record (0+ Per Purchase Order)

Position	Field Name	Format	Maximum Length
1	POREM	-	-
2	System ID	Character	12
3	Printer Key	Character	90
4	Purchase Order Number	Character	12
5	Purchase Order Sequence	Integer	>>>9
6	Updated By	Character	60
7	Updated Date	99/99/9999	10
8	Updated Time	00:00.000	9
9	Created By	Character	60
10	Created Date	99/99/9999	10
11	Created Time	00:00.000	9
12	Type	Character	12
13	Line Number	Integer	>>>9
14	Remark Number	Integer	>>>9
15	Remarks	Character	10000
16	Release Number	Integer	>>>9
17	Release Line Number	Integer	>>>9
18	Group	Character	10000