OCUSMA

-- ============================================================
-- Table  : OCUSMA — The customer master — one row per customer per company, with name and address, country, currency, and the default payment, delivery, and sales-rep terms new orders inherit
-- Purpose: Column-selected read of OCUSMA — auto-generated from field metadata
-- Grain  : One row per company (CONO) + OKCUNO
-- Notes  : Auto-generated skeleton for a prefixed physical M3 schema or a landing schema normalized to the prefixed names in this catalog. Raw Data Lake property names vary with the published object: map them through Data Catalog before running this SQL. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); all curated status values are decoded inline. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
  c.OKCONO AS "Company",
  c.OKCUNO AS "Customer number — the natural key order headers join on",
  c.OKSTAT AS "Customer status — whether the customer is active for new business",  -- status: decode c.OKSTAT against your configuration — see quirks guide #statuses
  c.OKCUNM AS "Customer name",
  c.OKCUA1 AS "Customer address, first line",
  c.OKTOWN AS "City",
  c.OKCSCD AS "Country code",
  c.OKCUCD AS "Currency the customer trades in",
  c.OKTEPY AS "Payment terms new orders and invoices inherit",
  c.OKTEDL AS "Delivery terms new orders inherit",
  c.OKMODL AS "Delivery method new orders inherit",
  c.OKSMCD AS "Salesperson responsible for the customer",
  c.OKECAR AS "Area, state, or province within the customer's country — the geographic slice for regional sales analytics",
  c.OKPONO AS "Postal code",
  c.OKPHNO AS "Telephone number"
FROM <catalog>.<schema>.OCUSMA c
WHERE
  c.OKCONO = <company>
  -- AND c.OKCUNO = '<CUNO>'
ORDER BY c.OKCUNO;