OIS180

-- ============================================================
-- Program: OIS180 — Customer order invoice print — invoices delivered orders into ODHEAD/ODLINE, and where the invoice date and the accounting date part ways in order-to-cash
-- Purpose: Read the tables behind program OIS180 — auto-generated from program-table-map
-- Grain  : ODHEAD × ODLINE — 1:N joins yield one row per line
-- Tables : ODHEAD, ODLINE
-- 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; company-partitioned tables are joined on CONO to prevent cross-company fan-out. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
  h.UACONO AS "Company",
  h.UAORNO AS "Customer order number",
  h.UADLIX AS "Delivery index the invoiced delivery corresponds to",
  h.UATEPY AS "Payment terms — part of the key, so one delivery can settle under more than one term",
  o.UBPONR AS "Order line number",
  o.UBPOSX AS "Line suffix",
  o.UBITNO AS "Item invoiced",
  o.UBIVQT AS "Invoiced quantity on this delivery line"
FROM <catalog>.<schema>.ODHEAD h
LEFT JOIN <catalog>.<schema>.ODLINE o
  ON o.UBORNO = h.UAORNO
 AND o.UBDLIX = h.UADLIX
 AND o.UBTEPY = h.UATEPY
 AND o.UBCONO = h.UACONO
WHERE
  h.UACONO = <company>
ORDER BY h.UAORNO;