Professional Services Automation Data Dictionary

Revenue_Forecast_Version_Detail__c

Label: Revenue Forecast Version Detail

Stores the detail records used by different versions of a revenue forecast.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
Actuals_Total__c Actuals Total Summer 2023 The total amount of actual revenue within the relevant time period.

Formula:
Equal_Split_Milestone_Pending__c + Equal_Split_Milestone_Recognized__c + Equal_Split_Project_Pending__c + Equal_Split_Project_Recognized__c + Expense_Pending__c + Expense_Recognized__c + Milestone_Pending__c + Milestone_Recognized__c + Misc_Adjustment_Pending__c + Misc_Adjustment_Recognized__c + Percent_Complete_Milestone_Pending__c + Percent_Complete_Milestone_Recognized__c + Percent_Complete_Project_Pending__c + Percent_Complete_Project_Recognized__c + Timecard_Pending__c + Timecard_Recognized__c
Currency(18,2) false
Corp_Actuals_Total__c Corp: Actuals Total Summer 2023 In the corporate currency, the total amount of actual revenue within the relevant time period.

Formula:
Corp_Equal_Split_Milestone_P__c + Corp_Equal_Split_Milestone_R__c + Corp_Equal_Split_Project_P__c + Corp_Equal_Split_Project_R__c + Corp_Expense_P__c + Corp_Expense_R__c + Corp_Milestone_P__c + Corp_Milestone_R__c + Corp_Misc_Adjustment_P__c + Corp_Misc_Adjustment_R__c + Corp_Percent_Complete_Milestone_P__c + Corp_Percent_Complete_Milestone_R__c + Corp_Percent_Complete_Project_P__c + Corp_Percent_Complete_Project_R__c + Corp_Timecard_P__c + Corp_Timecard_R__c
Currency(18,2) false
Corp_Currency__c Corp: Currency Fall 2020 The corporate currency of the org at the time the revenue forecast was run.

Text(3) false
Corp_Equal_Split_Milestone_P__c Corp: Equal Split: Milestone: Pending Fall 2020 In the corporate currency, the amount of revenue that is ready for recognition within the relevant time period for the Milestone revenue source, when using the Equal Split recognition method.

Number(18,2) false null
Corp_Equal_Split_Milestone_R__c Corp: Equal Split: Milestone: Recognized Fall 2020 In the corporate currency, the amount of revenue that has already been recognized within the relevant time period for the Milestone revenue source, when using the Equal Split recognition method.

Number(18,2) false null
Corp_Equal_Split_Milestone_S__c Corp: Equal Split: Milestone: Scheduled Fall 2020 In the corporate currency, the amount of revenue that is scheduled for recognition within the relevant time period for the Milestone revenue source, when using the Equal Split recognition method.

Number(18,2) false null
Corp_Equal_Split_Project_P__c Corp: Equal Split: Project: Pending Fall 2020 In the corporate currency, the amount of revenue that is ready for recognition within the relevant time period for the Project revenue source, when using the Equal Split recognition method.

Number(18,2) false null
Corp_Equal_Split_Project_R__c Corp: Equal Split: Project: Recognized Fall 2020 In the corporate currency, the amount of revenue that has already been recognized within the relevant time period for the Project revenue source, when using the Equal Split recognition method.

Number(18,2) false null
Corp_Equal_Split_Project_S__c Corp: Equal Split: Project: Scheduled Fall 2020 In the corporate currency, the amount of revenue that is scheduled for recognition within the relevant time period for the Project revenue source, when using the Equal Split recognition method.

Number(18,2) false null
Corp_Eva_S__c Corp: Deliverable: EVA: Scheduled Fall 2020 In the corporate currency, the amount of revenue that is scheduled for recognition within the relevant time period for the EVA revenue source, when using the Deliverable recognition method.

Number(18,2) false null
Corp_Expense_P__c Corp: Deliverable: Expense: Pending Fall 2020 In the corporate currency, the amount of revenue that is ready for recognition within the relevant time period for the Expense revenue source, when using the Deliverable recognition method.

Number(18,2) false null
Corp_Expense_R__c Corp: Deliverable: Expense: Recognized Fall 2020 In the corporate currency, the amount of revenue that has already been recognized within the relevant time period for the Expense revenue source, when using the Deliverable recognition method.

Number(18,2) false null
Corp_Milestone_P__c Corp: Deliverable: Milestone: Pending Fall 2020 In the corporate currency, the amount of revenue that is ready for recognition for the Milestone revenue source, when using the Deliverable recognition method.

Number(18,2) false null
Corp_Milestone_R__c Corp: Deliverable: Milestone: Recognized Fall 2020 In the corporate currency, the amount of revenue that has already been recognized within the relevant time period for the Milestone revenue source, when using the Deliverable recognition method.

Number(18,2) false null
Corp_Milestone_S__c Corp: Deliverable: Milestone: Scheduled Fall 2020 In the corporate currency, the amount of revenue that is scheduled for recognition within the relevant time period for the Milestone revenue source, when using the Deliverable recognition method.

Number(18,2) false null
Corp_Misc_Adjustment_P__c Corp: Deliverable: MA: Pending Fall 2020 In the corporate currency, the amount of revenue that is ready for recognition for the Miscellaneous Adjustment revenue source, when using the Deliverable recognition method.

Number(18,2) false null
Corp_Misc_Adjustment_R__c Corp: Deliverable: MA: Recognized Fall 2020 In the corporate currency, the amount of revenue that has already been recognized within the relevant time period for the Miscellaneous Adjustment revenue source, when using the Deliverable recognition method.

Number(18,2) false null
Corp_Opportunity_U_Best__c Corp: Opportunity: Unscheduled Best Spring 2021 In the corporate currency, the amount of unscheduled revenue within the relevant time period for the Opportunity revenue source, using the best case scenario.

Number(18,2) false null
Corp_Opportunity_U_Worst__c Corp: Opportunity: Unscheduled Worst Spring 2021 In the corporate currency, the amount of unscheduled revenue within the relevant time period for the Opportunity revenue source, using the worst case scenario.

Number(18,2) false null
Corp_Opportunity_U__c Corp: Opportunity: Unscheduled Fall 2020 In the corporate currency, the amount of unscheduled revenue within the relevant time period for the Opportunity revenue source, using the expected scenario.

Number(18,2) false null
Corp_Percent_Complete_Milestone_P__c Corp: % Complete: Milestone: Pending Fall 2020 In the corporate currency, the amount of revenue that is ready for recognition within the relevant time period for the Milestone revenue source, when using the % Complete recognition method.

Number(18,2) false null
Corp_Percent_Complete_Milestone_R__c Corp: % Complete: Milestone: Recognized Fall 2020 In the corporate currency, the amount of revenue that has already been recognized within the relevant time period for the Milestone revenue source, when using the % Complete recognition method.

Number(18,2) false null
Corp_Percent_Complete_Milestone_S__c Corp: % Complete: Milestone: Scheduled Fall 2020 In the corporate currency, the amount of revenue that is scheduled for recognition within the relevant time period for the Milestone revenue source, when using the % Complete recognition method.

Number(18,2) false null
Corp_Percent_Complete_Milestone_U__c Corp: % Complete: Milestone: Unscheduled Fall 2020 In the corporate currency, the amount of unscheduled revenue within the relevant time period for the Milestone revenue source, when using the % Complete recognition method.

Number(18,2) false null
Corp_Percent_Complete_Project_P__c Corp: % Complete: Project: Pending Fall 2020 In the corporate currency, the amount of revenue that is ready for recognition within the relevant time period for the Project revenue source, when using the % Complete recognition method.

Number(18,2) false null
Corp_Percent_Complete_Project_R__c Corp: % Complete: Project: Recognized Fall 2020 In the corporate currency, the amount of revenue that has already been recognized within the relevant time period for the Project revenue source, when using the % Complete recognition method.

Number(18,2) false null
Corp_Percent_Complete_Project_S__c Corp: % Complete: Project: Scheduled Fall 2020 In the corporate currency, the amount of revenue that is scheduled for recognition within the relevant time period for the Project revenue source, when using the % Complete recognition method.

Number(18,2) false null
Corp_Percent_Complete_Project_U__c Corp: % Complete: Project: Unscheduled Fall 2020 In the corporate currency, the amount of unscheduled revenue within the relevant time period for the Project revenue source, when using the % Complete recognition method.

Number(18,2) false null
Corp_Scheduled_Total__c Corp: Scheduled Total Summer 2023 In the corporate currency, the total amount of scheduled revenue within the relevant time period.

Formula:
Corp_Equal_Split_Milestone_S__c + Corp_Equal_Split_Project_S__c + Corp_Eva_S__c + Corp_Milestone_S__c + Corp_Percent_Complete_Milestone_S__c + Corp_Percent_Complete_Milestone_U__c + Corp_Percent_Complete_Project_S__c + Corp_Percent_Complete_Project_U__c
Currency(18,2) false
Corp_Timecard_P__c Corp: Deliverable: Timecard: Pending Fall 2020 In the corporate currency, the amount of revenue that is ready for recognition for the Timecard revenue source, when using the Deliverable recognition method.

Number(18,2) false null
Corp_Timecard_R__c Corp: Deliverable: Timecard: Recognized Fall 2020 In the corporate currency, the amount of revenue that has already been recognized within the relevant time period for the Timecard revenue source, when using the Deliverable recognition method.

Number(18,2) false null
Equal_Split_Milestone_Pending__c Equal Split: Milestone: Pending Fall 2020 Amount of revenue that is ready for recognition within the relevant time period for the Milestone revenue source, when using the Equal Split recognition method. Populated by the revenue forecast version batch Apex job.

Currency(18,2) false
Equal_Split_Milestone_Recognized__c Equal Split: Milestone: Recognized Fall 2020 Amount of revenue that has already been recognized within the relevant time period for the Milestone revenue source, when using the Equal Split recognition method. Populated using data from Revenue Management, if you are using the integration.

Currency(18,2) false
Equal_Split_Milestone_Scheduled__c Equal Split: Milestone: Scheduled Fall 2020 Amount of revenue that is scheduled for recognition within the relevant time period for the Milestone revenue source, when using the Equal Split recognition method.

Currency(18,2) false
Equal_Split_Project_Pending__c Equal Split: Project: Pending Fall 2020 Amount of revenue that is ready for recognition within the relevant time period for the Project revenue source, when using the Equal Split recognition method. Populated by the revenue forecast version batch Apex job.

Currency(18,2) false
Equal_Split_Project_Recognized__c Equal Split: Project: Recognized Fall 2020 Amount of revenue that has already been recognized within the relevant time period for the Project revenue source, when using the Equal Split recognition method. Populated using data from Revenue Management, if you are using the integration.

Currency(18,2) false
Equal_Split_Project_Scheduled__c Equal Split: Project: Scheduled Fall 2020 Amount of revenue that is scheduled for recognition within the relevant time period for the Project revenue source, when using the Equal Split recognition method.

Currency(18,2) false
Eva_Scheduled__c Deliverable: EVA: Scheduled Fall 2020 Amount of revenue that is scheduled for recognition within the relevant time period for the EVA revenue source, when using the Deliverable recognition method.

Currency(18,2) false
Expense_Pending__c Deliverable: Expense: Pending Fall 2020 Amount of revenue that is ready for recognition within the relevant time period for the Expense revenue source, when using the Deliverable recognition method. Populated by the revenue forecast version batch Apex job.

Currency(18,2) false
Expense_Recognized__c Deliverable: Expense: Recognized Fall 2020 Amount of revenue that has already been recognized within the relevant time period for the Expense revenue source, when using the Deliverable recognition method. Populated using data from Revenue Management, if you are using the integration.

Currency(18,2) false
Group__c Group Spring 2021 Lookup to the group this revenue forecast version detail relates to.

Looks up to: Grp__c
Lookup false
Milestone_Pending__c Deliverable: Milestone: Pending Fall 2020 Amount of revenue that is ready for recognition within the relevant time period for the Milestone revenue source, when using the Deliverable recognition method. Populated by the revenue forecast version batch Apex job.

Currency(18,2) false
Milestone_Recognized__c Deliverable: Milestone: Recognized Fall 2020 Amount of revenue that has already been recognized within the relevant time period for the Milestone revenue source, when using the Deliverable recognition method. Populated using data from Revenue Management, if you are using the integration.

Currency(18,2) false
Milestone_Scheduled__c Deliverable: Milestone: Scheduled Fall 2020 Amount of revenue that is scheduled for recognition within the relevant time period for the Milestone revenue source, when using the Deliverable recognition method.

Currency(18,2) false
Milestone__c Milestone Fall 2020 Lookup to the milestone this revenue forecast version detail relates to.

Looks up to: Milestone__c
Lookup false
Misc_Adjustment_Pending__c Deliverable: Misc Adjustment: Pending Fall 2020 Amount of revenue that is ready for recognition within the relevant time period for the Miscellaneous Adjustment revenue source, when using the Deliverable recognition method. Populated by the revenue forecast version batch Apex job.

Currency(18,2) false
Misc_Adjustment_Recognized__c Deliverable: Misc Adjustment: Recognized Fall 2020 Amount of revenue already recognized within the relevant time period for the Miscellaneous Adjustment revenue source, when using the Deliverable recognition method. Populated using data from Revenue Management, if you are using the integration.

Currency(18,2) false
Opportunity_Probability__c Opportunity Probability (%) Spring 2021 The probability of the opportunity that this revenue forecast version detail relates to.

Percent(3,0) false
Opportunity_Unscheduled_Best__c Opportunity: Unscheduled Best Spring 2021 Amount of unscheduled revenue within the relevant time period for the Opportunity revenue source, using the best case scenario.

Currency(18,2) false
Opportunity_Unscheduled_Worst__c Opportunity: Unscheduled Worst Spring 2021 Amount of unscheduled revenue within the relevant time period for the Opportunity revenue source, using the worst case scenario.

Currency(18,2) false
Opportunity_Unscheduled__c Opportunity: Unscheduled Fall 2020 Amount of unscheduled revenue within the relevant time period for the Opportunity revenue source, using the expected scenario.

Currency(18,2) false
Opportunity__c Opportunity Fall 2020 Lookup to the opportunity this revenue forecast version detail relates to.

Looks up to: Opportunity

Lookup false
Percent_Complete_Milestone_Pending__c % Complete: Milestone: Pending Fall 2020 Amount of revenue that is ready for recognition within the relevant time period for the Milestone revenue source, when using the % Complete recognition method. Populated by the revenue forecast version batch Apex job.

Currency(18,2) false
Percent_Complete_Milestone_Recognized__c % Complete: Milestone: Recognized Fall 2020 Amount of revenue that has already been recognized within the relevant time period for the Milestone revenue source, when using the % Complete recognition method. Populated using data from Revenue Management, if you are using the integration.

Currency(18,2) false
Percent_Complete_Milestone_Scheduled__c % Complete: Milestone: Scheduled Fall 2020 Amount of revenue that is scheduled for recognition within the relevant time period for the Milestone revenue source, when using the % Complete recognition method.

Currency(18,2) false
Percent_Complete_Milestone_Unscheduled__c % Complete: Milestone: Unscheduled Fall 2020 Amount of unscheduled revenue within the relevant time period for the Milestone revenue source, when using the % Complete recognition method.

Currency(18,2) false
Percent_Complete_Project_Pending__c % Complete: Project: Pending Fall 2020 Amount of revenue that is ready for recognition within the relevant time period for the Project revenue source, when using the % Complete recognition method. Populated by the revenue forecast version batch Apex job.

Currency(18,2) false
Percent_Complete_Project_Recognized__c % Complete: Project: Recognized Fall 2020 Amount of revenue that has already been recognized within the relevant time period for the Project revenue source, when using the % Complete recognition method. Populated using data from Revenue Management, if you are using the integration.

Currency(18,2) false
Percent_Complete_Project_Scheduled__c % Complete: Project: Scheduled Fall 2020 Amount of revenue that is scheduled for recognition within the relevant time period for the Project revenue source, when using the % Complete recognition method.

Currency(18,2) false
Percent_Complete_Project_Unscheduled__c % Complete: Project: Unscheduled Fall 2020 Amount of unscheduled revenue within the relevant time period for the Project revenue source, when using the % Complete recognition method.

Currency(18,2) false
Practice__c Practice Spring 2021 Lookup to the practice this revenue forecast version detail relates to.

Looks up to: Practice__c
Lookup false
Project__c Project Fall 2020 Lookup to the project this revenue forecast version detail relates to.

Looks up to: Proj__c
Lookup false
Region__c Region Spring 2021 Lookup to the region this revenue forecast version detail relates to.

Looks up to: Region__c
Lookup false
Revenue_Forecast_Version__c Revenue Forecast Version Fall 2020 Lookup to the revenue forecast version this record relates to.

Looks up to: Revenue_Forecast_Version__c
MasterDetail
Scheduled_Total__c Scheduled Total Summer 2023 The total amount of scheduled revenue within the relevant time period.

Formula:
Equal_Split_Milestone_Scheduled__c + Equal_Split_Project_Scheduled__c + Eva_Scheduled__c + Milestone_Scheduled__c + Percent_Complete_Milestone_Scheduled__c + Percent_Complete_Milestone_Unscheduled__c + Percent_Complete_Project_Scheduled__c + Percent_Complete_Project_Unscheduled__c
Currency(18,2) false
Time_Period_End__c Time Period End Fall 2020 End date of the time period this record relates to.

Date false
Time_Period_Start__c Time Period Start Fall 2020 Start date of the time period this record relates to.

Date false
Time_Period__c Time Period Fall 2020 Lookup to the time period this revenue forecast version detail relates to.

Looks up to: Time_Period__c
Lookup false
Timecard_Pending__c Deliverable: Timecard: Pending Fall 2020 Amount of revenue that is ready for recognition within the relevant time period for the Timecard revenue source, when using the Deliverable recognition method. Populated by the revenue forecast version batch Apex job.

Currency(18,2) false
Timecard_Recognized__c Deliverable: Timecard: Recognized Fall 2020 Amount of revenue that has already been recognized within the relevant time period for the Timecard revenue source, when using the Deliverable recognition method. Populated using data from Revenue Management, if you are using the integration.

Currency(18,2) false


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