CompanyInfo

-- ============================================================
-- Table  : CompanyInfo The legal-entity master — one row per company, carrying its DataArea code and registration and tax numbers; the company name and party details live on its DirPartyTable base record
-- Purpose: Column-selected read of CompanyInfo — auto-generated from field metadata
-- Grain  : One row per DataArea
-- 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.dataarea AS "The company code this legal entity owns — the natural join to DataArea and to every table's dataareaid",
  c.regnum AS "Company registration number",
  c.vatnum AS "Tax-registration (VAT) number",
  c.isconsolidationcompany AS "Whether the company exists only to receive consolidations — exclude from operational reporting",  -- enum: decode c.isconsolidationcompany via GlobalOptionsetMetadata join — see quirks guide #enums
  c.iseliminationcompany AS "Whether the company is an elimination company used in consolidation processing"  -- enum: decode c.iseliminationcompany via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.companyinfo c
-- Base-table fields: Name, PartyNumber, LanguageId are inherited from DirPartyTable —
-- a derived table's export lands only its own fields, so they are NOT in companyinfo
-- (see the extraction guide). Sync dirpartytable too, then uncomment (rows share recid):
-- LEFT JOIN <catalog>.<schema>.dirpartytable dp ON dp.recid = c.recid
ORDER BY c.dataarea;