D365 Reference
Product Information
Supply chainThe shared product master and its released-product records, dimensions groups, and units of measure that every inventory and order table points back to
11 tables7 entities
Tables
Main · 7
- EcoResProductThe shared product master — one row per product across all companies; released products in InventTable point back to it by RecIdSharedmain
- 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 inSharedmain
- 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 partitionSharedmain
- 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 columnsSharedmain
- 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 heremain
- 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 hereShared
- 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 0Shared
Group · 4
- 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 appliesSharedgroup
- 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 capturedSharedgroup
- InventItemGroupItem group master — one row per company and item group, the reporting and posting bucket items are assigned to via InventItemGroupItemgroup
- 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 allgroup
Data Entities
- EcoResProductTranslationEntityProduct translations — one record per product and language with the localized name and description, keyed by product number
- EcoResProductV2EntityProducts — the shared product master export (displayed as 'Products V2'), carrying product type, dimension-group assignments, and translated name and description
- EcoResReleasedProductV2EntityReleased products — the item master joined to its shared product, the standard export for item attributesReleasedProductsV2
- EcoResStorageDimensionGroupEntityStorage dimension groups — the shared site/warehouse/location activation setup, one record per group
- EcoResTrackingDimensionGroupEntityTracking dimension groups — the shared batch/serial activation setup, one record per group
- UnitOfMeasureConversionEntityUnit conversions — conversion factors between units, with the from/to unit symbols resolved; product-specific conversions are exported separately
- UnitOfMeasureEntityUnits — the unit-of-measure master export (displayed as 'Units'), one record per unit symbol with class, system of units, and precision