Model: Procurement - Specifications for Dimension Table: PURCHASE CHARGE TYPE
This model dimension represents condition codes and is based on the IFS Cloud
dimension DIM_PURCHASE_CHARGE_TYPE. All models that refer to this dimension will
have the attributes and hierarchies as described below.
Attributes
Attribute |
Description (where applicable) |
Charge | |
Charge Amount | Charge Amount |
Price UoM | Pricing Unit of Measure |
Purchase Charge Code | Represents the CODE of the dimension, i.e. the charge type
code. |
Purchase Charge Descr | Represents the DESCRIPTION of a charge type. |
Purchase Charge Distributed by | The method of distributing the charge, i.e. per amount,
per weight etc. Underlying column DISTRIBUTE_CHARGE_BY_DESC. |
Purchase Charge Group | Represents the charge group. |
Purchase Charge Site | The code of the site being charged. |
Purchase Charge Supplier | Charging Supplier Code if appicable |
Purchase Charge Type | Built as CONTRACT + ' - ' + CODE + ' - ' + DESCRIPTION |
Hierarchy |
Level |
PurchChargeGroupHy | |
| Purchase Charge Group |
| Purchase Charge Type |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
PURCHASE CHARGE TYPE | DIM_PURCHASE_CHARGE_TYPE_BI | DIM_PURCHASE_CHARGE_TYPE_BI | DIM_PURCHASE_CHARGE_TYPE | On Line |