Shipment Data Field Descriptions

The table below lists all shipment data fields that UPS WorldShip® can import or export.

Notes:

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:
Address Service Requested
Change Service Requested
Forward Service Requested
Return Service Requested
No Endorsement

Valid values for UPS SurePost are:
Carrier - Leave If No Response
Address Service Requested
Change Service Requested
Forward Service Requested
Return Service Requested

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

See Bill-To Information and Codes.

Bill Duty and Tax To

20

A

I/E

See Bill-To Information and Codes.

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

See Dangerous Goods Type Codes.

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

See Country/Territory and Currency Codes.

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
3 UPS Pickup Attempts
UPS Print Label
UPS Electronic Label

Import Control Recipient Email

50

A/N/S

I/E

See Validate Email Addresses.

Import Control Failed Email

50

A/N/S

I/E

See Validate Email Addresses.

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

See Validate Email Addresses.

Mail Innovations Return Service Failed Email Address

50

A/N/S

I/E

See Validate Email Addresses.

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:
Tracking Number
Reference Number 1
Reference Number 2

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

See Validate Email Addresses.

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

See Validate Email Addresses.

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

See Validate Email Addresses.

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

See Validate Email Addresses.

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

See Validate Email Addresses.

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

See Validate Email Addresses.

UPS Exchange Collect Option

1

A

I/E

Y or N.

UPS Exchange Collect Buyer Email Address

50

A/N/S

I/E

See Validate Email Addresses.

UPS Exchange Collect Seller Email Address

50

A/N/S

I/E

See Validate Email Addresses.

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:
EXCHANGE - LIKE ITEM ONLY
EXCHANGE - DRIVER INSTRUCTIONS INSIDE

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

See Validate Email Addresses.

Pre-alert Notification Failed Email Address

50

A/N/S

I/E

See Validate Email Addresses.

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:
1 UPS Collection Attempt
3 UPS Collection Attempts

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.
Package ID for UPS Mail Innovations shipments: length is 30 and type is A/N; no spaces, punctuation or 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

See Country/Territory and Currency Codes.

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

See Validate Email Addresses.

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

See Country/Territory and Currency Codes.

Postcode

9

A/N

I/E

0-9; A-Z.
Note:
When importing a postcode in any database, make sure that the field is a character field and not a number field because some postcodes must have a zero in the first position.

City or Town

30

A/N/S

I/E

0-9; A-Z; special characters.

State/Province/County

30

A

I/E

See US State and Canada Province Codes.

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

See Validate Email Addresses.

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

See Country/Territory and Currency Codes.

Postcode

9

A/N

I/E

0-9; A-Z.
Note:
When importing a postcode in any database, make sure that the field is a character field and not a number field because some postcodes must have a zero in the first position.

City or Town

30

A/N/S

I/E

0-9; A-Z; special characters.

State/Province/County

30

A

I/E

See US State and Canada Province Codes.

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

See Validate Email Addresses.

Tax ID Number

15

A/N/S

I/E

0-9; A-Z; special characters.

Tax ID Type

4

A

I/E

See Tax ID Type Codes.

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.
Package ID for UPS Mail Innovations shipments: length is 30 and type is A/N; no spaces, punctuation or 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
Adult Signature Required

1

A

I/E

Y or N.

Dangerous Goods Option

1

A

I/E

Y or N.

Dangerous Goods Type

10

A/N

E

See Dangerous Goods Type Codes.

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:
Tracking Number
Reference Number 1
Reference Number 2
Reference Number 3
Reference Number 4
Reference Number 5

QVN Memo

150

A/N/S

I/E

0-9; A-Z; special characters.

QVN Failed Email Address

50

A/N/S

I/E

See Validate Email Addresses.

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

See Validate Email Addresses.

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

See Validate Email Addresses.

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

See Validate Email Addresses.

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

See Validate Email Addresses.

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

See Validate Email Addresses.

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

See Country/Territory and Currency Codes.

Postcode

9

A/N

I/E

0-9; A-Z.
Note:
When importing a postcode in any database, make sure that the field is a character field and not a number field because some postcodes must have a zero in the first position.

City or Town

30

A/N/S

I/E

0-9; A-Z; special characters.

State/Province/County

30

A

I/E

See US State and Canada Province Codes.

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.
Note:
When importing a postcode in any database, make sure that the field is a character field and not a number field because some postcodes must have a zero in the first position.

City or Town

30

A/N/S

I/E

0-9; A-Z; special characters.

State/Province/County

30

A

I/E

See US State and Canada Province Codes.

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.
Note:
When importing a postcode in any database, make sure that the field is a character field and not a number field because some postcodes must have a zero in the first position.

City or Town

30

A/N/S

I/E

0-9; A-Z; special characters.

State/Province/County

30

A

I/E

See US State and Canada Province Codes.

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

See Terms of Sale Codes.

Invoice Reason For Export

2

A

I/E

See Reason for Export Codes.

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

See Country/Territory and Currency Codes.

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:
I have an ITN
No EEI needed
Self-file with AES Direct (AES OPT 2)
UPS file my EEI for me
File post departure (AES OPT 4)

EEI AES Exemption Legend

20

A/N/S

I/E

See AES Exemption Legend Codes.

EEI Parties To Transaction

255

A

I/E

See Parties to Transaction Codes.

EEI Ultimate Consignee Same As Ship To

1

A

I/E

EEI Ultimate Consignee Type

1

N

I/E

Valid values are:
1 = Direct Consumer
2 = Government Entity
3 = Reseller
4 = Other/Unknown

EEI Shipment Reference Number

17

N

I/E

EEI Internal Transaction Number

15

N

I/E

EEI Routed Transaction

17

A/N

I/E

See Routed Transaction Codes.

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

See Validate Email Addresses.

EEI Inbond Code

2

N

I/E

Valid values are:
67 = Foreign Trade Zone withdrawal for IE
68 = Foreign Trade Zone withdrawal for T&E
70 = Merchandise Not Shipped Inbond

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

See Customs Declaration CN 22 Codes.

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

See Country/Territory and Currency Codes.

Invoice/CN22 Units

4

N

I/E

Whole numbers.

Invoice/CN22 Unit of Measure

2

A

I/E

See Unit of Measure Codes for Invoices.

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

See Unit of Measure Codes for EEIs.

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

See Licence Type Codes.

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

See DDTR ITAR Exemption Codes.

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

See Country/Territory and Currency Codes.

City or Town

30

A/N/S

I/E

0-9; A-Z; special characters.

State/Province/County

30

A

I/E

See US State and Canada Province Codes.

Postcode

9

A/N

I/E

0-9; A-Z.
Note:
When importing a postcode in any database, make sure that the field is a character field and not a number field because some postcodes must have a zero in the first position.

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

See Country/Territory and Currency Codes.

City or Town

30

A/N/S

I/E

0-9; A-Z; special characters.

State/Province/County

30

A

I/E

See US State and Canada Province Codes.

Postcode

9

A/N

I/E

0-9; A-Z.
Note:
When importing a postcode in any database, make sure that the field is a character field and not a number field because some postcodes must have a zero in the first position.

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

See Country/Territory and Currency Codes.

City or Town

30

A/N/S

I/E

0-9; A-Z; special characters.

State/Province/County

30

A

I/E

See US State and Canada Province Codes.

Postcode

9

A/N

I/E

0-9; A-Z.
Note:
When importing a postcode in any database, make sure that the field is a character field and not a number field because some postcodes must have a zero in the first position.

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

See Handling Unit Type Codes.

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.