WMS Return Order Export Format

The following tables list the format for exporting return 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	RTNHDR	-	-
2	Customer Code	Character	12
3	Customer Name	Character	40
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	System ID	Character	12
27	Printer Key	Character	90
28	Contract Number	Character	20
29	Customer Purchase Order Number	Character	20
30	Cancelled	Yes/No	3
31	Order Cancelled Date	99/99/9999	10
32	First Cancel After Date	99/99/9999	10
33	Order Class	Character	10
34	Order Date	99/99/9999	10
35	Order Number	Character	12
36	Order Placer	Character	30
37	Order Placer Phone Number	Character	30
38	Order Total	Decimal	->>>,>>>,>>9.99
39	Order Type	Character	12
40	Order Weight Unit of Measure	Character	8
41	Required Date	99/99/9999	10
42	Sale Type	Character	8
43	Sales Representative ID	Character	12
44	Group Order Number	Character	12
45	Sales Tax Amount	Decimal	>>,>>>,>>9.99
46	Secondary Sales Representative	Character	12
47	Entered Currency	Character	8
48	Conversion Rate	Decimal	>>,>>9.9999<<<<
49	Conversion Date	99/99/9999	10
50	Convert to Currency	Character	8
51	Ship Complete	Yes/No	3
52	Quote Expiration Date	99/99/9999	10
53	Truncate Order Number	Character	12
54	Ship-To Name	Character	40
55	Ship-To Address 1	Character	30
56	Ship-To Address 2	Character	30
57	Ship-To Address 3	Character	30
58	Ship-To City	Character	40
59	Ship-To State	Character	3
60	Ship-To Postal Code	Character	12
61	Ship-To Country	Character	20
62	Ship-To Phone	Character	16
63	Ship-To Fax	Character	16
64	Ship-To Contact	Character	30
65	Ship-To Email Address	Character	254
66	Bill-To Name	Character	40
67	Bill-To Address 1	Character	30
68	Bill-To Address 2	Character	30
69	Bill-To Address 3	Character	30
70	Bill-To City	Character	40
71	Bill-To State	Character	3
72	Bill-To Postal Code	Character	12
73	Bill-To Country	Character	20
74	Bill-To Phone	Character	16
75	Bill-To Fax	Character	16
76	Bill-To Contact	Character	30
77	Bill-To Email Address	Character	254
78	Bill-To Card Type	Character	16
79	Bill-To Card Number	Character	19
80	Bill-To Card Expiration Date	99/99/9999	10
81	Bill-To Preferred Shipper	Character	12
82	Bill-To Shipper Name	Character	25
83	Bill-To Freight Collection Terms	Character	26
84	Bill-To Terms Code	Character	12
85	Bill-To Total VAT Amount	Decimal	->>,>>9.9999
86	Bill-To Total Amount with VAT	Decimal	->>,>>9.9999
87	Bill-To VAT ID	Character	16
88	Bill-To Total Prepayment Amount	Decimal	->>>,>>>,>>>,>>9.99
89	Created By	Character	60
90	Shipping Method	Character	8
91	Terms Description	Character	60
92	Sales Representative 1 First Name	Character	20
93	Sales Representative 1 Last Name	Character	25
94	Sales Representative 2 First Name	Character	20
95	Sales Representative 2 Last Name	Character	25
96	Associated Invoice	Character	12
97	Return Authorization Number	Character	12
98	Customer Reference Number	Character	12
99	Contract Code	Character	20
100	Customer Contract Number	Character	20
101	Contract Start Date	99/99/9999	10
102	Contract End Date	99/99/9999	10
103	WMS Export Sequence Number	Character	8
104	WMS Export Batch Number	Character	12
105	WMS Export Date	99/99/9999	10
106	WMS Export Time	00:00.000	9
107	Order User Defined 1	Character	400
108	Order User Defined 2	Character	400
109	Order User Defined 3	Character	400
110	Order User Defined 4	Character	400
111	Order User Defined 5	Character	400
112	Order User Defined 6	Character	400
113	Order User Defined 7	Character	400
114	Order User Defined 8	Character	400
115	Order User Defined 9	Character	400
116	Order User Defined 10	Character	400
117	Order User Defined 11	Character	400
118	Order User Defined 12	Character	400
119	Order User Defined 13	Character	400
120	Order User Defined 14	Character	400
121	Order User Defined 15	Character	400
122	Order User Defined 16	Character	400
123	Order User Defined 17	Character	400
124	Order User Defined 18	Character	400
125	Order User Defined 19	Character	400
126	Order User Defined 20	Character	400
127	User Date 1	99/99/9999	10
128	User Date 2	99/99/9999	10
129	User Date 3	99/99/9999	10
130	User Date 4	99/99/9999	10
131	User Date 5	99/99/9999	10
132	User Date 6	99/99/9999	10
133	User Date 7	99/99/9999	10
134	User Date 8	99/99/9999	10
135	User Date 9	99/99/9999	10
136	User Date 10	99/99/9999	10
137	Order EDI Spare 1	Character	8
138	Order EDI Spare 2	Character	8
139	Order EDI Spare 3	Character	8
140	Order EDI Spare 4	Character	8
141	Order EDI Spare 5	Character	8
142	Order Miscellaneous Data 1	Character	60
143	Order Miscellaneous Data 2	Character	60
144	Freight Free	Yes/No	3
145	Ship Backorder Complete	Yes/No	3
146	Ship Available at Cancel	Yes/No	3
147	Do Not Send EDI	Yes/No	3
148	Future Credit Check	Yes/No	3
149	On Hold Reason	Character	36
150	Remit To ID	Character	20
151	Remit To Name	Character	40
152	Remit To Address 1	Character	30
153	Remit To Address 2	Character	30
154	Remit To Address 3	Character	30
155	Remit To City	Character	40
156	Remit To State	Character	3
157	Remit To Postal Code	Character	10
158	Remit To Country	Character	20
159	Remit To County	Character	20
160	Remit To Phone	Character	16
161	Remit To Fax	Character	16
162	Remit To Email Address	Character	254
163	Remit To Attention	Character	36

Line Item Record (1+ Per Return Order)

Position	Field Name	Format	Maximum Length
1	RTNITM	-	-
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	Order Number	Character	12
53	Line Number	Integer	>>>9
54	Unit Price	Decimal	->,>>>,>>9.9999
55	Freight Rate	Decimal	>,>>>,>>9.9999
56	Extended Price	Decimal	->>>,>>>,>>9.9999
57	Quantity Ordered	Decimal	->>>,>>>,>>9.99<<
58	Quantity Backordered	Decimal	->>>,>>>,>>9.99<<
59	Quantity Allocated	Decimal	->>>,>>9.99<<
60	Customer Key	Character	8
61	Unit of Measure Key	Character	8
62	Price Source	Character	23
63	Product Name	Character	40
64	Unit Weight	Decimal	>>>,>>>,>>9.9999
65	Location Prefix	Character	3
66	Unit of Measure	Character	8
67	Unit of Measure Code	Character	8
68	Price Source Value	Character	23
69	Order Date	99/99/9999	10
70	Required Date	99/99/9999	10
71	Additional Charge Amount	Decimal	>>>,>>>,>>9.9999
72	Order Type	Character	12
73	Customer Code	Character	12
74	Group Order Number	Character	12
75	Bill of Material Key	Character	8
76	Total Amount	Decimal	->>>,>>>,>>9.99
77	Charge Amount	Decimal	->>>,>>>,>>9.9999
78	Unit Cube	Decimal	>>>,>>9.9999
79	Customer Product Code	Character	40
80	Customer Product Name	Character	40
81	Price Adjustment	Decimal	->,>>>,>>9.9999
82	Pack Quantity	Decimal	>,>>>,>>9.99
83	Promise Date	99/99/9999	10
84	List Price 1	Decimal	->>>,>>>,>>9.99<<
85	List Price 2	Decimal	->>>,>>>,>>9.99<<
86	List Price 3	Decimal	->>>,>>>,>>9.99<<
87	List Price 4	Decimal	->>>,>>>,>>9.99<<
88	Has Charges	Yes/No	3
89	UPC	Character	30
90	Has Remarks	Yes/No	3
91	GTIN	Character	30
92	Has Standard Remarks	Yes/No	3
93	VAT Rate	Decimal	->>,>>9.99
94	VAT Amount	Decimal	->>,>>9.9999
95	VAT-Inclusive Price	Decimal	->,>>>,>>9.9999
96	Extended VAT	Decimal	->>,>>9.9999
97	VAT-Inclusive Extended Price	Decimal	->>>,>>>,>>9.9999
98	Quantity Billed	Decimal	->>>,>>>,>>9.99<<
99	Cancelled Backorder	Yes/No	3
100	Cancelled	Yes/No	3
101	Cancel-After Date	99/99/9999	10
102	Adjustment Type	Character	10
103	Contract Code	Character	20
104	Customer Contract Number	Character	20
105	Contract Line Number	Integer	>>>9
106	Stage ID	Character	20
107	Contract Start Date	99/99/9999	10
108	Contract End Date	99/99/9999	10
109	Country of Origin	Character	10
110	Order Line Item User Defined 1	Character	400
111	Order Line Item User Defined 2	Character	400
112	Order Line Item User Defined 3	Character	400
113	Order Line Item User Defined 4	Character	400
114	Order Line Item User Defined 5	Character	400
115	Order Line Item User Defined 6	Character	400
116	Order Line Item User Defined 7	Character	400
117	Order Line Item User Defined 8	Character	400
118	Order Line Item User Defined 9	Character	400
119	Order Line Item User Defined 10	Character	400
120	Order Line Item User Defined 11	Character	400
121	Order Line Item User Defined 12	Character	400
122	Order Line Item User Defined 13	Character	400
123	Order Line Item User Defined 14	Character	400
124	Order Line Item User Defined 15	Character	400
125	Order Line Item User Defined 16	Character	400
126	Order Line Item User Defined 17	Character	400
127	Order Line Item User Defined 18	Character	400
128	Order Line Item User Defined 19	Character	400
129	Order Line Item User Defined 20	Character	400
130	Order Line Item EDI Spare 1	Character	12
131	Order Line Item EDI Spare 2	Character	12
132	Order Line Item EDI Spare 3	Character	12
133	Order Line Item EDI Spare 4	Character	12
134	Order Line Item EDI Spare 5	Character	12
135	Miscellaneous Data 1	Character	60
136	Miscellaneous Data 2	Character	60
137	Beverage Bottle Size	Character	10000
138	Beverage Bottle Size Unit of Measure	Character	8
139	Return Code	Character	10
140	Return Code Description	Character	30
141	Image File 1	Character	255
142	Image File 2	Character	255
143	Image File 3	Character	255
144	Package Unit of Measure	Character	8

Charge Record (0+ Per Return Order)

Position	Field Name	Format	Maximum Length
1	RTNCHG	-	-
2	System ID	Character	12
3	Printer Key	Character	90
4	Kind	Character	8
5	Line Number	Integer	>>>>>>>9
6	Type	Character	10
7	Description	Character	60
8	Amount Type	Character	15
9	Amount	Decimal	->>>,>>9.9999<<<<<<
10	Quantity Based On	Decimal	->>>,>>9.9999<<<<
11	Unit of Measure	Character	8
12	Charge Amount	Decimal	->>>,>>>,>>9.9999
13	Comment	Character	68
14	Entered in Warehouse	Yes/No	3
15	Receipt Number	Character	12
16	Invoiced Amount	Decimal	->>>,>>>,>>9.9999
17	Invoiced Complete	Yes/No	3
18	Order Number	Character	12
19	Customer Key	Character	8
20	VAT Rate	Decimal	->>,>>9.99
21	VAT Amount	Decimal	->>>,>>>,>>9.99<<
22	VAT-Inclusive Amount	Decimal	->>>,>>>,>>9.9999

Prepayment Record

Position	Field Name	Format	Maximum Length
1	RTNPP	-	-
2	Reference Number	Character	12
3	Reference Suffix	Character	99
4	Payer Customer Code	Character	12
5	Payer Customer Name	Character	40
6	Payment Date	99/99/9999	10
7	Payment Method	Character	30
8	Payment Amount	Decimal	->>>,>>>,>>>,>>9.99
9	Payment ID	Character	20
10	Open Amount	Decimal	->>>,>>>,>>>,>>9.99
11	Order Number	Character	12

Remark Record (0+ Per Return Order)

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

Company Record

Position	Field Name	Format	Maximum Length
1	RTNCMP	-	-
2	Company Name	Character	40
3	Address Type	Character	20
4	Address 1	Character	30
5	Address 2	Character	30
6	Address 3	Character	30
7	City	Character	40
8	State	Character	3
9	Country	Character	20
10	Postal Code	Character	12
11	Phone	Character	16
12	Fax	Character	16