Order.item_dates_stage captures the order lifecycle timeline as a status-history “item” table. Each row represents a single lifecycle event (a status entry) for an order, with the event date carried as a meta-date value and the event details stored as JSON metadata. Use it when you need to answer questions like: Grain and keys This is … Read more
What this is MP8 and MP9 are regional “Opportunity & Order Intake” extracts used to provide sales pipeline and win/loss visibility where the opportunity lifecycle is not yet fully represented in IFS (or where we need historic continuity). This logic standardises the two extracts into a single, report-ready shape that aligns to our BusOpp-style reporting … Read more
What this view is for Project.meta_dates provides the date-based and lifecycle attributes for projects. Where Project.core_details defines what a project is,and Project.meta_codes defines how a project is classified,Project.meta_dates defines when things happen in the life of a project. If you’re asking “when did this project start?”, “when is it due to finish?”, or “when did … Read more
What this view is for Project.meta_codes provides the categorical and classification attributes for projects. Where Project.core_details defines what a project is,Project.meta_codes defines how a project is described and grouped. If you’re asking “what type of project is this?”, “which programme does it belong to?”, or “how should this project be categorised?” — this is where … Read more
What this view is for Project.core_details is the starting point for all project-based reporting. Where: This view defines the project as a business object and provides the identity and links needed to relate delivery activity back to opportunities, orders, customers and ultimately invoicing. If you’re asking “what projects are we running, for whom, and how … Read more
What this view is for Invoice.item_values_lines provides the numeric values associated with invoices. Where: Invoice values represent what has actually been billed. This view is the authoritative source for invoiced amounts, tax and realised value. A note on “lines” in the CDM In the Common Data Model, lines indicates a value-bearing version, not necessarily a … Read more
What this view is for Invoice.meta_dates provides the key billing, lifecycle and payment-related dates for invoices. If: then meta_dates explains when important invoice events occurred or are expected to occur. This view is central to billing timelines, ageing analysis and cashflow reporting. Level of detail (grain) This view is intentionally long and thin.An invoice with … Read more
What this view is for Invoice.meta_codes provides the classification, status and commercial context for invoices. If: then meta_codes explains how the invoice should be interpreted, including its status, type, numbering context, payment terms and links back to upstream objects. This view is essential for understanding why an invoice looks the way it does and how … Read more
What this view is for Invoice.core_details is the starting point for all invoice-based reporting. Where: Invoices represent delivered and billed reality. This view defines the invoice as a business object and provides the identity and links needed to relate billing back to orders, opportunities, projects and customers. If you’re asking “what has been invoiced, to … Read more
What this view is for Order.item_values_lines provides the numeric values associated with customer orders. If: then item_values_lines answers how much has been ordered — in quantity, value and profit terms. This is the view where contracted order value lives. A note on “lines” in the CDM In the Common Data Model (CDM), the term lines … Read more