Contact
Contact
64 columns Fetched February 27, 2026
Columns
Contact_RecID Numeric
Also in 23 reports
Activity Campaign Tracking Company Company Contact Communication Configs Configuration 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
Company_RecID Numeric nullable
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 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
First_Name Text nullable
Last_Name Text nullable
Title Text nullable
Default_Flag Boolean nullable
Contact_Type_RecID Text nullable
Also in 2 reports
Contact_Type_Desc Text nullable
Default_Phone Text
Default_Email Text
Gender Text nullable
NickName Text nullable
Date_Birth DateTime nullable
Married_Flag Boolean
Spouse_Name Text nullable
Date_Anniversary DateTime nullable
Children_Flag Boolean
Children_Info Text nullable
School Text nullable
Hobbies Text nullable
Userfield1 Text nullable
Userfield2 Text nullable
Userfield3 Text nullable
Userfield4 Text nullable
Userfield5 Text nullable
Userfield6 Text nullable
Userfield7 Text nullable
Userfield8 Text nullable
Userfield9 Text nullable
Userfield10 Text nullable
Company_Address_RecID Numeric nullable
Personal_Address_Flag Boolean
Address_Line1 Text nullable
Address_Line2 Text nullable
City Text nullable
State_ID Text nullable
Zip Text nullable
Country Text nullable
Default_Billing_Flag Boolean
Unsubscribe_Flag Boolean
Inactive_Flag Boolean nullable
Image_Link Text nullable
Portal_PW Numeric nullable
Portal_Disable_Flag Boolean nullable
Portal_Security_Level Numeric nullable
Updated_By Text nullable
Last_Update DateTime
Time_Zone Text nullable
Territory 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
Department Text nullable
Last_Update_UTC DateTime
Delete_Flag Numeric nullable
| Name | Type | Nullable | Also In |
|---|---|---|---|
| Contact_RecID | Numeric | No | 23 reports Activity Campaign Tracking Company Company Contact Communication Configs Configuration 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 |
| Company_RecID | Numeric | Yes | 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 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 |
| First_Name | Text | Yes | unique |
| Last_Name | Text | Yes | unique |
| Title | Text | Yes | unique |
| Default_Flag | Boolean | Yes | unique |
| Contact_Type_RecID | Text | Yes | 2 reports |
| Contact_Type_Desc | Text | Yes | unique |
| Default_Phone | Text | No | unique |
| Default_Email | Text | No | unique |
| Gender | Text | Yes | unique |
| NickName | Text | Yes | unique |
| Date_Birth | DateTime | Yes | unique |
| Married_Flag | Boolean | No | unique |
| Spouse_Name | Text | Yes | unique |
| Date_Anniversary | DateTime | Yes | unique |
| Children_Flag | Boolean | No | unique |
| Children_Info | Text | Yes | unique |
| School | Text | Yes | unique |
| Hobbies | Text | Yes | unique |
| Userfield1 | Text | Yes | unique |
| Userfield2 | Text | Yes | unique |
| Userfield3 | Text | Yes | unique |
| Userfield4 | Text | Yes | unique |
| Userfield5 | Text | Yes | unique |
| Userfield6 | Text | Yes | unique |
| Userfield7 | Text | Yes | unique |
| Userfield8 | Text | Yes | unique |
| Userfield9 | Text | Yes | unique |
| Userfield10 | Text | Yes | unique |
| Company_Address_RecID | Numeric | Yes | |
| Personal_Address_Flag | Boolean | No | unique |
| Address_Line1 | Text | Yes | unique |
| Address_Line2 | Text | Yes | unique |
| City | Text | Yes | unique |
| State_ID | Text | Yes | unique |
| Zip | Text | Yes | unique |
| Country | Text | Yes | unique |
| Default_Billing_Flag | Boolean | No | unique |
| Unsubscribe_Flag | Boolean | No | unique |
| Inactive_Flag | Boolean | Yes | unique |
| Image_Link | Text | Yes | unique |
| Portal_PW | Numeric | Yes | unique |
| Portal_Disable_Flag | Boolean | Yes | unique |
| Portal_Security_Level | Numeric | Yes | unique |
| Updated_By | Text | Yes | unique |
| Last_Update | DateTime | No | unique |
| Time_Zone | Text | Yes | unique |
| Territory | 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 |
| Department | Text | Yes | unique |
| Last_Update_UTC | DateTime | No | unique |
| Delete_Flag | Numeric | Yes | unique |