Automatic Batch Processing Minimum Required Fields

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 Postcode in any database, make sure 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

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 postcode in any database, make sure 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

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 Postcode in any database, make sure 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

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.

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

Goods Grid-EEI

Description of Good

C105

Tariff Code number

C10

Schedule B Units 1

C10

Unit of Measure 1

C50

See Unit of Measure Codes for EEIs.

Gross Weight

C5

Licence Type

C4

See Licence Type Codes.

Licence Number

C26

Licence Line Value

C10

Licence Expiry Date

C8

Goods Grid-CO

Description of Good

C105

Country/Territory of Origin

C50

Full country/territory name.

No. of Pkgs. Containing Good

C3

Gross Weight

C5

Invoice Tab

Currency Code

C255

See Country/Territory and Currency Codes.

EEI Tab

Parties to Transaction

C255

See Parties to Transaction Codes. Required only if Filing Method is Self-file with AES Direct (AES OPT 2) or UPS file my EEI for me.

Routed Transaction

C1

Y or N. See Routed Transaction Codes. Required only if Filing Method is Self-file with AES Direct (AES OPT 2) or UPS file my EEI for me.

CO Tab

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 Postcode in any database, make sure 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

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 Postcode in any database, make sure 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

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.

Goods Grid-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

Tariff Code number

C10

Schedule B Units 1

C10

Unit of Measure 1

C50

Gross Weight

C5

Licence Number

C26

Licence Expiry Date

C8

Licence Exception

C4

SLI Tab

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.

Collect/Drop Off Request

Pieces Shipped As

C4

Requestor Company Name

C35

Collection request only.

Requestor Attention

C35

Collection request only.

Requestor Email Address

C50

Collection request only.

Requestor Telephone Number

C15

Collection request only.

Drop Off Date

C8

Drop off request only.

Drop Off Time

C6

Drop off request only.

Collection Date

C8

Collection Ready Time

C6

Collection Location Closing Time

C6