Professional Services Automation Data Dictionary

Forecast_Enhanced_Detail_Category__c

Label: Billing Forecast Detail Category

Stores the weighted category totals for the related project or opportunity.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
Actuals__c Actuals Spring 2019 The Actuals value is the sum of Billings: Expenses, Billings: Milestones, Billings: Misc Adjustments, and Billings: Timecards.

Currency(18,2) false
Adjusted_Value__c Adjusted Value Spring 2019 Formula field representing the value displayed on the Billing Forecast page for this billing forecast detail category. If an override value is present, it is displayed. If no override value is present, the sum of the roll-up variance and original billing forecast value is displayed. If there is no override value or roll-up variance, the original billing forecast value is displayed.

Formula:
IF(NOT(ISNULL(Override_Value__c)),Override_Value__c,Forecast_Value__c)
Currency(18,2) false
Billings_Expenses__c Billings: Expenses Spring 2019 The billings for expenses.

Currency(18,2) false
Billings_Milestones__c Billings: Milestones Spring 2019 The billings for milestones.

Currency(18,2) false
Billings_Misc_Adjustments__c Billings: Misc Adjustments Spring 2019 The billings for miscellaneous adjustments.

Currency(18,2) false
Billings_Timecards__c Billings: Timecards Spring 2019 The billings for timecards.

Currency(18,2) false
Category_Label__c Category Label Summer 2018 Lookup to the relevant billing forecast setup category label, for example, Expected.

Formula:
Forecast_Setup_Category__r.Label__c
Text false
Forecast_Enhanced_Detail__c Billing Forecast Detail Summer 2018 Lookup to the relevant billing forecast detail record.

Looks up to: Forecast_Enhanced_Detail__c
MasterDetail
Forecast_Enhanced_Override__c Billing Forecast Override Spring 2019 Lookup to the currently active billing forecast override applied to this billing forecast detail category.

Looks up to: Forecast_Enhanced_Override__c
Lookup false
Forecast_Setup_Category__c Billing Forecast Setup Category Summer 2018 Lookup to the billing forecast categories used on the Billing Forecast Setup page.

Looks up to: Forecast_Setup_Category__c
Lookup false
Forecast_Value__c Billing Forecast Total Value Summer 2018 Calculated value for this billing forecast category, using the multipliers entered on the Billing Forecast Setup page.

Currency(18,2) false
Override_CreatedBy__c Override Created By Spring 2019 Lookup to the user who created the currently active billing forecast override applied to this billing forecast detail category.

Looks up to: User

Lookup false
Override_CreatedDate__c Override Created Date Spring 2019 Created date and time of the currently active billing forecast override applied to this billing forecast detail category.

Formula:
Forecast_Enhanced_Override__r.CreatedDate
DateTime false
Override_Notes__c Override Notes Spring 2019 Notes on the currently active billing forecast override applied to this billing forecast detail category.

Formula:
Forecast_Enhanced_Override__r.Notes__c
Text false
Override_Value__c Override Value Spring 2019 Value of the currently active billing forecast override applied to this billing forecast detail category.

Formula:
Forecast_Enhanced_Override__r.Override_Value__c
Currency(18,2) false
Scheduled_Assignments__c Scheduled: Assignments Spring 2019 The scheduled assignments.

Currency(18,2) false
Scheduled_Backlog__c Scheduled Backlog Spring 2019 The Scheduled Backlog value is the sum of Scheduled: Assignments, Scheduled: Held RRs, Scheduled: Unheld RRs, and Scheduled: Milestones.

Currency(18,2) false
Scheduled_Held_Resource_Requests__c Scheduled: Held RRs Spring 2019 The scheduled held resource requests.

Currency(18,2) false
Scheduled_Milestones__c Scheduled: Milestones Spring 2019 The scheduled milestones.

Currency(18,2) false
Scheduled_Unheld_Resource_Requests__c Scheduled: Unheld RRs Spring 2019 The scheduled unheld resource requests.

Currency(18,2) false
Unscheduled_Backlog__c Unscheduled Backlog Spring 2019 Potential backlog, in the context of perpetual time periods (All Time Periods).

Currency(18,2) false


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