F0115

-- ============================================================
-- Table  : F0115 Phone numbers for address book entries and their contacts, keyed by address number, Who's Who line, and phone line.
-- Purpose: Column-selected read of F0115 — auto-generated from field metadata
-- Grain  : One row per WPAN8 + WPIDLN + WPCNLN + WPRCK7
-- 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.WPAN8 AS "Address book number the phone belongs to; joins to F0101.",
  f.WPIDLN AS "Who's Who line the phone is attached to; 0 means the entity itself.",
  f.WPCNLN AS "Related-person line identifier within the contact.",
  f.WPRCK7 AS "Sequence number distinguishing multiple phones on the same line.",
  f.WPPHTP AS "Phone type (home, work, fax, mobile, etc.).",
  f.WPAR1 AS "Area/country prefix portion of the number.",
  f.WPPH1 AS "Phone number itself."
FROM <catalog>.<schema_data>.f0115 f
WHERE
  f.WPAN8 = <AN8>
ORDER BY f.WPAN8;