ODLINE

-- ============================================================
-- Table  : ODLINE — The invoiced-delivery line — one row per invoiced order line per delivery, with the invoiced quantity and price; the revenue-at-line grain of order-to-cash analytics, joined to its header by ORNO + DLIX + payment term
-- Purpose: Column-selected read of ODLINE — auto-generated from field metadata
-- Grain  : One row per company (CONO) + UBORNO + UBPONR + UBPOSX + UBDLIX + UBTEPY
-- 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
  o.UBCONO AS "Company",
  o.UBORNO AS "Customer order number",
  o.UBPONR AS "Order line number",
  o.UBPOSX AS "Line suffix",
  o.UBDLIX AS "Delivery index the line was invoiced under",
  o.UBTEPY AS "Payment terms — part of the key, mirroring the header",
  o.UBITNO AS "Item invoiced",
  o.UBIVQT AS "Invoiced quantity on this delivery line",
  o.UBSAPR AS "Sales price the line was invoiced at"
FROM <catalog>.<schema>.ODLINE o
WHERE
  o.UBCONO = <company>
  -- AND o.UBORNO = '<ORNO>'
ORDER BY o.UBORNO;