The table below lists all shipment data fields that UPS WorldShip® can import or export.
Notes:
For a list of the minimum required fields for automatic batch processing, see Automatic Batch Processing Minimum Required Fields.
For a list of the minimum required fields for LTL/TL shipment processing, see LTL/TL Shipment Processing Minimum Required Fields. USPS Endorsement applies only for Mail Innovations shipments.
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 will fail 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 that 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.
For imports, the fields appear in a different order than shown in this help topic.
Even though the Notes column may show Y or N, imports accept Y or 1 for international shipments.
Category/Field |
Length |
Type |
I/E |
Notes |
Shipment Information |
||||
Void Indicator |
1 |
A |
I/E |
Y or N. |
Profile Name |
35 |
A/N/S |
I/E |
|
Service Type |
50 |
A/N |
I/E |
See UPS Service Codes, UPS Service Codes for Freight Shipments, UPS Service Codes for UPS Mail Innovations Shipments and UPS Service Codes and Weight Limits for UPS SurePost Shipments. UPS Service Codes for Freight Shipments does not apply for Mail Innovations Shipments. |
Endorsement |
40 |
A |
I/E |
Valid values for UPS Mail Innovations are: Valid values for UPS SurePost are: |
Master Carton ID |
30 |
A/N |
I/E |
Worldwide Economy Only |
Book Number |
10 |
N |
E |
|
Page Number |
5 |
N |
E |
|
Lead Tracking Number |
30 |
A/N |
E |
|
Shipment ID |
37 |
A/N |
E |
|
Hundredweight |
1 |
A |
E |
Y or N. |
Actual Weight |
4 |
N |
I/E |
|
Dimensional Weight |
4 |
N |
I/E |
|
Deficit Weight |
4 |
N |
E |
|
Extended Area Indicator |
1 |
A |
E |
Y or N. |
Billable Weight |
4 |
N |
E |
|
Billing Option |
20 |
A |
I/E |
|
Bill Transportation To |
20 |
A |
I/E |
|
Bill Duty and Tax To |
20 |
A |
I/E |
|
Split Duty and Tax |
1 |
A |
I/E |
Y or N. See Bill-To Information and Codes. |
DDU |
1 |
A |
I/E |
Y or N. |
DDP |
1 |
A |
I/E |
Y or N. |
Label Printer ID |
35 |
A/N |
I/E |
|
Invoice Printer ID |
35 |
A/N |
I/E |
|
Report Printer ID |
35 |
A/N |
I/E |
|
Dangerous Goods Printer ID |
35 |
A/N |
I/E |
|
UPS World Ease® Printer ID |
35 |
A/N |
I/E |
|
ShipmentProcess Timestamp |
14 |
N |
E |
YYYYMMDDHHMMSS |
Collection date |
10 |
N |
I/E |
|
Delivery Date/Transit Time |
10 |
N |
E |
|
Dangerous Goods Option |
1 |
A |
E |
Y or N. |
Dangerous Goods Type |
10 |
A/N |
E |
|
Dangerous Goods Published Charge |
9 |
N |
E |
99999.99. |
Dangerous Goods Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Dangerous Goods CCC Rates Charge |
9 |
N |
E |
99999.99 |
Dangerous Goods Signatory Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Dangerous Goods Signatory Title |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Dangerous Goods Signatory Date |
8 |
N |
I/E |
YYYYMMDD. |
Dangerous Goods Signatory Place |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Excepted Quantities Option |
1 |
A |
I/E |
Y or N. |
Excepted Quantities Published Charge |
9 |
N |
E |
99999.99 |
Excepted Quantities Negotiated Rates Charge |
9 |
N |
E |
99999.99 |
Excepted Quantities CCC Rates Charge |
9 |
N |
E |
99999.99 |
Declared Value Option |
1 |
A |
I/E |
Y or N. |
Declared Value Reference Charge |
9 |
N |
E |
99999.99. |
Declared Value Shipper Paid |
1 |
A |
I/E |
Y or N. |
Declared Value Published Charge |
9 |
N |
E |
99999.99. |
Declared Value Amount |
20 |
N |
I/E |
|
Declared Value Currency Code |
2 |
N |
E |
|
COD Option |
1 |
A |
I/E |
Y or N. |
COD Amount |
20 |
N |
I/E |
|
COD Currency Code |
3 |
A |
I/E |
|
COD Cash Only |
2 |
N |
I/E |
|
COD Reference Charge |
9 |
N/S |
E |
99999.99. |
COD Published Charge |
9 |
N |
E |
99999.99. |
COD Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
COD CCC Rates Charge |
9 |
N |
E |
99999.99. |
Delivery Area Surcharge Type |
255 |
A |
E |
|
Delivery Area Surcharge REF |
9 |
N |
E |
|
Delivery Area Surcharge PUB |
9 |
N |
E |
|
Delivery Area Surcharge CCC |
9 |
N |
E |
|
Delivery Area Surcharge ABR |
9 |
N |
E |
|
Peak Season Surcharge PUB |
9 |
N |
E |
|
Peak Season Surcharge CCC |
9 |
N |
E |
|
Peak Season Surcharge ABR |
9 |
N |
E |
|
Surge Fee Commercial PUB |
9 |
N |
E |
|
Surge Fee Commercial ABR |
9 |
N |
E |
|
Surge Fee Residential PUB |
9 |
N |
E |
|
Surge Fee Residential ABR |
9 |
N |
E |
|
Surge Fee Additional Handling PUB |
9 |
N |
E |
|
Surge Fee Additional Handling ABR |
9 |
N |
E |
|
Surge Fee Large Package PUB |
9 |
N |
E |
|
Surge Fee Large Package ABR |
9 |
N |
E |
|
Origin Area Type |
35 |
A/N |
E |
|
Origin Area Surcharge Published |
20 |
N |
E |
|
Origin Area Surcharge CCC |
20 |
N |
E |
|
Origin Area Surcharge Negotiated |
20 |
N |
E |
|
Destination Area Type |
35 |
A/N |
E |
|
Destination Area Surcharge Published |
20 |
N |
E |
|
Destination Area Surcharge CCC |
20 |
N |
E |
|
Destination Area Surcharge Negotiated |
20 |
N |
E |
|
Residential Surcharge Published |
20 |
N |
E |
|
Residential Surcharge CCC |
20 |
N |
E |
|
Residential Surcharge Negotiated |
20 |
N |
E |
|
Security Surcharge PUB |
20 |
N |
E |
|
Security Surcharge CCC |
20 |
N |
E |
|
Security Surcharge ABR |
20 |
N |
E |
|
Fuel Surcharge PUB |
20 |
N |
E |
|
Fuel Surcharge CCC |
20 |
N |
E |
|
Fuel Surcharge ABR |
20 |
N |
E |
|
Duty/Tax Forwarding Surcharge PUB |
20 |
N |
E |
|
Duty/Tax Forwarding Surcharge CCC |
20 |
N |
E |
|
Duty/Tax Forwarding Surcharge ABR |
20 |
N |
E |
|
LTL/TL Indicator |
1 |
A |
I/E |
Y or N. |
SubPro Number |
19 |
N |
I/E |
|
Notify Before Del Option |
1 |
A |
I/E |
Y or N. |
Notify Before Del Phone Number |
15 |
N |
I/E |
|
Notify Before Del Contact Name |
35 |
A/N |
I/E |
|
Handling Charge Option |
1 |
A |
I/E |
Y or N. |
Handling Charge Amount |
9 |
N |
E |
99999.99. |
Handling Charge Type |
22 |
A |
I/E |
Flat Rate, Flat Per-Shipment Rate or Percentage. |
Handling Charge Flat Rate |
8 |
N |
I/E |
|
HC Amount Increase Decrease Type |
8 |
A |
I/E |
Increase or Decrease. |
Handling Charge Percentage |
6 |
N |
I/E |
Percent.hundredths; such as 12.34. |
Food Items |
1 |
A |
I/E |
Y or N. |
Return Service Option |
1 |
A |
I/E |
Y or N. |
Return Service Type |
50 |
A/N |
I/E |
The return service types available depend on the shipment origin. See Return Services Shipment Option Codes. |
Recipient Email Address |
50 |
A/N/S |
I/E |
Email Address will be required for all international shipments except when the destination country is Germany, China, or Poland. See Validate Email Addresses. |
Failed Email Address |
50 |
A/N/S |
I/E |
Email Address will be required for all international shipments except when the destination country is Germany, China, or Poland. See Validate Email Addresses. |
Instruction and Receipt Language |
3 |
A |
I/E |
See Language Codes. |
Return Service Merchandise Description |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Return Service Reference Charge |
9 |
N |
E |
99999.99. |
Return Service Published Charge |
9 |
N |
E |
99999.99. |
Return Service Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Return Service CCC Rates Charge |
9 |
N |
E |
99999.99. |
Call Tag Reference Number |
12 |
N |
E |
|
Import Control Option |
1 |
A |
I/E |
Y or N. |
Import Control Label Type |
50 |
A/N |
I/E |
1 UPS Pickup Attempt |
Import Control Recipient Email |
50 |
A/N/S |
I/E |
|
Import Control Failed Email |
50 |
A/N/S |
I/E |
|
Import Control Instruction Language |
3 |
A |
I/E |
Any three-character language abbreviation, such as ENU and FRA. |
Import Control Merchandise Description |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Import Control Published Charge |
15 |
N |
E |
9999999999999.99. |
Import Control Negotiated Rates Charge |
15 |
N |
E |
9999999999999.99. |
Import Control CCC Rates Charge |
15 |
N |
E |
9999999999999.99. |
Mail Innovations Return Service Option |
1 |
A |
I/E |
Y or N. |
Mail Innovations Return Service Label Type |
50 |
A/N/S |
I/E |
|
Mail Innovations Return Service Recipient Email Address |
50 |
A/N/S |
I/E |
|
Mail Innovations Return Service Failed Email Address |
50 |
A/N/S |
I/E |
|
Mail Innovations Return Service Instruction and Receipt Language |
3 |
A |
I/E |
|
Mail Innovations Return Service Merchandise Description |
35 |
A/N/S |
I/E |
|
Mail Innovations Return Service Published Charge |
15 |
N |
E |
9999999999999.99 |
Mail Innovations Return Service Negotiated Rates Charge |
15 |
N |
E |
9999999999999.99 |
Commercial Invoice Removal Option |
1 |
A |
I/E |
Y or N. |
Commercial Invoice Removal Published Charge |
15 |
N |
E |
9999999999999.99. |
Commercial Invoice Removal Negotiated Rates Charge |
15 |
N |
E |
9999999999999.99. |
Commercial Invoice Removal CCC Rates Charge |
15 |
N |
E |
9999999999999.99. |
Saturday Delivery Option |
1 |
A |
I/E |
Y or N. |
Saturday Delivery Reference Charge |
9 |
N |
E |
99999.99. |
Saturday Delivery Published Charge |
9 |
N |
E |
99999.99. |
Saturday Delivery Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Saturday Delivery CCC Rates Charge |
9 |
N |
E |
99999.99. |
Saturday Collection Option |
1 |
A |
I/E |
Y or N. |
Saturday Collection Reference Charge |
9 |
N |
E |
99999.99. |
Saturday Collection Published Charge |
9 |
N |
E |
99999.99. |
Saturday Collection Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Saturday Collection CCC Rates Charge |
9 |
N |
E |
99999.99. |
Return of Document Option |
1 |
A |
I/E |
Y or N. |
Return of Document Reference Charge |
9 |
N |
E |
99999.99. |
Return of Document Published Charge |
9 |
N |
E |
99999.99. |
Return of Document Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Return of Document CCC Rates Charge |
9 |
N |
E |
99999.99. |
QVN Option |
1 |
A |
I/E |
Quantum View Notify® (QVN). Y or N. |
QVN Reference Charge |
9 |
N |
E |
99999.99. |
QVN Published Charge |
9 |
N |
E |
99999.99. |
QVN Ship From Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
QVN Subject Line |
18 |
A/N |
I/E |
Shipment-level values: |
QVN Memo |
150 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Packing List Memo |
300 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
QVN Failed Email Address |
50 |
A/N/S |
I/E |
|
Include Duties and Taxes in Memo |
1 |
A |
I/E |
Y or N. |
QVN Label Creation Notification 1 Option |
1 |
A |
I/E |
Y or N. |
QVN In-Transit Notification 1 Option |
1 |
A |
I/E |
Y or N. |
QVN Ship Notification 1 Option |
1 |
A |
I/E |
Y or N. |
QVN Delivery Notification 1 Option |
1 |
A |
I/E |
Y or N. |
QVN Exception Notification 1 Option |
1 |
A |
I/E |
Y or N. |
Notification Recipient 1 Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 1 Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 1 Email |
50 |
A/N/S |
I/E |
|
QVN Label Creation Notification 2 Option |
1 |
A |
I/E |
Y or N. |
QVN In-Transit Notification 2 Option |
1 |
A |
I/E |
Y or N. |
QVN Ship Notification 2 Option |
1 |
A |
I/E |
Y or N. |
QVN Delivery Notification 2 Option |
1 |
A |
I/E |
Y or N. |
QVN Exception Notification 2 Option |
1 |
A |
I/E |
Y or N. |
Notification Recipient 2 Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 2 Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 2 Email |
50 |
A/N/S |
I/E |
|
QVN Label Creation Notification 3 Option |
1 |
A |
I/E |
Y or N. |
QVN In-Transit Notification 3 Option |
1 |
A |
I/E |
Y or N. |
QVN Ship Notification 3 Option |
1 |
A |
I/E |
Y or N. |
QVN Delivery Notification 3 Option |
1 |
A |
I/E |
Y or N. |
QVN Exception Notification 3 Option |
1 |
A |
I/E |
Y or N. |
Notification Recipient 3 Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 3 Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 3 Email |
50 |
A/N/S |
I/E |
|
QVN Label Creation Notification 4 Option |
1 |
A |
I/E |
Y or N. |
QVN In-Transit Notification 4 Option |
1 |
A |
I/E |
Y or N. |
QVN Ship Notification 4 Option |
1 |
A |
I/E |
Y or N. |
QVN Delivery Notification 4 Option |
1 |
A |
I/E |
Y or N. |
QVN Exception Notification 4 Option |
1 |
A |
I/E |
Y or N. |
Notification Recipient 4 Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 4 Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 4 Email |
50 |
A/N/S |
I/E |
|
QVN Label Creation Notification 5 Option |
1 |
A |
I/E |
Y or N. |
QVN In-Transit Notification 5 Option |
1 |
A |
I/E |
Y or N. |
QVN Ship Notification 5 Option |
1 |
A |
I/E |
Y or N. |
QVN Delivery Notification 5 Option |
1 |
A |
I/E |
Y or N. |
QVN Exception Notification 5 Option |
1 |
A |
I/E |
Y or N. |
Notification Recipient 5 Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 5 Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 5 Email |
50 |
A/N/S |
I/E |
|
UPS Exchange Collect Option |
1 |
A |
I/E |
Y or N. |
UPS Exchange Collect Buyer Email Address |
50 |
A/N/S |
I/E |
|
UPS Exchange Collect Seller Email Address |
50 |
A/N/S |
I/E |
|
UPS Exchange Collect Amount |
20 |
N |
I/E |
|
UPS Exchange Collect Currency Code |
3 |
A |
I/E |
|
UPS Exchange Collect Buyers Percent of Service Fee |
4 |
N |
I/E |
|
UPS Exchange Collect Description of Goods |
50 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
UPS Exchange Collect Additional Comments |
50 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Special Commodities Option |
1 |
A |
I/E |
Y or N. |
ISC Alcoholic Beverages |
1 |
A |
I/E |
Y or N. |
ISC Biological Substance |
1 |
A |
I/E |
Y or N. |
ISC Perishables |
1 |
A |
I/E |
Y or N. |
ISC Plants |
1 |
A |
I/E |
Y or N. |
ISC Seeds |
1 |
A |
I/E |
Y or N. |
ISC Special Exception |
1 |
A |
I/E |
Y or N. |
ISC Tobacco |
1 |
A |
I/E |
Y or N. |
UPS Carbon Neutral Option |
1 |
A |
I/E |
Y or N. |
UPS Carbon Neutral Published Charge |
9 |
N |
E |
99999.99. |
UPS Carbon Neutral Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
UPS Carbon Neutral CCC Rates Charge |
9 |
N |
E |
99999.99. |
Description of Goods |
50 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Documents-Only Indicator |
1 |
A |
I/E |
Y or N. |
Goods NOT in Free Circulation |
1 |
A |
I/E |
Y or N. |
Special Instructions for Shipment |
69 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Shipper Number |
10 |
A/N |
I/E |
|
Total Shipment Reference Charge |
9 |
N |
E |
99999.99. |
Rating Currency Code |
3 |
A |
E |
|
Total Shipment Published Charge |
9 |
N |
E |
99999.99. |
Total Shipment Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Total Shipment CCC Rates Charge |
9 |
N |
E |
99999.99 |
Total Shipper Reference Charge: |
9 |
N |
E |
99999.99. |
Total Shipper Published Charge |
9 |
N |
E |
99999.99. |
Total Shipper Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Total Shipper CCC Rates Charge |
9 |
N |
E |
99999.99. |
Total Receiver Reference Charge |
9 |
N |
E |
99999.99. |
Total Receiver Published Charge |
9 |
N |
E |
99999.99. |
Total Receiver Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Total Receiver CCC Rates Charge |
9 |
N |
E |
99999.99. |
Total Shipment and Handling Reference Charge |
9 |
N |
E |
99999.99. |
Total Shipment and Handling Published Charge |
9 |
N |
E |
99999.99. |
Total Shipment and Handling Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Total Shipment and Handling CCC Rates Charge |
9 |
N |
E |
99999.99. |
Negotiated Rates Indicator |
1 |
A |
E |
Y or N. |
Number of Packages |
4 |
N |
I/E |
9999. |
UPS Proactive Response™ |
1 |
A |
I/E |
Y or N. |
UPS Proactive Response Reference Charge |
9 |
N |
E |
99999.99 |
UPS Proactive Response Published Charge |
9 |
N |
E |
99999.99 |
UPS Proactive Response Negotiated Rates Charge |
9 |
N |
E |
99999.99 |
UPS Proactive Response CCC Rates Charge |
9 |
N |
E |
99999.99 |
Refrigeration |
1 |
A |
I/E |
Y or N. |
Refrigeration Published Charge |
9 |
N |
E |
99999.99. |
Refrigeration Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Refrigeration CCC Rates Charge |
9 |
N |
E |
99999.99 |
UPS Returns® Exchange Option |
1 |
A |
I/E |
Y or N. |
UPS Returns Exchange Use Outbound |
1 |
A |
I/E |
Y or N. |
UPS Returns Exchange Key |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
UPS Returns Exchange UPS Driver Instruction |
50 |
A |
I/E |
Valid values are: |
UPS Returns Exchange Return Option |
1 |
A |
I/E |
Y or N. |
Pre-alert Notification Option |
1 |
A |
I/E |
Y or N. |
Pre-alert Notification SMS Text Option |
1 |
A |
I/E |
Y or N. |
Pre-alert Notification SMS Text Country/Territory |
50 |
A |
I/E |
|
Pre-alert Notification SMS Text Phone Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Pre-alert Notification Email Option |
1 |
A |
I/E |
Y or N. |
Pre-alert Notification Recipient Email Address |
50 |
A/N/S |
I/E |
|
Pre-alert Notification Failed Email Address |
50 |
A/N/S |
I/E |
|
Pre-alert Notification Language |
3 |
A |
I/E |
See Language Codes. |
UPS Returns Exchange Published Charge |
9 |
N |
E |
|
UPS Returns Exchange Negotiated Charge |
9 |
N |
E |
|
UPS Returns Exchange CCC Charge |
9 |
N |
E |
|
Pre-alert Notification Published Charge |
9 |
N |
E |
|
Pre-alert Notification Negotiated Charge |
9 |
N |
E |
|
Pre-alert Notification CCC Charge |
9 |
N |
E |
|
UPS Returns Pack and Collect Option |
1 |
A |
I/E |
Y or N. |
UPS Returns Pack and Collect Type |
30 |
A/N |
I/E |
Valid values are: |
UPS Returns Pack and Collect Published Charge |
9 |
N |
E |
|
UPS Returns Pack and Collect Negotiated Charge |
9 |
N |
E |
|
UPS Returns Pack and Collect CCC Charge |
9 |
N |
E |
|
State Department Licence Option |
1 |
A |
I/E |
Y or N. |
UPS World Ease® Shipment |
1 |
A |
I/E |
Y or N. |
UPS Hundredweight Pricing Applied |
1 |
A |
I |
Y or N. |
IS Doc Box |
1 |
A |
E |
|
WE Number |
36 |
N |
E |
|
World Ease Type |
10 |
A |
E |
|
Port of Entry Name |
35 |
A |
E |
|
Port of Entry Country/Territory |
50 |
A |
E |
|
Ground (Freight Pricing) |
1 |
A |
I/E |
|
Ground (Freight Pricing) Large Parcel Type |
50 |
A/N/S |
E |
Export values are: Large Parcel Length – Resi. Destination Large Parcel Length – Comm. Destination Large Parcel Length + Girth – Resi. Destination Large Parcel Length + Girth – Comm. Destination Large Parcel – Residential Destination (CA only) Large Parcel – Commercial Destination (CA only) |
Ground (Freight Pricing) Gross Charge |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Discounted Amount |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Discounted Rate |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Amount After Discount |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Fuel Published Surcharge |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Fuel Negotiated Surcharge |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Fuel CCC Surcharge |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Residential Published Surcharge |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Residential Negotiated Surcharge |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Residential CCC Surcharge |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Large Package Published Surcharge |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Large Package Negotiated Surcharge |
9 |
N |
E |
99999.99 |
Ground (Freight Pricing) Large Package CCC Surcharge |
9 |
N |
E |
99999.99 |
Signature Services Option |
1 |
A |
I/E |
Y or N. A 'Y' indicates Signature Services Signature Required. |
Signature Services Reference Charge |
9 |
N |
E |
99999.99. |
Signature Services Published Charge |
9 |
N |
E |
99999.99. |
Signature Services Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Signature Services CCC Rates Charge |
9 |
N |
E |
99999.99. |
Signature Services Adult Signature Required |
1 |
A |
I/E |
Y or N. To indicate Signature Services Adult Signature Required, Signature Services Option and Signature Services Adult Signature Required must both be 'Y'. |
Unique Shipment Identifier |
19 |
A/N |
I |
|
Package Type |
35 |
A/N |
I/E |
The package types available depend on the shipment origin and any custom package types that you have added. See Package Type Codes, Package Type Codes for UPS Freight, Package Type Codes and Weight Limits for UPS Mail Innovations Shipments and Package Type Codes for UPS Returns Pack and Collect. |
Additional Handling No. of Packages |
4 |
N |
I/E |
9999 |
Additional Handling Option |
1 |
A |
I/E |
Y or N. |
Large Package Indicator |
1 |
A |
I/E |
Y or N. |
Large Package No. of Packages |
5 |
N |
I/E |
|
Large Parcel Surcharge Type |
50 |
A/N/S |
E |
Export values are: Large Parcel Length – Resi. Destination Large Parcel Length – Comm. Destination Large Parcel Length + Girth – Resi. Destination Large Parcel Length + Girth – Comm. Destination Large Parcel – Residential Destination (CA only) Large Parcel – Commercial Destination (CA only) |
Merchandise Description for Package |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Reference 1 |
35 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Reference 2 |
35 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Reference 3 |
35 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Reference 4 |
35 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Reference 5 |
35 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Length |
3 |
N |
I/E |
999. |
Width |
3 |
N |
I/E |
999. |
Height |
3 |
N |
I/E |
999. |
Process as Paperless |
1 |
A |
I |
Y or N. |
Processed as Paperless |
1 |
A |
E |
Y or N. |
Additional Documents |
1 |
A |
I/E |
Y or N. |
Print Copy of Paperless Documents Indicator |
1 |
A |
E |
Y or N. |
USPS Delivered |
1 |
A |
I/E |
Y or N. |
Dry Ice Charge PUB |
20 |
N |
E |
|
Dry Ice Charge ABR |
20 |
N |
E |
|
Liftgate Service for Delivery Published |
20 |
N |
E |
|
Liftgate Service for Delivery Negotiated |
20 |
N |
E |
|
Liftgate Service for Collection Published |
20 |
N |
E |
|
Liftgate Service for Collection Negotiated |
20 |
N |
E |
|
Certificate of Origin Charge Published. |
20 |
N |
E |
|
Certificate of Origin Charge Negotiated |
20 |
N |
E |
|
EEI Charge Published |
20 |
N |
E |
|
EEI Charge Negotiated |
20 |
N |
E |
|
Freight Delivery Area Surcharge Published |
20 |
N |
E |
|
Freight Delivery Area Surcharge Negotiated |
20 |
N |
E |
|
Freight Delivery Area Surcharge Extended Published |
20 |
N |
E |
|
Freight Delivery Area Surcharge Extended Negotiated |
20 |
N |
E |
|
Freight Remote Area Surcharge Published |
20 |
N |
E |
|
Freight Remote Area Surcharge Negotiated |
20 |
N |
E |
|
Freight Remote Area Extended Surcharge Published |
20 |
N |
E |
|
Freight Remote Area Extended Surcharge Negotiated |
20 |
N |
E |
|
Freight Collection Area Surcharge Published |
20 |
N |
E |
|
Freight Collection Area Surcharge Negotiated |
20 |
N |
E |
|
Freight Collection Area Extended Surcharge Published |
20 |
N |
E |
|
Freight Collection Area Extended Surcharge Negotiated |
20 |
N |
E |
|
Freight Remote Collection Area Surcharge Published |
20 |
N |
E |
|
Freight Remote Collection Area Surcharge Negotiated |
20 |
N |
E |
|
Freight Remote Collection Area Extended Surcharge Published |
20 |
N |
E |
|
Freight Remote Collection Area Extended Surcharge Negotiated |
20 |
N |
E |
|
Oversize Pallet Handling Surcharge Published |
20 |
N |
E |
|
Oversize Pallet Handling Surcharge Negotiated |
20 |
N |
E |
|
Freight Residential Surcharge Published |
20 |
N |
E |
|
Freight Residential Surcharge Negotiated |
20 |
N |
E |
|
Hold at UPS Access Point™ Location Option |
1 |
A |
I/E |
Y or N. |
Hold at UPS Access Point Notification Type |
6 |
N |
I/E |
Valid values are 0=None,1=Email, and 3=SMS |
Hold at UPS Access Point Notification Value |
50 |
A |
I/E |
|
Hold at UPS Access Point Notification Country/Territory |
50 |
A |
I/E |
|
Hold at UPS Access Point Published Charge |
20 |
N |
E |
|
Hold at UPS Access Point Negotiated Rates Charge |
20 |
N |
E |
|
Hold at UPS Access Point Notification Telephone Country Code |
3 |
A/N/S |
I/E |
|
Hold at UPS Access Point Notification Failed Email Address |
50 |
A/N/S |
I/E |
|
Hold at UPS Access Point Notification Language |
3 |
N |
I/E |
See Language Codes |
Deliver to Addressee Only Option |
1 |
A |
I/E |
|
Deliver to Addressee Only Published Charge |
20 |
N |
E |
|
Deliver to Addressee Only Negotiated Rate Charge |
20 |
N |
E |
|
Deliver to Addressee Only CCC Rate Charge |
20 |
N |
E |
|
Direct Delivery Only Option |
1 |
A |
I/E |
0,1. |
Direct Delivery Only Published Charge |
20 |
N |
E |
|
Direct Delivery Only Negotiated Rates Charge |
20 |
N |
E |
|
Direct Delivery Only CCC Rates Charge |
20 |
N |
E |
|
Shipment Process Timestamp |
14 |
N |
E |
YYYYMMDDHHMMSS . |
Package release code Option |
1 |
A |
I/E |
0,1. |
Package release code |
6 |
N |
I |
0-9. |
Package Release Code Published Charge |
20 |
N |
E |
|
Package Release Code Negotiated Rate Charge |
20 |
N |
E |
|
Package Release Code CCC Rate Charge |
20 |
N |
E |
|
Guaranteed Indicator |
1 |
A |
E |
Y or N |
Estimated Delivery Date |
8 |
N |
E |
For both estimated and guaranteed date |
Estimated Delivery Time |
8 |
N |
E |
For both estimated and guaranteed time |
Available for Collection Date |
8 |
N |
E |
|
Available for Collection Time |
8 |
N |
E |
|
UPS Synchronised Delivery Option |
1 |
A |
I/E |
Y or N |
UPS Synchronised Delivery Deliver By Date |
8 |
N |
I/E |
YYYYMMDD |
Excluded from the UPS Synchronised Delivery Option |
1 |
A |
I/E |
Y or N |
Weekend Commercial Delivery Option |
1 |
A |
I/E |
Y or N |
Weekend Commercial Delivery Published Charge |
20 |
N |
E |
|
Weekend Commercial Delivery Negotiated Rates Charge |
20 |
N |
E |
|
International Compliance Origin Country Total Value |
13 |
N |
I/E |
|
International Compliance Destination Country Total Value |
13 |
N |
I/E |
|
International Compliance Shipment Sender |
1 |
A |
I/E |
B or C |
International Compliance Shipment Receiver |
1 |
A |
I/E |
B or C |
Compliance ID |
||||
International Compliance ID Owner |
1 |
A |
I/E |
S,R,I, or E |
International Compliance Country |
2 |
A |
I/E |
|
International Compliance ID Type |
10 |
A/N |
I/E |
Drop Down type |
International Compliance ID Number |
20 |
A/N |
I/E |
|
International Compliance ID Issuing Country |
2 |
A |
I/E |
|
International Compliance FieldType |
2 |
N |
I/E |
01 or 02 |
Ship To |
||||
Customer ID |
30 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Attention |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
USPS PO Box Indicator |
1 |
A |
I/E |
Y or N. |
Address 1 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 2 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 3 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Country/Territory |
50 |
A |
I/E |
|
Postcode |
9 |
A/N |
I/E |
0-9; A-Z. |
City or Town |
30 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
State/Province/County |
30 |
A |
I/E |
|
Telephone |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Fax Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Email Address |
50 |
A/N/S |
I/E |
|
Tax ID Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Receiver’s UPS Account Number |
10 |
A/N/S |
I/E |
Six alphanumeric characters for US and Puerto Rico addresses; 10 numbers for all other addresses. |
Location ID |
10 |
A/N |
I/E |
0-9; A-Z. |
Residential Indicator |
1 |
A |
I/E |
Y or N. |
Density Rating Indicator |
1 |
A |
I/E |
Y or N. |
Airport Code |
15 |
N |
I/E |
0-9. For Air Freight only. |
SCS Account Number |
10 |
A/N/S |
I/E |
0-9; A-Z; special characters. For Freight only. |
Simple Rate Size |
2 |
A |
I/E |
"SB" or "Extra Small" "SC" or "Small" "SD" or "Medium" "SE" or "Large" "SF" or "Extra Large" |
UPS Premier Option |
1 |
A |
I/E |
"Y" or "N" |
UPS Premier Published Charge |
9 |
N |
E |
99999.99 |
UPS Premier Negotiated Rates Charge |
9 |
N |
E |
99999.99 |
UPS Premier Category |
20 |
A |
I/E |
"140" or "UPS Premier Silver" "141" or "UPS Premier Gold" "142" or "UPS Premier Platinum" |
UPS Premier Mesh ID |
50 |
A |
I/E |
|
UPS Premier Temperature requirements |
3 |
A |
I/E |
"002" - Controlled Room Temperature "003" - Refrigerate "004" - Frozen "005" - Dry Ice Replenish "006" - Cryo-Liquid-Nitrogen "016" - Gel Pack Replenishment Frozen "017" - Gel Pack Replenishment Refrigerate "018" - Gel Pack Replenishment Controlled Room Temperature |
UPS Premier Alternate Package Flow |
3 |
A |
I/E |
"008" - Expedite to Receiver All Modes "009" - Expedite to Receiver UPS Air Network only "010" - Expedite to Receiver Ground Courier on |
UPS Premier Hold for Will Call |
1 |
A |
I/E |
"Y" or "N" |
UPS Premier Hold for Shipper's Instructions |
1 |
A |
I/E |
"Y" or "N" |
UPS Premier Upgrade to Weekend Delivery (if not delivered on Friday) |
1 |
A |
I/E |
"Y" or "N" |
UPS Premier UPS Operations to Contact Premier Support |
1 |
A |
I/E |
"Y" or "N" |
UPS Premier Return to Shipper |
1 |
A |
I/E |
"Y" or "N" |
UPS Premier No special handling instructions needed |
1 |
A |
I/E |
"Y" or "N" |
RFID Printer ID |
35 |
A/N |
I/E |
|
Vendor Collect ID Number |
35 |
A/N |
I/E |
"IMxxxyyyyyyz" EU or Northern Ireland "GBxxxxxxx" UK "VOECxxxxxxx" Norway See Vendor Collect ID for additional information |
Vendor Collect ID Number Exempt |
1 |
A/N |
I/E |
Y or 1 or N or 0 |
Vendor Collect ID Number Who Are You Shipping To |
1 |
N |
I/E |
1 = Business 2 = Customer |
Vendor Collect ID Number Shipment Value is less Than Or Equal To Threshold Indicator |
1 |
A/N |
I/E |
Y or 1 or N or 0 |
DDU Oversize |
1 |
A |
I/E |
Y or 1 or N or 0 |
Minimum Billable Weight |
1 |
A |
I/E |
Y or 1 or N or 0 |
DDU Oversize Surcharge Published |
9 |
N |
E |
99999.00 |
DDU Oversize Surcharge Negotiated |
9 |
N |
E |
99999.99 |
Ship From |
||||
Customer ID |
30 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Attention |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 1 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 2 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 3 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Country/Territory |
50 |
A |
I/E |
|
Postcode |
9 |
A/N |
I/E |
0-9; A-Z. |
City or Town |
30 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
State/Province/County |
30 |
A |
I/E |
|
Telephone |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Fax Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Email Address |
50 |
A/N/S |
I/E |
|
Tax ID Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Tax ID Type |
4 |
A |
I/E |
|
UPS Account Number |
10 |
A/N/S |
I/E |
Six alphanumeric characters for US and Puerto Rico addresses; 10 numbers for all other addresses. |
Residential Indicator |
1 |
A |
I/E |
Y or N. |
Company Display Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Airport Code |
15 |
N |
I/E |
0-9. For Air Freight only. |
SCS Account Number |
10 |
A/N/S |
I/E |
0-9; A-Z; special characters. For Freight only. |
Package |
||||
Void Indicator |
1 |
A |
E |
Y or N. |
Package Reference Charge |
11 |
N |
E |
|
Package Published Charge |
9 |
N |
E |
99999.99. |
Package Type |
35 |
A/N |
I/E |
The package types available depend on the shipment origin and any custom package types that you have added. See Package Type Codes, Package Type Codes for UPS Freight, Package Type Codes and Weight Limits for UPS Mail Innovations Shipments and Package Type Codes for UPS Returns Pack and Collect. |
Actual Weight |
4 |
N |
I/E |
|
USPS Weight |
7 |
N |
E |
0.0000-70.0000. |
Postal Sub-class |
255 |
A/N |
I/E |
|
Non-Machinable Indicator |
1 |
A |
E |
Y or N. |
Non-Machinable Published Charge |
9 |
N |
E |
99999.99. |
Non-Machinable Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Non-Machinable CCC Rates Charge |
9 |
N |
E |
99999.99. |
Non- DDU Published Charge |
9 |
N |
E |
99999.99. |
Non- DDU Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Non-DDU CCC Rates Charge |
9 |
N |
E |
99999.99. |
Mail Manifest ID |
18 |
A/N |
E |
0-9; A-Z. |
Tracking Number |
30 |
A/N |
I/E |
|
Package ID |
5 |
N |
I/E |
|
Large Package Indicator |
1 |
A |
I/E |
Y or N. |
Reference 1 |
35 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Reference 2 |
35 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Reference 3 |
35 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Reference 4 |
35 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Reference 5 |
35 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Additional Handling Option |
1 |
A |
I/E |
Y or N. |
Additional Handling Type |
50 |
A/N/S |
E |
Additional Handling Required – >70 lb/32 kg Additional Handling (User Selection) |
Additional Handling Reference Charge |
9 |
N |
E |
99999.99. |
Additional Handling Published Charge |
9 |
N |
E |
99999.99. |
Shipper Release Option |
1 |
A |
I/E |
Y or N |
Package Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Package CCC Rates Charge |
9 |
N |
E |
99999.99. |
Additional Handling Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Additional Handling CCC Rates Charge |
9 |
N |
E |
99999.99. |
COD Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
COD CCC Rates Charge |
9 |
N |
E |
99999.99. |
Signature Services Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Signature Services CCC Rates Charge |
9 |
N |
E |
99999.99. |
Verbal Confirmation Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Verbal Confirmation CCC Rates Charge |
9 |
N |
E |
99999.99. |
COD Option |
1 |
A |
I/E |
Y or N. |
COD Control Number |
12 |
N |
E |
|
COD Reference Charge |
9 |
N |
E |
99999.99. |
COD Published Charge |
9 |
N |
E |
99999.99. |
COD Amount |
9 |
N |
I/E |
99999.99. |
Cashier's Cheque/Money Order Only Indicator |
1 |
A |
I/E |
Y or N. |
Add Shipping Charges To COD Indicator |
1 |
A |
I/E |
Y or N. If you import this field, the shipping charges will be added to the amount imported in the COD Amount field. |
COD Currency Code |
3 |
A |
I/E |
|
Delivery Area Surcharge Type |
255 |
A |
E |
|
Delivery Area Surcharge REF |
9 |
N |
E |
|
Delivery Area Surcharge PUB |
9 |
N |
E |
|
Delivery Area Surcharge CCC |
9 |
N |
E |
|
Delivery Area Surcharge ABR |
9 |
N |
E |
|
Peak Season Surcharge PUB |
9 |
N |
E |
|
Peak Season Surcharge CCC |
9 |
N |
E |
|
Peak Season Surcharge ABR |
9 |
N |
E |
|
Security Surcharge PUB |
20 |
N |
E |
|
Security Surcharge CCC |
20 |
N |
E |
|
Security Surcharge ABR |
20 |
N |
E |
|
Fuel Surcharge PUB |
20 |
N |
E |
|
Fuel Surcharge ABR |
20 |
N |
E |
|
Fuel Surcharge CCC |
20 |
N |
E |
|
Large Package Surcharge PUB |
20 |
N |
E |
|
Large Package Surcharge ABR |
20 |
N |
E |
|
Large Package Surcharge CCC |
20 |
N |
E |
|
Declared Value Option |
1 |
A |
I/E |
Y or N. |
Declared Value Reference Charge |
9 |
N |
E |
99999.99. |
Declared Value Shipper Paid |
1 |
A |
I/E |
Y or N. |
Declared Value Published Charge |
9 |
N |
E |
99999.99. |
Declared Value Amount |
5 |
N |
I/E |
|
Flexible Parcel Insurance Option |
1 |
A |
I/E |
Y or N. |
Flexible Parcel Insurance Type |
20 |
A |
I/E |
Basic, Extended, Time in Transit. |
Flexible Parcel Insurance Value |
11 |
N |
I/E |
99999.99. |
Signature Services Option |
1 |
A |
I/E |
Y or N. |
Signature Services Reference Charge |
9 |
N |
E |
99999.99. |
Signature Services Published Charge |
9 |
N |
E |
99999.99. |
Signature Services Signature Required |
1 |
A |
I/E |
Y or N. |
Signature Services |
1 |
A |
I/E |
Y or N. |
Dangerous Goods Option |
1 |
A |
I/E |
Y or N. |
Dangerous Goods Type |
10 |
A/N |
E |
|
Dangerous Goods Reference ID 1 |
15 |
A/N/S |
I/E |
|
Dangerous Goods Reference ID 2 |
15 |
A/N/S |
I/E |
|
Dangerous Goods Reference ID 3 |
15 |
A/N/S |
I/E |
|
Dangerous Goods Packaging Type |
255 |
A |
I/E |
|
Dangerous Goods Package Q Value |
4 |
N |
I/E |
|
Dangerous Goods Infectious Substance Category A Indicator |
1 |
A |
I/E |
Y or N |
Dangerous Goods Reference Charge |
9 |
N |
E |
99999.99. |
Dangerous Goods Published Charge |
9 |
N |
E |
99999.99. |
Dangerous Goods Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Dangerous Goods CCC Rates Charge |
9 |
N |
E |
99999.99. |
QVN Option |
1 |
A |
I/E |
Quantum View Notify® (QVN). Y or N. |
QVN Reference Charge |
9 |
N |
E |
99999.99. |
QVN Published Charge |
9 |
N |
E |
99999.99. |
QVN Ship From Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
QVN Subject Line |
18 |
A/N |
I/E |
Package-level values: |
QVN Memo |
150 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
QVN Failed Email Address |
50 |
A/N/S |
I/E |
|
QVN In-Transit Notification 1 Option |
1 |
A |
I/E |
Y or N. |
QVN Ship Notification 1 Option |
1 |
A |
I/E |
Y or N. |
QVN Delivery Notification 1 Option |
1 |
A |
I/E |
Y or N. |
QVN Exception Notification 1 Option |
1 |
A |
I/E |
Y or N. |
Notification Recipient 1 Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 1 Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 1 Email |
50 |
A/N/S |
I/E |
|
QVN In-Transit Notification 2 Option |
1 |
A |
I/E |
Y or N. |
QVN Ship Notification 2 Option |
1 |
A |
I/E |
Y or N. |
QVN Delivery Notification 2 Option |
1 |
A |
I/E |
Y or N. |
QVN Exception Notification 2 Option |
1 |
A |
I/E |
Y or N. |
Notification Recipient 2 Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 2 Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 2 Email |
50 |
A/N/S |
I/E |
|
QVN In-Transit Notification 3 Option |
1 |
A |
I/E |
Y or N. |
QVN Ship Notification 3 Option |
1 |
A |
I/E |
Y or N. |
QVN Delivery Notification 3 Option |
1 |
A |
I/E |
Y or N. |
QVN Exception Notification 3 Option |
1 |
A |
I/E |
Y or N. |
Notification Recipient 3 Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 3 Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 3 Email |
50 |
A/N/S |
I/E |
|
QVN In-Transit Notification 4 Option |
1 |
A |
I/E |
Y or N. |
QVN Ship Notification 4 Option |
1 |
A |
I/E |
Y or N. |
QVN Delivery Notification 4 Option |
1 |
A |
I/E |
Y or N. |
QVN Exception Notification 4 Option |
1 |
A |
I/E |
Y or N. |
Notification Recipient 4 Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 4 Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 4 Email |
50 |
A/N/S |
I/E |
|
QVN In-Transit Notification 5 Option |
1 |
A |
I/E |
Y or N. |
QVN Ship Notification 5 Option |
1 |
A |
I/E |
Y or N. |
QVN Delivery Notification 5 Option |
1 |
A |
I/E |
Y or N. |
QVN Exception Notification 5 Option |
1 |
A |
I/E |
Y or N. |
Notification Recipient 5 Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 5 Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Notification Recipient 5 Email |
50 |
A/N/S |
I/E |
|
Verbal Confirmation Option |
1 |
A |
I/E |
Y or N. |
Verbal Confirmation Contact Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Verbal Confirmation Telephone |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Verbal Confirmation Reference Charge |
9 |
N |
E |
99999.99. |
Verbal Confirmation Published Charge |
9 |
N |
E |
99999.99. |
UPS Proactive Response™ |
1 |
A |
I/E |
Y or N. |
UPS Proactive Response Reference Charge |
9 |
N |
E |
99999.99. |
UPS Proactive Response Published Charge |
9 |
N |
E |
99999.99. |
UPS Proactive Response Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
UPS Proactive Response CCC Rates Charge |
9 |
N |
E |
99999.99. |
Refrigeration |
1 |
A |
I/E |
Y or N. |
Refrigeration Published Charge |
9 |
N |
E |
99999.99. |
Refrigeration Negotiated Rates Charge |
9 |
N |
E |
99999.99. |
Refrigeration CCC Rates Charge |
9 |
N |
E |
99999.99. |
Dry Ice Option |
1 |
A |
I/E |
Y or N. |
Dry Ice Weight |
5 |
N |
I/E |
|
Dry Ice UOM Weight |
10 |
A |
I/E |
LB or KG |
Dry Ice Regulation Set |
5 |
A |
I/E |
|
Dry Ice Medical Purpose |
1 |
A |
I/E |
|
Dry Ice Packaging Type |
255 |
A |
I/E |
|
Dry Ice Charge |
9 |
N |
E |
99999.99 |
Dry Ice Published Charge |
9 |
N |
E |
99999.99 |
Dry Ice Charge ABR |
9 |
N |
E |
99999.99 |
Dry Ice Charge CCC |
9 |
N |
E |
99999.99 |
Length |
3 |
N |
I/E |
999. |
Width |
3 |
N |
I/E |
999. |
Height |
3 |
N |
I/E |
999. |
Pieces on Pallet |
6 |
N |
I/E |
1-99,999. |
Merchandise Description for Package |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Postal Service Tracking ID |
22 |
N |
I/E |
|
Ground (Freight Pricing) NMFC |
6 |
N |
I/E |
|
Ground (Freight Pricing) Sub |
2 |
N |
I/E |
|
Ground (Freight Pricing) Freight Class |
10 |
N |
I/E |
|
UPS Premium Care Option |
1 |
A |
I/E |
Y or N. |
UPS Premium Care Published Charge |
9 |
N |
E |
0.00-99999.99. |
UPS Premium Care Negotiated Rates Charge |
9 |
N |
E |
0.00-99999.99. |
Package Billable Weight |
9 |
N |
E |
|
USPS Limited Quantities Hazmat |
1 |
A |
I/E |
Y or N |
UPS Access Point™ |
||||
Customer ID |
30 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Attention |
35 |
A/N/S |
I/E |
This field is no longer used or supported. |
Address 1 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 2 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 3 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Country/Territory |
50 |
A |
I/E |
|
Postcode |
9 |
A/N |
I/E |
0-9; A-Z. |
City or Town |
30 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
State/Province/County |
30 |
A |
I/E |
|
Telephone |
15 |
A/N/S |
I/E |
This field is no longer used or supported. |
Fax Number |
15 |
A/N/S |
I/E |
This field is no longer used or supported. |
UPS Account Number |
10 |
A/N/S |
I/E |
This field is no longer used or supported. |
UPS Access Point ID |
9 |
A/N |
I/E |
U12345678 Note: The ID must start with a 'U'. |
Third Party |
||||
Customer ID |
30 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Attention |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 1 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 2 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 3 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Country/Territory |
50 |
A |
I/E |
See Country/Territory and Currency Codes. Required during third party import. |
Postcode |
9 |
A/N |
I/E |
0-9; A-Z. |
City or Town |
30 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
State/Province/County |
30 |
A |
I/E |
|
Telephone |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Fax Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
UPS Account Number |
10 |
A/N/S |
I/E |
Six alphanumeric characters for US and Puerto Rico addresses; 10 numbers for all other addresses. |
Density Rating Indicator |
1 |
A |
I/E |
Y or N. |
SCS Account Number |
10 |
A/N/S |
I/E |
0-9; A-Z; special characters. For Freight only. |
Third Party (Receiver) |
||||
Customer ID |
30 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Attention |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 1 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 2 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 3 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Country/Territory |
50 |
A |
I/E |
See Country/Territory and Currency Codes. Required during third party import. |
Postcode |
9 |
A/N |
I/E |
0-9; A-Z. |
City or Town |
30 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
State/Province/County |
30 |
A |
I/E |
|
Telephone |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Fax Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
UPS Account Number |
10 |
A/N/S |
I/E |
Six alphanumeric characters for US and Puerto Rico addresses; 10 numbers for all other addresses. |
International Documentation |
||||
Create an Invoice |
1 |
A |
I/E |
Y or N. |
Invoice Importer Same As Ship To |
1 |
A |
I/E |
Y or N. |
Invoice Terms of Sale |
3 |
A |
I/E |
|
Invoice Reason For Export |
2 |
A |
I/E |
|
Invoice Declaration Statement |
255 |
A/N |
I/E |
See Declaration Statements. Only the name can be imported. |
Invoice Additional Comments |
45 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Invoice/EEI/CN22 Currency Code |
3 |
A |
I/E |
|
Invoice Discount |
5 |
N |
I/E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
Invoice Charges Freight |
8 |
N |
I/E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
Invoice Charges Insurance |
8 |
N |
I/E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
Invoice Charges Other |
8 |
N |
I/E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
Invoice Line Total |
12 |
N |
I/E |
Any numeric value (include decimal) up to total value of goods on Invoice. |
Total Invoice Amount |
15 |
N |
E |
|
Customs Value Total |
16 |
N |
I/E |
|
Customs Value Currency Code |
3 |
A |
I/E |
|
Customs Value Origin |
255 |
A |
I/E |
|
EEI Filing Method |
36 |
A/N |
I/E |
Valid values are: |
EEI AES Exemption Legend |
20 |
A/N/S |
I/E |
|
EEI Parties To Transaction |
255 |
A |
I/E |
|
EEI Ultimate Consignee Same As Ship To |
1 |
A |
I/E |
|
EEI Ultimate Consignee Type |
1 |
N |
I/E |
Valid values are: |
EEI Shipment Reference Number |
17 |
N |
I/E |
|
EEI Internal Transaction Number |
15 |
N |
I/E |
|
EEI Routed Transaction |
17 |
A/N |
I/E |
|
EEI Currency Conversion |
8 |
N |
I/E |
0-9; 9.999999 |
EEI Notification Indicator |
1 |
A |
I/E |
Y or N. |
EEI Notification Email Address |
50 |
A/N/S |
I/E |
|
EEI Inbond Code |
2 |
N |
I/E |
Valid values are: |
EEI Inbond Number |
15 |
N |
I/E |
|
EEI Inbond FTZ Number |
7 |
N |
I/E |
|
CO UPS Prepare CO |
1 |
N |
I/E |
0=No and 1=Yes. |
CO Owner Or Agent |
255 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Movement Reference Number (MRN) |
18 |
A/N |
I/E |
See MRN. |
CN 22 Goods Type |
1 |
A |
I/E |
|
CN 22 Goods Type Other Description |
20 |
A/N |
I/E |
|
CN 22 Number |
30 |
A/N |
E |
|
Request Duties and Taxes |
1 |
A |
I/E |
Y or N. |
Duties cost |
20 |
N |
E |
|
VAT cost |
20 |
N |
E |
|
Taxes and Fees cost |
20 |
N |
E |
|
Total Duties and Taxes |
20 |
N |
E |
|
Goods |
||||
Part Number |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Goods ID |
5 |
N |
I/E |
|
Description of Goods |
105 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Inv/CN22 Tariff Code |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Inv/CO/CN22 Country/Territory of Origin |
50 |
A |
I/E |
|
Invoice/CN22 Units |
4 |
N |
I/E |
Whole numbers. |
Invoice/CN22 Unit of Measure |
2 |
A |
I/E |
|
Invoice/EEI/CN22 Unit Price |
19 |
N/S |
I/E |
999999999999.999999. |
Currency Code |
3 |
A |
E |
|
Invoice/EEI/CN22 Currency Code |
3 |
A |
I |
|
Invoice Net Weight |
17 |
N/S |
I/E |
999999999999999.9. |
EEI/CO Gross Weight |
5 |
N |
I/E |
|
EEI/CO LBS or Kgs |
1 |
A |
I/E |
Y=Lbs and N=Kgs. |
EEI Print Good On EEI |
1 |
N |
I/E |
0=No and 1=Yes. |
Invoice/EEI/CO Marks And Numbers |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
EEI Schedule B Number |
10 |
N |
I/E |
|
EEI Schedule B Units1 |
7 |
N |
I/E |
|
EEI Schedule B Units 2 |
7 |
N |
I/E |
|
EEI Unit of Measure 1 |
2 |
A/N |
I/E |
|
EEI Unit of Measure 2 |
2 |
A/N |
I/E |
|
EEI ECCN |
15 |
A/N |
I/E |
0-9; A-Z. |
DFM |
1 |
A |
I/E |
D, F, M. |
EEI Licence Type |
10 |
A |
I/E |
|
EEI Licence Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
EEI Licence Expiry Date |
8 |
N |
I/E |
YYYYMMDD. |
EEI Licence Line Value |
10 |
I/E |
||
EEI Export Code |
I/E |
|||
DDTC ACM Number |
11 |
N |
I/E |
|
DDTC ITAR Exemption Code |
35 |
N |
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 Code |
4 |
N |
I/E |
|
DDTC Quantity |
5 |
N |
I/E |
|
DDTC Unit of Measure |
20 |
N |
I/E |
|
DDTC Licence Line Number |
15 |
N |
I/E |
|
CO Print Good On CO |
1 |
N |
I/E |
0=No and 1=Yes. |
CO Number of Packages Containing Goods |
3 |
N |
I/E |
|
SLI Print Good on SLI |
1 |
A |
I/E |
Y or N. |
DFM |
1 |
A |
I/E |
Y or N. For Freight only. |
Importer |
||||
Customer ID |
30 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Attention |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 1 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 2 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 3 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Country/Territory |
50 |
A |
I/E |
|
City or Town |
30 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
State/Province/County |
30 |
A |
I/E |
|
Postcode |
9 |
A/N |
I/E |
0-9; A-Z. |
Telephone |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Tax ID Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
UPS Account Number |
10 |
A/N/S |
I/E |
Six alphanumeric characters for US and Puerto Rico addresses; 10 numbers for all other addresses. |
Producer |
||||
Customer ID |
30 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Attention |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 1 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 2 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 3 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Country/Territory |
50 |
A |
I/E |
|
City or Town |
30 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
State/Province/County |
30 |
A |
I/E |
|
Postcode |
9 |
A/N |
I/E |
0-9; A-Z. |
Telephone |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Tax ID Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Ultimate Consignee |
||||
Customer ID |
30 |
A/N/S |
I/E |
Must be unique. 0-9; A-Z; special characters. |
Company or Name |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Attention |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 1 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 2 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Address 3 |
35 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Country/Territory |
50 |
A |
I/E |
|
City or Town |
30 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
State/Province/County |
30 |
A |
I/E |
|
Postcode |
9 |
A/N |
I/E |
0-9; A-Z. |
Telephone |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Tax ID Number |
15 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Dangerous Goods Data |
||||
Reference Number |
15 |
A/N |
E |
|
Regulation Set |
5 |
N |
E |
|
Reportable Quantity |
2 |
N |
E |
|
Proper Shipping Name |
150 |
A/N/S |
E |
0-9; A-Z; special characters. |
Technical Name |
200 |
A/N/S |
E |
0-9; A-Z; special characters. |
Class Division Number |
7 |
N |
E |
|
Subrisk Class |
7 |
N |
E |
|
Identification Number |
6 |
N |
E |
|
Packing Group |
5 |
N |
E |
|
Additional Description |
255 |
A/N/S |
E |
0-9; A-Z; special characters. |
Number of Packages |
3 |
N |
E |
|
Quantity |
5 |
N |
E |
|
Unit of Measure |
10 |
N |
E |
|
Packaging Type |
35 |
A/N |
E |
The package types available depend on the shipment origin and any custom package types that you have added. See Package Type Codes, Package Type Codes for UPS Freight, Package Type Codes and Weight Limits for UPS Mail Innovations Shipments and Package Type Codes for UPS Returns Pack and Collect. |
Record Identifier 1 |
30 |
N |
E |
|
Record Identifier 2 |
30 |
N |
E |
|
Record Identifier 3 |
30 |
N |
E |
|
Packing Instructions |
4 |
A/N |
E |
|
Transportation Mode |
30 |
A/N |
E |
|
Label Required |
50 |
A/N |
E |
|
Emergency Phone |
25 |
A/N |
E |
Only numbers; full stops “.”; parentheses “( )”; dashes ”-”; plus sign “+”; and alpha characters ‘EXT’ and ‘OPT’ in lower or upper case are allowed. |
ER Registrant |
24 |
A/N |
E |
Data entered cannot match the Emergency Phone number. |
LTL/TL Line Item |
Number of Identical Handling Units |
4 |
N |
I/E |
9999. |
Freight Class |
10 |
N |
I/E |
|
Package Type |
35 |
A/N |
I/E |
The package types available depend on the shipment origin and any custom package types that you have added. See Package Type Codes. |
Length |
3 |
N |
I/E |
999. |
Width |
3 |
N |
I/E |
999. |
Height |
3 |
N |
I/E |
999. |
Pieces on Pallet |
4 |
N |
I/E |
9999. |
Line Description |
400 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Handling Unit Weight |
4 |
N |
I/E |
9999. |
Packing List |
||||
Package ID |
5 |
N |
I/E |
The packing list will be required for WWE multipiece shipments |
Goods ID |
5 |
N |
I/E |
The packing list will be required for WWE multipiece shipments |
Units in Package |
255 |
N |
I/E |
The packing list will be required for WWE multipiece shipments |
User Forms |
||||
File Name |
500 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Form Type |
255 |
A/N |
I |
See Form Type Codes. |
Form Type |
5 |
N |
E |
|
Number of Forms |
5 |
N |
I/E |
|
Freight Handling Unit |
||||
Description |
105 |
A/N/S |
I/E |
0-9; A-Z; special characters. |
Type |
35 |
A/S |
I/E |
|
Units |
3 |
N |
I/E |
0-999. |
Length |
3 |
N |
I/E |
0-999. |
Width |
3 |
N |
I/E |
0-999. |
Height |
3 |
N |
I/E |
0-999. |