F4074

-- ============================================================
-- Table  : F4074 Price adjustment ledger - the pricing history behind each order line, one row per adjustment applied by Advanced Pricing
-- Purpose: Column-selected read of F4074 — auto-generated from field metadata
-- Grain  : One row per ALDOCO + ALDCTO + ALKCOO + ALSFXO + ALLNID + ALAKID + ALSRCFD + ALOSEQ + ALSUBSEQ + ALTIER + ALPA04
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. 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
  f.ALDOCO AS "Order number",
  f.ALDCTO AS "Order document type (e.g. OP purchase order, SO sales order)",
  f.ALKCOO AS "Company that owns the order-number sequence; part of the composite order key",
  f.ALSFXO AS "Order suffix distinguishing multiple documents under one order number",
  f.ALLNID / POWER(10, 3) AS "Order line number (3 implied decimals, e.g. 1.000)",  -- implied decimals: 3 (verify in F9210)
  f.ALAKID AS "Alternate key tying the adjustment to its source transaction",
  f.ALSRCFD AS "Source of the alternate key (which application wrote the row)",
  f.ALOSEQ AS "Sequence of the adjustment within the schedule",
  f.ALSUBSEQ AS "Sub-sequence when one adjustment level produces multiple rows",
  f.ALTIER AS "Quantity-break tier the line qualified for",
  f.ALPA04 AS "Target application flag (sales vs procurement pricing)",
  f.ALASN AS "Price and adjustment schedule",
  f.ALAST AS "Price adjustment name that generated this row",
  f.ALITM AS "Short internal item number - joins to F4101/F4102",
  f.ALAN8 AS "Customer or supplier address number the price was resolved for",
  f.ALCRCD AS "Transaction currency code",
  f.ALUOM AS "Transaction unit of measure",
  f.ALMNQ AS "From-quantity threshold of the price break applied",
  f.ALLEDG AS "Cost method used as the pricing basis",
  f.ALFRMN AS "Price formula applied, if formula-based",
  f.ALBSCD AS "Basis code - how the adjustment computes (percent, amount, formula, cost-plus)",
  f.ALFVTR / POWER(10, 4) AS "Factor value - the percent, amount, or multiplier applied",  -- implied decimals: 4 (verify in F9210)
  f.ALABAS AS "Flag: this adjustment overrides the base price",
  f.ALUPRC / POWER(10, 4) AS "Resulting unit price after the adjustment (4 implied decimals)",  -- implied decimals: 4 (verify in F9210)
  f.ALFUP / POWER(10, 4) AS "Unit price in foreign (transaction) currency",  -- implied decimals: 4 (verify in F9210)
  f.ALGLC AS "G/L offset class used to derive distribution accounts",
  f.ALARSN AS "Adjustment reason code",
  f.ALACNT AS "Adjustment control code (print/accrue behavior)",
  f.ALMDED AS "Flag: adjustment was manually added or changed",
  f.ALPROV AS "Price override flag",
  f.ALATID AS "Internal key of the adjustment detail definition",
  f.ALIGID AS "Item group key the price was resolved from",
  f.ALCGID AS "Customer group key the price was resolved from",
  f.ALOGID AS "Order group key the price was resolved from",
  f.ALBSDVAL / POWER(10, 4) AS "Value the adjustment calculation was based on",  -- implied decimals: 4 (verify in F9210)
  f.ALOLVL AS "Level the adjustment applies at (line, basket, or order)",
  f.ALADJSTS AS "Adjustment status",
  f.ALPMTN AS "Promotion ID tied to the adjustment",
  f.ALNBRORD AS "Order count used for volume-incentive accumulation"
FROM <catalog>.<schema_data>.f4074 f
WHERE
  f.ALDOCO = <DOCO>
  -- AND f.ALDCTO = '<DCTO>'
  -- AND f.ALKCOO = '<KCOO>'
ORDER BY f.ALDOCO;