Regional_Actuals__c
Label: Regional Actuals Represents rolled-up revenues and costs expressed in the regional currency for a particular time period, as well as total hours for the parent region. Projects and time periods have a master-detail relationship with regional actuals.
Billable_External_Hours__c |
Billable Hours (External) |
Pre-Spring 2018 |
|
Number(18,2) |
0.00 |
Billable_Internal_Hours__c |
Billable Hours (Internal) |
Pre-Spring 2018 |
|
Number(18,2) |
0.00 |
Billed__c |
Billed |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Billings__c |
Billings |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Bookings__c |
Bookings |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Credited_Non_Billable_Internal_Hours__c |
Credited Hours |
Pre-Spring 2018 |
|
Number(18,2) |
0.00 |
End_Date__c |
End Date |
Pre-Spring 2018 |
Formula: Time_Period__r.End_Date__c
|
Date |
|
Excluded_Hours__c |
Excluded Hours |
Pre-Spring 2018 |
|
Number(18,2) |
0.00 |
Expense_Budget__c |
Expense Budget |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Expense_Costs__c |
Expense Costs |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
External_Costs__c |
External Costs |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Internal_Budget__c |
Internal Budget |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Internal_Costs__c |
Internal Costs |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Invoiced__c |
Invoiced |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Is_Verification__c |
Is Verification |
Pre-Spring 2018 |
Contains true if this record serves to verify the contents of another record
|
Checkbox |
false |
Margin__c |
Margin |
Pre-Spring 2018 |
Formula: Billings__c + Pass_Through_Billings__c - Internal_Costs__c - External_Costs__c - Expense_Costs__c - Other_Costs__c
|
Currency(18,2) |
|
Non_Billable_External_Hours__c |
Non-Billable Hours (External) |
Pre-Spring 2018 |
|
Number(18,2) |
0.00 |
Non_Billable_Internal_Hours__c |
Non-Billable Hours (Internal) |
Pre-Spring 2018 |
|
Number(18,2) |
0.00 |
Other_Costs__c |
Other Costs |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Pass_Through_Billings__c |
Pass-Through Billings |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Pre_Billed__c |
Pre-Billed |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Region_Head__c |
Region Owner |
Pre-Spring 2018 |
Formula: Region__r.Region_Head__r.FirstName & " " & Region__r.Region_Head__r.LastName
|
Text |
|
Region__c |
Region |
Pre-Spring 2018 |
Looks up to: Region__c
|
MasterDetail |
|
Revenue__c |
Revenue |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Scheduled_Backlog_Calculated_Date__c |
Scheduled Backlog Calculated Date |
Pre-Spring 2018 |
|
Date |
Today() |
Scheduled_Milestone__c |
Scheduled Milestone |
Pre-Spring 2018 |
|
Currency(18,2) |
|
Scheduled_Time__c |
Scheduled Time |
Pre-Spring 2018 |
|
Currency(18,2) |
|
Start_Date__c |
Start Date |
Pre-Spring 2018 |
Formula: Time_Period__r.Start_Date__c
|
Date |
|
Time_Period_Type__c |
Time Period Type |
Pre-Spring 2018 |
Formula: TEXT(Time_Period__r.Type__c)
|
Text |
|
Time_Period__c |
Time Period |
Pre-Spring 2018 |
Looks up to: Time_Period__c
|
MasterDetail |
|
Total_Costs__c |
Total Costs |
Pre-Spring 2018 |
Formula: Internal_Costs__c + External_Costs__c + Expense_Costs__c + Other_Costs__c
|
Currency(18,2) |
|
Unique_Name__c |
Unique Name |
Pre-Spring 2018 |
|
Text(80) |
|
Unscheduled_Backlog__c |
Unscheduled Backlog |
Pre-Spring 2018 |
|
Currency(18,2) |
|
Verified_By__c |
Verified By |
Pre-Spring 2018 |
Self-join to store a temporary recalculation of the actuals for verification purposes
Looks up to: Regional_Actuals__c
|
Lookup |
|
|