Account__c |
Account |
Pre-Spring 2018 |
Looks up to: Account
|
Lookup |
false |
|
Admin_Global_Edit__c |
Admin Global Edit |
Pre-Spring 2018 |
If checked, allows Admin to make 'global' changes to the Budget, including edits to the Budget's Project, Resource, Currency, or Date, even if Include In Financials is checked. Config requirement: Actuals Calculation Mode must be set to 'Scheduled'.
|
Checkbox |
|
false |
Amount_Consumed_Alert_Threshold_1__c |
Amount Consumed Alert Threshold 1 |
Summer 2024 |
A percentage of the budget's Amount. When the budget's Amount Consumed exceeds this value, the Project Manager and the Alert Recipient (if populated on the project) are notified.
|
Percent(6,2) |
false |
|
Amount_Consumed_Alert_Threshold_2__c |
Amount Consumed Alert Threshold 2 |
Summer 2024 |
A percentage of the budget's Amount. When the budget's Amount Consumed exceeds this value, the Project Manager and the Alert Recipient (if populated on the project) are notified.
|
Percent(6,2) |
false |
|
Amount_Consumed__c |
Amount Consumed |
Spring 2024 |
The monetary amount of this budget that has been consumed. Must be the same currency as the project.
|
Currency(18,2) |
false |
0.00 |
Amount_Consumed_by_Expenses__c |
Amount Consumed by Expenses |
Summer 2024 |
The monetary amount of this budget that has been consumed by expenses. Must be the same currency as the project.
|
Currency(18,2) |
false |
0.00 |
Amount_Consumed_by_Milestones__c |
Amount Consumed by Milestone Fees |
Summer 2024 |
The monetary amount of this budget that has been consumed by milestones. Must be the same currency as the project.
|
Currency(18,2) |
false |
0.00 |
Amount_Consumed_by_Misc_Adjustments__c |
Amount Consumed by Misc Adjustments |
Summer 2024 |
The monetary amount of this budget that has been consumed by miscellaneous adjustments. Must be the same currency as the project.
|
Currency(18,2) |
false |
0.00 |
Amount_Consumed_by_Timecard_Splits__c |
Amount Consumed by Timecard Splits |
Summer 2024 |
The monetary amount of this budget that has been consumed by timecard splits. Must be the same currency as the project.
|
Currency(18,2) |
false |
0.00 |
Amount_Released__c |
Amount Released for Invoicing |
Winter 2025 |
A billing event item is included in this amount when its related business record, which must be allocated to this budget, is marked as billed.
|
Currency(18,2) |
false |
0.00 |
Amount_Remaining__c |
Amount Remaining |
Summer 2024 |
The monetary amount of this budget that has not been consumed yet.
Formula: Amount__c - Amount_Consumed__c
|
Currency(18,2) |
false |
|
Amount__c |
Amount |
Pre-Spring 2018 |
The monetary amount for the Budget, not including any amount entered separately in the Expense Amount field. Defaults to and must always be same currency as Project.
|
Currency(18,2) |
true |
0.00 |
Apply_Billing_Cap__c |
Apply Billing Cap |
Summer 2024 |
This field controls both the prevention of billing event release (if no budget amount remains), and the optimization of billing event items to allow releasing the budget's full amount (if some budget amount remains). For optimization during bulk release, the project's Bill to Budget Cap field must also be set.
|
Checkbox |
|
false |
Approved__c |
Approved |
Pre-Spring 2018 |
This checkbox should be checked when the Budget is approved - typically by a workflow driven by the Status field.
|
Checkbox |
|
false |
Approved_for_Billing__c |
Approved for Billing |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead.
|
Checkbox |
|
false |
Approver__c |
Approver |
Pre-Spring 2018 |
Looks up to: User
|
Lookup |
false |
|
Audit_Notes__c |
Audit Notes |
Pre-Spring 2018 |
|
TextArea |
false |
|
Bill_Date__c |
Bill Date |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead.
|
Date |
false |
|
Billable__c |
Billable |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead.
|
Checkbox |
|
false |
Billed__c |
Billed |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead.
|
Checkbox |
|
false |
Billing_Event_Invoiced__c |
Billing Event Invoiced |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead. Reflects Invoiced flag value on Billing Event Item's parent Billing Event
Formula: IF(OR(ISNULL(Billing_Event_Item__c),ISBLANK(Billing_Event_Item__c),ISNULL(Billing_Event_Item__r.Billing_Event__c),ISBLANK(Billing_Event_Item__r.Billing_Event__c)),$Label.common_label_n_a,IF(Billing_Event_Item__r.Billing_Event__r.Invoiced__c,$Label.common_label_yes,$Label.common_label_no))
|
Text |
false |
|
Billing_Event_Item__c |
Billing Event Item |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead.
Looks up to: Billing_Event_Item__c
|
Lookup |
false |
|
Billing_Event_Released__c |
Billing Event Released |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead. Reflects Released flag value on Billing Event Item's parent Billing Event
Formula: IF(OR(ISNULL(Billing_Event_Item__c),ISBLANK(Billing_Event_Item__c),ISNULL(Billing_Event_Item__r.Billing_Event__c),ISBLANK(Billing_Event_Item__r.Billing_Event__c)),$Label.common_label_n_a,IF(Billing_Event_Item__r.Billing_Event__r.Is_Released__c,$Label.common_label_yes,$Label.common_label_no))
|
Text |
false |
|
Billing_Event_Status__c |
Billing Event Status |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead. Status pick list value on Billing Event Item's parent Billing Event
Formula: IF(OR(ISNULL(Billing_Event_Item__c),ISBLANK(Billing_Event_Item__c),ISNULL(Billing_Event_Item__r.Billing_Event__c),ISBLANK(Billing_Event_Item__r.Billing_Event__c)),'',TEXT(Billing_Event_Item__r.Billing_Event__r.Status__c))
|
Text |
false |
|
Billing_Event__c |
Billing Event |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead. Formula hyperlink to the Billing Event (parent record to the Bill Event Item) if any.
Formula: IF(OR(ISNULL(Billing_Event_Item__c),ISBLANK(Billing_Event_Item__c),ISNULL(Billing_Event_Item__r.Billing_Event__c),ISBLANK(Billing_Event_Item__r.Billing_Event__c)),'',HYPERLINK('/'&Billing_Event_Item__r.Billing_Event__c, IF(OR(ISNULL(Billing_Event_Item__r.Billing_Event__r.Name),ISBLANK(Billing_Event_Item__r.Billing_Event__r.Name)),Billing_Event_Item__r.Billing_Event__c,(Billing_Event_Item__r.Billing_Event__r.Name))))
|
Text |
false |
|
Billing_Hold__c |
Billing Hold |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead.
|
Checkbox |
|
false |
Budget_Header__c |
Budget Header |
Pre-Spring 2018 |
Looks up to: Budget_Header__c
|
Lookup |
false |
|
Customer_Reference__c |
Customer Reference |
Spring 2024 |
The customer purchase order number that this budget represents.
|
Text(50) |
false |
|
Description__c |
Description |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
|
Effective_Date__c |
Effective Date |
Pre-Spring 2018 |
|
Date |
true |
Today() |
Eligible_for_Billing__c |
Eligible for Billing |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead. Indicates Budget is in a state that is eligible for Billing Event Generation (not including the Approved for Billing flag, which may also be required per global config). This means all of the following conditions must be met: Billing Hold = false Exclude from Billing = false Include In Financials = true Billable = true Billed = false Invoiced = false Billing Event Item = {blank} Project = {not blank} Project's Account = {not blank} Project Exclude From Billing = false
Formula: IF(AND(NOT(Billing_Hold__c),NOT(Exclude_from_Billing__c),Include_In_Financials__c,Billable__c,NOT(Billed__c),NOT(Invoiced__c),OR(ISNULL(Billing_Event_Item__c),ISBLANK(Billing_Event_Item__c)),NOT(OR(ISNULL(Project__c),ISBLANK(Project__c))),NOT(OR(ISNULL(Project__r.Account__c),ISBLANK(Project__r.Account__c))),NOT(Project__r.Exclude_From_Billing__c)),$Label.common_label_yes,$Label.common_label_no)
|
Text |
false |
|
Exclude_from_Billing__c |
Exclude from Billing |
Pre-Spring 2018 |
>This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead. If checked, never bill this business record. Same effect as Billing Hold, but intended to reflect a permanent exclusion from Billing Generation.
|
Checkbox |
|
false |
Expense_Amount__c |
Expense Amount |
Pre-Spring 2018 |
The monetary amount (if any) explicitly set aside for Expenses in the Budget. This is separate from and in addition to the Budget Amount field. Defaults to and must always be same currency as Project.
|
Currency(18,2) |
false |
0.00 |
Expense_Transaction__c |
Expense Transaction |
Pre-Spring 2018 |
Looks up to: Transaction__c
|
Lookup |
false |
|
Include_In_Financials__c |
Include In Financials |
Pre-Spring 2018 |
|
Checkbox |
|
false |
Invoice_Date__c |
Invoice Date |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead.
|
Date |
false |
|
Invoice_Number__c |
Invoice Number |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead.
|
Text(80) |
false |
|
Invoiced__c |
Invoiced |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead.
|
Checkbox |
|
false |
Opportunity__c |
Opportunity |
Pre-Spring 2018 |
Looks up to: Opportunity
|
Lookup |
false |
|
Override_Project_Group_Currency_Code__c |
Override Project Group Currency Code |
Pre-Spring 2018 |
Formula: TEXT(Override_Project_Group__r.CurrencyIsoCode)
|
Text |
false |
|
Override_Project_Group__c |
Override Project Group |
Pre-Spring 2018 |
If this field is set, it overrides the Group to which a Budget's Transactions will roll up for Group Actuals, even if its Project is in a different Group. Typically a Budget's Transactions roll up to its Project's Group. Note that either way, the Transactions will continue to roll up to the same Project's Project Actuals.
Looks up to: Grp__c
|
Lookup |
false |
|
Override_Project_Practice_Currency_Code__c |
Override Project Practice Currency Code |
Pre-Spring 2018 |
Formula: TEXT(Override_Project_Practice__r.CurrencyIsoCode)
|
Text |
false |
|
Override_Project_Practice__c |
Override Project Practice |
Pre-Spring 2018 |
If this field is set, it overrides the Practice to which a Budget's Transactions will roll up for Practice Actuals, even if its Project is in a different Practice. Typically a Budget's Transactions roll up to its Project's Practice. Note that either way, the Transactions will continue to roll up to the same Project's Project Actuals.
Looks up to: Practice__c
|
Lookup |
false |
|
Override_Project_Region_Currency_Code__c |
Override Project Region Currency Code |
Pre-Spring 2018 |
Formula: TEXT(Override_Project_Region__r.CurrencyIsoCode)
|
Text |
false |
|
Override_Project_Region__c |
Override Project Region |
Pre-Spring 2018 |
If this field is set, it overrides the Region to which a Budget's Transactions will roll up for Regional Actuals, even if its Project is in a different Region. Typically a Budget's Transactions roll up to its Project's Region. Note that either way, the Transactions will continue to roll up to the same Project's Project Actuals.
Looks up to: Region__c
|
Lookup |
false |
|
PreBilledAmount__c |
DEPRECATED: Pre-Billed Amount |
Pre-Spring 2018 |
The field is deprecated. It has been replaced by Pre_Billed_Amount__c.
|
Currency(18,0) |
false |
|
Pre_Billed_Amount__c |
Pre-Billed Amount |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead. The portion of the combined Budget/Expense Amounts to be pre-billed. Defaults to and must always be same currency as Project. This field is a replacement for the old Pre-Billed Amount field (PreBilledAmount__c) which did not allow non-integer decimals.
|
Currency(18,2) |
false |
|
Pre_Billed_Transaction__c |
Pre-Billed Transaction |
Pre-Spring 2018 |
This field will be deprecated in a future release. Instead of billing a budget record, use a milestone or misc. adjustment instead.
Looks up to: Transaction__c
|
Lookup |
false |
|
Project__c |
Project |
Pre-Spring 2018 |
Looks up to: Proj__c
|
Lookup |
false |
|
Status__c |
Status |
Pre-Spring 2018 |
|
Picklist: Approved Draft Open Rejected |
false |
|
Total_Amount__c |
Total Amount |
Pre-Spring 2018 |
This field will be deprecated in a future release. This used to sum the Amount and Expense Amount fields. We now recommend storing expenses on a separate budget, in which case the Amount field will hold the total amount for the budget.
Formula: Amount__c + Expense_Amount__c
|
Currency(18,2) |
false |
|
Transaction__c |
Transaction |
Pre-Spring 2018 |
Looks up to: Transaction__c
|
Lookup |
false |
|
Type__c |
Type |
Pre-Spring 2018 |
|
Picklist: Billable Expenses Customer Purchase Order Customer Purchase Order Change Request Internal Budget Internal Budget Change Request Non-Billable Expenses Vendor Purchase Order Vendor Purchase Order Change Request Work Order Work Order Change Request |
false |
|