LTL/TL Shipment Processing Minimum Required Fields

The table below lists the fields that must be included in order to process LTL/TL shipments without further data entry.  

Note: The default values for the UPS Standard Profile are listed in the Notes column of the following table.  If the default value is acceptable, you will not need to include this field in an import.  All default values can be changed using the Profile Editor.

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.

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.

Shipment Information

 

 

LTL/TL Shipment Check box

C1

Y or N

UPS Service

C22

See UPS Service Codes. The UPS Standard Profile default value is LTL Standard.

Bill Transportation To

C20

See Bill-To Information and Codes. The UPS Standard Profile default value is Bill Shipper Freight.

General Description of Goods

C400

 

Freight Line

 

 

Number of Identical Handling Units

C4

UPS Standard Profile default value is 1.

Freight Class

C10

 

Length

C4

999.9

Width

C4

999.9

Height

C4

999.9

Package Type

C35

UPS Standard Profile default value is Pallet/Skid. See Package Type Codes.

Pieces on Pallet (If Package Type = Pallet/Skid)

C4

 

Description

C400

 

Weight

 

 

Handling Unit

C5

 

Note: The following fields are required only if you print a consolidated movement invoice.

Documents

 

 

Currency

C255

See Country/Territory and Currency Codes.

Good - Invoice

 

 

Description of Good

C105

 

Country/Territory of Origin

C50

Full country/territory name.

Units

C255

 

Unit of Measure

C255

See Unit of Measure Codes for Invoices.

Unit Price

C19

999999999999.999999

Currency

C255

See Country/Territory and Currency Codes.