Model: CRM - Specifications for Dimension Table: DIM_RPD_COMPANY_PERIOD

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

Attributes

Attribute Description (where applicable)
ACCOUNTING_DATENot Required
ALT_DIM_IDNot Required
ALT_DIM_ID_WITH_RPD_IDNot Required
CODENot Required
COMPANYNot Required
FROM_DATENot Required
IDNot Required
ID_WITH_RPD_IDNot Required
NUMBER_ATTRIBUTE1Not Required
NUMBER_ATTRIBUTE2Not Required
NUMBER_ATTRIBUTE3Not Required
NUMBER_ATTRIBUTE4Not Required
NUMBER_ATTRIBUTE5Not Required
REPORTING_DATENot Required
RPD_IDNot Required
RPD_ID_DESCRIPTIONNot Required
RPD_PERIODNot Required
RPD_YEARNot Required
STRING_ATTRIBUTE1Not Required
STRING_ATTRIBUTE2Not Required
STRING_ATTRIBUTE3Not Required
STRING_ATTRIBUTE4Not Required
STRING_ATTRIBUTE5Not Required
UNTIL_DATENot Required
YEAR_PERIOD_NUMNot Required
YEAR_PERIOD_STRNot Required

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
DIM_RPD_COMPANY_PERIODDIM_RPD_COMPANY_PERIOD_BIDIM_RPD_COMPANY_PERIOD_BIDIM_RPD_COMPANY_PERIODOn Line