The table below lists all UPS World Ease shipment data fields that UPS WorldShip can export.
Notes:
UPS World Ease is available only if you have a contract for this service.
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.
|
Category/Field |
Length |
Type |
I/E |
Exceptions and Notes |
|
World Ease Shipment |
||||
|
Shipper Number |
6 |
N |
E |
|
|
World Ease Type |
10 |
A |
E |
|
|
WE Number |
36 |
A/N |
E |
Must be unique. 0-9; A-Z. |
|
Port of Entry Name |
35 |
A/N |
E |
0-9; A-Z. |
|
Port of Entry Country/Territory |
50 |
A |
E |
|
|
Number of Shipments |
3 |
N |
E |
|
|
Number of Packages |
3 |
N |
E |
|
|
Service Type |
2 |
A/N |
E |
|
|
Billing Option |
20 |
A |
E |
|
|
Collection Date |
8 |
N |
E |
YYYYMMDD. |
|
Total Weight |
4 |
N |
E |
|
|
Description of Goods |
50 |
A/N/S |
E |
0-9; A-Z; special characters. |
|
Master Invoice Number |
35 |
N |
E |
|
|
Master Invoice PO Number |
35 |
N |
E |
|
|
Master Invoice Terms of Sale |
2 |
N |
E |
|
|
Master Invoice Reason for Export |
2 |
N |
E |
|
|
Master Invoice Declaration Statement |
255 |
A/N |
E |
See Declaration Statements. Only the name can be exported. |
|
Master Invoice Additional Comments |
45 |
A/N/S |
E |
0-9; A-Z; special characters. |
|
Master Invoice Ship To Type |
2 |
A/N |
E |
|
|
Master Invoice Line Total |
12 |
N |
E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
|
Master Invoice Discount Rebate Amount |
5 |
N |
E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
|
Master Invoice Freight Amount |
8 |
N |
E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
|
Master Invoice Insurance Amount |
8 |
N |
E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
|
Master Invoice Other Amount |
8 |
N |
E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
|
Master Invoice Total Amount |
16 |
N |
E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
|
Master Invoice Currency Code |
3 |
A |
E |
Note: For data field descriptions in the Shipment Information, Ship To, Ship From, Package, Third Party, Third Party (Receiver), International Documentation, Goods, Importer, Producer, Ultimate Consignee, Dangerous Goods Data, and LTL/TL Line Item categories, see Shipment Data Field Descriptions; however, all the fields in these categories are export only for World Ease.