WMS Container Export Format

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

Container Record

Position	Field Name	Format	Maximum Length
1	CNT	-	-
2	Container Code	Character	12
3	Container Name	Character	25
4	Shipment Number	Character	25
5	Vessel Name	Character	40
6	Ship Date	99/99/9999	10
7	Delivery Date	99/99/9999	10
8	Country	Character	20
9	Shipment Status	Character	20
10	Container Status	Character	20
11	Ship Via	Character	12
12	Shipper	Character	25
13	From Port	Character	30
14	To Port	Character	30
15	Open Amount	Decimal	->,>>>,>>9.9999
16	Currency	Character	3
17	Purchase Order Number	Character	12
18	Original Quantity	Decimal	>>>,>>>,>>9.99<<
19	Open Quantity	Decimal	>>>,>>>,>>9.99<<
20	Unit of Measure	Character	8
21	Remarks	Character	10000
22	Purchase Order Line Number	Integer	>>>9
23	Release Number	Integer	>>>9
24	Release Line Number	Integer	>>>9
25	Lot	Character	40
26	Lot Quantity	Decimal	>>>,>>>,>>9.99<<
27	Expiration Date	99/99/9999	10
28	Best Before Date	99/99/9999	10
29	Track Detention	Yes/No	3
30	Detention Date	99/99/9999	10
31	Track Demurrage	Yes/No	3
32	Demurrage Date	99/99/9999	10
33	Pickup Scheduled	Yes/No	3
34	Pickup Scheduled Date	99/99/9999	10
35	Left Port	Yes/No	3
36	Left Port Date	99/99/9999	10
37	Receipt Complete	Yes/No	3
38	Return Scheduled	Yes/No	3
39	Return Scheduled Date	99/99/9999	10
40	Returned	Yes/No	3
41	Date Returned	99/99/9999	10
42	Container Type Code	Character	20
43	Product Code	Character	40
44	Product Code Unformatted	Character	40
45	Product Name	Character	40
46	Product Key	Character	8
47	Description	Character	30
48	Search Name	Character	400
49	Product User Defined 1	Character	400
50	Product User Defined 2	Character	400
51	Product User Defined 3	Character	400
52	Product User Defined 4	Character	400
53	Product User Defined 5	Character	400
54	Product User Defined 6	Character	400
55	Product User Defined 7	Character	400
56	Product User Defined 8	Character	400
57	Product User Defined 9	Character	400
58	Product User Defined 10	Character	400
59	Product User Defined 11	Character	400
60	Product User Defined 12	Character	400
61	Product User Defined 13	Character	400
62	Product User Defined 14	Character	400
63	Product User Defined 15	Character	400
64	Product User Defined 16	Character	400
65	Product User Defined 17	Character	400
66	Product User Defined 18	Character	400
67	Product User Defined 19	Character	400
68	Product User Defined 20	Character	400
69	Category Code	Character	12
70	Category Description	Character	240
71	Category Key	Character	8
72	Subcategory Code	Character	12
73	Subcategory Name	Character	30
74	Subcategory Key	Character	8
75	Size Code	Character	8
76	Size Name	Character	30
77	Size Sort Sequence	Integer	>,>>>,>>9
78	NRF Size Code	Integer	>>>>9
79	Color Code	Character	8
80	Color Name	Character	30
81	Color Sort Sequence	Integer	>,>>>,>>9
82	NRF Color Code	Integer	>>9
83	Product Style	Character	12
84	Style Name	Character	30
85	Style Sort Sequence	Integer	>,>>>,>>9
86	Product Line Code	Character	8
87	Product Line Name	Character	30
88	Product Line Sort Sequence	Integer	>,>>>,>>9
89	Bottle Size	Decimal	>>>,>>9.9999
90	Bottle Dimension Basis	Character	8
91	Shipment User Defined 1	Character	30
92	Shipment User Defined 2	Character	30
93	Shipment User Defined 3	Character	30
94	Shipment User Defined 4	Character	30
95	Shipment User Defined 5	Character	30
96	Shipment User Defined 6	Character	30
97	Shipment User Defined 7	Character	30
98	Shipment User Defined 8	Character	30
99	Shipment User Defined 9	Character	30
100	Shipment User Defined 10	Character	30
101	Shipment User Defined 11	Character	30
102	Shipment User Defined 12	Character	30
103	Shipment User Defined 13	Character	30
104	Shipment User Defined 14	Character	30
105	Shipment User Defined 15	Character	30
106	Shipment User Defined 16	Character	30
107	Shipment User Defined 17	Character	30
108	Shipment User Defined 18	Character	30
109	Shipment User Defined 19	Character	30
110	Shipment User Defined 20	Character	30
111	Container User Defined 1	Character	30
112	Container User Defined 2	Character	30
113	Container User Defined 3	Character	30
114	Container User Defined 4	Character	30
115	Container User Defined 5	Character	30
116	Container User Defined 6	Character	30
117	Container User Defined 7	Character	30
118	Container User Defined 8	Character	30
119	Container User Defined 9	Character	30
120	Container User Defined 10	Character	30
121	Container User Defined 11	Character	30
122	Container User Defined 12	Character	30
123	Container User Defined 13	Character	30
124	Container User Defined 14	Character	30
125	Container User Defined 15	Character	30
126	Container User Defined 16	Character	30
127	Container User Defined 17	Character	30
128	Container User Defined 18	Character	30
129	Container User Defined 19	Character	30
130	Container User Defined 20	Character	30
131	WMS Export Sequence	Character	8
132	WMS Export Batch Number	Character	12
133	WMS Export Date	99/99/9999	10
134	WMS Export Time	00:00.000	9
135	Customer Purchase Order	Character	20
136	Shipping Location	Character	20
137	Shipping Location Name	Character	40
138	Shipping Location Address 1	Character	30
139	Shipping Location Address 2	Character	30
140	Shipping Location Address 3	Character	30
141	Shipping Location City	Character	40
142	Shipping Location State/Province	Character	3
143	Shipping Location Postal Code	Character	12
144	Shipping Location Country	Character	20
145	Shipping Location Phone	Character	16
146	Shipping Location Fax	Character	16
147	Shipping Location Email Address	Character	254
148	Shipping Location Contact	Character	30
149	Seal Number	Character	20
150	Supplier Order Number	Character	20
151	Default Receipt UM	Character	8
152	Package UM	Character	8
153	Default Receiving UM Qty	Decimal	>,>>>,>>9.99
154	Supplier Code	Character	15

Container Note Record

Position	Field Name	Format	Maximum Length
1	CNTNTE	-	-
2	Shipment Number	Character	25
3	Notes	Character	10000
4	Container Code	Character	12
5	Container Name	Character	25
6	Sequence	Integer	>>>9

Shipment Note Record

Position	Field Name	Format	Maximum Length
1	SHPNTE	-	-
2	Shipment Number	Character	25
3	Notes	Character	10000
4	Container Code	Character	12
5	Sequence	Integer	>>>9