Company

Company

89 columns Fetched February 27, 2026

n8n

Columns

Company_ID Text nullable
Company_Name Text nullable
Company_Type_RecID Text nullable
Also in 2 reports
Company_Type_Desc Text nullable
Company_Status_RecID Numeric nullable
Also in 1 report
Company_Status_Desc Text nullable
Market_RecID Numeric nullable
Also in 1 report
Market_Desc Text nullable
PhoneNbr Text nullable
PhoneNbr_Fax Text nullable
Website_URL Text nullable
Account_Nbr Text nullable
Tax_Code_RecID Numeric nullable
Also in 4 reports
Lead_Flag Boolean
Lead_Source Text nullable
Parent_Company_RecID Numeric nullable
Annual_Revenue Numeric
Revenue_Year Numeric nullable
Nbr_Employees Numeric nullable
Tax_Code_Desc Text nullable
Tax_Code_ID Text nullable
Currency_Desc Text nullable
Currency_ID Text nullable
Location Text nullable
Time_Zone_RecID Numeric nullable
Also in 1 report
SIC_Code_ID Text nullable
Remit_To_RecID Numeric nullable
Also in 2 reports
Billable_Flag Numeric nullable
Userfield_1 Text nullable
Userfield_2 Text nullable
Userfield_3 Text nullable
Userfield_4 Text nullable
Userfield_5 Text nullable
Userfield_6 Text nullable
Userfield_7 Text nullable
Userfield_8 Text nullable
Userfield_9 Text nullable
Userfield_10 Text nullable
Unsubscribe_Flag Boolean nullable
Vendor_Nbr Text nullable
Delete_Flag Boolean
Updated_By Text
Last_Update DateTime
Time_Zone Text nullable
Billing_Terms_Desc Text nullable
Due_Days Numeric nullable
Custom_Note Text nullable
Userfield1_Caption Text nullable
Userfield2_Caption Text nullable
Userfield3_Caption Text nullable
Userfield4_Caption Text nullable
Userfield5_Caption Text nullable
Userfield6_Caption Text nullable
Userfield7_Caption Text nullable
Userfield8_Caption Text nullable
Userfield9_Caption Text nullable
Userfield10_Caption Text nullable
Default_Contact_First_Name Text nullable
Default_Contact_Last_Name Text nullable
Default_Contact_Email Text nullable
Date_Entered DateTime
Date_Acquired DateTime nullable
Delivery_Method Text nullable
OwnershipType Text nullable
Office_Calendar_RecID Numeric nullable
Also in 5 reports
Company_Calendar Text nullable
Last_Update_UTC DateTime
Date_Entered_UTC DateTime
Date_Acquired_UTC DateTime nullable
Entered_By Text
Email_Cc_Flag Boolean
Email_Cc_Address Text nullable
Tax_ID Text nullable
BL_InvTemplate_Setup_RecID Numeric nullable
Also in 1 report
IV_Price_Header_RecID Numeric nullable
Also in 2 reports
Customer_Usage_Type_RecID Numeric nullable
Also in 1 report
Bill_To_Company_RecID Numeric nullable
Bill_To_Company_Name Text nullable
Bill_To_Company_Address_RecID Numeric nullable
Bill_To_Description Text nullable
Bill_To_Contact_RecID Numeric nullable
Bill_To_First_Name Text nullable
Bill_To_Last_Name Text nullable
Year_Established Numeric nullable