Address Book Data Field Descriptions

The table below lists all address data fields that UPS WorldShip can import or export.

Notes:

Field

Length

Type

I/E

Exceptions and Notes

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.

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

No hyphen; 0-9; Canada 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/N

I/E

See Country/Territory and Currency 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.

Tax ID Number

15

A/N/S

I/E

0-9; A-Z; special characters.

Tax ID Type

5

A

I/E

See Tax ID Type Codes.

Location ID

10

A/N

I/E

0-9; A-Z.

Consignee Billed

1

A

I/E

Y or N.

Residential Indicator

1

A

I/E

Y or N.

Email Address

50

A/N/S

I/E

See Validate E-mail Addresses.

Address Validation Status

13

A

I/E

Not Validated The address was not submitted for validation, the validated address was not reconciled, or the candidate address was not used.

Pending The address was submitted for validation, but a response has not been returned.

Validated The address was validated and reconciled.

Address Validation Date

33

N

I/E

0-9.

Profile Name

35

A/N/S

I/E

0-9; A-Z; special characters.

Reference 1 qualifier

2

A/N/S

I/E

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

Reference 2 qualifier

2

A/N/S

I/E

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

Reference 3 qualifier

2

A/N/S

I/E

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

Reference 4 qualifier

2

A/N/S

I/E

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

Reference 5 qualifier

2

A/N/S

I/E

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

Reference 1 use on all packages

1

A

I/E

Y or N.

Reference 2 use on all packages

1

A

I/E

Y or N.

Reference 3 use on all packages

1

A

I/E

Y or N.

Reference 4 use on all packages

1

A

I/E

Y or N.

Reference 5 use on all packages

1

A

I/E

Y or N.