Overview
When working with batches in Excel, each type of transaction sends back a different set of information to Excel. You can choose which bits of information you would like to record. See below for details about each transaction. If you would like to see the required information to initiate a transaction, see:
Minimum Fields to Map.
Address Validation
UPS will not always send back values for every possible field. For example, it is unlikely that a residential address will include a "building name." The following information can be recorded in Excel when validating an address:
|
Code
|
Notes
|
|
Address Validation::Status
|
Status of the address. Examples: VALID, AMBIGUOUS
|
|
Address Validation::Classification
|
Residential or Commercial
|
|
Address Validation::Consignee Name
|
Consignee Name, if any
|
|
Address Validation::Building Name
|
Building Name, if any
|
|
Address Validation::Address 1
|
First line of address
|
|
Address Validation::Address 2
|
Second line of address
|
|
Address Validation::Address 3
|
Third line of address
|
|
Address Validation::City
|
City
|
|
Address Validation::State
|
State
|
|
Address Validation::Zip
|
Zip Code
|
|
Address Validation::Plus 4
|
Additional zip code digits
|
|
Address Validation::Error
|
Tells you if anything went wrong (always record this)
|
.
To validate a full street level address you must turn street level on in OzLINK. To turn on street level validation in OzLINK, click the Setup menu in OzLINK for UPS, select Address Validation, then check the Enable street level validation box.
Rating
The following information can be recorded in Excel when validating an address:
|
Code
|
Notes
|
|
Rating::Published Rate
|
The normal cost to ship the package
|
|
Rating::Negotiated Rate
|
Your cost to ship the package based on your rate discounts
|
|
Rating::Business Transit Days
|
Number of business days the package will be in transit
|
|
Rating::Arrival Date
|
Arrival Date
|
|
Rating::Arrival Time
|
Arrival Time
|
|
Rating::Arrival Day of Week
|
Arrival Day of Week (MON, TUE, WED, etc)
|
|
Rating::Error
|
Tells you if anything went wrong (always record this)
|
Tracking
The following information can be recorded in Excel when tracking a package:
|
Code
|
Notes
|
|
Tracking::Last Status
|
Most recent package status. Example: Delivered
|
|
Tracking::City
|
Current city that the package is in
|
|
Tracking::State
|
Current state that the package is in
|
|
Tracking::Location Description
|
Where the package was delivered. Examples: PORCH, FRONT DOOR
|
|
Tracking::Signature Available
|
Y or N, if the signature can be viewed
|
|
Tracking::Proof of Delivery
|
A link to the UPS website with a proof of delivery form
|
|
Tracking::Signed For By Name
|
Name of the person who signed for the package
|
|
Tracking::Status Type
|
Short version of the current package status. Example: D for Delivered
|
|
Tracking::Status Type Description
|
Current package status. Example: Delivered
|
|
Tracking::Date
|
Date of the last status update
|
|
Tracking::Time
|
Time of the last status update
|
|
Tracking::Service
|
The service used to ship
|
|
Tracking::Package Weight
|
Weight of the package in pounds
|
|
Tracking::Package Reference 1
|
Package Reference 1
|
|
Tracking::Package Reference 2
|
Package Reference 2
|
|
Tracking::Package Reference 3
|
Package Reference 3
|
|
Tracking::Package Reference 4
|
Package Reference 4
|
|
Tracking::Package Reference 5
|
Package Reference 5
|
|
Tracking::Shipment Reference 1
|
Shipment Reference 1
|
|
Tracking::Shipment Reference 2
|
Shipment Reference 2
|
|
Tracking::Shipment Reference 3
|
Shipment Reference 3
|
|
Tracking::Shipment Reference 4
|
Shipment Reference 4
|
|
Tracking::Shipment Reference 5
|
Shipment Reference 5
|
|
Tracking::Pickup Date
|
Date that UPS picked up the package
|
|
Tracking::Scheduled Delivery Date
|
Scheduled delivery date
|
|
Tracking::Message
|
Additional delivery information
|
|
Tracking::Ship To City
|
Ship To City
|
|
Tracking::Ship To State
|
Ship To State
|
|
Tracking::Ship To Postal Code
|
Ship To Postal Code
|
|
Tracking::Ship To Country Code
|
Ship To Country Code
|
|
Tracking::Shipper Number
|
Shipper number
|
|
Tracking::Shipper City
|
Shipper City
|
|
Tracking::Shipper Postal Code
|
Shipper Postal Code
|
|
Tracking::Shipper Country Code
|
Shipper Country Code
|
|
Tracking::Error
|
Tells you if anything went wrong (always record this)
|
Shipping
Below are the most common pieces of information recorded when shipping with Excel. They can be found in the Shipping Quick Picks section when adding a new column to record. There are a huge number of details that can be recorded from a shipment - see the link below the table for help with the rest of the available fields.
|
Code
|
Notes
|
|
Date
|
Date when the package was shipped
|
|
Time
|
Time when the package was shipped
|
|
Tracking Link
|
A clickable link to track the package
|
|
Package::Tracking_Number
|
The tracking number for the package
|
|
Shipment_Information::Total_Shipment_Charge
|
Total charged for the shipment
|
|
Shipment_Information::Service_Type
|
Service used for the shipment
|
For more details about additional codes that can be recorded, see the UPS data field help site here:
Related Pages