JDE Reference

P4071

Interactive

Price Adjustment Definitions — the screen where advanced pricing adjustments are defined: adjustment name, controls, target application, and preference hierarchy.

Module: 45 · Advanced Pricing
Lineage hook

Rows written by P4071 carry …PID = 'P4071' in their audit columns — a ready-made marker for isolating the records this program produced. See the audit-columns guide →

Notes

Verified via form IDs W4071A/W4071C on the 9.2 Advanced Pricing guide.

Boilerplate SQL

Databricks SQL

Starting point for querying the tables behind this program. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.

Query parameters
-- ============================================================
-- 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  : F4071 × F4092 — 1:N joins yield one row per detail line
-- Tables : F4071, F4092
-- 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.
-- ============================================================
SELECT
  h.ATAST AS "Adjustment name — the identifier every F4072 rate row and F4074 ledger row points back to.",
  f.GPGPTY AS "Group type: whether this definition is an item, customer, or order detail group.",
  f.GPGPC AS "Group code — the price group name referenced by F4071 adjustments and item/customer masters."
FROM <catalog>.<schema_data>.f4071 h
LEFT JOIN <catalog>.<schema_data>.f4092 f
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
ORDER BY h.ATAST;

2 parameters not filled: <catalog>, <schema_data>

Tables Used by This Program