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 |