D365 Reference

EcoResProductTranslationEntity

Product translations — one record per product and language with the localized name and description, keyed by product number

Module: Product Information
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

CDM-confirmed; backing table EcoResProductTranslation declared.

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 : EcoResProductTranslationEntity
-- Purpose: Rebuild EcoResProductTranslationEntity from landed F&O tables — auto-generated from table-entity-map
-- Grain  : EcoResProductTranslation × EcoResProduct — 1:N joins yield one row per line
-- Tables : EcoResProductTranslation, EcoResProduct
-- 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.product AS "RecId of the shared product in EcoResProduct this translation belongs to",
  h.languageid AS "Language code of the translation; product + language is the natural key",
  h.name AS "Product name in this language — the display name most reports actually want",
  h.description AS "Longer product description in this language",
  p.displayproductnumber AS "The product number shown to users; the natural key of the shared product"
FROM <catalog>.<schema>.ecoresproducttranslation h
LEFT JOIN <catalog>.<schema>.ecoresproduct p
  ON p.recid = h.product
ORDER BY h.product;

2 parameters not filled: <catalog>, <schema>

Backing Tables

How these tables connect. Nodes are clickable.

Join details