Measures - Sales Contract Line

This table shows the sales contract line fact measures:


Measure	Mapping	Note
Active	1 if sales contract line status = Active, 0 if Free or Terminated
Agreed Quantity	tdsls301.qoor
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 / Sales Contract Line Contract Count Distinct
Called Amount	tdsls301.camt
Called Quantity	tdsls301.qicl
Contract Count Distinct	Distinct count Sales Contract
Count	Always 1 but 0 for null records
Customer Count Distinct	Distinct customer count
Discount Amount	Gross Amount – Net Amount
Called Quantity	tdsls301.qicl
Contract Count Distinct	Distinct count Sales Contract
Count	Always 1 but 0 for null records
Customer Count Distinct	Distinct customer count
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
External Sales Rep Count Distinct	Distinct external sales rep count
Free	1 if sales contract line status = Free, 0 if Active or Terminated
Gross Amount	Agreed Quantity * Price. Calculated in LN matching field in session tdsls3501m000.
Gross Price	Gross Amount / Ordered Quantity
Invoice Price	Invoiced Amount / Invoiced Quantity
Invoiced Amount	tdsls301.bamt
Invoiced Quantity	tdsls301.qiiv
Item Count Distinct	Distinct item count
Net Amount	Gross Amount – Discounts based on the Discount Arrays. Calculated in LN, matching field in session tdsls3501m000.
Net Amount Ratio	Net Amount / Gross Amount
Net Price	Net Amount / Ordered Quantity
New Customer	1 if no contract lines exist for the Sold-to BP in the quarter before the effective date.	(1)
New Customer Ratio	New Customer Contract / Sales Contract Line Count	(1)
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 / Sales Contract Line Count	(1)
Non Renewal Ratio	Not Renewed / Contract Line Count (aka Lost Contracts)
Not Renewed	1 = Renewal status is Not Renewed 0 = Renewal status is Renewed
Price	Gross Amount / Agreed Quantity
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 Customer-Item combination and with a later expiry date. Does not consider field Original Contract.
Repeat Customer	1 - New Customer Contract	(1)
Repeat Item	1 - New Item Contract	(1)
Result	Total Quantity / Agreed Quantity
Terminated	1 if sales 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 Customer, Repeat Customer, New Item, Repeat Item are based on the effective date on the sales contract line. If a customer is new in a specified quarter, then all sales contract lines in that quarter count as new customer contracts. After the quarter, sales contract lines are considered repeat customer contracts.
The default bucket is Quarter. This bucket can be changed to Year, Quarter, or Month in user variable LN_usr_ReportNewCustomerBucket. For New Item Sales and Repeat Item Sales, the default is Year. This bucket can be changed to Year, Quarter, or Month in user variable LN_usr_ReportNewItemBucket.