EcoResProductTranslation

-- ============================================================
-- Table  : EcoResProductTranslation Language-specific product names and descriptions — one row per shared product and language, joined back to EcoResProduct by RecId; the table product names actually live in
-- Purpose: Column-selected read of EcoResProductTranslation — auto-generated from field metadata
-- Grain  : One row per Product + LanguageId
-- 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. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
  e.product AS "RecId of the shared product in EcoResProduct this translation belongs to",
  e.languageid AS "Language code of the translation; product + language is the natural key",
  e.name AS "Product name in this language — the display name most reports actually want",
  e.description AS "Longer product description in this language"
FROM <catalog>.<schema>.ecoresproducttranslation e
-- Resolve EcoResProduct (via Product): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.ecoresproduct eco ON eco.recid = e.product
ORDER BY e.product;