Invoices
Invoices
92 columns Fetched February 27, 2026
Columns
Billing_Log_RecID Numeric
Invoice_Number Text nullable
Invoice_Type Text
Billing_Type_ID Text 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 Expense Invoice Header Invoice Time 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
CompanyRecId Numeric
Company_Name Text nullable
Remit_To_RecID Numeric
Also in 2 reports
Remit_To_Name Text nullable
Attention Text nullable
Company_Address_RecID Numeric nullable
Address_Line1 Text nullable
Address_Line2 Text nullable
City Text nullable
State_ID Text nullable
Zip Text nullable
Country Text nullable
Date_Invoice DateTime nullable
Due_Date DateTime nullable
Billing_Terms_RecID Numeric
Also in 7 reports
Billing_Terms Text nullable
Top_Comment Text nullable
Bottom_Comment Text nullable
PO_Number Text nullable
Reference Text nullable
Internal_Note Text nullable
Adj_Amount Numeric
Adj_By Text nullable
Adj_Reason Text nullable
Owner_Level_RecID Numeric
Also in 48 reports
Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header Invoice Time Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Marketing Campaign Member Owner Level Portal Agr Type Portal Invoices Portal Project Portal Ticket Types Price Header Pricing Schedule Project Header Purchase Order Purchase Order Template Sales Commission Service Board Service Code Service Item Service Status Service Sub Type Service Team Service Type Time Transaction Unposted Expense Unposted Invoice Unposted Procurement User Defined Field Owner Levels Warehouse Warehouse Bin Work Roles Location
Location Text nullable
Billing_Unit_RecID Numeric nullable
Also in 29 reports
Accounts Receivable Aging Agr Type Billing Unit Billing Unit Location Charge Code Company Team Configs Configuration Invoice Header Invoice Time Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Member Portal Agr Type Project Header Purchase Order Purchase Order Template Service Code Service Item Service Status Service Sub Type Service Team Service Type Time User Defined Field Billing Units Warehouse Warehouse Bin
BusGroup Text nullable
Billing_Status_RecID Numeric
Also in 4 reports
Billing_Type_Desc Text nullable
Status_Description Text nullable
Invoice_Amount Numeric
DownPayment Numeric
Progress_Amount_Applied Numeric
Expense_Amount Numeric
Misc_Amount Numeric
Time_Amount Numeric
Rem_Downpayment Numeric
Tax_Code_RecID Numeric nullable
Also in 4 reports
Tax_Code Text nullable
Sales_Tax_Amount Numeric
Tax_Code1 Text nullable
Tax1_Amount Numeric
Tax_Code2 Text nullable
Tax2_Amount Numeric
Tax_Code3 Text nullable
Tax3_Amount Numeric
Tax_Code4 Text nullable
Tax4_Amount Numeric
Tax_Code5 Text nullable
Tax5_Amount Numeric
Tax_Code6 Text nullable
Tax6_Amount Numeric
Territory_recid Numeric nullable
Territory Text nullable
AGR_Header_RecID Numeric
Also in 20 reports
Agreement_Name Text nullable
AGR_Amount Numeric
AGR_Hours Numeric nullable
Agr_Adjustment Numeric
TicketNbr Numeric
Ticket_Summary Text nullable
PM_Project_RecID Numeric
Project_ID Text nullable
PM_Phase_RecID Numeric nullable
Phase_ID Text nullable
SalesOrderNbr Numeric nullable
Date_Created DateTime
Date_Closed DateTime nullable
Closed_Flag Boolean nullable
Date_Paid DateTime nullable
Paid_Amount Numeric
Credit_Amount Numeric nullable
Updated_By Text nullable
Last_Update DateTime
Time_Zone Text nullable
Processing_Flag Boolean
Date_Processing DateTime nullable
Sent_Flag Boolean nullable
Billing_Contact_RecID Numeric nullable
Billing_Contact_First_Name Text nullable
Billing_Contact_Last_Name Text nullable
Paid_Flag Numeric
Apply_To Text nullable
Remaining_Credit_Balance Numeric nullable
ship_to_company_address_recid Numeric nullable
Currency_RecID Numeric
| Name | Type | Nullable | Also In |
|---|---|---|---|
| Billing_Log_RecID | Numeric | No | |
| Invoice_Number | Text | Yes | unique |
| Invoice_Type | Text | No | unique |
| Billing_Type_ID | Text | Yes | unique |
| 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 Expense Invoice Header Invoice Time 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 |
| CompanyRecId | Numeric | No | unique |
| Company_Name | Text | Yes | unique |
| Remit_To_RecID | Numeric | No | 2 reports |
| Remit_To_Name | Text | Yes | unique |
| Attention | Text | Yes | unique |
| Company_Address_RecID | Numeric | Yes | |
| Address_Line1 | Text | Yes | unique |
| Address_Line2 | Text | Yes | unique |
| City | Text | Yes | unique |
| State_ID | Text | Yes | unique |
| Zip | Text | Yes | unique |
| Country | Text | Yes | unique |
| Date_Invoice | DateTime | Yes | unique |
| Due_Date | DateTime | Yes | unique |
| Billing_Terms_RecID | Numeric | No | |
| Billing_Terms | Text | Yes | unique |
| Top_Comment | Text | Yes | unique |
| Bottom_Comment | Text | Yes | unique |
| PO_Number | Text | Yes | unique |
| Reference | Text | Yes | unique |
| Internal_Note | Text | Yes | unique |
| Adj_Amount | Numeric | No | unique |
| Adj_By | Text | Yes | unique |
| Adj_Reason | Text | Yes | unique |
| Owner_Level_RecID | Numeric | No | 48 reports Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header Invoice Time Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Marketing Campaign Member Owner Level Portal Agr Type Portal Invoices Portal Project Portal Ticket Types Price Header Pricing Schedule Project Header Purchase Order Purchase Order Template Sales Commission Service Board Service Code Service Item Service Status Service Sub Type Service Team Service Type Time Transaction Unposted Expense Unposted Invoice Unposted Procurement User Defined Field Owner Levels Warehouse Warehouse Bin Work Roles Location |
| Location | Text | Yes | unique |
| Billing_Unit_RecID | Numeric | Yes | 29 reports Accounts Receivable Aging Agr Type Billing Unit Billing Unit Location Charge Code Company Team Configs Configuration Invoice Header Invoice Time Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Member Portal Agr Type Project Header Purchase Order Purchase Order Template Service Code Service Item Service Status Service Sub Type Service Team Service Type Time User Defined Field Billing Units Warehouse Warehouse Bin |
| BusGroup | Text | Yes | unique |
| Billing_Status_RecID | Numeric | No | |
| Billing_Type_Desc | Text | Yes | unique |
| Status_Description | Text | Yes | unique |
| Invoice_Amount | Numeric | No | unique |
| DownPayment | Numeric | No | unique |
| Progress_Amount_Applied | Numeric | No | unique |
| Expense_Amount | Numeric | No | unique |
| Misc_Amount | Numeric | No | unique |
| Time_Amount | Numeric | No | unique |
| Rem_Downpayment | Numeric | No | unique |
| Tax_Code_RecID | Numeric | Yes | 4 reports |
| Tax_Code | Text | Yes | unique |
| Sales_Tax_Amount | Numeric | No | unique |
| Tax_Code1 | Text | Yes | unique |
| Tax1_Amount | Numeric | No | unique |
| Tax_Code2 | Text | Yes | unique |
| Tax2_Amount | Numeric | No | unique |
| Tax_Code3 | Text | Yes | unique |
| Tax3_Amount | Numeric | No | unique |
| Tax_Code4 | Text | Yes | unique |
| Tax4_Amount | Numeric | No | unique |
| Tax_Code5 | Text | Yes | unique |
| Tax5_Amount | Numeric | No | unique |
| Tax_Code6 | Text | Yes | unique |
| Tax6_Amount | Numeric | No | unique |
| Territory_recid | Numeric | Yes | unique |
| Territory | Text | Yes | unique |
| AGR_Header_RecID | Numeric | No | 20 reports |
| Agreement_Name | Text | Yes | unique |
| AGR_Amount | Numeric | No | unique |
| AGR_Hours | Numeric | Yes | unique |
| Agr_Adjustment | Numeric | No | unique |
| TicketNbr | Numeric | No | unique |
| Ticket_Summary | Text | Yes | unique |
| PM_Project_RecID | Numeric | No | |
| Project_ID | Text | Yes | unique |
| PM_Phase_RecID | Numeric | Yes | |
| Phase_ID | Text | Yes | unique |
| SalesOrderNbr | Numeric | Yes | unique |
| Date_Created | DateTime | No | unique |
| Date_Closed | DateTime | Yes | unique |
| Closed_Flag | Boolean | Yes | unique |
| Date_Paid | DateTime | Yes | unique |
| Paid_Amount | Numeric | No | unique |
| Credit_Amount | Numeric | Yes | unique |
| Updated_By | Text | Yes | unique |
| Last_Update | DateTime | No | unique |
| Time_Zone | Text | Yes | unique |
| Processing_Flag | Boolean | No | unique |
| Date_Processing | DateTime | Yes | unique |
| Sent_Flag | Boolean | Yes | unique |
| Billing_Contact_RecID | Numeric | Yes | unique |
| Billing_Contact_First_Name | Text | Yes | unique |
| Billing_Contact_Last_Name | Text | Yes | unique |
| Paid_Flag | Numeric | No | unique |
| Apply_To | Text | Yes | unique |
| Remaining_Credit_Balance | Numeric | Yes | unique |
| ship_to_company_address_recid | Numeric | Yes | unique |
| Currency_RecID | Numeric | No |