P4071

-- ============================================================
-- Program: P4071 Price Adjustment Definitions — the screen where advanced pricing adjustments are defined: adjustment name, controls, target application, and preference hierarchy.
-- Purpose: Price Adjustment Definitions — the screen where advanced pricing adjustments are defined: adjustment name, controls, target application, and preference hierarchy. — auto-generated boilerplate from program-table-map
-- Grain  : One row per F4071
-- Tables : F4071
-- 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: F4092 is cataloged for this program, but no verified join condition connects it to F4071, so it is left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.ATAST AS "Adjustment name — the identifier every F4072 rate row and F4074 ledger row points back to."
FROM <catalog>.<schema_data>.f4071 h
ORDER BY h.ATAST;