CustGroup

-- ============================================================
-- Table  : CustGroup Customer group master — one row per posting/reporting group of customers, carrying default payment terms and the settle-period used to derive due dates
-- Purpose: Column-selected read of CustGroup — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + CustGroup
-- 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
  c.custgroup AS "The customer group code — the natural key CustTable.CustGroup joins on",
  c.name AS "Descriptive name of the customer group",
  c.paymtermid AS "Default terms of payment applied to customers in the group",
  c.clearingperiod AS "Terms of payment used to suggest the settle period for payments from customers in the group",
  c.taxgroupid AS "Default sales tax group for customers in the group",
  c.priceincludesalestax AS "Whether prices for the group are entered inclusive of sales tax",  -- enum: decode c.priceincludesalestax via GlobalOptionsetMetadata join — see quirks guide #enums
  c.defaultdimension AS "RecId of the group's default financial-dimension value set in DimensionAttributeValueSet"
FROM <catalog>.<schema>.custgroup c
-- Resolve DimensionAttributeValueSet (via DefaultDimension): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.dimensionattributevalueset dim ON dim.recid = c.defaultdimension
WHERE
  c.dataareaid = '<company>'
ORDER BY c.custgroup;