Measures - Purchase Contract Line

This table shows the purchase contract line fact measures:

Measure Mapping Note

Active

1 if purchase contract line status = Active, 0 if Free or Terminated

Agreed Quantity

tdpur301.qoor + tdpur301.qogo

Amount Negative Variance

-1 * Amount Variance if negative, else 0

Amount Negative Variance Ratio

Amount Negative Variance / Expected Amount

Amount Positive Variance

Amount Variance if positive, else 0

Amount Positive Variance Ratio

Amount Positive Variance / Expected Amount

Amount Variance

Total Amount - Expected Amount

Amount Variance Ratio

Amount Variance / Expected Amount

Average Amount

Net Amount / Contract Count Distinct

Buyer Count Distinct

Distinct buyer count

Called Amount

tdpur301.camt + tdpur301.caga

Called Quantity

tdpur301.qicl + tdpur301.qigc

Contract Count Distinct

Distinct count Purchase Contract

Count

Always 1 but 0 for null records

Discount Amount

Gross Amount – Net Amount

Discount Ratio

Discount Amount / Gross Amount

Duration

Expiry Date - Effective Date (in days)

Elapsed Time

Current Date - Effective Date

0 if Current Date <= Effective Date

Contract Duration if Current Date >= Expiry Date

Expected Amount

Net Amount * Expected Ratio

Expected Quantity

Agreed qty * Expected Ratio

Expected Ratio

Elapsed Time/Contract Duration

Extended

1 if Expiry Date was changed to a later date, else 0

Free

1 if purchase contract line status = Free, 0 if Active or Terminated

Gross Amount

Agreed Quantity * Price. Calculated in LN matching field in session tdpur3600m000.

Gross Price

Gross Amount / Agreed Quantity

Invoice Price

Invoiced Amount / Invoiced Quantity

Invoiced Amount

tdpur301.bamt + tdpur301.iaga

Invoiced Quantity

tdpur301.qiiv + tdpur301.qigi

Item Count Distinct

Distinct item count

Net Amount

Gross Amount – Discounts. Calculated in LN matching field in session tdpur3600m000.

Net Amount Ratio

Net Amount / Gross Amount

Net Price

Net Amount / Agreed Quantity

New Item

1 if no contract lines exist for the Item in the quarter before the effective date. (1)

New Item Ratio

New Item Contract / Purchase Contract Line Count

New Supplier

1 if no contract lines exist for the Buy-from BP in the quarter before the effective date. (1)

New Supplier Ratio

New Supplier Contract / Purchase Contract Line Count

Non Renewal Ratio

Not Renewed / Contract Line Count (aka Lost Contracts)

Not Renewed

1 = Renewal status is Not Renewed

0 = Renewal status is Renewed

Remaining Amount

Net Amount - Total Amount

0 if Total Amount > Net Amount

Remaining Amount Ratio

Remaining Amount / Net Amount

Schedule Adherence: halfway contract means called and invoiced = 50% of agreed qty

Remaining Quantity

Agreed Quantity - Total Quantity

0 if Total Quantity > Agreed Quantity

Remaining Time

Contract Duration - Elapsed Time

Elapsed Time = Current Date - Effective Date

Elapsed Time = 0 if Current Date <= Effective Date

Elapsed Time = Contract Duration if Current Date >= Expiry Date

Remaining Time Ratio

Remaining Time/Contract Duration

Renewal Ratio

Renewed/Contract Line Count

Renewal Time

Expiry date - Contract date of new active contract line

0 if not renewed

Renewed

1 = A newer active contract line exists

0 = No new active contract line exists

Checks if another active contract line exists with the same supplier-item combination and with a later expiry date.

Does not consider the Original Contract field.

Repeat Item

1 - New Item Contract (1)

Repeat Supplier

1 - New Supplier Contract (1)

Result

Total Quantity / Agreed Quantity

Supplier Count Distinct

Distinct supplier count

Terminated

1 if purchase contract line status = Terminated, 0 if Free or Active

Total Amount

Called Amount + Invoiced Amount

Total Quantity

Called Quantity + Invoiced Quantity

Usage Ratio

Total Amount / Net Amount
  • (1) New Supplier, Repeat Supplier, New Item, Repeat Item are based on the effective date on the purchase contract line. If a supplier is new in a specified quarter, then all purchase contract lines in that quarter count as new supplier contracts. After the quarter, purchase contract lines are considered repeat supplier contracts.

    The default bucket is Quarter. This bucket can be changed to Year, Quarter, or Month in user variable LN_usr_ReportNewSupplierBucket.

    For New Item and Repeat Item, the default is Year. This bucket can be changed to Year, Quarter, or Month in user variable LN_usr_ReportNewItemBucket.