Measures
This table shows the purchase order line measures:
Measure | Mapping | Note |
---|---|---|
Actual Throughput Duration | Actual Receipt Date (tdpur401.ddte) - Order Date (tdpur401.odat) | |
Approved Amount | Approved Quantity * Price (tdpur401.pric) | |
Approved Amount Ratio | Approved Amount / Receipt Amount | |
Approved Quantity | tdpur401.qiap | |
Approved Quantity Ratio | Approved Quantity / Received Quantity | |
Back Order Amount | Back Order Quantity * Price (tdpur401.pric) | |
Back Order Line | 1 if Order Line Type (tdpur401.oltp) = Backorder, else 0 | |
Back Order Line Ratio | Back Order Line / Purchase Order Line Count | |
Back Order Quantity | If order line type = Backorder then Ordered Quantity | |
Blocked | 1 if tdpur401.bkyn = yes else 0 | |
Buyer Count Distinct | Distinct buyer count | |
Confirmation Lead Time | Order Confirmation Date - Order Date. 0 if confirmation date is not filled 0 if negative |
|
Confirmed | 1 if Order Confirmed date (tdpur401.ddtf) is filled, else 0 | |
Confirmed Ratio | Confirmed / Purchase Order Line Count | |
Contract Ignored | 1 if Contract Ignored (tdpur401.cnig) = Yes, else 0 | |
Contract Ignored Ratio | Contract Ignored / Purchase Order Line Count | |
Contract Linked | 1 if tdpur401.cono is filled, else 0 | |
Contract Linked Ratio | Contract Linked / Purchase Order Line Count | |
Contract Not Linked | Purchase Order Line Count - Contract Linked | |
Cost Reduction | Cost Target - Net Amount | |
Cost Reduction Ratio | Cost Reduction / Cost Target | |
Cost Target | Ordered Quantity * Target Price If Target Price = 0.0, then average price last year (= sum net amount last year / sum ordered quantity last year for item on purchase order line. Order date in 2020 means compare to prices in 2019). If ordered quantity last year = 0.0, then Net Amount. |
(2) |
Days Overdue | Number of days after the Current Planned Receipt Date. | |
Defect | 1 for Order line with Rejected Quantity > 0. Else, 0. | |
Defect Rate | Rejected Quantity / Received Quantity | |
Discount Amount | Gross Amount - Net Amount | |
Discount Ratio | Discount Amount / Gross Amount | |
Early | 1 if Final Receipt = Yes and Actual Receipt Date is before
Current Planned Receipt Date (tdpur401.ddte < tdpur401.ddtb). 0 if Final Receipt = Yes and Actual Receipt Date is on or after Current Planned Receipt Date (tdpur401.ddte >= tdpur401.ddtb) and Final Receipt = 0. 0 if not received (Final Receipt = No or no Actual Receipt Date: tdpur401.ddte = 0). |
|
Early Ratio | Early / Final Receipt | |
Final Receipt | 1 if Final Receipt = Yes 0 if Final Receipt = No |
|
Gross Amount | Order Amount (tdpur401.oamt) + Order Line Discount Amount (tdpur401.amld) | |
Gross Price | Gross Amount / Ordered Quantity | |
Gross Profit | Standard Cost – Net Amount (positive profit if you purchase below standard cost, negative profit if you purchase above standard cost) |
|
Gross Profit Net Amount Ratio | Gross Profit / Net Amount | |
Gross Profit Standard Cost Ratio | Gross Profit / Standard Cost | |
Invoice Amount | tdpur401.iamt | |
Invoice Amount Ratio | Invoice Amount / Net Amount | |
Invoice Amount Variance | Invoice Amount - Net Amount | |
Invoice Price | Invoice Amount / Invoice Quantity | |
Invoiced Quantity | tdpur401.qiiv | |
Item Count Distinct | Distinct item count | |
Landed Cost Amount | Total landed cost amount from tclct200 Landed Cost Lines | |
Late | 1 if Final Receipt = Yes and Actual Receipt Date is after
Current Planned Receipt Date (tdpur401.ddte > tdpur401.ddtb). 0 if Final Receipt = Yes and Actual Receipt Date is before or on Current Planned Receipt Date (tdpur401.ddte <= tdpur401.ddtb). 0 if not received (Final Receipt = No or no Actual Receipt Date: tdpur401.ddte = 0). |
|
Late Ratio | Late / Final Receipt | |
Line Discount Amount | tdpur401.amld | |
Net Amount | Order Amount (tdpur401.oamt) - Order Discount Amount (tdpur401.amod) | |
Net Amount Ratio | Net Amount / Gross Amount | |
Net Price | Net Amount / Ordered Quantity | |
New Item Purchase | 1 if no purchase order lines exist for the Item (tdpur401.item)
in the year before the End Date 0 otherwise |
(1) |
New Item Purchase Ratio | New Item Purchase / Purchase Order Line Count | (1) |
New Supplier Purchase | 1 if no Purchase order lines exist for the Buy-from BP
(tdpur400.otbp) in the quarter before the End Date 0 otherwise |
(1) |
New Supplier Purchase Ratio | New Supplier Purchase / Purchase Order Line Count | (1) |
Number of Deliveries Done | tdpur401.ddon | |
On Time | 1 if Final Receipt = Yes and Actual Receipt Date is on Current
Planned Receipt Date (same day) (tdpur401.ddte = tdpur401.ddtb). 0 if Final Receipt = Yes and Actual Receipt Date is before or after Current Planned Receipt Date (tdpur401.ddte <> tdpur401.ddtb). 0 if not received (Final Receipt = No or no Actual Receipt Date: tdpur401.ddte = 0). |
|
On Time Ratio | On Time / Final Receipt | |
Open | 1 if Purchase Order Line Status is Open, else 0 (Open means Ordered Quantity > 0 and Received Quantity = 0) |
|
Open Amount | Open quantity * Price (tdpur401.pric) | |
Open Quantity | Received Quantity - Ordered Quantity. Open Quantity = 0 for Received Quantity >= Ordered Quantity Open Quantity = 0 for Ordered Quantity < 0 (returns) |
|
Operation Costs | tdpur401.coop | |
Order Discount Amount | tdpur401.amod | |
Ordered Quantity | tdpur401.qoor, but if Back Order Confirmed (tdpur401.qibo) then Ordered Quantity – Back Order Quantity | |
Partially Received | 1 if Purchase Order Line Status is Partially Received, else 0 (Partially Received means Received Quantity < Ordered Quantity and Received Quantity > 0) |
|
Perfect Order Line | 1 if not late, no shortage, no rejects (Late = 0 and Shortage = 0 and Defect = 0) 0 else |
|
Perfect Order Line Ratio | Perfect Order Line / Purchase Order Line Count | |
Planned Throughput Duration | Current Planned Receipt Date (tdpur401.ddtb) - Order Date (tdpur401.odat) | |
Punctuality | (Early + On Time) / (Early + On Time + Late) | |
Purchase Order Count Distinct | Distinct purchase order count | |
Purchase Order Line Count | Always 1 but 0 for null records | |
Quantity Negative Variance | -1 * Quantity Variance if negative, else 0 | |
Quantity Positive Variance | Quantity Variance if positive else 0 | |
Quantity Ratio | Received Quantity / Ordered Quantity | |
Quantity Variance | Received Quantity – Ordered Quantity | |
Receipt Amount | tdpur401.damt | |
Received | 1 if Purchase Order Line Status is Received, else 0 (Received means Ordered Quantity > 0 and Received Quantity >= Ordered Quantity) |
|
Received Early Days | Current Planned Receipt Date – Actual Receipt Date
(tdpur401.ddtb - tdpur401.ddte) 0 if negative |
|
Received Late Days | Actual Receipt Date - Current Planned Receipt Date
(tdpur401.ddte - tdpur401.ddtb) 0 if negative |
|
Received Quantity | tdpur401.qidl | |
Rejected Amount | Rejected Quantity * Price | |
Rejected Quantity | tdpur401.qirj | |
Repeat Item Purchase | 1 if New Item Purchase = 0 0 if New Item Purchase = 1 |
(1) |
Repeat Supplier Purchase | 1 if New Supplier Purchase = 0 0 if New Supplier Purchase = 1 |
(1) |
Return | 1 if Purchase Order Line Status is Return, else 0 | |
Return Ratio | Return / Purchase Order Line Count | |
Shortage | 1 if Ordered Quantity > 0 and Received Quantity < Ordered
Quantity and Final Receipt = 1 and Back Order Line = 0(Return means Ordered Quantity < 0 or/and amount <
0) Ese 0 |
|
Shortage Ratio | Shortage / Final Receipt | |
Standard Cost | tdpur401.copr | |
Supplier Availability | 1 - Shortage Ratio | |
Supplier Available | 1 if Shortage = 0 (Return means Ordered Quantity 0 if Shortage = 1 |
|
Supplier Count Distinct | Distinct supplier count | |
Target Price | tdpur401.tapr | (2) |
-
(1) New Supplier Purchase and Repeat Supplier Purchase are based on the actual receipt date on the purchase order line (current planned receipt date is used if the purchase order line not received). If a supplier is new in a quarter, then all purchase order lines in that quarter count as new supplier Purchase. After the quarter, purchase order lines are considered repeat supplier Purchase.
The default bucket is Quarter, this bucket can be changed in user variable LN_usr_ReportNewSupplierBucket with choice of Year, Quarter, Month.
For New Item Purchase and Repeat Item Purchase, the default is Year. This bucket can be changed in user variable LN_usr_ReportNewItemBucket again with choice of Year, Quarter, Month.
-
(2) Target Price can be enabled in the Procurement Parameters (tdpur0100m000) session in LN. If not enabled, or the Target Price = 0.0 for another reason, then the average price of last year is used. For the item on the purchase order line, this price is calculated as follows: sum net amount last year / sum ordered quantity last year. Users can choose if last year, last quarter or last month is used.