Billing Central Data Dictionary

BillingSchedule__c

Label: Billing Schedule

Contains the billing schedules used to create billing documents from contracts in Billing Central.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
BillingContract__c Billing Contract Summer 2020 Lookup to the billing contract on the billing schedule.

Looks up to: Contract__c
Lookup
BillingDate__c Billing Date Pre-Spring 2018 Date on which a billing document is due to be created for this billing schedule.

Date
BillingDocumentLineItem__c Billing Document Line Item Pre-Spring 2018 Lookup to the billing document line item generated from this billing schedule.

Looks up to: fferpcore__BillingDocumentLineItem__c

Lookup
BillingPeriodEndDate__c End of Period Pre-Spring 2018 Last day of the billing period for this billing schedule.

Date
BillingPeriodStartDate__c Start of Period Pre-Spring 2018 First day of the billing period for this billing schedule.

Date
CompleteBillingDocumentDeleted__c Complete Billing Document Deleted Summer 2022 Indicates that this schedule's related billing document line item has been completed and deleted after having been archived.

Checkbox false
ContractGrouping__c Contract Pre-Spring 2018 Contract Id to which this billing schedule belongs.

Formula:
ContractLineItem__r.Contract__r.Name
Text
ContractLineItem__c Contract Line Item Pre-Spring 2018 Lookup to the contract line item that is to be processed.

Looks up to: ContractLineItem__c
Lookup
ContractStatus__c Contract Status Pre-Spring 2018 Formula field containing the status of the contract to which the billing schedule belongs.

Formula:
ContractLineItem__r.ContractStatus__c
Text
ContractType__c Contract Type Pre-Spring 2018 Formula field containing the type of contract to which this billing schedule belongs.

Formula:
ContractLineItem__r.ContractType__c
Text
EndDateAfterContractLineEndDate__c Ends Later Than Contract Line Summer 2022 For internal use only. This checkbox is selected when the billing period end date falls after the contract line item's end date, or when the contract line item is canceled.

Formula:
BillingPeriodEndDate__c > ContractLineItem__r.EndDate__c || ContractLineItem__r.Canceled__c
Checkbox
IsFinalSchedule__c Final Schedule Pre-Spring 2018 Indicates whether this is the last billing schedule for the contract line item.

Formula:
AND ( !ISNULL(ContractLineItem__c), OR ( BillingPeriodEndDate__c >= ContractLineItem__r.EndDate__c, ISPICKVAL(ContractLineItem__r.BillingType__c, 'One-off') ) )
Checkbox
IsFirstSchedule__c First Schedule Pre-Spring 2018 Indicates whether this is the first billing schedule for the contract line item.

Formula:
AND ( !ISNULL(ContractLineItem__c), OR ( BillingPeriodStartDate__c <= ContractLineItem__r.StartDate__c, ISPICKVAL(ContractLineItem__r.BillingType__c, 'One-off') ) )
Checkbox
Month__c Month Pre-Spring 2018 Formula field which calculates the month of the Billing Period Start Date.

Formula:
MONTH( BillingPeriodStartDate__c)
Number(18,0)
UniqueId__c Unique Id Spring 2022 Combination of contract line item, start date, end date and billing date that enforces uniqueness.

Text(50)
Value__c Value Pre-Spring 2018 Value of the billing schedule. When the billing schedule is created, the sales price is copied from the related contract line item. If you edit this field, the contract line item is not updated.

Number(18,2) 0
Year__c Year Pre-Spring 2018 Formula field which calculates the year of the Billing Period Start Date.

Formula:
YEAR( BillingPeriodStartDate__c)
Number(18,0)


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