Model Table DIM_RPD_COMPANY_PERIOD

Attributes

Attribute Description (where applicable)
ACCOUNTING_DATE
ALT_DIM_ID
ALT_DIM_ID_WITH_RPD_ID
CODE
COMPANY
FROM_DATE
ID
ID_WITH_RPD_ID
NUMBER_ATTRIBUTE1
NUMBER_ATTRIBUTE2
NUMBER_ATTRIBUTE3
NUMBER_ATTRIBUTE4
NUMBER_ATTRIBUTE5
REPORTING_DATE
RPD_ID
RPD_ID_DESCRIPTION
RPD_PERIOD
RPD_YEAR
STRING_ATTRIBUTE1
STRING_ATTRIBUTE2
STRING_ATTRIBUTE3
STRING_ATTRIBUTE4
STRING_ATTRIBUTE5
UNTIL_DATE
YEAR_PERIOD_NUM
YEAR_PERIOD_STR

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