BC Data Dictionary

BillingSchedule__c

Label: Billing Schedule

Contains the billing schedules used to create billing documents from contracts in FinancialForce 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
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
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)
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–2020 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.