VendGroup

-- ============================================================
-- Table  : VendGroup Vendor group master — the posting, payment-term, and number-sequence defaults shared by every vendor in the group
-- Purpose: Column-selected read of VendGroup — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + VendGroup
-- 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
  v.vendgroup AS "The vendor group code — the natural key",
  v.name AS "Group description",
  v.paymtermid AS "Default terms of payment for vendors in the group",
  v.clearingperiod AS "Default payment clearing period for the group",
  v.taxgroupid AS "Default sales tax group for the group",
  v.vendaccountnumseq AS "RecId of the number sequence new vendor accounts in the group are drawn from"
FROM <catalog>.<schema>.vendgroup v
WHERE
  v.dataareaid = '<company>'
ORDER BY v.vendgroup;