Billing Contracts Dataset Output Fields

Billing Contracts Fields
Field		Description
Account Base Date 1		The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.
Account Base Date 2		The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.
Account Base Date 3		The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.
Account Base Date 4		The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.
Account Billing City		The city portion of the account billing address.
Account Billing Country		The country portion of the account billing address.
Account Billing State		The state portion of the account billing address.
Account Contact Email		The contact email specified for the account.
Account Contact Name		The account contact name.
Account Contact Phone		The phone number of the account contact.
Account Credit Limit Value		The credit limit for the account in the account currency.
Account Credit Status		The current credit status for this account
Account Days Offset 1 Value		The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.
Account Days Offset 2 Value		The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.
Account Days Offset 3 Value		The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.
Account Days Offset 4 Value		The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.
Account Finance Contact		The contact associated with the account to which mass email messages, such as remittances and reminder letters are sent.
Account ID		The identification number of the account.
Account Industry		The industry sector to which the account belongs.
Account Name		The name of the account.
Account Payment Method		The payment method for the vendor account.
Account Phone		The primary phone number of the account.
Account Type		The type of account. For example: customer, competitor or partner.
Account User Name		The user name of the account.
Account Website		The URL of the account website.
ARR Churn	C	The value of MRR Churn multiplied by 12.
ARR Contract Adjustments Replaced	C	The value of MRR Contract Adjustments Replaced multiplied by 12.
ARR Contract Adjustments Replacement	C	The value of MRR Contract Adjustments Replacement multiplied by 12.
ARR Down Sell	C	The value of MRR Down Sell multiplied by 12.
ARR Net New	C	The value of MRR Net New multiplied by 12.
ARR Renewals	C	The value of MRR Renewal multiplied by 12.
ARR Upsell	C	The value of MRR Upsell multiplied by 12.
Bank Account Name		The name of the Bank Account.
Company City		The city portion of the company address.
Company Country		The country portion of the company's address.
Company EC Country Code		The code for the European Union country in which the company operates.
Company Logo URL		Full URL to the location of the logo image stored in the Certinia Documents Folder.
Company Name		The name of the company created in Foundations.
Company Sales Tax Company Code		The code which identifies the company in external tax calculation and reporting systems
Company Short Street		The short street portion of the company's address.
Company State		The state portion of the company's address.
Company Street		The street portion of the company's address.
Company Validated City		The validated city portion of the company address.
Company Validated Country		The validated country portion of the company address.
Company Validated State		The validated state or province portion of the company address.
Company Validated Street		The validated street portion of the company address.
Company Validated ZipPostalCode		The validated ZIP code portion of the company address.
Company VAT GST Group		Indicates whether the company is part of a VAT or GST group.
Company VAT Registration Number		Identifying number used for VAT purposes.
Company Website		The URL of the company's website.
Company Year End Mode		The default processing mode for the year end process.
Company Zip Post Code		The zip or postal code portion of the company address.
Contract Account ID		The identification number of the account to which the contract belongs.
Contract Active Contract ID		The identification number of the active contract if this is a change request.
Contract Adjustments Replaced	C	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	C	This displays the MRR of a contract line item on a replacement contract.
Contract Annual Recurring Revenue Value		Monthly Recurring Revenue Multiplied by 12. Contract line items with the billing type One-off are excluded from this calculation. This includes discounts.
Contract Approval Status		The approval status of the contract if the contract is a contract change request.
Contract Company ID		The identification number of the associated company.
Contract Created By ID		The identification number of the user who created the contract.
Contract Created Date		The date on which the contract was created.
Contract Currency ISO Code		The currency ISO code of the contract.
Contract Description		The description of the contract.
Contract End Contract Notes		Additional information about the reason for ending the contract.
Contract End Date		The end date of the contract. The end date of new contract line items are initially set to this date.
Contract Engagement ID		The ID of the engagement Represents a single customer engagement that can include diverse revenue streams. It links together related products for a customer within a given time frame, such as professional services, subscriptions, and goods. to which the contract belongs.
Contract First Bill Date		The first date on which the contract is to be billed. The first bill date of new contract line items are initially set to this date.
Contract ID		The identification number of the contract.
Contract Is Renewal Of Previous Contract		Indicates whether this contract is a renewal of the previous contract.
Contract Line Item Active Contract Line Item ID		The identification number of the active contract line item if this is a change request line item for a contract line item on an active contract.
Contract Line Item Amount Billed Externally		The amount billed for this contract line item outside of Billing Central. This field is cleared on renewals.
Contract Line Item Annual Recurring Revenue		Monthly Recurring Revenue Multiplied by 12. The Annual Recurring Revenue for Contract line items with the billing type One-off is zero. This includes discounts.
Contract Line Item Bill In Arrears		Indicates whether the contract line is to be billed in arrears.
Contract Line Item Billed Externally To Date		The date up to which the contract line item has been billed outside of Billing Central. Billing schedules are not created for periods before this date.
Contract Line Item Billed To Date		Date up to which the contract line item has been billed. This is the Billing Period End Date of the related billing document line item, which belongs to the last completed billing document associated with this contract line item.
Contract Line Item Billing Term ID		The identification number of the soft date which defines the frequency with which billing schedules are created for the contract line item.
Contract Line Item Billing Term Name		The name of the soft date which defines the frequency with which billing schedules are created for the contract line item.
Contract Line Item Billing Type		The way in which a bill is to be generated. Available options are: Recurring Fixed, Recurring Variable and One-off. The default value is None.
Contract Line Item Contract ID		The identification number of the contract to which this contract line item belongs.
Contract Line Item Created By ID		The identification number of the user who created the contract line item.
Contract Line Item Created Date		The date on which the contract line item was created.
Contract Line Item Deferred Revenue	C	Deferred revenue for the contract line item. Calculated as Contract Line Item Total Billed - Contract Line Item Revenue Recognized. When the Contract Line Item Revenue Recognized field is not available in the dataset, this is set to Contract Line Item Total Billed.
Contract Line Item Description		The description of the contract line item.
Contract Line Item End Date		The end date of the contract line item. When a new contract line item is created, this is initially set to the end date of the contract.
Contract Line Item First Bill Date		The first date on which the contract line item is to be billed. When a new contract line item is created, this is initially set to the first bill date of the contract.
Contract Line Item ID		The identification number of the contract line item.
Contract Line Item Monthly Recurring Revenue		The monthly recurring revenue for the contract line item including discounts.
Contract Line Item MRR Multiplier Value		Multiplier used to calculate monthly recurring revenue.
Contract Line Item Name		The name of the contract line item.
Contract Line Item Previous Contract Line Item ID		The identification number of the previous contract line item to which this contract line item relates.
Contract Line Item Pricing Type		The pricing type of the contract line item. Available options are: Fixed, Volume and Tiered.
Contract Line Item Product Service ID		The identification number of the Salesforce Product to which the contract relates. This can be a product or service.
Contract Line Item Quantity		The quantity of the product or service being purchased to six decimal places.
Contract Line Item Revenue Category		The type of revenue from which the contract line item originates.
Contract Line Item Revenue Recognized	C	The revenue recognized to date for the contract line item. This is populated from the field specified in the Recognized To Date Value field on the Revenue Management settings record for the Billing Contract Line Item object. Note: This field is only available if you use Revenue Management and you answered "Yes" to question 5b. Do you want to include the amount of revenue recognized for billing contract line items? in the configuration wizard.
Contract Line Item Sales Price		The total price for the contract line including discounts.
Contract Line Item Sales Price Override		Contains a value that overrides the Sales Price. This value is calculated when complex pricing rules apply, such as when the contract line item has a pricing structure.
Contract Line Item Start Date		The first date from which billing can commence for this contract line item.
Contract Line Item Total Billed		The total amount billed for the contract line item.
Contract Line Item Total Contract Line Value		The total value of the contract line item over its lifetime including discounts.
Contract Line Item Unit Price		The price of one item to nine decimal places. This is used to calculate the Sales Price.
Contract Major Version Value		Indicates the major version of the contract. This field is set to 1 when the contract is created.
Contract Monthly Recurring Revenue Value		The total monthly recurring revenue for all contract line items that do not have the billing type One-off. This includes discounts.
Contract Name		The name of the contract.
Contract Number		The name of the contract expressed as a reference number.
Contract Original End Date		The original date on which the contract was due to end.
Contract Owner ID		The identification number of the contract owner.
Contract Previous Contract ID		The identification number of the previous contract to which this contract relates.
Contract Reason For Ending Contract		The reason that the contract was ended.
Contract Renewal Reminder Date		The date on which to report that the contract is due for renewal.
Contract Start Date		The date on which the contract starts. The start date of new contract line items are initially set to this date.
Contract Status		The status of the contract. Statuses are: Active, Draft, Expired, or Superseded.
Contract Total Contract Value		The total value of all recurring fixed and one-off contract lines over the entire life of the contract if the contract is not continuous.
Contract Type		The type of contract. This determines whether the record is a contract or a change request.
Dimension 1		The name of Dimension 1.
Dimension 2		The name of Dimension 2.
Dimension 3		The name of Dimension 3.
Dimension 4		The name of Dimension 4.
FFA Company ID		The identification number of the company created in Accounting.
MRR Churn	C	The value of contracts lost between a range of dates. For more information, see the KPIs Table.
MRR Down Sell	C	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.
MRR Net New	C	The value of contracts won between a range of dates. For more information, see the KPIs Table.
MRR Renewals	C	The value of contract line items renewed between a range of dates. For more information, see the KPIs Table.
MRR Upsell	C	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.
Next Contract Line Item End Date	C	The end date of the next contract line item.
Next Contract Line Item ID	C	The identification number of the next contract line item.
Next Contract Line Item Name	C	The name of the next contract line item.
Next Contract Line Item Start Date	C	The start date of the next contract line item.
Next Contract Line Item Total Contract Line Value	C	The total contract line value of the next contract line item.
Next Opportunity ID	C	The identification number of the next opportunity associated with a contract.
Next Opportunity Name	C	The name of the next opportunity.
Opportunity Account ID		The identification number of the account that the opportunity is linked to.
Opportunity Amount		The estimated total sale amount.
Opportunity Close Date		The date on which you plan to close the opportunity.
Opportunity Contract End Date		The date on which a contract created from this opportunity is to end.
Opportunity Contract First Bill Date		The first date on which a contract created from this opportunity is to be billed.
Opportunity Contract ID		The identification number of the contract created from this opportunity.
Opportunity Contract Start Date		The date from which billing can start for a contract created from this opportunity.
Opportunity Created By ID		The identification number of the user who created the opportunity.
Opportunity Created Date		The date on which the contract was created.
Opportunity Description		The description of the opportunity.
Opportunity Forecast Category		The category within the sales cycle to which an opportunity is assigned, based on its opportunity stage.
Opportunity Forecast Category Name		The name of the forecast category.
Opportunity Has Open Activity		Indicates there are open activities related to the opportunity.
Opportunity Has Opportunity Line Item		Indicates the opportunity product related to the opportunity.
Opportunity Has Overdue Task		Indicates there are overdue tasks related to the opportunity.
Opportunity ID		The name of the opportunity.
Opportunity Is Closed		Indicates that the opportunity is closed.
Opportunity Is Won		Indicates that the opportunity is won.
Opportunity Lead Source		The source of the opportunity.
Opportunity Name		The name of the opportunity.
Opportunity Next Step		Description of the next task in closing the opportunity.
Opportunity Original Opportunity ID		The identification number of the related opportunity that is being upsold, renewed, or replaced.
Opportunity Owner ID		The identification number of the owner of the opportunity.
Opportunity Owner Name		The opportunity owner name, rather than the identification number of the opportunity number.
Opportunity Probability		The likelihood that opportunity will close, stated as a percentage.
Opportunity Stage Name		The current stage of opportunity based on selections made from a predefined list.
Opportunity Type		The type of opportunity.
Previous Contract Line Item ARR	C	The annual recurring revenue (ARR) for the previous contract line item.
Previous Contract Line Item Billing Type	C	The billing type for the previous contract line item.
Previous Contract Line Item Contract ID	C	The identification number of the previous contract line item.
Previous Contract Line Item Contract Status	C	The contract status of the previous contract line item.
Previous Contract Line Item End Date	C	The end date of the previous contract line item.
Previous Contract Line Item ID	C	The identification number of the previous contract line item.
Previous Contract Line Item MRR	C	The monthly recurring revenue (MRR) for the previous contract line item.
Previous Contract Line Item Name	C	The name of the previous contract line item.
Previous Contract Line Item Quantity	C	The quantity of the previous contract line item.
Previous Contract Line Item Sales Price	C	The sales price of the previous contract line item.
Previous Contract Line Item Start Date	C	The start date of the previous contract line item.
Previous Contract Line Item Total Contract Line Value	C	The total contract line value of the previous contract line item.
Previous Contract Line Item Unit Price	C	The unit price of the previous contract line item.
Previous Opportunity ID	C	The identification number of the previous opportunity.
Previous Opportunity Name	C	The previous opportunity name.
Product Billing Type		The way in which a bill is to be generated. See the Product object.
Product Description		The description of the product.
Product Display URL		The URL for the product.
Product Family		The category specified for the product.
Product ID		The identification number of the product.
Product Is Active		Indicates that the product is active.
Product Name		The name of the product.
Product Place Of Supply		The product place of supply. Available values are "With Account" (default) or "With Customer".
Product Product Code		The product code for the product.
Product Sales Tax Rule		The tax code used if the org is configured to use an external system for tax calculation, such as Avalara.
Product Sales Tax Status		The tax status of the product.
Product Sales Tax Status		The tax status of this product for SUT companies.
Product Stock Keeping Unit		The product's SKU, which can be used with or in place of the Product Code field.
Product Tax Code		The tax code to be used when calculating tax in a VAT or GST company. See the Product object.
Product Tax Code		If your organization is configured to use an external system for tax calculation and product-specific tax calculation is required, you can map this product to a tax code in the external system by specifying the tax code here.
Renewed Contract Line Item End Date	C	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 Date	C	This displays the day after the end date for contract line items that have been replaced or are otherwise null.
System Next Opportunity Process Action		Stores the value for the following opportunity in order to classify KPIs used in the Billing Contracts dataset. For example, a contract line item might have a System Opportunity Process Action of "New Customer" and a System Next Opportunity Process Action of "Existing Customer - Upgrade". This indicates that the next contract is an upgrade.
System Process Action		Stores the action values used by the Opportunity to Contract Integration. For example, if the process action is Opportunity Type, the System Process Action can be "New Customer", "Existing Customer - Renewal", "Existing Customer - Upgrade" or "Existing Customer - Replacement".
System Process Trigger		Triggers the Opportunity to Contract integration. For example, if the process trigger is Opportunity Stage, the System Process Trigger is "Closed Won").
Total Previous ARR	C	The value of Total Previous MRR multiplied by 12.
Total Previous MRR	C	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.
Account Contact Department		The organizational department of the account contact.
Account Contact Mailing Country		The mailing country of the account contact.
Account Contact Title		The honorific address title of the account contact.

Account Base Date 1

The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.

Account Base Date 2

The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.

Account Base Date 3

The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.

Account Base Date 4

The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.

Account Billing City

The city portion of the account billing address.

Account Billing Country

The country portion of the account billing address.

Account Billing State

The state portion of the account billing address.

Account Contact Email

The contact email specified for the account.

Account Contact Name

The account contact name.

Account Contact Phone

The phone number of the account contact.

Account Credit Limit Value

The credit limit for the account in the account currency.

Account Credit Status

The current credit status for this account

Account Days Offset 1 Value

The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.

Account Days Offset 2 Value

The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.

Account Days Offset 3 Value

The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.

Account Days Offset 4 Value

The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.

Account Finance Contact

The contact associated with the account to which mass email messages, such as remittances and reminder letters are sent.

Account ID

The identification number of the account.

Account Industry

The industry sector to which the account belongs.

Account Name

The name of the account.

Account Payment Method

The payment method for the vendor account.

Account Phone

The primary phone number of the account.

Account Type

The type of account. For example: customer, competitor or partner.

Account User Name

The user name of the account.

Account Website

The URL of the account website.

ARR Churn

C

The value of MRR Churn multiplied by 12.

ARR Contract Adjustments Replaced

C

The value of MRR Contract Adjustments Replaced multiplied by 12.

ARR Contract Adjustments Replacement

C

The value of MRR Contract Adjustments Replacement multiplied by 12.

ARR Down Sell

C

The value of MRR Down Sell multiplied by 12.

ARR Net New

C

The value of MRR Net New multiplied by 12.

ARR Renewals

C

The value of MRR Renewal multiplied by 12.

ARR Upsell

C

The value of MRR Upsell multiplied by 12.

Bank Account Name

The name of the Bank Account.

Company City

The city portion of the company address.

Company Country

The country portion of the company's address.

Company EC Country Code

The code for the European Union country in which the company operates.

Company Logo URL

Full URL to the location of the logo image stored in the Certinia Documents Folder.

Company Name

The name of the company created in Foundations.

Company Sales Tax Company Code

The code which identifies the company in external tax calculation and reporting systems

Company Short Street

The short street portion of the company's address.

Company State

The state portion of the company's address.

Company Street

The street portion of the company's address.

Company Validated City

The validated city portion of the company address.

Company Validated Country

The validated country portion of the company address.

Company Validated State

The validated state or province portion of the company address.

Company Validated Street

The validated street portion of the company address.

Company Validated ZipPostalCode

The validated ZIP code portion of the company address.

Company VAT GST Group

Indicates whether the company is part of a VAT or GST group.

Company VAT Registration Number

Identifying number used for VAT purposes.

Company Website

The URL of the company's website.

Company Year End Mode

The default processing mode for the year end process.

Company Zip Post Code

The zip or postal code portion of the company address.

Contract Account ID

The identification number of the account to which the contract belongs.

Contract Active Contract ID

The identification number of the active contract if this is a change request.

Contract Adjustments Replaced

C

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

C

This displays the MRR of a contract line item on a replacement contract.

Contract Annual Recurring Revenue Value

Monthly Recurring Revenue Multiplied by 12. Contract line items with the billing type One-off are excluded from this calculation. This includes discounts.

Contract Approval Status

The approval status of the contract if the contract is a contract change request.

Contract Company ID

The identification number of the associated company.

Contract Created By ID

The identification number of the user who created the contract.

Contract Created Date

The date on which the contract was created.

Contract Currency ISO Code

The currency ISO code of the contract.

Contract Description

The description of the contract.

Contract End Contract Notes

Additional information about the reason for ending the contract.

Contract End Date

The end date of the contract. The end date of new contract line items are initially set to this date.

Contract Engagement ID

The ID of the engagement Closed

Represents a single customer engagement that can include diverse revenue streams. It links together related products for a customer within a given time frame, such as professional services, subscriptions, and goods. to which the contract belongs.

Contract First Bill Date

The first date on which the contract is to be billed. The first bill date of new contract line items are initially set to this date.

Contract ID

The identification number of the contract.

Contract Is Renewal Of Previous Contract

Indicates whether this contract is a renewal of the previous contract.

Contract Line Item Active Contract Line Item ID

The identification number of the active contract line item if this is a change request line item for a contract line item on an active contract.

Contract Line Item Amount Billed Externally

The amount billed for this contract line item outside of Billing Central. This field is cleared on renewals.

Contract Line Item Annual Recurring Revenue

Monthly Recurring Revenue Multiplied by 12. The Annual Recurring Revenue for Contract line items with the billing type One-off is zero. This includes discounts.

Contract Line Item Bill In Arrears

Indicates whether the contract line is to be billed in arrears.

Contract Line Item Billed Externally To Date

The date up to which the contract line item has been billed outside of Billing Central. Billing schedules are not created for periods before this date.

Contract Line Item Billed To Date

Date up to which the contract line item has been billed. This is the Billing Period End Date of the related billing document line item, which belongs to the last completed billing document associated with this contract line item.

Contract Line Item Billing Term ID

The identification number of the soft date which defines the frequency with which billing schedules are created for the contract line item.

Contract Line Item Billing Term Name

The name of the soft date which defines the frequency with which billing schedules are created for the contract line item.

Contract Line Item Billing Type

The way in which a bill is to be generated. Available options are: Recurring Fixed, Recurring Variable and One-off. The default value is None.

Contract Line Item Contract ID

The identification number of the contract to which this contract line item belongs.

Contract Line Item Created By ID

The identification number of the user who created the contract line item.

Contract Line Item Created Date

The date on which the contract line item was created.

Contract Line Item Deferred Revenue

C

Deferred revenue for the contract line item. Calculated as Contract Line Item Total Billed - Contract Line Item Revenue Recognized.

When the Contract Line Item Revenue Recognized field is not available in the dataset, this is set to Contract Line Item Total Billed.

Contract Line Item Description

The description of the contract line item.

Contract Line Item End Date

The end date of the contract line item. When a new contract line item is created, this is initially set to the end date of the contract.

Contract Line Item First Bill Date

The first date on which the contract line item is to be billed. When a new contract line item is created, this is initially set to the first bill date of the contract.

Contract Line Item ID

The identification number of the contract line item.

Contract Line Item Monthly Recurring Revenue

The monthly recurring revenue for the contract line item including discounts.

Contract Line Item MRR Multiplier Value

Multiplier used to calculate monthly recurring revenue.

Contract Line Item Name

The name of the contract line item.

Contract Line Item Previous Contract Line Item ID

The identification number of the previous contract line item to which this contract line item relates.

Contract Line Item Pricing Type

The pricing type of the contract line item. Available options are: Fixed, Volume and Tiered.

Contract Line Item Product Service ID

The identification number of the Salesforce Product to which the contract relates. This can be a product or service.

Contract Line Item Quantity

The quantity of the product or service being purchased to six decimal places.

Contract Line Item Revenue Category

The type of revenue from which the contract line item originates.

Contract Line Item Revenue Recognized

C

The revenue recognized to date for the contract line item.

This is populated from the field specified in the Recognized To Date Value field on the Revenue Management settings record for the Billing Contract Line Item object.

Note:

This field is only available if you use Revenue Management and you answered "Yes" to question 5b. Do you want to include the amount of revenue recognized for billing contract line items? in the configuration wizard.

Contract Line Item Sales Price

The total price for the contract line including discounts.

Contract Line Item Sales Price Override

Contains a value that overrides the Sales Price. This value is calculated when complex pricing rules apply, such as when the contract line item has a pricing structure.

Contract Line Item Start Date

The first date from which billing can commence for this contract line item.

Contract Line Item Total Billed

The total amount billed for the contract line item.

Contract Line Item Total Contract Line Value

The total value of the contract line item over its lifetime including discounts.

Contract Line Item Unit Price

The price of one item to nine decimal places. This is used to calculate the Sales Price.

Contract Major Version Value

Indicates the major version of the contract. This field is set to 1 when the contract is created.

Contract Monthly Recurring Revenue Value

The total monthly recurring revenue for all contract line items that do not have the billing type One-off. This includes discounts.

Contract Name

The name of the contract.

Contract Number

The name of the contract expressed as a reference number.

Contract Original End Date

The original date on which the contract was due to end.

Contract Owner ID

The identification number of the contract owner.

Contract Previous Contract ID

The identification number of the previous contract to which this contract relates.

Contract Reason For Ending Contract

The reason that the contract was ended.

Contract Renewal Reminder Date

The date on which to report that the contract is due for renewal.

Contract Start Date

The date on which the contract starts. The start date of new contract line items are initially set to this date.

Contract Status

The status of the contract. Statuses are: Active, Draft, Expired, or Superseded.

Contract Total Contract Value

The total value of all recurring fixed and one-off contract lines over the entire life of the contract if the contract is not continuous.

Contract Type

The type of contract. This determines whether the record is a contract or a change request.

Dimension 1

The name of Dimension 1.

Dimension 2

The name of Dimension 2.

Dimension 3

The name of Dimension 3.

Dimension 4

The name of Dimension 4.

FFA Company ID

The identification number of the company created in Accounting.

MRR Churn

C

The value of contracts lost between a range of dates. For more information, see the KPIs Table.

MRR Down Sell

C

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.

MRR Net New

C

The value of contracts won between a range of dates. For more information, see the KPIs Table.

MRR Renewals

C

The value of contract line items renewed between a range of dates. For more information, see the KPIs Table.

MRR Upsell

C

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.

Next Contract Line Item End Date

C

The end date of the next contract line item.

Next Contract Line Item ID

C

The identification number of the next contract line item.

Next Contract Line Item Name

C

The name of the next contract line item.

Next Contract Line Item Start Date

C

The start date of the next contract line item.

Next Contract Line Item Total Contract Line Value

C

The total contract line value of the next contract line item.

Next Opportunity ID

C

The identification number of the next opportunity associated with a contract.

Next Opportunity Name

C

The name of the next opportunity.

Opportunity Account ID

The identification number of the account that the opportunity is linked to.

Opportunity Amount

The estimated total sale amount.

Opportunity Close Date

The date on which you plan to close the opportunity.

Opportunity Contract End Date

The date on which a contract created from this opportunity is to end.

Opportunity Contract First Bill Date

The first date on which a contract created from this opportunity is to be billed.

Opportunity Contract ID

The identification number of the contract created from this opportunity.

Opportunity Contract Start Date

The date from which billing can start for a contract created from this opportunity.

Opportunity Created By ID

The identification number of the user who created the opportunity.

Opportunity Created Date

The date on which the contract was created.

Opportunity Description

The description of the opportunity.

Opportunity Forecast Category

The category within the sales cycle to which an opportunity is assigned, based on its opportunity stage.

Opportunity Forecast Category Name

The name of the forecast category.

Opportunity Has Open Activity

Indicates there are open activities related to the opportunity.

Opportunity Has Opportunity Line Item

Indicates the opportunity product related to the opportunity.

Opportunity Has Overdue Task

Indicates there are overdue tasks related to the opportunity.

Opportunity ID

The name of the opportunity.

Opportunity Is Closed

Indicates that the opportunity is closed.

Opportunity Is Won

Indicates that the opportunity is won.

Opportunity Lead Source

The source of the opportunity.

Opportunity Name

The name of the opportunity.

Opportunity Next Step

Description of the next task in closing the opportunity.

Opportunity Original Opportunity ID

The identification number of the related opportunity that is being upsold, renewed, or replaced.

Opportunity Owner ID

The identification number of the owner of the opportunity.

Opportunity Owner Name

The opportunity owner name, rather than the identification number of the opportunity number.

Opportunity Probability

The likelihood that opportunity will close, stated as a percentage.

Opportunity Stage Name

The current stage of opportunity based on selections made from a predefined list.

Opportunity Type

The type of opportunity.

Previous Contract Line Item ARR

C

The annual recurring revenue (ARR) for the previous contract line item.

Previous Contract Line Item Billing Type

C

The billing type for the previous contract line item.

Previous Contract Line Item Contract ID

C

The identification number of the previous contract line item.

Previous Contract Line Item Contract Status

C

The contract status of the previous contract line item.

Previous Contract Line Item End Date

C

The end date of the previous contract line item.

Previous Contract Line Item ID

C

The identification number of the previous contract line item.

Previous Contract Line Item MRR

C

The monthly recurring revenue (MRR) for the previous contract line item.

Previous Contract Line Item Name

C

The name of the previous contract line item.

Previous Contract Line Item Quantity

C

The quantity of the previous contract line item.

Previous Contract Line Item Sales Price

C

The sales price of the previous contract line item.

Previous Contract Line Item Start Date

C

The start date of the previous contract line item.

Previous Contract Line Item Total Contract Line Value

C

The total contract line value of the previous contract line item.

Previous Contract Line Item Unit Price

C

The unit price of the previous contract line item.

Previous Opportunity ID

C

The identification number of the previous opportunity.

Previous Opportunity Name

C

The previous opportunity name.

Product Billing Type

The way in which a bill is to be generated. See the Product object.

Product Description

The description of the product.

Product Display URL

The URL for the product.

Product Family

The category specified for the product.

Product ID

The identification number of the product.

Product Is Active

Indicates that the product is active.

Product Name

The name of the product.

Product Place Of Supply

The product place of supply. Available values are "With Account" (default) or "With Customer".

Product Product Code

The product code for the product.

Product Sales Tax Rule

The tax code used if the org is configured to use an external system for tax calculation, such as Avalara.

Product Sales Tax Status

The tax status of the product.

Product Sales Tax Status

The tax status of this product for SUT companies.

Product Stock Keeping Unit

The product's SKU, which can be used with or in place of the Product Code field.

Product Tax Code

The tax code to be used when calculating tax in a VAT or GST company. See the Product object.

Product Tax Code

If your organization is configured to use an external system for tax calculation and product-specific tax calculation is required, you can map this product to a tax code in the external system by specifying the tax code here.

Renewed Contract Line Item End Date

C

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 Date

C

This displays the day after the end date for contract line items that have been replaced or are otherwise null.

System Next Opportunity Process Action

Stores the value for the following opportunity in order to classify KPIs used in the Billing Contracts dataset. For example, a contract line item might have a System Opportunity Process Action of "New Customer" and a System Next Opportunity Process Action of "Existing Customer - Upgrade". This indicates that the next contract is an upgrade.

System Process Action

Stores the action values used by the Opportunity to Contract Integration. For example, if the process action is Opportunity Type, the System Process Action can be "New Customer", "Existing Customer - Renewal", "Existing Customer - Upgrade" or "Existing Customer - Replacement".

System Process Trigger

Triggers the Opportunity to Contract integration. For example, if the process trigger is Opportunity Stage, the System Process Trigger is "Closed Won").

Total Previous ARR

C

The value of Total Previous MRR multiplied by 12.

Total Previous MRR

C

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.

Account Contact Department

The organizational department of the account contact.

Account Contact Mailing Country

The mailing country of the account contact.

Account Contact Title

The honorific address title of the account contact.

Billing Contracts Dataset Output Fields

Related Content