Overview sustainability.item_values_co2factor provides a structured, item-value representation of greenhouse gas (GHG) conversion factors used for carbon reporting. The view standardises UK Government conversion factor data into a consistent CDM-aligned format, enabling emissions calculations to be performed in a repeatable and governed way across reporting and analytics. It forms a foundational dataset for sustainability, emissions tracking, … Read more
Overview Compliance.item_codes_osh provides a structured, business-ready item code view of OSH incident and safety form records. It consolidates form-level and location-related attributes from the source OSH records into a single consistent pattern so that incident, safety, and compliance information can be queried in the same way as other itemised CDM-style views. This view is designed … Read more
Overview The resource.item_values_activity view provides a structured, item-level representation of planned resource effort, linking employees to project activities through planned hours. It expresses resource planning as measurable activity, enabling clear visibility of how effort is distributed across projects, activities, and time-based snapshots. Purpose This view standardises planned resource effort into the CDM item_values pattern, allowing: … Read more
Overview The AccountsReceivable.item_values_receipts view provides a structured, line-level representation of how customer receipts are applied within Accounts Receivable. It exposes the financial impact of payments across ledger items, including settlement behaviour, adjustments, and associated financial movements. This view enables a transparent understanding of how incoming cash is allocated against customer balances, supporting reconciliation, audit, and … 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.item_values provides the numeric and financial measures for projects. Where: If you’re asking:“how much has this project cost?”,“how much revenue has it generated?”, or“what is the current forecast or contingency?” — this is where you look. Architectural maturity This view is delivered as a cvw (collated view). It is assembled … 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 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
What this view is for Busopp.item_values_lines provides the numeric values associated with business opportunities. If: then item_values_lines tells you how much. This is the view where pipeline value lives. A note on “lines” in the CDM For convinience, in the Common Data Model (CDM), the term lines is used as a version indicator. For opportunities, … Read more
Overview The Employee Item Values Expense view provides the transactional value layer for employee expense and mileage items within the Common Data Model (CDM). It captures the key numeric measures associated with employee claims and presents them in a standardised long-form item structure, enabling flexible analysis, auditability, and controlled reuse across reporting and planning use … Read more