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.

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 Shipment.

Endorsement

40

A

I/E

Valid values for UPS Mail Innovations are:
Address Service Requested
Change Service Requested
Forwarding Service Requested
Return Service Requested

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

Book Number

4

N

E

 

Page Number

2

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.

Collection date

10

N

I/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

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 Cash Only

2

N

I/E

 

COD Currency Code

3

A

I/E

See Country/Territory and Currency Codes.

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

 

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

 

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.

HC Amount Increase Decrease Type

8

A

I/E

Increase or Decrease.

Handling Charge Flat Rate

8

N

I/E

 

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.

Returns Flexible Access 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

See Validate E-mail Addresses.

Failed Email Address

50

A/N/S

I/E

See Validate E-mail 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.

Returns Flexible Access Published Charge

9

N

E

99999.99.

Returns Flexible Access Negotiated Rates Charge

9

N

E

99999.99.

Returns Flexible Access CCC Rates Charge

9

N

E

99999.99.

Returns Flexible Access Convenience Published Charge

9

N

E

99999.99.

Returns Flexible Access Convenience Negotiated Charge

9

N

E

99999.99.

Returns Flexible Access Convenience CCC Rates Charge

9

N

E

99999.99.

Import Control Option

1

A

I/E

Y or N.

Import Control Label Type

50

A/N

I/E

UPS Print Label
UPS Electronic Label
UPS Print & Mail Label
1 UPS Pickup Attempt
3 UPS Pickup Attempts

Import Control Recipient Email

50

A/N/S

I/E

See Validate E-mail Addresses.

Import Control Failed Email

50

A/N/S

I/E

See Validate E-mail 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.

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.

Call Tag Reference Number

12

N

E

 

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 Pickup Option

1

A

I/E

Y or N.

Saturday Pickup Reference Charge

9

N

E

99999.99.

Saturday Pickup Published Charge

9

N

E

99999.99.

Saturday Pickup Negotiated Rates Charge

9

N

E

99999.99.

Saturday Pickup 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.

QVN Failed Email Address

50

A/N/S

I/E

See Validate E-mail 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 E-mail 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 E-mail 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 E-mail 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 E-mail 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 E-mail 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 E-mail Addresses.

UPS Exchange Collect Seller Email Address

50

A/N/S

I/E

See Validate E-mail 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.

Proactive Response

1

A

I/E

Y or N.

Proactive Response Reference Charge

9

N

E

99999.99

Proactive Response Published Charge

9

N

E

99999.99

Proactive Response Negotiated Rates Charge

9

N

E

99999.99

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 Like Item Only and Driver Instructions Inside.

UPS Returns Exchange Return Option

1

A

I/E

Y or N.

Prealert Notification Option

1

A

I/E

Y or N.

Prealert Notification Telephone Option

1

A

I/E

Y or N.

Prealert Notification Telephone Number

15

A/N/S

I/E

0-9; A-Z; special characters.

Prealert Notification SMS Text Option

1

A

I/E

Y or N.

Prealert Notification SMS Text Phone Number

15

A/N/S

I/E

0-9; A-Z; special characters.

Prealert Notification Email Option

1

A

I/E

Y or N.

Prealert Notification Recipient Email Address

50

A/N/S

I/E

See Validate E-mail Addresses.

Prealert Notification Failed Email Address

50

A/N/S

I/E

See Validate E-mail Addresses.

Prealert 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

 

Prealert Notification Published Charge

9

N

E

 

Prealert Notification Negotiated Charge

9

N

E

 

Prealert 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 Pickup Attempt
3 UPS Pickup 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

 

World Ease Shipment

1

A

I/E

Y or N.

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) 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

Delivery Confirmation Option

1

A

I/E

Y or N. A "Y" indicates Delivery Confirmation Signature Required (but Delivery Confirmation Adult Signature Required must be "N").

Delivery Confirmation Reference Charge

9

N

E

99999.99.

Delivery Confirmation Published Charge

9

N

E

99999.99.

Delivery Confirmation Negotiated Rates Charge

9

N

E

99999.99.

Delivery Confirmation CCC Rates Charge

9

N

E

99999.99.

Delivery Confirmation Adult Signature Required

1

A

I/E

Y or N. To indicate Delivery Confirmation Adult Signature Required, Delivery Confirmation Option and Delivery Confirmation 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 Num 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 Num Packages

5

N

I/E

 

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.

Transit Time

4

N

E

 

Print Copy of Paperless Documents Indicator

1

A

E

Y or N.

USPS Delivered

1

A

I/E

Y or N.

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

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.

Postal Code

9

A/N

I/E

0-9; A-Z.
Note: When importing a ZIP code in any database, make sure the field is a character field and not a number field because some ZIP codes 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 E-mail Addresses.

Tax ID Number

15

A/N/S

I/E

0-9; A-Z; special characters.

Receiver 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.

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.

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.

Postal Code

9

A/N

I/E

0-9; A-Z.
Note: When importing a ZIP code in any database, make sure the field is a character field and not a number field because some ZIP codes 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 E-mail 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.

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.

Weight

4

N

I/E

 

USPS Weight

7

N

E

0.0000-70.0000.

Postal Subclass

255

A/N

I/E

 

Nonmachinable Indicator

1

A

I/E

Y or N.

Nonmachinable Published Charge

9

N

E

99999.99.

Nonmachinable Negotiated Rates Charge

9

N

E

99999.99.

Nonmachinable 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

 

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 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.

Delivery Confirmation Negotiated Rates Charge

9

N

E

99999.99.

Delivery Confirmation 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.

Dangerous Goods Negotiated Rates Charge

9

N

E

99999.99.

Dangerous Goods 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 Check/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

 

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.

Delivery Confirmation Option

1

A

I/E

Y or N.

Delivery Confirmation Reference Charge

9

N

E

99999.99.

Delivery Confirmation Published Charge

9

N

E

99999.99.

Delivery Confirmation Signature Required

1

A

I/E

Y or N.

Delivery Confirmation
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 Custom Package Name

50

A

I/E

 

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 E-mail 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 E-mail 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 E-mail 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 E-mail 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 E-mail 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 E-mail 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.

Proactive Response

1

A

I/E

Y or N.

Proactive Response Reference Charge

9

N

E

99999.99.

Proactive Response Published Charge

9

N

E

99999.99.

Proactive Response Negotiated Rates Charge

9

N

E

99999.99.

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

N

I/E

 

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.

Merchandise Description for Package

35

A/N/S

I/E

0-9; A-Z; special characters.

USPS Delivery Confirmation Option

1

A

I/E

Y or N.

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

 

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.

Postal Code

9

A/N

I/E

0-9; A-Z.
Note: When importing a ZIP code in any database, make sure the field is a character field and not a number field because some ZIP codes 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.

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.

Postal Code

9

A/N

I/E

0-9; A-Z.
Note: When importing a ZIP code in any database, make sure the field is a character field and not a number field because some ZIP codes 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

Invoice Importer Same As Ship To

1

A

I/E

Y or N.

Invoice Terms Of Sale

2

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/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

 

SED Code

36

A/N

I/E

Valid values are:
SED Included
Electronically Filed Pre Departure
Electronically Files Post Departure
UPS Prepared

SED Parties To Transaction

255

A

I/E

See Parties to Transaction Codes.

SED Ultimate Consignee Same As Ship To

1

A

I/E

 

SED Country/Territory Of Ultimate Destination

255

A

I/E

 

SED AES Transaction Number

17

N

I/E

 

SED AES Transaction Number Type

3

A

I/E

 

SED Routed Transaction

17

A/N

I/E

See Routed Transaction Codes.

SED Currency Conversion

 

 

I/E

 

SED Export Code

2

A

I/E

See Export Codes.

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.

NAFTA Producer

255

A/N/S

I/E

0-9; A-Z; special characters.

NAFTA Blanket Period Start

8

N

I/E

YYYYMMDD.

NAFTA Blanket Period End

8

N

I/E

YYYYMMDD.

Movement Reference Number (MRN)

18

A/N

E

For German export shipments. 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

 

Request Duties and Taxes

1

A

I/E

Y or N.

Duties cost

 

 

E

 

VAT cost

 

 

E

 

Taxes and Fees cost

 

 

E

 

Total Duties and Taxes

 

 

E

 

Goods

Part Number

35

A/N/S

I/E

0-9; A-Z; special characters.

Description Of Good

105

A/N/S

I/E

0-9; A-Z; special characters.

Inv/NAFTA/CN22 Tariff Code

15

N

I/E

 

Inv/NAFTA/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/SED/CN22 Unit Price

19

N/S

I/E

999999999.999999.

Currency Code

3

A

E

 

Invoice/CN22 Currency Code

3

A

I

 

Invoice Net Weight

17

N/S

I/E

999999999999999.9.

SED/CO Gross Weight

5

N

I/E

 

SED/CO LBS or Kgs

1

A

I/E

Y=Lbs and N=Kgs.

SED Print Good On SED

1

N

I/E

0=No and 1=Yes.

Invoice/SED/CO Marks And Numbers

35

A/N/S

I/E

0-9; A-Z; special characters.

SED Schedule B Number

10

N

I/E

 

SED Schedule B Units1

7

N

I/E

 

SED Schedule B Units2

7

N

I/E

 

SED Unit of Measure 1

2

A/N

I/E

See Unit of Measure Codes for SEDs.

SED Unit of Measure 2

2

A/N

I/E

 

SED ECCN

15

A/N

I/E

0-9; A-Z.

DFM

1

A

I/E

D, F, M.

SED Exception

4

A

I/E

See License Exception Codes.

SED License Number

15

A/N/S

I/E

0-9; A-Z; special characters.

SED License Expiration Date

8

N

I/E

YYYYMMDD.

SEC Export Code

 

 

I/E

 

DDTC Registration Number

10

N

I/E

 

DDTC Significant Military Equipment Indicator

1

A

I/E

Y or N.

DDTC Eligible Party Certification Indicator

1

A

I/E

Y or N.

DDTC USML Category Code

4

N

I/E

 

DDTC Quantity

9

N

I/E

 

DDTC Unit of Measure

20

N

I/E

 

DDTC License Line Number

50

N

I/E

 

NAFTA Print Good On NAFTA

1

N

I/E

0=No and 1=Yes.

NAFTA Preference Criterion

1

N

I/E

See Preference Criteria Codes.

NAFTA Producer

5

A/N

I/E

See Producer Codes.

NAFTA Multiple Countries/Territories Of Origin

1

N

I/E

0=No and 1=Yes.

NAFTA Net Cost Method

1

N

I/E

0=No and 1=Yes.

NAFTA Net Cost Period Start Date

8

N

I/E

YYYYMMDD.

NAFTA Net Cost Period End Date

8

N

I/E

YYYYMMDD.

CO Print Good On CO

1

N

I/E

0=No and 1=Yes.

CO Number Of Packages Containing Good

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.

Postal Code

9

A/N

I/E

0-9; A-Z.
Note: When importing a ZIP code in any database, make sure the field is a character field and not a number field because some ZIP codes 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.

Postal Code

9

A/N

I/E

0-9; A-Z.
Note: When importing a ZIP code in any database, make sure the field is a character field and not a number field because some ZIP codes 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.

Postal Code

9

A/N

I/E

0-9; A-Z.
Note: When importing a ZIP code in any database, make sure the field is a character field and not a number field because some ZIP codes 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.

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

0-9; A-Z.

ER Registrant

24

A/N

E

0-9; A-Z.

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.