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 Infor Data Lake-landed M3 data. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); status ladders decoded inline where verified. 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"
FROM <catalog>.<schema>.OCUSMA c
WHERE
  c.OKCONO = <company>
  -- AND c.OKCUNO = '<CUNO>'
ORDER BY c.OKCUNO;