D365 Reference
All D365 F&O Data Entities
Every data entity in the reference, sorted alphabetically — the export-shaped surfaces that expose the underlying tables. Use the jump-bar to skip to a letter, or filter by module.
What the badges mean
- main
- Table group: how F&O categorizes the table's role — main entity, group/header, transaction, worksheet header, worksheet line, reference, parameter, or framework.
- Shared across companies
- The table carries no
DataAreaId— rows aren’t partitioned per company, so a query never needs (and can’t use) a company filter here (see the quirks guide). - Date-effective
- The table carries a
ValidFrom/ValidToeffectivity window — a join without a date filter multiplies every key by its history (see the quirks guide).
In field listings, K marks a key field.
Module
Showing 26 of 26 entities
Entities starting with B
Entities starting with C
Entities starting with D
Entities starting with E
- EcoResProductTranslationEntity — Product translations — one record per product and language with the localized name and description, keyed by product numberproduct
- EcoResProductV2Entity — Products — the shared product master export (displayed as 'Products V2'), carrying product type, dimension-group assignments, and translated name and descriptionproduct
- EcoResReleasedProductV2Entity — Released products — the item master joined to its shared product, the standard export for item attributesReleasedProductsV2product
- EcoResStorageDimensionGroupEntity — Storage dimension groups — the shared site/warehouse/location activation setup, one record per groupproduct
- EcoResTrackingDimensionGroupEntity — Tracking dimension groups — the shared batch/serial activation setup, one record per groupproduct
Entities starting with I
- InventOperationalSiteEntity — Operational sites — the site master export, one record per site with its time zone, default status, and primary address flattened into columnsinventory
- InventWarehouseEntity — Warehouses — the warehouse master export, one record per warehouse with its site, type, and warehouse-management settingsinventory
- InventWarehouseOnHandV2Entity — Inventory on-hand by warehouse — aggregated on-hand, reserved, available, and on-order quantities per item variant, site, and warehouseinventory
Entities starting with O
Entities starting with P
- ProdProductionOrderHeaderEntity — Production orders — one record per production order header, the standard export for order status, quantities, and schedule datesProductionOrderHeadersproduction
- PurchPurchaseOrderHeaderV2Entity — Purchase order headers — one record per order, the header-level export for procure-to-payPurchaseOrderHeadersV2procurement
- PurchPurchaseOrderLineV2Entity — Purchase order lines — one record per order line, the line-level export joined to its headerPurchaseOrderLinesV2procurement
Entities starting with S
- SalesInvoiceHeaderV2Entity — Sales invoice headers — one record per posted customer invoice, the header-level export for invoiced revenueSalesInvoiceHeadersV2sales
- SalesInvoiceLineV2Entity — Sales invoice lines — one record per posted invoice line including inventory-related fields, the line-level export for invoiced revenuesales
- SalesOrderHeaderV2Entity — Sales order headers — one record per order, the header-level export for order-to-cashSalesOrderHeadersV2sales
- SalesOrderLineV2Entity — Sales order lines — one record per order line, the line-level export joined to its headerSalesOrderLinesV2sales
Entities starting with U
- UnitOfMeasureConversionEntity — Unit conversions — conversion factors between units, with the from/to unit symbols resolved; product-specific conversions are exported separatelyproduct
- UnitOfMeasureEntity — Units — the unit-of-measure master export (displayed as 'Units'), one record per unit symbol with class, system of units, and precisionproduct
Entities starting with V
Entities starting with W
- WHSOutboundLoadHeaderEntity — Outbound load headers — load-level export with carrier, equipment, and seal detail for outbound transportationwarehouse
- WHSOutboundShipmentHeaderEntity — Outbound shipment headers — shipment-level export with delivery address detail and the outbound load referencewarehouse
- WHSWarehouseWorkLineEntity — Warehouse work lines — line-level warehouse work with header context (work ID, status, closed datetime) folded in; the standard export for work execution analysiswarehouse