F0101

-- ============================================================
-- Table  : F0101 Address book master — the shared registry of customers, suppliers, employees, and other entities
-- Purpose: Column-selected read of F0101 — auto-generated from field metadata
-- Grain  : One row per ABAN8
-- 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
  ab.ABAN8 AS "Address book number - the master key for any entity",
  ab.ABALKY AS "Long address - a user-defined alternate key",
  ab.ABTAX AS "Tax ID (EIN, VAT, etc.)",
  ab.ABALPH AS "Alpha name - the entity display name",
  ab.ABDC AS "Compressed name used for word search (no blanks/specials)",
  TRIM(ab.ABMCU) AS "Responsible business unit (right-justified, space-padded)",
  ab.ABSIC AS "Standard industry classification code",
  ab.ABLNGP AS "Preferred language for documents",
  ab.ABAT1 AS "Search type - classifies the entity (C customer, V supplier, E employee, ...)",
  ab.ABCM AS "Credit message shown during order/invoice entry",
  ab.ABTAXC AS "Person/corporation code for 1099 and tax reporting",
  ab.ABSBLI AS "Subledger inactive code - non-blank blocks use as a subledger",
  CASE WHEN ab.ABEFTB IS NULL OR ab.ABEFTB = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(ab.ABEFTB AS INT) DIV 1000, 1, 1), CAST(ab.ABEFTB AS INT) % 1000 - 1) END AS "Effective start date of the record",  -- CYYDDD Julian → DATE
  ab.ABAN81 AS "Related address number 1",
  ab.ABAN82 AS "Related address number 2",
  ab.ABAN83 AS "Related address number 3",
  ab.ABAN84 AS "Related address number 4",
  ab.ABAN85 AS "Factor / special payee address number",
  ab.ABAN86 AS "Related address number 5",
  ab.ABAC01 AS "Address book category code 01",
  ab.ABAC02 AS "Address book category code 02",
  ab.ABAC03 AS "Address book category code 03",
  ab.ABAC04 AS "Address book category code 04",
  ab.ABAC05 AS "Address book category code 05",
  ab.ABAC06 AS "Address book category code 06",
  ab.ABAC07 AS "Address book category code 07",
  ab.ABAC08 AS "Address book category code 08",
  ab.ABAC09 AS "Address book category code 09",
  ab.ABAC10 AS "Address book category code 10",
  ab.ABRMK AS "Free-text remark",
  ab.ABTXCT AS "Tax exemption certificate number",
  ab.ABTX2 AS "Additional individual tax ID",
  ab.ABALP1 AS "Secondary alpha name",
  ab.ABDUNS AS "Dun & Bradstreet DUNS number",
  ab.ABNOE AS "Number of employees (company records)"
FROM <catalog>.<schema_data>.f0101 ab
WHERE
  ab.ABAN8 = <AN8>
ORDER BY ab.ABAN8;