F01151

-- ============================================================
-- Table  : F01151 Email and other electronic addresses (URLs, EDI endpoints) for address book entries and contacts, one row per address line.
-- Purpose: Column-selected read of F01151 — auto-generated from field metadata
-- Grain  : One row per EAAN8 + EAIDLN + EARCK7
-- 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.EAAN8 AS "Address book number the electronic address belongs to; joins to F0101.",
  f.EAIDLN AS "Who's Who line the address is attached to; 0 means the entity itself.",
  f.EARCK7 AS "Sequence number distinguishing multiple electronic addresses per line.",
  f.EAETP AS "Kind of electronic address (email, internet URL, etc.).",
  f.EAEMAL AS "The email address or URL value.",
  f.EAEHIER AS "Messaging hierarchy indicator controlling workflow delivery.",
  f.EAEFOR AS "Preferred message format for this address.",
  f.EAECLASS AS "Category classifying the electronic address."
FROM <catalog>.<schema_data>.f01151 f
WHERE
  f.EAAN8 = <AN8>
ORDER BY f.EAAN8;