F0111

-- ============================================================
-- Table  : F0111 Contact (Who's Who) records attached to address book entries: individual names, titles, and contact classifications, keyed by address number and line.
-- Purpose: Column-selected read of F0111 — auto-generated from field metadata
-- Grain  : One row per WWAN8 + WWIDLN
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  f.WWAN8 AS "Address book number the contact belongs to; joins to F0101.",
  f.WWIDLN AS "Line number distinguishing multiple contacts under one address; line 0 mirrors the entity itself.",
  f.WWMLNM AS "Contact's full mailing name.",
  f.WWATTL AS "Job title of the contact.",
  f.WWALPH AS "Alphabetic search name for the contact.",
  f.WWGNNM AS "First (given) name.",
  f.WWMDNM AS "Middle name.",
  f.WWSRNM AS "Last (sur)name.",
  f.WWTYC AS "Who's Who type code classifying the line (billing, shipping, contact, etc.).",
  f.WWMLN1 AS "Secondary mailing name.",
  f.WWALP1 AS "Secondary search name.",
  f.WWNTYP AS "Contact type classification.",
  f.WWNICK AS "Informal or preferred name.",
  f.WWGEND AS "Gender code.",
  f.WWDDATE AS "Day component of birth date.",
  f.WWDMON AS "Month component of birth date.",
  f.WWDYR AS "Year component of birth date.",
  f.WWFUCO AS "Job function classification for the contact.",
  f.WWPCM AS "Preferred way to reach the contact (phone, email, etc.).",
  f.WWPCF AS "Marks which line is the primary contact.",
  f.WWCFRGUID AS "GUID assigned to the contact record for CRM synchronization.",
  f.WWW001 AS "User-defined Who's Who category code 1.",
  f.WWW002 AS "User-defined Who's Who category code 2.",
  f.WWW003 AS "User-defined Who's Who category code 3."
FROM <catalog>.<schema_data>.f0111 f
WHERE
  f.WWAN8 = <AN8>
ORDER BY f.WWAN8;