R4981

-- ============================================================
-- Program: R4981 Freight Update and Report — the batch job that finalizes freight after delivery confirmation: writes freight audit history, books payable freight accruals/vouchers, and adds billable freight charges to the customer's order
-- Purpose: Freight Update and Report — the batch job that finalizes freight after delivery confirmation: writes freight audit history, books payable freight accruals/vouchers, and adds billable freight charges to the customer's order — auto-generated boilerplate from program-table-map
-- Grain  : F4981 × F0411 — 1:N joins yield one row per detail line
-- Tables : F4981, F0411
-- Notes  : Auto-generated skeleton. Julian dates are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210). 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.
-- Omitted: F4215, F4211, F0911 are cataloged for this program, but no verified join condition connects them to F4981, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.FHUK01 AS "Internal unique key - the physical primary key of this table.",
  f04.RPKCO AS "Document company that owns the voucher number sequence",
  f04.RPDCT AS "Voucher document type (PV standard voucher, PD debit memo, PL logged, etc.)",
  f04.RPSFX AS "Pay item — vouchers split into pay items with independent terms and status",
  f04.RPSFXE AS "Pay item extension used by prepayments and multi-tax-rate splits"
FROM <catalog>.<schema_data>.f4981 h
LEFT JOIN <catalog>.<schema_data>.f0411 f04
  ON f04.RPDOC = h.FHDOC
ORDER BY h.FHUK01;