JDE Reference
P0014
InteractivePayment Terms Revisions — define the payment terms (due dates, discounts) applied to vouchers, invoices, and orders
Lineage hook
Rows written by P0014 carry …PID = 'P0014' in their audit columns — a ready-made marker for isolating the records this program produced. See the audit-columns guide
Boilerplate SQL
Databricks SQLStarting 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
2 parameters not filled: <catalog>, <schema_data>
-- ============================================================
-- Program: P0014 Payment Terms Revisions — define the payment terms (due dates, discounts) applied to vouchers, invoices, and orders
-- Purpose: Payment Terms Revisions — define the payment terms (due dates, discounts) applied to vouchers, invoices, and orders — auto-generated boilerplate from program-table-map
-- Grain : One row per F0014
-- Tables : F0014
-- 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.PNPTC AS "Payment terms code referenced by customers, suppliers, invoices, and vouchers."
FROM <catalog>.<schema_data>.f0014 h
ORDER BY h.PNPTC;Tables Used by This Program
R read · W write · R/W read + write