Calculated Fields

The Billing Contracts dataset includes calculated fields derived from the Company, Contract, Contract Line Item, Opportunity and Account objects in Accounting and Billing Central as well as other associated objects. These fields are:

Calculated Fields

Field

Description

Churn The value of contracts lost between a range of dates. For more information, see the KPIs Table.
Contract Adjustments (Replacements) The value of the corrections to contracts that have had a change request created by the "Replacement" opportunity type. For more information, see the KPIs Table.
Contract Adjustments For contract lines on replacement contracts. For more information, see the KPIs Table.
Contract Adjustments Replaced This displays the negative Monthly Recurring Revenue (MRR) of a contract line item on a contract which is replaced by another contract.
Contract Adjustments Replacement This displays the MRR of a contract line item on a replacement contract.
Downsell The value of contracts which have decreased in value, by additional licenses or products, between a range of dates. For more information, see the KPIs Table.
Net New The value of contracts won between a range of dates. For more information, see the KPIs table.
Next Contract Line Item End Date The end date of the next contract line item.
Next Contract Line Item ID The identification number of the next contract line item.
Next Contract Line Item Name The name of the next contract line item.
Next Contract Line Item Start Date The start date of the next contract line item.
Next Contract Line Item Total Contract Line Value The total contract line value of the next contract line item.
Next Opportunity ID The identification number of the next opportunity associated with a contract.
Next Opportunity Name The name of he next opportunity.
Next Opportunity Type The type of next opportunity.
Previous Contract Line Item Annual Recurring Revenue The annual recurring revenue (ARR) for the previous contract line item.
Previous Contract Line Item Billing Type The billing type for the previous contract line item.
Previous Contract Line Item Contract ID The identification number of the previous contract line item.
Previous Contract Line Item Contract Status The contract status of the previous contract line item.
Previous Contract Line Item End Date The end date of the previous contract line item.
Previous Contract Line Item ID The identification number of the previous contract line item.
Previous Contract Line Item Monthly Recurring Revenue The MRR for the previous contract line item.
Previous Contract Line Item Name The name of the previous contract line item.
Previous Contract Line Item Quantity The quantity of the previous contract line item.
Previous Contract Line Item Sales Price The sales price of the previous contract line item.
Previous Contract Line Item Start Date The start date of the previous contract line item.
Previous Contract Line Item Total Contract Line Value The total contract line value of the previous contract line item.
Previous Contract Line Item Unit Price The unit price of the previous contract line item.
Previous Opportunity ID The identification number of the previous opportunity.
Previous Opportunity Name The previous opportunity name.
Renewed Contract Line Item End Date This stores the end date of a contract line item on a previous contract, when this contract line item is a renewal. For example: Contract line item 1 ends on January 1, 2017. Contract line item 2 is the renewal line, and so has a renewed contract line item end date of January 1, 2017.
Replacement Start Date The day after the end date for contract line items that have been replaced or are otherwise null.
Total Previous Monthly Recurring Revenue Combines the MRR value of contract lines if these are contract lines for the same product on an upgraded contract, which are then merged into one line on a renewal contract. It is used to calculate the MRR value of the Upsell and Down Sell KPIs.
Unaccounted Error The difference between the end date of a previous contract line item and the start date of the new contract line item on the contract renewal. For more information, see the KPIs Table.
Upsell The value of contracts which have increased in value, by additional licenses or products, between a range of dates. For more information, see the KPIs Table.