Penn Computing

University of Pennsylvania
Penn Computing << go backback
UPS_PACKAGE_MASTER Table - Data Element Index   Tables and Data Elements   Express Mail Home   Data Warehouse Home

UPS_PACKAGE_MASTER Table

Explanation
The UPS_PACKAGE_MASTER table contains detailed information related to packages shipped.

Common Uses
Reviewing the quantity of packages in a shipment, their weight, dimensions, etc.

Primary Key Indexed Data Elements Related Tables 
PACKAGE_ID
 
ACCOUNTING_PERIOD
CALENDAR_MONTH
CALENDAR_YEAR
COA_ACCOUNT
COA_BC
COA_CNAC
COA_CREF
COA_FUND
COA_OBJECT
COA_ORG
COA_PROGRAM
COA_RESPONSIBLE_ORG
DEFAULT_COA_ACCOUNT
DEFAULT_COA_BC
DEFAULT_COA_CNAC
DEFAULT_COA_CREF
DEFAULT_COA_FUND
DEFAULT_COA_OBJECT
DEFAULT_COA_ORG
DEFAULT_COA_PROGRAM
DEFAULT_COA_RESPONSIBLE_ORG
FISCAL_MONTH_SEQ
FISCAL_YEAR
PACKAGE_ID
TRANSACTION_MASTER_ID

      
UPS_CHARGES
UPS_TRANS_CUSTOMS_INFO
UPS_TRANS_DUTIABLE
UPS_TRANSACTION_ADDRESS
UPS_TRANSACTION_MASTER
UPS_TRANSACTION_MISC_DETAILS

Cautions

  • The UPS_PACKAGE_MASTER table is stored in the DWBSD schema in the Data Warehouse.
UPS_PACKAGE_MASTER Table - Data Element Index   Tables and Data Elements   Express Mail Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania