Invoices

Invoices

92 columns Fetched February 27, 2026

n8n

Columns

Invoice_Number Text nullable
Invoice_Type Text
Billing_Type_ID Text nullable
CompanyRecId Numeric
Company_Name Text nullable
Remit_To_RecID Numeric
Also in 2 reports
Remit_To_Name Text nullable
Attention Text 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 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
Location Text nullable
BusGroup Text nullable
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
Agreement_Name Text nullable
AGR_Amount Numeric
AGR_Hours Numeric nullable
Agr_Adjustment Numeric
TicketNbr Numeric
Ticket_Summary Text nullable
Project_ID Text 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