Services Estimator Data Dictionary

ffscpq__Estimate_Financial_Summary__c

Label: Estimate Financial Summary

Stores the financial summaries of an estimate or estimate product instance.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
ffscpq__Billable_Expense_Amount_Est_Curr__c Billable Expense Amount (Est Curr) September 2025 The total billable expense amount of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Number(18,4) false
ffscpq__Billable_Expense_Amount__c Billable Expense Amount September 2025 The total billable expense amount of the associated estimate product or independent records in the Financial Summary.

Currency(18,4) false
ffscpq__Billing_Schedule_Amount_Est_Curr__c Billing Schedule Amount (Est Curr) September 2025 The total billing schedule amount of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Formula:
ffscpq__EVLI_Revenue_Estimate_Currency__c + ffscpq__Fixed_Price_Milestone_Amount_Est_Curr__c
Number(18,4) false
ffscpq__Billing_Schedule_Amount__c Billing Schedule Amount September 2025 The total billing schedule amount of the associated estimate product or independent records in the Financial Summary.

Formula:
ffscpq__Estimate_Vendor_Line_Item_Revenue__c + ffscpq__Fixed_Price_Milestone_Amount__c
Currency(18,4) false
ffscpq__Contingency_Revenue_Estimate_Currency__c Contingency Revenue (Estimate Currency) September 2025 The total contingency revenue of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Number(18,4) false
ffscpq__Contingency_Revenue__c Contingency Revenue September 2025 The total contingency revenue of the associated estimate product or independent records in the Financial Summary.

Currency(18,4) false
ffscpq__EVLI_Cost_Estimate_Currency__c EVLI Cost (Estimate Currency) September 2025 The total EVLI cost of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Number(18,4) false
ffscpq__EVLI_Revenue_Estimate_Currency__c EVLI Revenue (Estimate Currency) September 2025 The total EVLI revenue of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Number(18,4) false
ffscpq__End_Date__c End Date September 2025 The end date of the record displayed in the Financial Summary.

Formula:
ffscpq__Time_Period__r.pse__End_Date__c
Date false
ffscpq__Estimate_Product_Instance__c Estimate Product Instance September 2025 The estimate product instance that relates to the Financial Summary.

Looks up to: ffscpq__Estimate_Product_Instance__c
Lookup false
ffscpq__Estimate_Vendor_Line_Item_Cost__c Estimate Vendor Line Item Cost September 2025 The total EVLI cost of the associated estimate product or independent records in the Financial Summary.

Currency(18,4) false
ffscpq__Estimate_Vendor_Line_Item_Revenue__c Estimate Vendor Line Item Revenue September 2025 The total EVLI revenue of the associated estimate product or independent records in the Financial Summary.

Currency(18,4) false
ffscpq__Estimate__c Estimate September 2025 The estimate that relates to the Financial Summary.

Looks up to: ffscpq__Estimate__c
MasterDetail
ffscpq__Fixed_Price_Milestone_Amount_Est_Curr__c Fixed Price Milestone Amount (Est Curr) September 2025 The total fixed price milestone amount of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Number(18,4) false
ffscpq__Fixed_Price_Milestone_Amount__c Fixed Price Milestone Amount September 2025 The total fixed price milestone amount of the associated estimate product or independent records in the Financial Summary.

Currency(18,4) false
ffscpq__Labor_Cost_Estimate_Currency__c Labor Cost (Estimate Currency) September 2025 The total labor cost of role requests of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Number(18,4) false
ffscpq__Labor_Cost__c Labor Cost September 2025 The total labor cost of role requests of the associated estimate product or independent records in the Financial Summary.

Currency(18,4) false
ffscpq__Labor_Revenue_Estimate_Currency__c Labor Revenue (Estimate Currency) September 2025 The total labor revenue of role requests of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Number(18,4) false
ffscpq__Labor_Revenue__c Labor Revenue September 2025 The total labor revenue of role requests of the associated estimate product or independent records in the Financial Summary.

Currency(18,4) false
ffscpq__Non_Billable_Expense_Cost_Est_Curr__c Non-Billable Expense Cost (Est Curr) September 2025 The total non-billable expense cost of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Number(18,4) false
ffscpq__Non_Billable_Expense_Cost__c Non-Billable Expense Cost September 2025 The total non-billable expense cost of the associated estimate product or independent records in the Financial Summary.

Currency(18,4) false
ffscpq__Non_Labor_Cost_Estimate_Currency__c Non-Labor Cost (Estimate Currency) September 2025 The total non-labor cost of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Formula:
ffscpq__EVLI_Cost_Estimate_Currency__c + ffscpq__Non_Billable_Expense_Cost_Est_Curr__c + ffscpq__Services_Product_Cost_Estimate_Currency__c
Number(18,4) false
ffscpq__Non_Labor_Cost__c Non-Labor Cost September 2025 The total non-labor cost of the associated estimate product or independent records in the Financial Summary.

Formula:
ffscpq__Estimate_Vendor_Line_Item_Cost__c + ffscpq__Non_Billable_Expense_Cost__c + ffscpq__Services_Product_Cost__c
Currency(18,4) false
ffscpq__Non_Labor_Revenue_Estimate_Currency__c Non-Labor Revenue (Estimate Currency) September 2025 The total non-labor revenue of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Formula:
ffscpq__EVLI_Revenue_Estimate_Currency__c + ffscpq__Services_Product_Revenue_Est_Curr__c + ffscpq__Contingency_Revenue_Estimate_Currency__c
Number(18,4) false
ffscpq__Non_Labor_Revenue__c Non-Labor Revenue September 2025 The total non-labor revenue of the associated estimate product or independent records in the Financial Summary.

Formula:
ffscpq__Estimate_Vendor_Line_Item_Revenue__c + ffscpq__Services_Product_Revenue__c + ffscpq__Contingency_Revenue__c
Currency(18,4) false
ffscpq__Services_Product_Cost_Estimate_Currency__c Services Product Cost (Est Currency) September 2025 The total services product cost of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Number(18,4) false
ffscpq__Services_Product_Cost__c Services Product Cost September 2025 The total services product cost of the associated estimate product or independent records in the Financial Summary.

Currency(18,4) false
ffscpq__Services_Product_Revenue_Est_Curr__c Services Product Revenue (Est Curr) September 2025 The total services product revenue of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Number(18,4) false
ffscpq__Services_Product_Revenue__c Services Product Revenue September 2025 The total services product revenue of the associated estimate product or independent records in the Financial Summary.

Currency(18,4) false
ffscpq__Start_Date__c Start Date September 2025 The start date of the record displayed in the Financial Summary.

Formula:
ffscpq__Time_Period__r.pse__Start_Date__c
Date false
ffscpq__Summary_Type__c Summary Type September 2025 The type of Financial Summary being created.

Picklist:
Summarize Independent Records or Products
Summarize Whole Estimate
false
ffscpq__Time_Period__c Time Period September 2025 Lookup to the time period set on the Financial Summary.

Looks up to: pse__Time_Period__c

Lookup false
ffscpq__Total_Cost_Estimate_Currency__c Total Cost (Estimate Currency) September 2025 The total cost of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Formula:
ffscpq__Labor_Cost_Estimate_Currency__c + ffscpq__Non_Labor_Cost_Estimate_Currency__c
Number(18,4) false
ffscpq__Total_Cost__c Total Cost September 2025 The total cost of the associated estimate product or independent records in the Financial Summary.

Formula:
ffscpq__Labor_Cost__c + ffscpq__Non_Labor_Cost__c
Currency(18,4) false
ffscpq__Total_Hours__c Total Hours September 2025 The total number of hours all resources are required to work for the corresponding period, in the Financial Summary.

Number(18,2) false
ffscpq__Total_Margin_Estimate_Currency__c Total Margin (Amount, Estimate Currency) September 2025 The difference between the total revenue and total cost, for the associated estimate product or independent records, in the Financial Summary, in the currency of the related estimate.

Formula:
ffscpq__Total_Revenue_Estimate_Currency__c - ffscpq__Total_Cost_Estimate_Currency__c
Number(18,2) false
ffscpq__Total_Margin__c Total Margin (Amount) September 2025 The difference between the total revenue and total cost, for the associated estimate product or independent records, in the Financial Summary.

Formula:
ffscpq__Total_Revenue__c - ffscpq__Total_Cost__c
Currency(18,2) false
ffscpq__Total_Percent_Margin__c Total Margin (%) September 2025 The margin as a percentage of the total revenue for the associated estimate product or independent records in the Financial Summary.

Formula:
IF(ffscpq__Total_Revenue__c = 0, 0, ffscpq__Total_Margin__c / ffscpq__Total_Revenue__c)
Percent(18,2) false
ffscpq__Total_Pricing_Modifiers_Amount__c Total Pricing Modifiers Amount September 2025 The total amount of the pricing modifier records in the Estimate Financial Summary.

Summary
ffscpq__Total_Revenue_Before_Pricing_Modifiers__c Total Revenue Before Pricing Modifiers September 2025 The total revenue of this associated estimate product or independent records in the Financial Summary, before pricing modifiers are applied.

Formula:
ffscpq__Labor_Revenue__c + ffscpq__Non_Labor_Revenue__c
Currency(18,4) false
ffscpq__Total_Revenue_Estimate_Currency__c Total Revenue (Estimate Currency) September 2025 The total revenue of the associated estimate product or independent records in the Financial Summary, in the currency of the related estimate.

Formula:
ffscpq__Labor_Revenue_Estimate_Currency__c + ffscpq__Non_Labor_Revenue_Estimate_Currency__c
Number(18,4) false
ffscpq__Total_Revenue__c Total Revenue September 2025 The total revenue of the associated estimate product or independent records in the Financial Summary.

Formula:
ffscpq__Total_Revenue_Before_Pricing_Modifiers__c + ffscpq__Total_Pricing_Modifiers_Amount__c
Currency(18,4) false


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