Forecast Date Dimension

Modified on Mon, 27 Jul at 9:21 PM

Calendar Summary

The Forecast Date Dimension provides a single inventory-planning date by combining the Sales Order Ship Date with the Purchase Order Expected Date.

Calendar Type

QQube inventory forecast date

Date Represents

Planned outbound or inbound date

QQube Source

Combined transaction dates

Primary Use

Inventory planning

Included Data Models

Operations: Inventory

QQube Source

QQube creates the forecast date by combining the following QuickBooks dates:

Sales Order Ship Date
Purchase Order Expected Date

This provides a single shortcut date for inventory planning.

QQube Forecast Date source combining Sales Order Ship Date and Purchase Order Expected Date

Available Fields

The following fields are included in the Forecast Date Dimension.

Display Order	Field Name
1	Forecast Date
2	Forecast Date Calendar Month Number
3	Forecast Date Calendar Year Number
4	Forecast Date Day Holiday Name
5	Forecast Date Day is Holiday
6	Forecast Date Day is Weekend Day
7	Forecast Date Day is Working Day
8	Forecast Date Day Number in Month
9	Forecast Date Day Number in Quarter
10	Forecast Date Day Number in Week
11	Forecast Date Day Number in Year
12	Forecast Date Day of Week
13	Forecast Date Day of Week Abbr
14	Forecast Date Formal Date
15	Forecast Date Month Abbr
16	Forecast Date Month Begin Date
17	Forecast Date Month End Date
18	Forecast Date Month Name
19	Forecast Date Month Number
20	Forecast Date Month Number in Quarter
21	Forecast Date Month-Year
22	Forecast Date Quarter (FQ)
23	Forecast Date Quarter (Q)
24	Forecast Date Quarter Begin Date
25	Forecast Date Quarter End Date
26	Forecast Date Quarter Number
27	Forecast Date Quarter-Year (FQ)
28	Forecast Date Quarter-Year (Q)
29	Forecast Date Week Begin Date
30	Forecast Date Week End Date
31	Forecast Date Year (FY)
32	Forecast Date Year (Y)
33	Forecast Date Year Begin Date
34	Forecast Date Year End Date
35	Forecast Date Year Number