Invoice Expense
InvoiceExpense
30 columns Fetched February 27, 2026
Columns
EX_Detail_RecID Numeric
Also in 4 reports
Member_RecID Numeric
Member_ID Text
First_Name Text nullable
Last_Name Text nullable
Billing_Log_RecID Numeric nullable
Company_RecID Numeric
Also in 44 reports
Accounts Receivable Aging Activity Agr Config Renewals Agr Site Agreement Invoice Charge Code Company Company Address Company Company Type Descriptions Company Company Types Company Custom Fields Company Group Company Markets Company Mgmt Company State Tax Rate Company Team Company Work Roles Company Work Types Configuration Contact Contact Group Document Expense Invoice Header Invoice Time Invoices Management Report Setup Member Certifications Opportunity Opportunity Restricted Portal Config Names Portal Invoices Pricing Schedule Project Header Purchase Order Template Sales Commission Sales Order Service Location Service Summary Service Summary Open Time Unposted Expense Unposted Invoice Warehouse
Company_Name Text nullable
Option_ID Text nullable
Date_Expense DateTime nullable
Expense_Type Text nullable
Expense_Cost Numeric nullable
Extended_Amount Numeric nullable
Agreement Text nullable
Agreement_Amount_Covered Numeric
PM_Project_RecID Numeric nullable
Project_Name Text nullable
Project_Phase Text nullable
PM_Phase_RecID Numeric nullable
Also in 9 reports
SR_Service_RecID Numeric nullable
Also in 21 reports
SR_Summary Text nullable
Charge_To Text nullable
Reason Text nullable
Updated_By Text nullable
Last_Update DateTime nullable
Time_Zone Text nullable
Currency_RecID Numeric
Currency_Symbol Text nullable
DisplaySymbol_Flag Boolean
Invoice_Number Text nullable
| Name | Type | Nullable | Also In |
|---|---|---|---|
| EX_Detail_RecID | Numeric | No | 4 reports |
| Member_RecID | Numeric | No | |
| Member_ID | Text | No | unique |
| First_Name | Text | Yes | unique |
| Last_Name | Text | Yes | unique |
| Billing_Log_RecID | Numeric | Yes | |
| Company_RecID | Numeric | No | 44 reports Accounts Receivable Aging Activity Agr Config Renewals Agr Site Agreement Invoice Charge Code Company Company Address Company Company Type Descriptions Company Company Types Company Custom Fields Company Group Company Markets Company Mgmt Company State Tax Rate Company Team Company Work Roles Company Work Types Configuration Contact Contact Group Document Expense Invoice Header Invoice Time Invoices Management Report Setup Member Certifications Opportunity Opportunity Restricted Portal Config Names Portal Invoices Pricing Schedule Project Header Purchase Order Template Sales Commission Sales Order Service Location Service Summary Service Summary Open Time Unposted Expense Unposted Invoice Warehouse |
| Company_Name | Text | Yes | unique |
| Option_ID | Text | Yes | unique |
| Date_Expense | DateTime | Yes | unique |
| Expense_Type | Text | Yes | unique |
| Expense_Cost | Numeric | Yes | unique |
| Extended_Amount | Numeric | Yes | unique |
| Agreement | Text | Yes | unique |
| Agreement_Amount_Covered | Numeric | No | unique |
| PM_Project_RecID | Numeric | Yes | |
| Project_Name | Text | Yes | unique |
| Project_Phase | Text | Yes | unique |
| PM_Phase_RecID | Numeric | Yes | |
| SR_Service_RecID | Numeric | Yes | 21 reports |
| SR_Summary | Text | Yes | unique |
| Charge_To | Text | Yes | unique |
| Reason | Text | Yes | unique |
| Updated_By | Text | Yes | unique |
| Last_Update | DateTime | Yes | unique |
| Time_Zone | Text | Yes | unique |
| Currency_RecID | Numeric | No | |
| Currency_Symbol | Text | Yes | unique |
| DisplaySymbol_Flag | Boolean | No | unique |
| Invoice_Number | Text | Yes | unique |