D365 Reference
All D365 F&O Tables
Every table in the reference, sorted alphabetically. Use the jump-bar to skip to a letter, or filter by module, table group, and company partition.
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.
FilterShowing 62 of 62 tables
Module
Tables starting with B
- BOMBill of materials line — one component per row under a BOM header, with quantity per unit, validity dates, scrap factors, and the operation it is consumed atmainproduction
- BOMTableBill of materials header — one row per BOM identifier, with its name, approval state, and production site; versions in BOMVersion decide which items use it and whenmainproduction
- BOMVersionBOM version — the link that assigns a BOM header to a finished item for a validity period, quantity range, and site; the Active flag decides which version planning and orders pickmainproduction
Tables starting with C
- CompanyInfoThe legal-entity master — one row per company, carrying its DataArea code and registration and tax numbers; the company name and party details live on its DirPartyTable base recordSharedmainorganization
- CustGroupCustomer group master — one row per posting/reporting group of customers, carrying default payment terms and the settle-period used to derive due datesgroupsales
- CustInvoiceJourPosted customer invoice header — one row per invoice issued from a sales order (or free-text posting), with totals, currency, due date, and the ledger voucher it posted undertransactionsales
- CustInvoiceTransPosted customer invoice line — one row per invoiced line with item, quantity, price, and amounts; the revenue-by-item grain of order-to-cash analyticstransactionsales
- CustPackingSlipJourPosted packing-slip header — one row per shipment document posted against a sales order, with delivery date, ship-to address reference, and carrier detailstransactionsales
- CustTableCustomer master — one row per customer account, with the RecId links to its global-address-book party and its default financial dimensionsmainsales
- CustTransThe customer transaction ledger — one open-item row per posted AR amount (invoice, payment, credit note), carrying signed amounts, due date, and settlement state; the table AR aging and DSO are built from, companion to the CustInvoiceJour invoice detailtransactionfinance
Tables starting with D
- DataAreaThe kernel table that lists every company (legal entity data area) in the environment — the source of every dataareaid value used to partition application tablesSharedframeworkorganization
- DimensionAttributeThe registry of financial dimensions themselves (cost center, department, business unit…) — one row per dimension, recording which table or view backs its valuesSharedreferencefinance
- DimensionAttributeValueOne row per used value of a financial dimension — the middle hop that ties a value-set item back to the dimension it belongs to and the backing record that defines itSharedmainfinance
- DimensionAttributeValueSetA stored set of financial-dimension values referenced by masters and transactions via a RecId; the first hop when decoding default dimensions into columnsSharedmainfinance
- DimensionAttributeValueSetItemOne row per dimension value inside a stored value set — the line level of DimensionAttributeValueSet, carrying the value's display code denormalized for fast decodesSharedreferencefinance
- DirPartyTableThe global address book party master — the shared registry behind every customer, vendor, and organization; referenced by RecId, no company partitionSharedmainaddress-book
Tables starting with E
- EcoResProductThe shared product master — one row per product across all companies; released products in InventTable point back to it by RecIdSharedmainproduct
- EcoResProductTranslationLanguage-specific product names and descriptions — one row per shared product and language, joined back to EcoResProduct by RecId; the table product names actually live inSharedmainproduct
- EcoResStorageDimensionGroupStorage dimension group master — shared setup that decides which storage dimensions (site, warehouse, location) are active and mandatory for the products assigned to it, including whether advanced warehousing appliesSharedgroupproduct
- EcoResTrackingDimensionGroupTracking dimension group master — shared setup that decides whether batch and serial tracking are active for the products assigned to it, and where serials are capturedSharedgroupproduct
Tables starting with F
Tables starting with I
- InventBatchBatch master — one row per item and batch number, carrying expiry and manufacturing dates plus vendor batch details; the record behind the inventBatchId dimensionworksheet headerinventory
- InventDimThe inventory dimension hub — one row per unique combination of site, warehouse, location, batch, and serial that every stock quantity hangs off by InventDimIdmaininventory
- InventItemGroupItem group master — one row per company and item group, the reporting and posting bucket items are assigned to via InventItemGroupItemgroupproduct
- InventItemGroupItemThe link table that assigns each released item to its item group — in D365 the item group is NOT a column on InventTable; this table is where the assignment lives. Cross-company: it carries explicit ItemDataAreaId / ItemGroupDataAreaId columns instead of a DataAreaId partitionSharedmainproduct
- InventItemPriceItem price records — activated cost, purchase, and sales prices per item, costing version, and dimension; the source for standard-cost analysistransaction headerinventory
- InventJournalTableInventory journal header — one row per movement, adjustment, transfer, BOM, or counting journal, with its type, posting status, and line countworksheet headerinventory
- InventJournalTransInventory journal line — one row per item movement in a journal, with quantity, cost, counted figures, and the dimension combination it posts againstworksheet lineinventory
- InventLocationWarehouse master — one row per warehouse (inventory location) with its site and typegroupinventory
- InventModelGroupItem model group master — one row per company and model group, controlling inventory policy for its items: costing model, negative-stock rules, and whether the product is stocked at allgroupproduct
- InventModelGroupItemThe link table that assigns each released item to its item model group — like the item group, the model group is not a column on InventTable. Cross-company, with explicit ItemDataAreaId / ModelGroupDataAreaId columnsSharedmainproduct
- InventSiteSite master — one row per operational site, the top of the inventory dimension hierarchy that warehouses roll up togroupinventory
- InventSumAggregated on-hand quantities by item and inventory dimension — physical, available, and posted balancestransactioninventory
- InventTableReleased product master — one row per item within a company, carrying the RecId link to its shared product; item group and model group are assigned in the InventItemGroupItem / InventModelGroupItem link tables, not heremainproduct
- InventTableModulePer-module item settings — one row per released item per module (inventory, purchase, sales), holding that module's default unit, base price and price unit, discount groups, tax item group, and over/under-delivery tolerances; a fully set-up item normally has exactly three rows per companymainproduct
- InventTransThe inventory transaction ledger — every physical and financial stock movement, with issue/receipt status, quantities, dates, and links back to its source documenttransactioninventory
- InventTransOriginThe origin record every inventory transaction points to — resolves an InventTrans row back to the sales line, purchase line, or journal that created ittransactioninventory
Tables starting with L
Tables starting with P
- ProdBOMProduction order BOM line — the materials a specific production order plans to consume, copied from the item's active BOM at order creation and then adjusted per orderworksheet lineproduction
- ProdTableProduction order header — one row per order carrying the item being built, order status and type, scheduled and actual dates, and the BOM and route it was created fromworksheet headerproduction
- PurchLinePurchase order line — one row per order line; the core buy-side transaction, joined to its header by PurchIdworksheet lineprocurement
- PurchTablePurchase order header — one row per order carrying vendor, status, and delivery dateworksheet headerprocurement
Tables starting with R
- ReqTransNet requirements — every demand and supply the planning run sees per plan version, with the planned orders and action suggestions it generated; the table behind supply/demand pegging analysistransactionplanning
- RouteRoute operation sequence — one row per operation number on a route, ordering the operations and linking each to the next; operation times live on the related RouteOpr tablemainproduction
- RouteTableRoute header — one row per route identifier with its name and approval state; route versions assign it to items, and Route rows hold its operation sequencemainproduction
- RouteVersionRoute version — the link that assigns a route to a finished item for a validity period, quantity range, and site, mirroring how BOMVersion assigns a BOMmainproduction
Tables starting with S
Tables starting with U
- UnitOfMeasureThe shared unit-of-measure master — one row per unit symbol (kg, ea, hr) with its unit class and system of units; every quantity column in the lake ultimately resolves to a symbol hereSharedproduct
- UnitOfMeasureConversionUnit conversion rules — factor, numerator/denominator, and offsets for converting between two units, referenced by RecId to UnitOfMeasure on both sides; product-specific conversions carry the product's RecId, standard conversions leave it 0Sharedproduct
Tables starting with V
- VendGroupVendor group master — the posting, payment-term, and number-sequence defaults shared by every vendor in the groupgroupprocurement
- VendInvoiceJourPosted vendor invoice header — one row per posted AP invoice, carrying totals, due date, cash-discount terms, and the ledger vouchertransactionprocurement
- VendInvoiceTransPosted vendor invoice line — one row per invoiced line with quantity, price, and the links back to its purchase order and inventory movementstransactionprocurement
- VendPackingSlipJourPosted product receipt (packing slip) header — one row per receipt posted against a purchase order, the record of when goods physically arrivedtransactionprocurement
- VendTableVendor master — one row per vendor account, with the RecId link to its global-address-book partymainprocurement
- VendTransThe vendor transaction ledger — one open-item row per posted AP amount (invoice, payment, credit note), mirroring CustTrans on the payable side; the table AP aging and DPO are built from, companion to the VendInvoiceJour invoice detailtransactionfinance
Tables starting with W
- WHSLoadLineWarehouse load line — one row per order line placed on a load, linking the load and shipment to the source document line, item, and picked quantitiesworksheet linewarehouse
- WHSLoadTableWarehouse load header — one row per load (a truck, trailer, or container worth of goods); shipments are grouped onto loads, and ship confirmation happens at this levelworksheet headerwarehouse
- WHSShipmentTableWarehouse shipment header — one row per shipment built from released order lines, carrying its load, status, carrier, and ship-confirm timestamp; the outbound unit customers trackworksheet headerwarehouse
- WHSWorkLineWarehouse work line — the individual pick and put steps of a work order, with item, location, quantities, and the worker who executed them; the grain for labor and travel analysisworksheet linewarehouse
- WHSWorkTableWarehouse work header — one row per work order (pick, put, count, replenish) created by wave processing, with status, priority, and the load/shipment it servesworksheet headerwarehouse
- WMSLocationWarehouse location (bin) master — one row per storage location within a warehouse, with its aisle/rack/level coordinates, zone, profile, and capacity limitsmaininventory