InventTableModule

-- ============================================================
-- Table  : InventTableModule Per-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 company
-- Purpose: Column-selected read of InventTableModule — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + ItemId + ModuleType
-- 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
  i.itemid AS "The item number the module settings apply to — the join back to InventTable",
  CASE i.moduletype WHEN 0 THEN 'Inventory' WHEN 1 THEN 'Purchase order' WHEN 2 THEN 'Sales order' ELSE CAST(i.moduletype AS STRING) END AS "Which module this row's settings belong to — 0 inventory, 1 purchase, 2 sales; the column every query over this table pivots on",  -- enum: ModuleInventPurchSales
  i.unitid AS "Default unit of measure the module transacts the item in — the sales unit on the sales row, the purchase unit on the purchase row",
  i.price AS "Base price for the module — the sales list price on the sales row, the standard purchase price on the purchase row; it is the price for PriceUnit units, not for one",
  i.priceunit AS "Number of units Price is quoted for; unit price is Price / PriceUnit, and skipping the division is the classic costing error on this table",
  i.priceqty AS "Quantity the fixed charges in Markup are spread across",
  CASE WHEN CAST(i.pricedate AS DATE) = DATE '1900-01-01' THEN NULL ELSE CAST(i.pricedate AS DATE) END AS "Date the module's price was last changed; never-priced rows carry the 1900-01-01 sentinel",  -- 1900-01-01 sentinel → NULL
  i.markup AS "Fixed charges added to the price once per invoice, on top of Price",
  i.overdeliverypct AS "Percentage above the ordered quantity that may still be received or delivered — the tolerance behind over-receipt analysis",
  i.underdeliverypct AS "Percentage below the ordered quantity that still counts as complete — the tolerance behind short-ship and fill-rate analysis",
  i.taxitemgroupid AS "Item sales tax group applied to the item in this module; sales and purchase rows commonly differ",
  i.linedisc AS "Line discount group the item belongs to for this module's price agreements",
  i.multilinedisc AS "Multiline discount group the item belongs to — the grouping that qualifies several lines together for a volume break"
FROM <catalog>.<schema>.inventtablemodule i
WHERE
  i.dataareaid = '<company>'
  -- AND i.itemid = '<ItemId>'
ORDER BY i.itemid;