Admin_Global_Edit__c |
Admin Global Edit |
Pre-Spring 2018 |
If checked, allows Admin to make 'global' changes to the Expense, including edits to the Expense'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_To_Bill__c |
Amount To Bill |
Pre-Spring 2018 |
Formula: Billing_Currency__c & ' ' & TEXT(ROUND(Billing_Amount__c,2))
|
Text |
|
Amount_To_Reimburse__c |
Amount To Reimburse |
Pre-Spring 2018 |
Formula: Reimbursement_Currency__c & ' ' & TEXT(ROUND(Reimbursement_Amount__c,2))
|
Text |
|
Amount__c |
Amount |
Pre-Spring 2018 |
The amount of this expense (in the expense's incurred currency)
|
Currency(18,2) |
|
Applied_Expense_Rate__c |
Applied Expense Rate |
Pre-Spring 2018 |
Field will hold the Expense Rate applied on Expense.
Looks up to: Expense_Limit_Rate__c
|
Lookup |
|
Approved__c |
Approved |
Pre-Spring 2018 |
This checkbox should be checked when the Expense is approved, which should be based on whether its parent Expense Report (if any) is approved.
|
Checkbox |
false |
Approved_for_Billing__c |
Approved for Billing |
Pre-Spring 2018 |
|
Checkbox |
false |
Approved_for_Vendor_Payment__c |
Approved for Vendor Payment |
Pre-Spring 2018 |
|
Checkbox |
false |
Assignment__c |
Assignment |
Pre-Spring 2018 |
Looks up to: Assignment__c
|
Lookup |
|
Attachments_moved_to_ER__c |
Attachments moved to ER |
Pre-Spring 2018 |
Automatically checked by configuration to indicate whether expense attachments have been moved from the expense line to the expense report.
|
Checkbox |
false |
Audit_Notes_History__c |
Audit Notes History |
Pre-Spring 2018 |
Stores audit notes history. When a user changes a project or assignment using the Timecard UI and the audit notes exceed 255 characters, older audit notes are moved and appended here.
|
LongTextArea(32768) |
|
Audit_Notes__c |
Audit Notes |
Pre-Spring 2018 |
|
TextArea |
|
Bill_Date__c |
Bill Date |
Pre-Spring 2018 |
|
Date |
|
Bill_Transaction__c |
Bill Transaction |
Pre-Spring 2018 |
Looks up to: Transaction__c
|
Lookup |
|
Billable_Amount__c |
Billable Amount |
Pre-Spring 2018 |
This formula equals Amount (minus Non-Billable Incurred Amount and Tax if any) for billable Expenses and zero for non-billable Expenses: all in the incurred currency.
Formula: IF(ISNULL(Amount__c),0.00,IF((Billable__c),(Amount__c-Non_Billable_Incurred_Subtotal__c),0.00))
|
Currency(18,2) |
|
Billable_Fee_Flat_Amount__c |
Billable Fee Flat Amount |
Pre-Spring 2018 |
Flat fee in Project currency by which to increase the billable amount of the Expense, defaulted from the Project. The calculation will apply any percentage expense fee*before* this flat expense fee amount.
|
Number(18,2) |
|
Billable_Fee_Flat__c |
Billable Fee Flat |
Pre-Spring 2018 |
Text formula showing flat fee in Project currency by which to increase the billable amount of the Expense, defaulted from Project along with Project currency. The calculation will apply any percentage expense fee*before* this flat expense fee amount.
Formula: TEXT(Project__r.CurrencyIsoCode) & " " & IF(ISNULL(Billable_Fee_Flat_Amount__c),"0.00",TEXT(Billable_Fee_Flat_Amount__c))
|
Text |
|
Billable_Fee_Percentage__c |
Billable Fee Percentage |
Pre-Spring 2018 |
Fee percentage by which to increase the billable amount of the Expense, defaulted from the Project. 0% means no increase (default), whereas 100% means double. The calculation will apply the percentage expense fee*before* any flat expense fee.
|
Percent(8,2) |
|
Billable__c |
Billable |
Pre-Spring 2018 |
|
Checkbox |
false |
Billed__c |
Billed |
Pre-Spring 2018 |
|
Checkbox |
false |
Billing_Amount_Pre_Fee_Subtotal__c |
Billing Amount (Pre-Fee Subtotal) |
Pre-Spring 2018 |
|
Number(18,2) |
0.00 |
Billing_Amount__c |
Billing Amount |
Pre-Spring 2018 |
|
Number(18,2) |
0.00 |
Billing_Currency__c |
Billing Currency |
Pre-Spring 2018 |
|
Text(3) |
|
Billing_Event_Invoiced__c |
Billing Event Invoiced |
Pre-Spring 2018 |
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 |
|
Billing_Event_Item__c |
Billing Event Item |
Pre-Spring 2018 |
Looks up to: Billing_Event_Item__c
|
Lookup |
|
Billing_Event_Released__c |
Billing Event Released |
Pre-Spring 2018 |
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 |
|
Billing_Event_Status__c |
Billing Event Status |
Pre-Spring 2018 |
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 |
|
Billing_Event__c |
Billing Event |
Pre-Spring 2018 |
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 |
|
Billing_Hold__c |
Billing Hold |
Pre-Spring 2018 |
If true, this item cannot be billed
|
Checkbox |
false |
Cost_Transaction__c |
Cost Transaction |
Pre-Spring 2018 |
Looks up to: Transaction__c
|
Lookup |
|
Description__c |
Description |
Pre-Spring 2018 |
|
TextArea |
|
Distance__c |
Distance |
Pre-Spring 2018 |
|
Number(8,2) |
|
Eligible_for_Billing__c |
Eligible for Billing |
Pre-Spring 2018 |
Indicates Expense 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 |
|
Exchange_Rate_Billing_Currency__c |
Exchange Rate (Billing Currency) |
Pre-Spring 2018 |
|
Number(18,6) |
|
Exchange_Rate_Incurred_Currency__c |
Exchange Rate (Incurred Currency) |
Pre-Spring 2018 |
|
Number(18,6) |
|
Exchange_Rate_Reimbursement_Currency__c |
Exchange Rate (Reimbursement Currency) |
Pre-Spring 2018 |
|
Number(18,6) |
|
Exchange_Rate_Resource_Defined__c |
Exchange Rate (Resource-Defined) |
Pre-Spring 2018 |
When set, this field sets the *relative* exchange rate between Incurred Rate and Reimbursement Rate that is experienced by the Resource incurring the Expense. This then overrides the Incurred Exchange Rate (relative to corporate rate) so that it has the right ratio to the Reimbursement Exchange Rate (relative to corporate rate).
|
Number(18,6) |
|
Exclude_from_Billing__c |
Exclude from Billing |
Pre-Spring 2018 |
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_Date__c |
Expense Date |
Pre-Spring 2018 |
|
Date |
Today() |
Expense_Report__c |
Expense Report |
Pre-Spring 2018 |
Looks up to: Expense_Report__c
|
Lookup |
|
Expense_Split_Parent__c |
Expense Split Parent |
Pre-Spring 2018 |
Looks up to: Expense__c
|
Lookup |
|
Include_In_Financials__c |
Include In Financials |
Pre-Spring 2018 |
|
Checkbox |
false |
Incurred_Tax_Non_Billable__c |
Incurred Tax Non-Billable |
Pre-Spring 2018 |
If checked for a billable Expense, this means that the portion of the Expense amount specified in the Incurred Tax field is not billable. (This is separate from and in addition to any amount in the Non-Billable Incurred Amount field).
|
Checkbox |
false |
Incurred_Tax__c |
Incurred Tax |
Pre-Spring 2018 |
The amount of tax incurred
|
Currency(18,2) |
0 |
Invoice_Date__c |
Invoice Date |
Pre-Spring 2018 |
|
Date |
|
Invoice_Number__c |
Invoice Number |
Pre-Spring 2018 |
|
Text(80) |
|
Invoice_Transaction__c |
Invoice Transaction |
Pre-Spring 2018 |
Looks up to: Transaction__c
|
Lookup |
|
Invoiced__c |
Invoiced |
Pre-Spring 2018 |
|
Checkbox |
false |
Lost_Receipt__c |
Lost Receipt |
Pre-Spring 2018 |
This field is visible on UI if user requires attachment on expense lines if Expense report is submitted. If this field is set true then user does not need to add attachment although the config is set to true.
|
Checkbox |
false |
Milestone__c |
Milestone |
Pre-Spring 2018 |
Looks up to: Milestone__c
|
Lookup |
|
Mobile_Expense_Reference_ID__c |
Mobile Expense Reference ID |
Pre-Spring 2018 |
|
Text(255) |
|
Non_Billable_Amount__c |
Non-Billable Amount |
Pre-Spring 2018 |
This formula equals Amount for non-billable Expenses and Non-Billable Incurred Amount and Tax (anywhere from zero to Expense Amount) for billable Expenses: all in the incurred currency.
Formula: IF(ISNULL(Amount__c),0.00,IF(Billable__c,Non_Billable_Incurred_Subtotal__c,Amount__c))
|
Currency(18,2) |
|
Non_Billable_Incurred_Amount__c |
Non-Billable Incurred Amount |
Pre-Spring 2018 |
If provided for a billable Expense, this is subtracted from the Expense Amount (incurred currency) to calculate the Expense's billable amount. Min. value zero, max. value Expense amount. Default value: zero or null. No effect on non-billable Expenses.
|
Currency(18,2) |
0.00 |
Non_Billable_Incurred_Subtotal__c |
Non-Billable Incurred Subtotal |
Pre-Spring 2018 |
This formula adds any Non-Billable Incurred Tax (only if Incurred Tax Non-Billable is checked) to any additional Non-Billable Incurred Amount to get a Non-Billable Incurred Subtotal, with a minimum of 0.00 and a maximum of the Expense Amount.
Formula: MIN(MAX((IF(ISNULL(Non_Billable_Incurred_Amount__c),0.00,Non_Billable_Incurred_Amount__c)+IF(OR(NOT(Incurred_Tax_Non_Billable__c),ISNULL(Incurred_Tax__c)),0.00,Incurred_Tax__c)),0.00),MAX(Amount__c,0.00))
|
Currency(18,2) |
|
Non_Reimbursible__c |
Non-Reimbursable |
Pre-Spring 2018 |
If this checkbox is checked, the Reimbursement amount for the Expense will be zero regardless of the incurred amount.
|
Checkbox |
false |
Notes__c |
Notes |
Pre-Spring 2018 |
|
TextArea |
|
Override_Group_Currency_Code__c |
Override Group Currency Code |
Pre-Spring 2018 |
Formula: TEXT(Override_Group__r.CurrencyIsoCode)
|
Text |
|
Override_Group__c |
Override Group |
Pre-Spring 2018 |
Overrides the Group to which the Expense Transactions will roll up for Group Actuals, even if the Project is in a different Group. Typically an Expense's Transactions roll up to its Project's or Resource's Group based on 'follows' rules. Note that either way, the Transactions will continue to roll up to the same Project's Project Actuals.
Looks up to: Grp__c
|
Lookup |
|
Override_Practice_Currency_Code__c |
Override Practice Currency Code |
Pre-Spring 2018 |
Formula: TEXT(Override_Practice__r.CurrencyIsoCode)
|
Text |
|
Override_Practice__c |
Override Practice |
Pre-Spring 2018 |
Overrides the Practice to which the Expense Transactions will roll up for Practice Actuals, even if the Project is in a different Practice. Typically an Expense's Transactions roll up to its Project's or Resource's Practice based on 'follows' rules. Note that either way, the Transactions will continue to roll up to the same Project's Project Actuals.
Looks up to: Practice__c
|
Lookup |
|
Override_Rate_Billing_Currency__c |
Override Rate (Billing Currency) |
Pre-Spring 2018 |
|
Checkbox |
false |
Override_Rate_Incurred_Currency__c |
Override Rate (Incurred Currency) |
Pre-Spring 2018 |
|
Checkbox |
false |
Override_Rate_Reimbursement_Currency__c |
Override Rate (Reimbursement Currency) |
Pre-Spring 2018 |
|
Checkbox |
false |
Override_Region_Currency_Code__c |
Override Region Currency Code |
Pre-Spring 2018 |
Formula: TEXT(Override_Region__r.CurrencyIsoCode)
|
Text |
|
Override_Region__c |
Override Region |
Pre-Spring 2018 |
Overrides the Region to which the Expense Transactions will roll up for Regional Actuals, even if the Project is in a different Region. Typically an Expense's Transactions roll up to its Project's or Resource's Region based on 'follows' rules. Note that either way, the Transactions will continue to roll up to the same Project's Project Actuals.
Looks up to: Region__c
|
Lookup |
|
Project_Methodology__c |
Project Methodology |
Pre-Spring 2018 |
Lookup to Project Methodology
Looks up to: Project_Methodology__c
|
Lookup |
|
Project_Phase__c |
Project Phase |
Pre-Spring 2018 |
Lookup to Project Phase
Looks up to: Project_Phase__c
|
Lookup |
|
Project__c |
Project |
Pre-Spring 2018 |
Looks up to: Proj__c
|
Lookup |
|
Rate_Unit__c |
Rate Unit |
Pre-Spring 2018 |
Must be kept in sync with Expense_Limit_Rate__c.Rate_Unit__c
|
Picklist: Kilometer Mile |
|
Recognition_Method__c |
Recognition Method |
Fall 2019 |
The recognition method to apply to this record for revenue forecasting.
|
Picklist |
|
Reimbursement_Amount_In_Project_Currency__c |
Reimbursement Amount In Project Currency |
Pre-Spring 2018 |
This field stores a numeric value for the Reimbursement Amount converted to the Project (billing) currency using system (not overridden) rates, for later use in vendor invoicing.
|
Number(18,2) |
0.00 |
Reimbursement_Amount__c |
Reimbursement Amount |
Pre-Spring 2018 |
|
Number(18,2) |
0.00 |
Reimbursement_Currency__c |
Reimbursement Currency |
Pre-Spring 2018 |
|
Text(3) |
|
Resource__c |
Resource |
Pre-Spring 2018 |
Looks up to: Contact
|
Lookup |
|
Revenue_Transaction__c |
Revenue Transaction |
Pre-Spring 2018 |
Looks up to: Transaction__c
|
Lookup |
|
Split_Expense__c |
Split Expense |
Pre-Spring 2018 |
|
Checkbox |
false |
Split_Notes__c |
Split Notes |
Pre-Spring 2018 |
|
TextArea |
|
Status__c |
Status |
Pre-Spring 2018 |
|
Picklist: Approved Draft Rejected Submitted |
|
Submitted__c |
Submitted |
Pre-Spring 2018 |
|
Checkbox |
false |
Synchronous_Update_Required__c |
Synchronous Update Required |
Pre-Spring 2018 |
This checkbox is for system use. It is intended to be checked in conjunction with any insert/update of the Timecard Split executed within a future method, and will then ensure that no downstream future methods are called. In Salesforce, a future method can't call another future method. Triggers should then unset this checkbox so that it never remains checked persistently. Danger: only check this flag for changes NOT on the "critical" path with respect to governor limits. For example, it is ok to check this flag if the only change to the Expense is to modify the Billed/Invoiced flags and the Billing Event Item lookup value.
|
Checkbox |
false |
Tax_Type__c |
Tax Type |
Pre-Spring 2018 |
An optional type of tax that has been included in the expense
|
Picklist: GST VAT 1 VAT 2 |
|
Third_Party_Expenses_App_Expense_ID__c |
Third-Party Expenses App Expense ID |
Spring 2019 |
The Expense ID from the Third-Party Expenses Application.
|
Text(255) |
|
Type__c |
Type |
Pre-Spring 2018 |
|
Picklist: Airfare Auto Mileage Business Meals Car Rental Employee Relations Gasoline General and Admin Expenses IT Equipment and Services Lodging (Room and Tax) Miscellaneous Office Supplies and Services Personal Meals Phone Postage and Shipping Recruiting Subway Taxi |
|
Vendor_Invoice_Item__c |
Vendor Invoice Item |
Pre-Spring 2018 |
Looks up to: Vendor_Invoice_Item__c
|
Lookup |
|