Trade Direct Shipment Data Field Descriptions

Category/Field

Length

Type

I/E

Exceptions and Notes

Consolidated Movement

Shipper Number

10

A/N

E

Unique Shipment Identifier

19

A/N

E

Target Ready Date

8

N

E

YYYYMMDD.

Status

2

E

Small Package Shipments

3

N

E

Packages

3

N

E

LTL Shipments

3

N

E

LTL Line Items

3

N

E

Total Weight

8

N

E

Description of Goods

400

A/N

E

0-9; A-Z.

Shipper Reference

35

A/N

E

0-9; A-Z.

Dangerous Goods

1

A

E

Y or N.

Billing Option

20

A

E

Bill Transportation To

20

A

E

See Bill-To Information and Codes.

Bill Duty and Tax To

20

A

E

See Bill-To Information and Codes.

Split Duty and Tax

1

A

E

Y or N. See Bill-To Information and Codes.

Terms of Sale

2

N

E

See Terms of Sale Codes.

Reason for Export

2

N

E

See Reason for Export Codes.

Declaration Statement

255

A/N

E

See Declaration Statements. Only the name can be exported.

Additional Comments

45

A/N/S

E

0-9; A-Z; special characters.

Importer Same As Ship To

1

A

E

Y or N.

Product Type

3

N

E

302: Ocean
303: Cross Border North
304: Cross Border South
305: Air

Unit of Measure

2

A

E

Total Weight For Detail Line

6

N

E

Ship Date Time Stamp

34

A/N

E

Has Different Currency Code For Commodities

1

A

E

Y or N.

Currency Code

3

A

E

See Country/Territory and Currency Codes.

Invoice Line Total

12

N

E

Any numeric value (include decimal) up to total value of goods on Invoice.

Discount

5

N

E

Any numeric value (include decimal) up to total value of goods on Invoice.

Freight Charge

8

N

E

Any numeric value (include decimal) up to total value of goods on Invoice.

Insurance Charge

8

N

E

Any numeric value (include decimal) up to total value of goods on Invoice.

Other Charge

8

N

E

Any numeric value (include decimal) up to total value of goods on Invoice.

Countries of Origin

3

A

E

Customs Value

3

N

E

Customs Value Currency

3

A

E

CM Importer

Customer ID

30

A/N/S

E

Must be unique. 0-9; A-Z; special characters.

Company or Name

35

A/N/S

E

0-9; A-Z; special characters.

Attention

35

A/N/S

E

0-9; A-Z; special characters.

Address 1

35

A/N/S

E

0-9; A-Z; special characters.

Address 2

35

A/N/S

E

0-9; A-Z; special characters.

Address 3

35

A/N/S

E

0-9; A-Z; special characters.

Country/Territory

50

A

E

See Country/Territory and Currency Codes.

City or Town

30

A/N/S

E

0-9; A-Z; special characters.

State/Province/County

30

A

E

See US State and Canada Province Codes.

Postal Code

9

A/N

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

E

0-9; A-Z; special characters.

Tax ID Number

15

A/N/S

E

0-9; A-Z; special characters.

UPS Account Number

10

A/N/S

E

Six alphanumeric characters for US and Puerto Rico addresses; 10 numbers for all other addresses.

Package Pallet Label

Number of Identical Handling Units

6

N

E

999999.

Palletized Indicator

1

A

E

Y or N.

Length

6

N

E

999999.

Width

6

N

E

999999.

Height

6

N

E

999999.

Handling Unit Weight

15

N

E

999999999999999.

Number of Packages Air Service

6

N

E

999999.

Number of Packages Ground Service

6

N

E

999999.

CM Third Party

Customer ID

30

A/N/S

E

Must be unique. 0-9; A-Z; special characters.

Company or Name

35

A/N/S

E

0-9; A-Z; special characters.

Attention

35

A/N/S

E

0-9; A-Z; special characters.

Address 1

35

A/N/S

E

0-9; A-Z; special characters.

Address 2

35

A/N/S

E

0-9; A-Z; special characters.

Address 3

35

A/N/S

E

0-9; A-Z; special characters.

Country/Territory

50

A

E

See Country/Territory and Currency Codes.

Postal Code

9

A/N

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

E

0-9; A-Z; special characters.

State/Province/County

30

A

E

See US State and Canada Province Codes.

Telephone

15

A/N/S

E

0-9; A-Z; special characters.

Fax Number

15

A/N/S

E

0-9; A-Z; special characters.

UPS Account Number

10

A/N/S

E

Six alphanumeric characters for US and Puerto Rico addresses; 10 numbers for all other addresses.

Quantum View Notify

Option

1

A

E

Y or N.

Reference Charge

20

N

E

Published Charge

20

N

E

Ship From Company or Name

35

A/N/S

E

0-9; A-Z; special characters.

Memo

150

A/N/S

E

0-9; A-Z; special characters.

Failed Email Address

50

A/N/S

E

See Validate E-mail Addresses.

Ship Notification 1 Option

1

A

E

Y or N.

Exception Notification 1 Option

1

A

E

Y or N.

Delivery Notification 1 Option

1

A

E

Y or N.

Notification Recipient 1 Company or Name

35

A/N/S

E

0-9; A-Z; special characters.

Notification Recipient 1 Contact Name

35

A/N/S

E

0-9; A-Z; special characters.

Notification Recipient 1 Email

50

A/N/S

E

See Validate E-mail Addresses.

Ship Notification 2 Option

1

A

E

Y or N.

Exception Notification 2 Option

1

A

E

Y or N.

Delivery Notification 2 Option

1

A

E

Y or N.

Notification Recipient 2 Company or Name

35

A/N/S

E

0-9; A-Z; special characters.

Notification Recipient 2 Contact Name

35

A/N/S

E

0-9; A-Z; special characters.

Notification Recipient 2 Email

50

A/N/S

E

See Validate E-mail Addresses.

Ship Notification 3 Option

1

A/N

E

Y or N.

Exception Notification 3 Option

1

A/N

E

Y or N.

Delivery Notification 3 Option

1

A/N

E

Y or N.

Notification Recipient 3 Company or Name

35

A/N/S

E

0-9; A-Z; special characters.

Notification Recipient 3 Contact Name

35

A/N/S

E

0-9; A-Z; special characters.

Notification Recipient 3 Email

50

A/N/S

E

See Validate E-mail Addresses.

Ship Notification 4 Option

1

A

E

Y or N.

Exception Notification 4 Option

1

A

E

Y or N.

Delivery Notification 4 Option

1

A

E

Y or N.

Notification Recipient 4 Company or Name

35

A/N/S

E

0-9; A-Z; special characters.

Notification Recipient 4 Contact Name

35

A/N/S

E

0-9; A-Z.; special characters.

Notification Recipient 4 Email

50

A/N/S

E

See Validate E-mail Addresses.

Ship Notification 5 Option

1

A

E

Y or N.

Exception Notification 5 Option

1

A

E

Y or N.

Delivery Notification 5 Option

1

A

E

Y or N.

Notification Recipient 5 Company or Name

35

A/N/S

E

0-9; A-Z; special characters.

Notification Recipient 5 Contact Name

35

A/N/S

E

0-9; A-Z; special characters.

Notification Recipient 5 Email

50

A/N/S

E

See Validate E-mail Addresses.

Origin CFS

Company or Name

35

A/N/S

E

0-9; A-Z; special characters.

Address 1

35

A/N/S

E

0-9; A-Z; special characters.

Address 2

35

A/N/S

E

0-9; A-Z/ special characters.

City or Town

30

A/N/S

E

0-9; A-Z; special characters.

State/Province/County

30

A

E

See US State and Canada Province Codes.

Postal Code

9

A/N

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.

Country/Territory

50

A

E

See Country/Territory and Currency Codes.

Destination CFS

Company or Name

35

A/N/S

E

0-9; A-Z; special characters.

Attention

35

A/N/S

E

0-9; A-Z; special characters.

Address 1

35

A/N/S

E

0-9; A-Z; special characters.

Address 2

35

A/N/S

E

0-9; A-Z; special characters.

City or Town

30

A/N/S

E

0-9; A-Z; special characters.

State/Province/County

30

A

E

See US State and Canada Province Codes.

Postal Code

9

A/N

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.

Country/Territory

50

A

E

Use full country name. See Country/Territory and Currency Codes.

Telephone

15

A/N

E

0-9; A-Z.