Automatic Batch Processing Minimum Required Fields

The table below lists the minimum required fields for automatic batch processing. These fields are all of the "blue" fields for a no-option shipment in UPS WorldShip. Certain package/shipping options require additional fields.

Note: There are no minimum required fields for manual batch processing.

Domestic Shipping:

Field

Size

Notes

Ship To

 

 

Company or Name

C35

 

Address 1

C35

 

Country/Territory

C50

Full country/territory name.

Postal Code

C10

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

C30

 

State/Province/County

C5

See US State and Canada Province Codes.

UPS Service

C25

See UPS Service Codes.

Bill Transportation To

C20

See Bill-To Information and Codes.

Package Type

C35

See Package Type Codes.

Package Weight

C5

 

Ship From

 

 

Company or Name

C35

 

Address 1

C35

 

Country/Territory

C50

Full country/territory name.

Postal Code

C10

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

C30

 

State/Province/County

C5

See US State and Canada Province Codes.

Tax ID Type

C4

See Tax ID Type Codes.

International Shipping:

 

 

Field

Size

Notes

Ship To

 

 

Company or Name

C35

 

Attention

C35

 

Address 1

C35

 

Country/Territory

C50

Full country/territory name.

City or Town

C30

 

Telephone

C15

 

UPS Service

C25

See UPS Service Codes.

Package Type

C35

See Package Type Codes.

Bill Transportation To

C20

See Bill-To Information and Codes.

Bill Duty and Tax To

C20

See Bill-To Information and Codes.

General Description of Goods

C35

 

Package Weight

C5

 

Ship From

 

 

Company or Name

C35

 

Address 1

C35

 

Country/Territory

C50

Full country/territory name.

Postal Code

C10

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

C30

 

State/Province/County

C5

See US State and Canada Province Codes.

Tax ID Type

C4

See Tax ID Type Codes.

Note: The following fields are required only if you print International documents using WorldShip.

Good-Invoice

 

 

Description of Good

C105

 

Country/Territory of Origin

C50

Full country/territory name.

Units

C10

 

Unit of Measure

C50

See Unit of Measure Codes for Invoices.

Unit Price

C16

 

Currency

C255

See Country/Territory and Currency Codes.

Good-SED

 

 

Description of Good

C105

 

Schedule B Number

C10

 

Schedule B Units 1

C10

 

Unit of Measure 1

C50

See Unit of Measure Codes for SEDs.

Gross Weight

C5

 

License Number

C26

 

License Expiration Date

C8

 

License Exception

C4

See License Exception Codes.

Good-CO

 

 

Description of Good

C105

 

Country/Territory of Origin

C50

Full country/territory name.

No. of Pkgs. Containing Good

C3

 

Gross Weight

C5

 

INVOICE

 

 

Currency Code

C3

See Country/Territory and Currency Codes.

SED

 

 

Parties to Transaction

C255

See Parties to Transaction Codes.

Country/Territory of Ultimate Destination

C3

 

Routed Transaction

C1

Y or N. See Routed Transaction Codes.

Export Code

C2

See Export Codes.

CO

 

 

Owner or Agent

C255

 

Air Freight and Ground Freight Shipping:

Field

Size

Notes

Ship To

 

 

Company or Name

C35

 

Address 1

C35

 

Country/Territory

C50

Full country/territory name.

Postal Code

C10

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

C30

 

State/Province/County

C5

See US State and Canada Province Codes and Australia Province and Mexico State Codes for Air/Ground Freight.

Telephone

C15

Air Freight only.

Ship From

 

 

Company or Name

C35

 

Address 1

C35

 

Country/Territory

C50

Full country/territory name.

Postal Code

C10

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

C30

 

State/Province/County

C5

See US State and Canada Province Codes and Australia Province and Mexico State Codes for Air/Ground Freight.

Telephone

C15

 

Tax ID Type

C4

See Tax ID Type Codes.

UPS or SCS Account

C10

Air Freight only.

Service

 

 

UPS Service

C25

See UPS Service Codes for Freight Shipments.
To be considered a Freight shipment, a Freight service code must be imported.

Bill Transportation To

C20

See Bill-To Information and Codes.

Description

C255

 

Packaging Type

C35

See Packaging Type Codes for UPS Freight.

Pieces

C4

 

Total Weight

C7

 

Freight Class

C10

Ground Freight only.

Length

C3

Air Freight only.

Width

C3

Air Freight only.

Height

C3

Air Freight only.

Good-SLI

 

 

Note: The following Good-SLI fields are required only if you print International documents using WorldShip.

Description of Good

C105

 

D/F/M

C1

 

Schedule B Number

C10

 

Schedule B Units 1

C10

 

Unit of Measure 1

C50

 

Gross Weight

C5

 

License Number

C26

 

License Expiration Date

C8

 

License Exception

C4

See License Exception Codes.

SLI

 

 

Note: The following SLI fields are required only if you print International documents using WorldShip.

Routed Transaction

C1

Y or N. See Routed Transaction Codes.

Parties to Transaction

C255

See Parties to Transaction Codes.

Pickup/Drop Off Request

 

 

Pieces Shipped As

C4

 

Requestor Company Name

C35

Pickup request only.

Requestor Attention

C35

Pickup request only.

Requestor Email Address

C50

Pickup request only.

Requestor Telephone Number

C15

Pickup request only.

Drop Off Date

C8

Drop off request only.

Drop Off Time

C6

Drop off request only.

Pickup Date

C8

 

Pickup Ready Time

C6

 

Pickup Location Closing Time

C6