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

UPS_TRANSACTION_MASTER Table

Explanation
The UPS_TRANSACTION_MASTER table contains details related to the express shipping transaction such as transaction date, lead shipment number, shipment description and the PennID of the individual sending the shipment.

Common Uses
Obtaining specific details surrounding shipment transactions.

TRANSACTION_MASTER_ID

INVOICE_NUMBER
TRANSACTION_CUSTOMS_ID
TRANSACTION_MASTER_ID

      

UPS_CHARGES
UPS_PACKAGE_MASTER
UPS_TRANS_CUSTOMS_INFO
UPS_TRANS_DUTIABLE
UPS_TRANSACTION_ADDRESS
UPS_TRANSACTION_MASTER
UPS_TRANSACTION_MISC_
DETAILS

      

Cautions

• The UPS_TRANSACTION_MASTER table is stored in the DWBSD schema in the Data Warehouse.

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