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

UPS_CHARGES Table

Explanation
The UPS_CHARGES table contains records of transactions related to the charge descriptions of packages sent as well as their associated costs.

Common Uses
Reviewing shipment types and their financial charges.

HIBERNATE_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
HIBERNATE_ID
PACKAGE_CHARGE_ID
TRANSACTION_MASTER_ID


      

UPS_PACKAGE_MASTER
UPS_TRANS_CUSTOMS_INFO
UPS_TRANS_DUTIABLE
UPS_TRANSACTION_ADDRESS
UPS_TRANSACTION_MASTER
UPS_TRANSACTION_MISC_DETAILS


      

Cautions

• There can be many address types in the ADDRESS_TYPE field within the TRANSACTION_ADDRESS table 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_CHARGES table is stored in the DWBSD schema in the Data Warehouse.

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