Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SURCHARGE POSTINGS Table


View exposing surcharge posting records including calculated surcharge amounts applied to financial objects.


Field Name

Description

Data Type

Length

COST_ELEMENT_ID

Business identifier for the cost element.

VARCHAR2

6

GL_ACCOUNT_KEY

Surrogate key identifying the gl account.

VARCHAR2

10

SURCHARGE_BASE_PATTERN_KEY

Surrogate key identifying the surcharge base pattern.

NUMBER

SURCHARGE_CALC_PATTERN_KEY

Surrogate key identifying the surcharge calc pattern.

VARCHAR2

50

SURCHARGE_PERCENT

Surcharge percent associated with the record.

NUMBER

18,4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE