Billing Central Data Dictionary

Plan__c

Label: Plan

Contains the products and price plans that you can create a contract from.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AnnualValue__c Annual Value Pre-Spring 2018 Value of the plan over 12 months. If the plan is shorter than a year this is the value of the plan based on its actual duration, not extrapolated out to a whole year.

Formula:
IF(IsContinuous__c || NumberOfTerms__c * Term__r.EstimatedDaysPerTerm__c > 365, 12 * TermValue__c * Term__r.MrrMultiplier__c, TotalValue__c - OneOffValue__c)
Currency(18,2)
Company__c Company Pre-Spring 2018 Lookup to the associated company.

Looks up to: fferpcore__Company__c

Lookup
Description__c Description Pre-Spring 2018 Description of the plan.

TextArea
EndDate__c Available To Pre-Spring 2018 Date on which the plan expires and is no longer available to customers.

Date
IsContinuous__c Continuous Pre-Spring 2018 Indicates whether the plan continues indefinitely.

Checkbox false
NumberOfTerms__c Number of Billing Terms Pre-Spring 2018 Number of Billing Terms to be applied.

Number(9,0)
OneOffValue__c One-off Value Pre-Spring 2018 Total value of the plan line items with the Billing Type One-off.

Summary
StartDate__c Available From Pre-Spring 2018 Date on which the plan is available to customers. The default value is today.

Date TODAY()
Status__c Status Pre-Spring 2018 Status of the plan. This can be Draft, Active or Expired.

Picklist:
Active
Draft
Expired
TermValue__c Billing Term Value Pre-Spring 2018 Total value of one billing term. This excludes plan line items where the Billing Type is One-off.

Summary
Term__c Billing Term Pre-Spring 2018 Lookup to the soft date that determines when billing of the plan occurs.

Looks up to: SoftDate__c
Lookup
TotalValue__c Total Value Pre-Spring 2018 Total value of all billing terms if the plan is not continuous. This is calculated by multiplying the Billing Term Value by the Number of Billing Terms then adding the One-off Value.

Formula:
IF( IsContinuous__c , null, (TermValue__c * NumberOfTerms__c) + OneOffValue__c)
Currency(18,2)


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