CustTable

-- ============================================================
-- Table  : CustTable Customer master — one row per customer account, with the RecId links to its global-address-book party and its default financial dimensions
-- Purpose: Column-selected read of CustTable — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + AccountNum
-- 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.accountnum AS "The customer account number — the natural key",
  c.party AS "RecId of the global-address-book party in DirPartyTable this customer resolves to for its name",
  c.defaultdimension AS "RecId of the customer's default financial-dimension value set in DimensionAttributeValueSet",
  c.custgroup AS "Customer group for posting and reporting",
  c.invoiceaccount AS "Account invoices for this customer are billed to",
  c.currency AS "Default transaction currency for the customer",
  c.paymtermid AS "Terms of payment for the customer",
  c.paymmode AS "Default method of payment for the customer",
  c.cashdisc AS "Cash discount code for early payment",
  c.creditmax AS "Credit limit for the customer in the company currency (0 = no limit set)",
  c.creditrating AS "Free-text credit rating note for the customer",
  c.blocked AS "Whether and how the customer is blocked (all transactions, invoicing and delivery, never…)",  -- enum: decode c.blocked via GlobalOptionsetMetadata join — see quirks guide #enums
  c.dlvmode AS "Default mode of delivery for the customer",
  c.dlvterm AS "Default terms of delivery for the customer",
  c.taxgroup AS "Default sales tax group for the customer",
  c.vatnum AS "The customer's tax-exempt / VAT registration number",
  c.salesgroup AS "Default commission sales group for the customer",
  c.salespoolid AS "Default sales pool orders for the customer are grouped into",
  c.pricegroup AS "Sales price group determining which trade agreements apply",
  c.linedisc AS "Line discount group for the customer",
  c.multilinedisc AS "Multiline discount group for the customer",
  c.enddisc AS "Total (end) discount group for the customer",
  c.markupgroup AS "Charges group applied to the customer's orders",
  c.incltax AS "Whether prices for the customer include sales tax",  -- enum: decode c.incltax via GlobalOptionsetMetadata join — see quirks guide #enums
  c.invoiceaddress AS "Which address (invoice account's or order account's) prints on invoices",  -- enum: decode c.invoiceaddress via GlobalOptionsetMetadata join — see quirks guide #enums
  c.statisticsgroup AS "Statistics group for customer reporting"
FROM <catalog>.<schema>.custtable c
-- Resolve DirPartyTable (via Party): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.dirpartytable dir ON dir.recid = c.party
-- 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>'
  -- AND c.accountnum = '<CustAccount>'
ORDER BY c.accountnum;