Estimate Builder Lightning Component Fields

The table below shows the objects displayed in the Estimate Builder component and how the cell values for each column is determined for each record type.

For more information about the Lightning App Builder properties for this component, see Estimate Builder Lightning Component Properties.

Key:

* – Mandatory field

R – Read-only

FP – Only used for records with a billing type of Fixed Price

TM – Only used for records with a billing type of Time & Materials

Column Name

Record Type

 

Description
Bill Rate Estimate Product

FP

R

The total bill amount of the estimate product's child records. Includes discounts on the estimate product, child line sets, tasks, and role requests, and the estimate's global discount.
Line Set

FP

R

The total bill amount of the line set's child records. Includes discounts on the line set, parent estimate product, child tasks and role requests, and the estimate's global discount.
Task

FP

R

The value in the Bill Amount field on the task record. Includes discounts on the task, parent estimate product and line set, child role requests, and the estimate's global discount.
Role Request FP The value in the Suggested Bill Rate field on the role request record, or the Bill Rate Override field if an override exists. Includes discounts on the role request, parent estimate product, line set, and task, and the estimate's global discount.
Billing Type Estimate Product   The value in the Billing Type field on the estimate product instance record.
Line Set R The value in the Billing Type field on the line set instance record.
Cost Rate Estimate Product R The total cost amount of the estimate product's child records.
Line Set R The total cost amount of the line set's child records.
Task R The value in the Cost Amount field on the task record.
Role Request   The value in the Actual Cost Rate field on the role request record.
Discount (Percent) Estimate Product   The value in the Discount (%) field on the estimate product record.
Line Set TM The value in the Discount (%) field on the line set record.
Task TM The value in the Discount (%) field on the task record.
Role Request TM The value in the Discount (%) field on the role request record.
End Date Estimate Product   The value in the End Date field on the estimate product record.
Line Set   The value in the End Date field on the line set record.
Task   The value in the End Date field on the task record.
Role Request * The value in the End Date field on the role request record.
Group Role Request   The value in the Group field on the role request record.

Hours

Estimate Product R The total number of hours of the estimate product's child records.
Line Set R The total number of hours of the line set's child records.
Task R The value in the Hours field on the task record.
Role Request * The value in the Hours field on the role request record.
Margin (Amount) Estimate Product R The net bill amount of the estimate product minus the cost rate. Includes discounts on the estimate product, child line sets, tasks, and role requests, and the estimate's global discount.
Line Set R The net bill amount of the line set minus the cost rate. Includes discounts on the line set, parent estimate product, child tasks and role requests, and the estimate's global discount.
Task R The net bill amount of the task minus the cost rate. Includes discounts on the task, parent estimate product and line set, child role requests, and the estimate's global discount.
Role Request R

The following calculation is used: Net Bill Amount - (Cost Rate * Hours). Includes discounts on the role request, parent estimate product, line set, and task, and the estimate's global discount.

Margin (Percent) Estimate Product FP The margin amount of the estimate product as a percentage. Includes the estimate's global discount. If the estimate product has a billing type of Time & Materials, this includes discounts on the estimate product, child line sets, tasks, and role requests, and the estimate's global discount.
Line Set R The margin amount of the line set as a percentage. Includes the estimate's global discount. If the line set has a billing type of Time & Materials, this includes discounts on the line set, parent estimate product, child tasks and role requests, and the estimate's global discount.
Task R The margin amount of the task as a percentage. If the task has a billing type of Time & Materials, this includes the estimate's global discount. Includes discounts on the task, parent estimate product and line set, child role requests, and the estimate's global discount.
Role Request R The margin amount of the role request as a percentage. If the role request has a billing type of Time & Materials, this includes the estimate's global discount. Includes discounts on the role request, parent estimate product, line set, and task, and the estimate's global discount.
Name Estimate Product * The value in the Name field on the estimate product record.
Line Set * The value in the Name field on the line set record.
Task * The value in the Name field on the task record.
Role Request * The value in the Role field on the role request record.
Net Bill Amount Estimate Product R The total net bill amount of the estimate product's child records. Includes discounts on the estimate product, child line sets, tasks, and role requests, and the estimate's global discount.
Line Set R The total net bill amount of the line set's child records. Includes discounts on the line set, parent estimate product, child tasks and role requests, and the estimate's global discount.
Task R The net amount of the task minus the global discount on the estimate. Includes discounts on the task, parent estimate product and line set, child role requests, and the estimate's global discount.
Role Request R The net amount of the role request minus the global discount on the estimate. Includes discounts on the role request, parent estimate product, line set, and task, and the estimate's global discount.
Practice Role Request   The value in the Practice field on the role request record.
Region Role Request   The value in the Region field on the role request record.
Skills Role Request   Comma separated list of the skills on the related role skill request record.
Start Date Estimate Product * The value in the Start Date field on the estimate product record.
Line Set   The value in the Start Date field on the line set record.
Task   The value in the Start Date field on the task record.
Role Request * The value in the Start Date field on the role request record.

Buttons

Buttons in the Estimate Builder Component
Button Name Description Further Information
Refresh button in Estimate Builder component Refresh Refreshes the Estimate Builder component to display any external changes.  
Hours Breakdown button in Estimate Builder component Hours Breakdown

Opens the Hours Breakdown view, where you can specify the hours for each role request for the selected task per week.

Adding Role Requests to an Estimate
Collapse All button in Estimate Builder component Collapse All Collapses all records in the builder so that only the highest level records are visible.  
Expand All button in Estimate Builder component Expand All Expands all records in the builder so that all of the estimate's records are visible.  
Undo button in Estimate Builder component Undo Undoes changes made in the builder, up to the last save.  
Redo button in Estimate Builder component Redo Redoes the previous undo action.  
Delete button in Estimate Builder component Delete

Deletes the selected records.

Tip:

You can delete multiple records by selecting the checkboxes next to the records you want to delete, or by holding down Command (Mac), Ctrl (PC) while selecting a cell on the row of the records you want to delete. Then, click .

 
Add Line Set button in Estimate Builder component Add Line Set Adds a line set to the estimate. Adding Line Sets to an Estimate
Add Role Request button in Estimate Builder component Add Role Request Adds a role request to the estimate. Adding Role Requests to an Estimate
Add Task button in Estimate Builder component Add Task Adds a task to the estimate. Adding Tasks to an Estimate