Revenue Management Data Dictionary

RevenueContract__c

Label: Revenue Contract

Represents a single revenue contract between a vendor and a customer.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AccountName__c Display Information Pre-Spring 2018 The name of the account for this Revenue Contract.

Text(255)
Account__c Account Pre-Spring 2018 Looks up to: Account

Lookup
Active__c Active Pre-Spring 2018 Indicates whether this Revenue Contract is active.

Checkbox true
Allocatable__c Ready for Allocation Pre-Spring 2018 Indicates whether allocation can be run successfully for this Revenue Contract.

Formula:
Revenue__c != 0 && NullSSPCount__c = 0 && TotalSSP__c != 0
Checkbox
AllocationRatio__c Allocation Ratio Pre-Spring 2018 The ratio used to allocate revenue to linked Performance Obligations where the Allocated Revenue value has not been overridden.

Formula:
IF(NullSSPCount__c <> 0 || TotalSSPForAllocation__c = 0, null, (Revenue__c - TotalAllocatedRevenueOverride__c) / TotalSSPForAllocation__c)
Number(18,14)
AllocationStatus__c Allocation Status Pre-Spring 2018 Shows if the Revenue for this contract has been fully allocated, or needs reallocating.

Formula:
IF( RevenueAllocated__c, IMAGE('/img/msg_icons/confirm16.png', $Label.RevenueAllocatedSuccessfully ) & ' ' & $Label.RevenueAllocatedSuccessfully, IF ( Revenue__c = 0, IMAGE('/img/msg_icons/warning16.png', $Label.NoRevenueToAllocate ) & ' ' & $Label.NoRevenueToAllocate, IF ( NullSSPCount__c > 0, IMAGE('/img/msg_icons/error16.png', SUBSTITUTE($Label.NullSSPCountGreaterThanZero, '{0}', TEXT( NullSSPCount__c ) ) ) & ' ' & SUBSTITUTE($Label.NullSSPCountGreaterThanZero, '{0}', TEXT( NullSSPCount__c ) ), IF ( TotalSSP__c = 0, IMAGE('/img/msg_icons/error16.png', $Label.TotalSSPIsZero ) & ' ' & $Label.TotalSSPIsZero, IF ( TotalNullAllocationRatioCount__c > 0, IMAGE('/img/msg_icons/warning16.png', $Label.RevenueNotAllocated ) & ' ' & $Label.RevenueAllocationNotRun, IMAGE('/img/msg_icons/warning16.png', $Label.RevenueNotAllocated ) & ' ' & $Label.RevenueNotAllocated ) ) ) ) )
Text
Company__c Company Summer 2023 Lookup to the company object.

Looks up to: fferpcore__Company__c

Lookup
CurrencyDP__c Currency Decimal Places Summer 2023 Number of decimal places on the record's currency.

Number(1,0)
Description__c Description Pre-Spring 2018 The description of this Revenue Contract.

Text(255)
EndDate__c End Date Pre-Spring 2018 The end date of this Revenue Contract.

Date
Engagement__c Engagement Summer 2023 Engagement this revenue contract relates to.

Looks up to: fferpcore__ff_Engagement__c

Lookup
NullSSPCount__c Null SSP Count Pre-Spring 2018 The number of Performance Obligations relating to revenue that have at least one null SSP value.

Summary
POAllocatedRevenueOverrideCount__c PO Allocated Revenue Override Count Pre-Spring 2018 The number of linked Performance Obligations where an Allocated Revenue Override value has been entered.

Summary
PerformanceObligationsCount__c Performance Obligations Count Pre-Spring 2018 The number of Performance Obligations on this Contract.

Summary
RevenueAllocated__c Revenue Allocated Pre-Spring 2018 Indicates if the Revenue for this contract has been allocated successfully.

Formula:
ROUND(Revenue__c, IF(ISBLANK(CurrencyDP__c), 2, CurrencyDP__c)) = ROUND(TotalAllocatedRevenue__c, IF(ISBLANK(CurrencyDP__c), 2, CurrencyDP__c)) && ROUND(TotalAllocatedRevenue__c, IF(ISBLANK(CurrencyDP__c), 2, CurrencyDP__c)) <> 0 && TotalNullAllocationRatioCount__c = 0
Checkbox
RevenueOverride__c Revenue Override Pre-Spring 2018 When populated this value is used in the Revenue field.

Currency(16,2)
RevenueRecognitionComplete__c Recognition Complete Pre-Spring 2018 Indicates whether this Revenue Contract is fully recognized.

Formula:
IF(Revenue__c = 0 && TotalRecognizedToDate__c = 0 && TotalCost__c = 0 && TotalAmortizedToDate__c = 0, false, Revenue__c == TotalRecognizedToDate__c && TotalCost__c == TotalAmortizedToDate__c)
Checkbox
Revenue__c Revenue Pre-Spring 2018 The value that will be allocated to the Performance Obligations. Uses Total Revenue, or Revenue Override if populated.

Formula:
ROUND(IF(ISBLANK(RevenueOverride__c), TotalRevenue__c, RevenueOverride__c), IF(ISBLANK(CurrencyDP__c), 2, CurrencyDP__c))
Currency(18,3)
StartDate__c Start Date Pre-Spring 2018 The start date for this Revenue Contract.

Date
TotalAllocatedRevenueOverride__c Total Allocated Revenue Override Pre-Spring 2018 Sum of Allocated Revenue Override values from all linked Performance Obligations.

Summary
TotalAllocatedRevenue__c Total Allocated Revenue Pre-Spring 2018 Total Allocated Revenue for this Revenue Contract.

Summary
TotalAmortizedToDate__c Total Cost Recognized To Date Spring 2018 Total Cost Recognized To Date for this Revenue Contract.

Summary
TotalCost__c Total Cost Spring 2018 Sum of Cost values from all linked Performance Obligations.

Summary
TotalNullAllocationRatioCount__c Null Allocation Ratio Count Pre-Spring 2018 The number of linked Performance Obligations where the Allocation Ratio and Allocated Revenue Override fields are null.

Summary
TotalRecognizedToDate__c Total Revenue Recognized To Date Pre-Spring 2018 Total Revenue Recognized To Date for this Revenue Contract.

Summary
TotalRevenue__c Total Revenue Pre-Spring 2018 Sum of Revenue values from all linked Performance Obligations.

Summary
TotalSSPForAllocation__c Total SSP for Allocation Pre-Spring 2018 Sum of SSP values for linked Performance Obligations where the Allocated Revenue value has not been overridden.

Summary
TotalSSP__c Total SSP Pre-Spring 2018 Sum of Standalone Selling Prices from all linked Performance Obligations.

Summary
ZeroSSPCount__c Zero SSP Count Pre-Spring 2018 The number of Performance Obligations relating to revenue where SSP is zero.

Summary
ffrrtemplate__c Recognition Template Pre-Spring 2018 Looks up to: Template__c
Lookup


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