Invoice Header
InvoiceHeader
120 columns Fetched February 27, 2026
Columns
Billing_Log_RecID Numeric
Invoice_Number Text nullable
Billing_Unit_RecID Numeric
Also in 29 reports
Accounts Receivable Aging Agr Type Billing Unit Billing Unit Location Charge Code Company Team Configs Configuration Invoice Time Invoices 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
Company_Address_RecID Numeric
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 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
Address_Line1 Text nullable
Address_Line2 Text nullable
City Text nullable
State_ID Text nullable
Zip Text nullable
PhoneNbr Text nullable
Country Text nullable
Bill_To_RecID Numeric
Bill_To_Name Text nullable
Bill_To_Address_Line1 Text nullable
Bill_To_Address_Line2 Text nullable
Bill_To_City Text nullable
Bill_To_State_ID Text nullable
Bill_To_Zip Text nullable
Bill_To_PhoneNbr Text nullable
Bill_To_Country Text nullable
Account Text nullable
Remit_To_Name Text
Remit_To_Address_Line1 Text nullable
Remit_To_Address_Line2 Text nullable
Remit_To_City Text nullable
Remit_To_State_ID Text nullable
Remit_To_Zip Text nullable
Remit_To_PhoneNbr Text nullable
Remit_To_Country Text nullable
PO_Number Text nullable
Billing_Terms Text nullable
Billing_Terms_RecID Numeric
Also in 7 reports
Top_Comment Text nullable
Bottom_Comment Text nullable
Invoice_Amount Numeric
Invoice_Subtotal Numeric nullable
Misc_Amount Numeric
Time_Amount Numeric
Rem_Downpayment Numeric
Tax_Code_RecID Numeric
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
Reference Text nullable
Internal_Note Text nullable
Adj_Amount Numeric
Adj_By Text nullable
Adj_Reason Text nullable
AGR_Header_RecID Numeric
Also in 20 reports
Agreement_Name Text nullable
AGR_Amount Numeric
AGR_Hours Numeric nullable
Agr_Adjustment Numeric
Attention Text nullable
Date_Invoice DateTime nullable
Due_Date DateTime nullable
Date_Created DateTime
Date_Closed DateTime nullable
Closed_Flag Boolean
Invoice_Type Text
Date_Paid DateTime nullable
Paid_Amount Numeric
Credit_Amount Numeric nullable
Billing_Type_ID Text
Location Text nullable
BusGroup Text nullable
Billing_Status_RecID Numeric
Also in 4 reports
Billing_Type_Desc Text nullable
Status_Description Text nullable
Territory Text nullable
TicketNbr Numeric
PM_Project_RecID Numeric
Project_ID Text nullable
PM_Phase_RecID Numeric
Also in 9 reports
Phase_ID Text nullable
SalesOrderNbr Numeric
Processing_Flag Boolean
Date_Processing DateTime nullable
Sent_Flag Boolean
DownPayment Numeric
Progress_Amount_Applied Numeric
Expense_Amount Numeric
Updated_By Text nullable
Last_Update DateTime
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 Time Invoices 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
Territory_RecID Numeric nullable
Billing_Method Text nullable
Invoice_Footer Text nullable
Billing_Contact_Name Text
Ship_To_Company_RecID Numeric
Ship_To_Name Text nullable
Ship_To_Attention Text nullable
Ship_To_Address_Line1 Text nullable
Ship_To_Address_Line2 Text nullable
Ship_To_City Text nullable
Ship_To_State_ID Text nullable
Ship_To_Zip Text nullable
Ship_To_PhoneNbr Text nullable
Ship_To_Country Text nullable
Payable_Name Text nullable
Currency_RecID Numeric
Currency_Symbol Text nullable
DisplaySymbol_Flag Boolean
Paid_Flag Numeric
Apply_To Text nullable
Bill_to_Address_RecID Numeric
Ship_To_Address_RecID Numeric nullable
| Name | Type | Nullable | Also In |
|---|---|---|---|
| Billing_Log_RecID | Numeric | No | |
| Invoice_Number | Text | Yes | unique |
| Billing_Unit_RecID | Numeric | No | 29 reports Accounts Receivable Aging Agr Type Billing Unit Billing Unit Location Charge Code Company Team Configs Configuration Invoice Time Invoices 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 |
| Company_Address_RecID | Numeric | No | |
| 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 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 |
| Address_Line1 | Text | Yes | unique |
| Address_Line2 | Text | Yes | unique |
| City | Text | Yes | unique |
| State_ID | Text | Yes | unique |
| Zip | Text | Yes | unique |
| PhoneNbr | Text | Yes | unique |
| Country | Text | Yes | unique |
| Bill_To_RecID | Numeric | No | unique |
| Bill_To_Name | Text | Yes | unique |
| Bill_To_Address_Line1 | Text | Yes | unique |
| Bill_To_Address_Line2 | Text | Yes | unique |
| Bill_To_City | Text | Yes | unique |
| Bill_To_State_ID | Text | Yes | unique |
| Bill_To_Zip | Text | Yes | unique |
| Bill_To_PhoneNbr | Text | Yes | unique |
| Bill_To_Country | Text | Yes | unique |
| Account | Text | Yes | unique |
| Remit_To_Name | Text | No | unique |
| Remit_To_Address_Line1 | Text | Yes | unique |
| Remit_To_Address_Line2 | Text | Yes | unique |
| Remit_To_City | Text | Yes | unique |
| Remit_To_State_ID | Text | Yes | unique |
| Remit_To_Zip | Text | Yes | unique |
| Remit_To_PhoneNbr | Text | Yes | unique |
| Remit_To_Country | Text | Yes | unique |
| PO_Number | Text | Yes | unique |
| Billing_Terms | Text | Yes | unique |
| Billing_Terms_RecID | Numeric | No | |
| Top_Comment | Text | Yes | unique |
| Bottom_Comment | Text | Yes | unique |
| Invoice_Amount | Numeric | No | unique |
| Invoice_Subtotal | Numeric | Yes | unique |
| Misc_Amount | Numeric | No | unique |
| Time_Amount | Numeric | No | unique |
| Rem_Downpayment | Numeric | No | unique |
| Tax_Code_RecID | Numeric | No | 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 |
| Reference | Text | Yes | unique |
| Internal_Note | Text | Yes | unique |
| Adj_Amount | Numeric | No | unique |
| Adj_By | Text | Yes | unique |
| Adj_Reason | Text | Yes | unique |
| AGR_Header_RecID | Numeric | No | |
| Agreement_Name | Text | Yes | unique |
| AGR_Amount | Numeric | No | unique |
| AGR_Hours | Numeric | Yes | unique |
| Agr_Adjustment | Numeric | No | unique |
| Attention | Text | Yes | unique |
| Date_Invoice | DateTime | Yes | unique |
| Due_Date | DateTime | Yes | unique |
| Date_Created | DateTime | No | unique |
| Date_Closed | DateTime | Yes | unique |
| Closed_Flag | Boolean | No | unique |
| Invoice_Type | Text | No | unique |
| Date_Paid | DateTime | Yes | unique |
| Paid_Amount | Numeric | No | unique |
| Credit_Amount | Numeric | Yes | unique |
| Billing_Type_ID | Text | No | unique |
| Location | Text | Yes | unique |
| BusGroup | Text | Yes | unique |
| Billing_Status_RecID | Numeric | No | |
| Billing_Type_Desc | Text | Yes | unique |
| Status_Description | Text | Yes | unique |
| Territory | Text | Yes | unique |
| TicketNbr | Numeric | No | unique |
| PM_Project_RecID | Numeric | No | |
| Project_ID | Text | Yes | unique |
| PM_Phase_RecID | Numeric | No | |
| Phase_ID | Text | Yes | unique |
| SalesOrderNbr | Numeric | No | unique |
| Processing_Flag | Boolean | No | unique |
| Date_Processing | DateTime | Yes | unique |
| Sent_Flag | Boolean | No | unique |
| DownPayment | Numeric | No | unique |
| Progress_Amount_Applied | Numeric | No | unique |
| Expense_Amount | Numeric | No | unique |
| Updated_By | Text | Yes | unique |
| Last_Update | DateTime | No | 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 Time Invoices 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 |
| Territory_RecID | Numeric | Yes | unique |
| Billing_Method | Text | Yes | unique |
| Invoice_Footer | Text | Yes | unique |
| Billing_Contact_Name | Text | No | unique |
| Ship_To_Company_RecID | Numeric | No | unique |
| Ship_To_Name | Text | Yes | unique |
| Ship_To_Attention | Text | Yes | unique |
| Ship_To_Address_Line1 | Text | Yes | unique |
| Ship_To_Address_Line2 | Text | Yes | unique |
| Ship_To_City | Text | Yes | unique |
| Ship_To_State_ID | Text | Yes | unique |
| Ship_To_Zip | Text | Yes | unique |
| Ship_To_PhoneNbr | Text | Yes | unique |
| Ship_To_Country | Text | Yes | unique |
| Payable_Name | Text | Yes | unique |
| Currency_RecID | Numeric | No | |
| Currency_Symbol | Text | Yes | unique |
| DisplaySymbol_Flag | Boolean | No | unique |
| Paid_Flag | Numeric | No | unique |
| Apply_To | Text | Yes | unique |
| Bill_to_Address_RecID | Numeric | No | unique |
| Ship_To_Address_RecID | Numeric | Yes | unique |