DirPartyTable

-- ============================================================
-- Table  : DirPartyTable The global address book party master — the shared registry behind every customer, vendor, and organization; referenced by RecId, no company partition
-- Purpose: Column-selected read of DirPartyTable — auto-generated from field metadata
-- Grain  : One row per PartyNumber
-- 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
  dp.partynumber AS "The global-address-book party number",
  dp.name AS "Party name — the display name behind customers, vendors, and organizations",
  dp.namealias AS "Search alias for the party",
  dp.recid AS "The 64-bit surrogate key masters like CustTable.Party join to",
  dp.knownas AS "Informal name the party is known as",
  dp.instancerelationtype AS "The party-type discriminator (labeled ""Party type"" in the client) — identifies whether the row is a person, organization, or other party subtype",
  dp.languageid AS "Preferred language of the party",
  dp.primarycontactemail AS "RecId of the party's primary email record in the electronic-address table — a pointer, not the address text itself",
  dp.primarycontactphone AS "RecId of the party's primary phone record in the electronic-address table — a pointer, not the number itself",
  dp.primarycontacturl AS "RecId of the party's primary URL record in the electronic-address table — a pointer, not the URL text itself",
  dp.primaryaddresslocation AS "RecId of the party's primary address location record",
  dp.addressbooknames AS "Names of the address books the party is assigned to, stored as display text"
FROM <catalog>.<schema>.dirpartytable dp
ORDER BY dp.partynumber;