PurchPurchaseOrderLineV2Entity
OData: PurchaseOrderLinesV2Purchase order lines — one record per order line, the line-level export joined to its header
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
V2 line entity; CDM page confirms PurchLine as the backing table (entity version 1.2 as of the 2026-08-30 CDM verification).
Rebuild-from-tables SQL
Databricks SQLStarting 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.
3 parameters not filled: <catalog>, <schema>, <company>
-- ============================================================
-- Entity : PurchPurchaseOrderLineV2Entity (OData: PurchaseOrderLinesV2)
-- Purpose: Rebuild PurchPurchaseOrderLineV2Entity from landed F&O tables — auto-generated from table-entity-map
-- Grain : One row per PurchLine record
-- Tables : PurchLine
-- 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
pl.purchid AS "The purchase order this line belongs to",
pl.linenumber AS "Line number within the order — a 64-bit sequence, unlike the decimal LineNum on sales lines",
pl.name AS "Line description"
FROM <catalog>.<schema>.purchline pl
LEFT JOIN <catalog>.<schema>.purchtable po
ON po.purchid = pl.purchid
AND po.dataareaid = pl.dataareaid
WHERE
pl.dataareaid = '<company>'
ORDER BY pl.purchid;Backing Tables
How these tables connect — join details in the list below.
Join details
ON purchtable.purchid = purchline.purchid AND purchtable.dataareaid = purchline.dataareaid