Invoice Header

InvoiceHeader

120 columns Fetched February 27, 2026

n8n

Columns

Invoice_Number Text nullable
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
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
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_Type_Desc Text nullable
Status_Description Text nullable
Territory Text nullable
TicketNbr Numeric
Project_ID Text nullable
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
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_Symbol Text nullable
DisplaySymbol_Flag Boolean
Paid_Flag Numeric
Apply_To Text nullable
Bill_to_Address_RecID Numeric
Ship_To_Address_RecID Numeric nullable