Model: Sales - Specifications for Dimension Table: INVOICE DATE

On this page you will find the specifications regarding the Model: Sales and Dimension Table: INVOICE DATE.

This model represents the sales dimension invoice date and is based on the IFS Applications dimension DIM_BI_TIME.

Attributes

Attribute	Description (where applicable)
Current Month Flag	Represents a flag that is set to 1 if the date represents the current month. Else the value is 0.
Current Year Flag	Represents a flag that is set to 1 if the date represents the current year. Else the value is 0
Invoice Date	The date without time stamp.
Invoice Date String	The date converted to string according to the format 'YYYY-MM-DD'
Invoice Month	Represents the name of the month.
Invoice Month No	Represents the month of the year.
Invoice Month Short	Represents the short name of the month (MMM) of the year.
Invoice Quarter	Represents the quarter of the year.
Invoice Week	Represents the ISO week number.
Invoice Weekday	Represents the day of week by name.
Invoice Weekday No	Represents the day of week by number.
Invoice Year	Represents the year.
Invoice Year Month	Represents a combination of YEAR and MONTH_OF_YEAR in the format "YYYYMM".
Last 12 Months Flag	Represents a flag that is set to 1 if the date represents one of the last completed 12 months. Else the value is 0. If transfer date is 15 Nov 2020, then last 12 months means the range Nov 2019 until Oct 2010.
Last 24 Months Flag	Represents a flag that is set to 1 if the date represents one of the last completed 24 months. Else the value is 0. If transfer date is 15 Nov 2020, then last 24 months means the range Nov 2018 until Oct 2020.
Year (Week based)	Represents the ISO year with respect to Invoice Date.

Hierarchies

Hierarchy	Level
InvoiceMFHy
	Invoice Year
	Invoice Quarter
	Invoice Month
	Invoice Date
InvoiceMSHy
	Invoice Year
	Invoice Quarter
	Invoice Month
InvoiceWFHy
	Year (Week based)
	Invoice Week
	Invoice Date
InvoiceWSHy
	Year (Week based)
	Invoice Week

USED BY MODEL(S)

Model Name

Sales

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
INVOICE DATE	DIM_BI_TIME_BI	DIM_BI_TIME_BI	DIM_BI_TIME	On Line