UPS_TRANSACTION_ADDRESS Table - Data Element Index   Tables and Data Elements   Express Mail Home   Data Warehouse Home

UPS_TRANSACTION_ADDRESS Table

Explanation
The UPS_TRANSACTION_ADDRESS table provides address detail of the individuals who are sending express mail shipments and the addresses of where those packages are sent.

Common Uses
Reviewing individuals that are sending shipments and the locations they are shipping to.

TRANSACTION_ADDRESS_ID

ADDRESS_TYPE
TRANSACTION_ADDRESS_ID
TRANSACTION_MASTER_ID

UPS_CHARGES
UPS_PACKAGE_MASTER
UPS_TRANS_CUSTOMS_INFO
UPS_TRANS_DUTIABLE
UPS_TRANSACTION_MASTER
UPS_TRANSACTION_MISC_
DETAILS

Cautions

• There can be many address types in the ADDRESS_TYPE field that relate to the same tracking number. This will cause dollar amounts to be repeated when linked to the UPS_CHARGES table, and must be taken into consideration when creating ad-hoc queries. An example would be for each package that has an ADDRESS_TYPE of "SenderAddress", there is an associated ADDRESS_TYPE of "ReceiverAddress".
• The UPS_TRANSACTION_ADDRESS table is stored in the DWBSD schema in the Data Warehouse.
  

UPS_TRANSACTION_ADDRESS Table - Data Element Index   Tables and Data Elements   Express Mail Home   Data Warehouse Home