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 VersionDescriptionTypeDefault 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)
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)
Corp_Currency__c Corp: Currency Fall 2020 The corporate currency of the org at the time the revenue forecast was run.

Text(3)
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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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)
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) 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) 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)
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)
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)
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)
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)
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)
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)
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)
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)
Group__c Group Spring 2021 Lookup to the group this revenue forecast version detail relates to.

Looks up to: Grp__c
Lookup
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)
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)
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)
Milestone__c Milestone Fall 2020 Lookup to the milestone this revenue forecast version detail relates to.

Looks up to: Milestone__c
Lookup
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)
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)
Opportunity_Probability__c Opportunity Probability (%) Spring 2021 The probability of the opportunity that this revenue forecast version detail relates to.

Percent(3,0)
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)
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)
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)
Opportunity__c Opportunity Fall 2020 Lookup to the opportunity this revenue forecast version detail relates to.

Looks up to: Opportunity

Lookup
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)
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)
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)
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)
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)
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)
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)
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)
Practice__c Practice Spring 2021 Lookup to the practice this revenue forecast version detail relates to.

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

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

Looks up to: Region__c
Lookup
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)
Time_Period_End__c Time Period End Fall 2020 End date of the time period this record relates to.

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

Date
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
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)
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)


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