Billing Central Data Dictionary

ContractLineItem__c

Label: Billing Contract Line Item

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
ActiveContractLineItem__c Active Contract Line Item Pre-Spring 2018 Lookup to the active contract line item to which this change request line item relates.

Looks up to: ContractLineItem__c
Lookup
AlignForBilling__c Align for Billing Spring 2022 The existing contract line item to which this contract line item is aligned for billing.

Looks up to: ContractLineItem__c
Lookup
AmountBilledExternally__c Amount Billed Externally Spring 2019 The amount that has been billed for this contract line item outside of Billing Central.

Currency(18,2) 0
AnalysisItem1__c Analysis Item 1 Spring 2020 Used to sub-analyze billing contract lines and can be used to represent a number of different business concepts.

Looks up to: fferpcore__AnalysisItem__c

Lookup
AnalysisItem2__c Analysis Item 2 Spring 2020 Used to sub-analyze billing contract lines and can be used to represent a number of different business concepts.

Looks up to: fferpcore__AnalysisItem__c

Lookup
AnalysisItem3__c Analysis Item 3 Spring 2020 Used to sub-analyze billing contract lines and can be used to represent a number of different business concepts.

Looks up to: fferpcore__AnalysisItem__c

Lookup
AnalysisItem4__c Analysis Item 4 Spring 2020 Used to sub-analyze billing contract lines and can be used to represent a number of different business concepts.

Looks up to: fferpcore__AnalysisItem__c

Lookup
AnnualRecurringRevenue__c Annual Recurring Revenue Pre-Spring 2018 Monthly Recurring Revenue multiplied by 12.

Formula:
MonthlyRecurringRevenue__c * 12
Currency(18,2)
BilledExternallyTo__c Billed Externally To Spring 2019 Date up to which the contract line item has been billed outside of Billing Central.

Date
BilledTo__c Billed To Pre-Spring 2018 Date up to which the contract line item has been billed.

Date
BillingTermDefinition__c Billing Term Definition Spring 2020 Formula field containing the definition of the billing term associated with this line.

Formula:
BillingTerm__r.Definition__c
Text
BillingTerm__c Billing Term Pre-Spring 2018 Lookup to the soft date that determines when billing occurs.

Looks up to: SoftDate__c
Lookup
BillingType__c Billing Type Pre-Spring 2018 The type of billing for this contract line item.

Picklist:
One-off
Recurring Fixed
Recurring Variable
Canceled__c Canceled Summer 2022 Indicates whether the contract line item is canceled and not eligible for billing.

Checkbox false
ChargeTermDefinition__c Charge Term Definition Summer 2020 Formula field containing the definition of the charge term associated with this line.

Formula:
IF(ISBLANK(ChargeTerm__c), BillingTermDefinition__c, ChargeTerm__r.Definition__c)
Text
ChargeTerm__c Charge Term Summer 2020 Lookup to the soft date that determines when charging occurs.

Looks up to: SoftDate__c
Lookup
ContractEndDate__c Contract End Date Pre-Spring 2018 Formula field containing the end date of the contract to which the contract line item belongs.

Formula:
Contract__r.EndDate__c
Date
ContractFirstBillDate__c Contract First Bill Date Pre-Spring 2018 Formula field containing the first bill date of the contract to which the contract line item belongs.

Formula:
Contract__r.FirstBillDate__c
Date
ContractStartDate__c Contract Start Date Pre-Spring 2018 Formula field containing the start date of the contract to which the contract line item belongs.

Formula:
Contract__r.StartDate__c
Date
ContractStatus__c Contract Status Pre-Spring 2018 Formula field containing the status of the contract to which the contract line item belongs.

Formula:
TEXT(Contract__r.Status__c)
Text
ContractType__c Contract Type Pre-Spring 2018 Formula field containing the type of contract to which this contract line item belongs.

Formula:
TEXT(Contract__r.Type__c)
Text
Contract__c Contract Pre-Spring 2018 Contract to which this contract line belongs.

Looks up to: Contract__c
MasterDetail
Description__c Description Pre-Spring 2018 Description of the contract line item.

TextArea
Discount__c Discount Pre-Spring 2018 Lookup to the discount applied to this contract line item.

Looks up to: Discount__c
Lookup
EndDate__c End Date Pre-Spring 2018 Date on which this contract line item ends.

Date
FirstBillDate__c First Bill Date Pre-Spring 2018 First date on which the contract line item is to be billed.

Date
InArrears__c Bill in Arrears Pre-Spring 2018 Indicates whether the contract line item is to be billed in arrears.

Checkbox false
IsControllingLine__c Controlling Line for Billing Alignment Winter 2023 For internal use only. This checkbox is selected if other lines on the contract are aligned to this line to sync with its billing periods and billing dates.

Checkbox false
MonthlyRecurringRevenue__c Monthly Recurring Revenue Pre-Spring 2018 Monthly recurring revenue for the contract line item. This is calculated by multiplying the Sales Price by the Monthly Recurring Revenue Multiplier of the Charge Term or Billing Term associated with the contract line item.

Formula:
MrrMultiplier__c * SalesPrice__c
Currency(18,2)
MrrMultiplier__c Monthly Recurring Revenue Multiplier Pre-Spring 2018 Multiplier used to calculate monthly recurring revenue. Must contain a positive number.

Number(18,9)
OnHold__c On Hold Spring 2022 Indicates that the contract line item is on hold for billing, meaning that its billing schedule lines are currently excluded from billing processes.

Checkbox false
Plan__c Plan Name Pre-Spring 2018 Plan

Looks up to: Plan__c
Lookup
PreviousContractLineItem__c Previous Contract Line Item Pre-Spring 2018 Lookup to the previous contract line item to which this contract line item relates.

Looks up to: ContractLineItem__c
Lookup
PricingStructure__c Pricing Structure Pre-Spring 2018 Lookup to the pricing structure that determines the Unit Price for different quantities on this contract line item.

Looks up to: PricingStructure__c
Lookup
PricingType__c Pricing Type Pre-Spring 2018 Type of pricing to be used for this contract line item. When set to Fixed, the unit price is always the same. Otherwise, the unit price is determined by quantity.

Formula:
IF(ISBLANK(PricingStructure__c), $Label.PricingTypeFixed, TEXT(PricingStructure__r.PricingType__c) )
Text
ProductService__c Product or Service Pre-Spring 2018 Lookup to the Salesforce product or service.

Looks up to: Product2

Lookup
Quantity__c Quantity Pre-Spring 2018 Quantity of the product or service being purchased. You must enter a value if a fixed Billing Type is selected.

Number(18,6) 0
RecurringBillDate__c Recurring Bill Date Spring 2022 Soft date that will be used to calculate the billing dates for recurring lines. If not specified, the billing term will be used.

Looks up to: SoftDate__c
Lookup
RevenueCategory__c Revenue Category Pre-Spring 2018 The type of revenue from which the contract line item originates.

Picklist:
Churn
Downgrade
Net New Booking
Upgrade
SalesPriceOverride__c Sales Price Override Pre-Spring 2018 Contains a value that is used to calculate the Sales Price when a contract line item contains a pricing structure.

Currency(18,2)
SalesPrice__c Sales Price Pre-Spring 2018 Total price for the contract line. This is either calculated using the formula Quantity x Unit Price or it is equal to the Sales Price Override if that field contains a value.

Formula:
BLANKVALUE(SalesPriceOverride__c, Quantity__c * UnitPrice__c)
Currency(18,2)
StartDate__c Start Date Pre-Spring 2018 Date from which billing can commence for this contract line item.

Date
TotalBilled__c Total Billed Pre-Spring 2018 Total amount billed for the contract line item.

Currency(18,2) 0
TotalContractLineValue__c Total Contract Line Value Pre-Spring 2018 Total value of the contract line item over its lifetime. The value is zero if the billing type is Recurring Variable or the Billing Type is Recurring Fixed and there is no end date. If the billing type is Recurring Fixed and there is an end date, the value is calculated using the formula: Sales Price x Number of Terms (including partial terms). If the billing type is One-off, the value is the sales price.

Currency(18,2)
TriggerId__c Trigger ID Pre-Spring 2018 An identifier that is used by Billing Central services when creating contract line items.

Number(5,0)
UnitOfMeasure__c Unit Of Measure Pre-Spring 2018 Lookup to the unit of measure used to determine customer usage on this contract line item.

Looks up to: UnitOfMeasure__c
Lookup
UnitPrice__c Unit Price Pre-Spring 2018 Price of one item. This is used to calculate the Sales Price.

Number(18,9) 0
ValueCalculationWarning__c Value Calculation Warning Spring 2020 Information about why the Total Contract Line Value was not calculated.

TextArea


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.