Model: CRM - Specifications for Dimension Table: SITE DISCOM INFO

On this page you will find the specifications regarding the Model: CRM and Dimension Table: SITE DISCOM INFO.

This model dimension represents site distribution information and is based on the IFS Cloud dimension DIM_SITE_DISCOM_INFO. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
Site Discom Defined as CODE + ' - ' + DESCRIPTION, i.e. site and its description.
Site Discom Branch Branch
Site Discom Create Order In Rel State Create CO in released state
Site Discom Create Order In Rel State Descr Create CO in released state description
Site Discom Customer Order Disc Method Customer order discount method
Site Discom Customer Order Disc Method Descr Customer order discount method description
Site Discom Customer Order Pricing Method Customer order pricing method
Site Discom Customer Order Pricing Method Descr Customer order pricing method description
Site Discom Disp Cond Customer Order Display condition code on CO
Site Discom Disp Cond Customer Order Descr Display condition code on CO description
Site Discom Disp Cond Purchase Order Display condition code on PO
Site Discom Disp Cond Purchase Order Descr Display condition code on PO description
Site Discom Purch Comp Method Purchase component method
Site Discom Purch Comp Method Description Purchase component method description
Site Discom Ship Inventory Location Number Default shipment location
Site Discom User PartCa Description Order Use Part Catalog Description as Description for Sales Part
Site Discom User PartCa Description Order Descr Use PartCat Desc as Desc for Sales Part Description
Site Discom User PartCa Description Purchase Use Part Catalog Description as Description for Purchase part
Site Discom User PartCa Description Purchase Descr Use PartCat Desc as Desc for Purchase Part Description

USED BY MODEL(S)

Model Name
CRM

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
SITE DISCOM INFO DIM_SITE_DISCOM_INFO_TM DIM_SITE_DISCOM_INFO_BI DIM_SITE_DISCOM_INFO On Line