Address Book Data Field Descriptions

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

Notes:

Use only a Western character set to create records for an import file. If you use any other character set to create the field names and data in a record, the import fails for that record.
If you use Character Map (a Windows function) to insert special characters into the data that you plan to import, use only characters that belong to the Windows: Western character set. If you use another character set, the characters are converted to the Windows: Western character set and may not appear as you want.
Table Legend:
The Length column indicates the maximum number of characters you can type for the field.
The Type column indicates A for alphabetic characters, N for numeric characters, and S for special characters (such as, press the Shift and 4 keys to type $). For example, A/N/S means that you can type alphabetic, numeric, and special characters.
The I/E column indicates if the field applies to import (I), export (E), or both import and export (I/E) maps.
The Exceptions and Notes column provides additional information, such as valid values, field formats, or links to additional information.
Even though the Notes column may show Y or N, imports accept Y or 1 for international shipments.

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	8	N	I/E	YYYYMMDD.
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.
Company Display Name	35	A/N/S	I/E	0-9; A-Z; special characters.
UPS Access Point ID	9	A/N	I/E	U12345678 Note: The ID must start with a "U."