Company
Company
89 columns Fetched February 27, 2026
Columns
Company_RecID Numeric
Also in 44 reports
Accounts Receivable Aging Activity Agr Config Renewals Agr Site Agreement Invoice Charge Code 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 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_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_RecID Numeric nullable
Currency_Desc Text nullable
Currency_ID Text nullable
Owner_Level_RecID Numeric nullable
Also in 48 reports
Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header 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
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_RecID Numeric nullable
Also in 7 reports
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
Contact_RecID Numeric nullable
Also in 23 reports
Activity Campaign Tracking Company Contact Communication Configs Configuration Contact Contact Communication Contact Contact Type Descriptions Contact Contact Types Contact Custom Fields Contact Group Contact Name Contact Presence Contacts Document Marketing Emails Opened Marketing Forms Submitted Marketing Links Clicked Opportunity Opportunity Restricted Project Contact Project Header Service Note
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
| Name | Type | Nullable | Also In |
|---|---|---|---|
| Company_RecID | Numeric | No | 44 reports Accounts Receivable Aging Activity Agr Config Renewals Agr Site Agreement Invoice Charge Code 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 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_ID | Text | Yes | unique |
| Company_Name | Text | Yes | unique |
| Company_Type_RecID | Text | Yes | 2 reports |
| Company_Type_Desc | Text | Yes | unique |
| Company_Status_RecID | Numeric | Yes | 1 report |
| Company_Status_Desc | Text | Yes | unique |
| Market_RecID | Numeric | Yes | 1 report |
| Market_Desc | Text | Yes | unique |
| PhoneNbr | Text | Yes | unique |
| PhoneNbr_Fax | Text | Yes | unique |
| Website_URL | Text | Yes | unique |
| Account_Nbr | Text | Yes | unique |
| Tax_Code_RecID | Numeric | Yes | 4 reports |
| Lead_Flag | Boolean | No | unique |
| Lead_Source | Text | Yes | unique |
| Parent_Company_RecID | Numeric | Yes | unique |
| Annual_Revenue | Numeric | No | unique |
| Revenue_Year | Numeric | Yes | unique |
| Nbr_Employees | Numeric | Yes | unique |
| Tax_Code_Desc | Text | Yes | unique |
| Tax_Code_ID | Text | Yes | unique |
| Currency_RecID | Numeric | Yes | |
| Currency_Desc | Text | Yes | unique |
| Currency_ID | Text | Yes | unique |
| Owner_Level_RecID | Numeric | Yes | 48 reports Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header 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 |
| Location | Text | Yes | unique |
| Time_Zone_RecID | Numeric | Yes | 1 report |
| SIC_Code_ID | Text | Yes | unique |
| Remit_To_RecID | Numeric | Yes | 2 reports |
| Billable_Flag | Numeric | Yes | unique |
| Userfield_1 | Text | Yes | unique |
| Userfield_2 | Text | Yes | unique |
| Userfield_3 | Text | Yes | unique |
| Userfield_4 | Text | Yes | unique |
| Userfield_5 | Text | Yes | unique |
| Userfield_6 | Text | Yes | unique |
| Userfield_7 | Text | Yes | unique |
| Userfield_8 | Text | Yes | unique |
| Userfield_9 | Text | Yes | unique |
| Userfield_10 | Text | Yes | unique |
| Unsubscribe_Flag | Boolean | Yes | unique |
| Vendor_Nbr | Text | Yes | unique |
| Delete_Flag | Boolean | No | unique |
| Updated_By | Text | No | unique |
| Last_Update | DateTime | No | unique |
| Time_Zone | Text | Yes | unique |
| Billing_Terms_RecID | Numeric | Yes | |
| Billing_Terms_Desc | Text | Yes | unique |
| Due_Days | Numeric | Yes | unique |
| Custom_Note | Text | Yes | unique |
| Userfield1_Caption | Text | Yes | unique |
| Userfield2_Caption | Text | Yes | unique |
| Userfield3_Caption | Text | Yes | unique |
| Userfield4_Caption | Text | Yes | unique |
| Userfield5_Caption | Text | Yes | unique |
| Userfield6_Caption | Text | Yes | unique |
| Userfield7_Caption | Text | Yes | unique |
| Userfield8_Caption | Text | Yes | unique |
| Userfield9_Caption | Text | Yes | unique |
| Userfield10_Caption | Text | Yes | unique |
| Contact_RecID | Numeric | Yes | 23 reports Activity Campaign Tracking Company Contact Communication Configs Configuration Contact Contact Communication Contact Contact Type Descriptions Contact Contact Types Contact Custom Fields Contact Group Contact Name Contact Presence Contacts Document Marketing Emails Opened Marketing Forms Submitted Marketing Links Clicked Opportunity Opportunity Restricted Project Contact Project Header Service Note |
| Default_Contact_First_Name | Text | Yes | unique |
| Default_Contact_Last_Name | Text | Yes | unique |
| Default_Contact_Email | Text | Yes | unique |
| Date_Entered | DateTime | No | unique |
| Date_Acquired | DateTime | Yes | unique |
| Delivery_Method | Text | Yes | unique |
| OwnershipType | Text | Yes | unique |
| Office_Calendar_RecID | Numeric | Yes | 5 reports |
| Company_Calendar | Text | Yes | unique |
| Last_Update_UTC | DateTime | No | unique |
| Date_Entered_UTC | DateTime | No | unique |
| Date_Acquired_UTC | DateTime | Yes | unique |
| Entered_By | Text | No | unique |
| Email_Cc_Flag | Boolean | No | unique |
| Email_Cc_Address | Text | Yes | unique |
| Tax_ID | Text | Yes | unique |
| BL_InvTemplate_Setup_RecID | Numeric | Yes | 1 report |
| IV_Price_Header_RecID | Numeric | Yes | 2 reports |
| Customer_Usage_Type_RecID | Numeric | Yes | 1 report |
| Bill_To_Company_RecID | Numeric | Yes | unique |
| Bill_To_Company_Name | Text | Yes | unique |
| Bill_To_Company_Address_RecID | Numeric | Yes | unique |
| Bill_To_Description | Text | Yes | unique |
| Bill_To_Contact_RecID | Numeric | Yes | unique |
| Bill_To_First_Name | Text | Yes | unique |
| Bill_To_Last_Name | Text | Yes | unique |
| Year_Established | Numeric | Yes | unique |