The table below lists all commodity data fields that UPS WorldShip can import or export.
Notes:
Use only a Western character set to create records for an import file. If you use any other character set to create the field names and data in a record, the import fails for that record.
If you use Character Map (a Windows function) to insert special characters into the data that you plan to import, use only characters that belong to the Windows: Western character set. If you use another character set, the characters are converted to the Windows: Western character set and may not appear as you want.
Table Legend:
The Length column indicates the maximum number of characters you can type for the field.
The Type column indicates A for alphabetic characters, N for numeric characters, and S for special characters (such as, press the Shift and 4 keys to type $). For example, A/N/S means that you can type alphabetic, numeric, and special characters.
The I/E column indicates if the field applies to import (I), export (E), or both import and export (I/E) maps.
The Exceptions and Notes column provides additional information, such as valid values, field formats, or links to additional information.
|
Field |
Length |
Type |
I/E |
Exceptions and Notes |
|
Commodity |
|
|
|
|
|
Description of goods |
105 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
|
Tariff code |
15 |
N |
I/E |
0-9. |
|
Country/Territory of origin |
50 |
A |
I/E |
|
|
Unit of measure |
3 |
A |
I/E |
|
|
Unit price |
19 |
N/S |
I/E |
999999999999.999999; one period permitted. |
|
Currency Code |
3 |
A |
I/E |
|
|
Part number |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
|
SED Specific Data |
|
|
|
|
|
Schedule B number |
10 |
N |
I/E |
0-9. |
|
Unit of Measure 1 |
3 |
A/N |
I/E |
|
|
Unit of Measure 2 |
3 |
A/N |
I/E |
|
|
ECCN |
15 |
A/N |
I/E |
0-9; A-Z. |
|
DFM |
1 |
A |
I/E |
D, F, M. |
|
Exception code |
4 |
A |
I/E |
|
|
License number |
15 |
A/N |
I/E |
0-9; A-Z. |
|
Expiration date |
8 |
N |
I/E |
YYYYMMDD. |
|
SED Export Code |
|
|
I/E |
|
|
DDTC Registration Number |
10 |
N |
I/E |
|
|
DDTC Significant Military Equipment Indicator |
1 |
A |
I/E |
Y or N. |
|
DDTC Eligible Party Certification Indicator |
1 |
A |
I/E |
Y or N. |
|
DDTC USML Category Codes |
4 |
N |
I/E |
|
|
DDTC Quantity |
9 |
N |
I/E |
|
|
DDTC Unit of Measure |
20 |
N |
I/E |
|
|
DDTC License Line Number |
50 |
|
I/E |
|
|
NAFTA Specific Data |
|
|
|
|
|
Preference criterion |
1 |
A |
I/E |
|
|
Producer |
5 |
A/N |
I/E |
See Producer Codes. |
|
Multiple Countries/Territories of Origin |
1 |
A |
I/E |
Y or N. |
|
Net cost method |
1 |
A |
I/E |
Y or N. |
|
Period start |
8 |
N |
I/E |
YYYYMMDD. |
|
Period end |
8 |
N |
I/E |
YYYYMMDD. |