D365 Reference

SalesInvoiceHeaderV2Entity

OData: SalesInvoiceHeadersV2

Sales invoice headers — one record per posted customer invoice, the header-level export for invoiced revenue

Module: Sales & Marketing
Tables vs entities

This entity is an export-shaped view over the tables below. When you land raw F&O tables instead of the entity, the SQL further down rebuilds it — joining the backing tables on their keys and DataAreaId. When to land tables vs entities →

Notes

V2 header entity; CDM- and MS Learn-confirmed, primary datasource CustInvoiceJour.

Rebuild-from-tables SQL

Databricks SQL

Starting point for reconstructing this entity from landed tables — the backing tables joined on their keys and DataAreaId. Set your Unity Catalog location, company, and filter values below.

Query parameters
-- ============================================================
-- Entity : SalesInvoiceHeaderV2Entity (OData: SalesInvoiceHeadersV2)
-- Purpose: Rebuild SalesInvoiceHeaderV2Entity from landed F&O tables — auto-generated from table-entity-map
-- Grain  : One row per CustInvoiceJour record
-- Tables : CustInvoiceJour
-- Notes  : Auto-generated skeleton for Synapse Link / Fabric Link-landed F&O data (lowercase column names). Enums decoded inline where verified; datetimes stored in UTC; 1900-01-01 dates are sentinels mapped to NULL. Company-partitioned tables are joined on DataAreaId to prevent cross-company fan-out. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
  h.invoiceid AS "The invoice number; unique only together with InvoiceDate, numberSequenceGroup, and SalesId",
  h.invoicedate AS "Date the invoice was posted — the primary analysis date for revenue reporting",
  h.numbersequencegroup AS "Number-sequence group the invoice number was drawn from; part of the composite key (often blank)",
  h.salesid AS "Sales order the invoice was posted from; part of the composite key"
FROM <catalog>.<schema>.custinvoicejour h
WHERE
  h.dataareaid = '<company>'
ORDER BY h.invoiceid;

3 parameters not filled: <catalog>, <schema>, <company>

Backing Tables