EcoResProduct

-- ============================================================
-- Table  : EcoResProduct The shared product master — one row per product across all companies; released products in InventTable point back to it by RecId
-- Purpose: Column-selected read of EcoResProduct — auto-generated from field metadata
-- Grain  : One row per DisplayProductNumber
-- 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
  p.displayproductnumber AS "The product number shown to users; the natural key of the shared product",
  p.producttype AS "Whether the product is an item or a service",  -- enum: decode p.producttype via GlobalOptionsetMetadata join — see quirks guide #enums
  p.searchname AS "Searchable short name for the product",
  p.recid AS "The 64-bit surrogate key released products reference by Product",
  p.instancerelationtype AS "Subtype discriminator of the shared product supertype — tells you whether the row is a distinct product or a product master with variants",
  p.servicetype AS "For service products, whether the service is a plain service or a rights/subscription type",  -- enum: decode p.servicetype via GlobalOptionsetMetadata join — see quirks guide #enums
  p.pdscwproduct AS "Whether the product is catch-weight — quantities then carry both a nominal and an actual weight unit",  -- enum: decode p.pdscwproduct via GlobalOptionsetMetadata join — see quirks guide #enums
  p.engchgproductownerid AS "Engineering product owner responsible for change management on the product",
  p.engchgproducttype AS "RecId reference to the engineering product type controlling versioning rules for the product"
FROM <catalog>.<schema>.ecoresproduct p
ORDER BY p.displayproductnumber;