ConnectWise Report Columns
Browse all 263 ConnectWise PSA /system/reports endpoints with 4,502 searchable columns.
Updated February 27, 2026
Report Name Matches
Column Matches
Accounts Receivable Aging
19 cols Company_RecID Company_Name Owner_Level_RecID Location Business_Unit_Description Billing_Unit_RecID +13 more
Activity
51 cols SO_Activity_Recid Contact_RecID Opportunity_Recid Subject SR_Service_Recid Date_Entered +45 more
Activity Custom Fields
10 cols User_Defined_Field_RecID Pod_RecID customfield_podID SO_Activity_RecID Subject activity_customfield +4 more
Activity Status
10 cols SO_Act_Status_RecID SO_Act_Status_Desc Default_Flag Closed_Flag Inactive_Flag Updated_By +4 more
Activity Type
8 cols SO_Activity_Type_RecID SO_Activity_Type_Desc Default_Flag Inactive_Flag Updated_By Last_Update +2 more
Agr Config Renewals
20 cols Rec_Table Company_Name Company_RecID Location Site_Name Rec_Name +14 more
Agr Site
8 cols AGR_Header_RecID AGR_Site_RecID SiteId AGR_Name Company_RecID Updated_By +2 more
Agr Type
70 cols AGR_Type_RecID AGR_Type_Desc AGR_Inactive_Flag Owner_Level_RecID OL_Restrict_Flag location +64 more
Agr Units
3 cols AGR_Detail_Type_ID AGR_Detail_Type_Desc Restrict_Flag
Agreement Additions
27 cols AGR_RecID AGR_Name Addition_RecId Product_RecId Product_Description Total_Quantity +21 more
Agreement App Cycle
5 cols AGR_AppCycle_RecID AppCycle_ID AppCycle_Name cycle_basis cycle_interval
Agreement Audit
8 cols AGR_Header_RecID AGR_Audit_RecID Audit_Text Audit_Source_ID Audit_Type_ID Locale_Text_key +2 more
Agreement Invoice
14 cols AGR_Header_RecID AGR_Name Billing_Log_RecID Invoice_Number Date_Invoice Company_RecID +8 more
Agreement List
41 cols AGR_Name AGR_Header_RecID agr_type_desc agr_type_recid PM_Type_RecID CompanyRecId +35 more
Batch
8 cols RecID GL_BatchID Last_Update Updated_By Procurement_Flag Invoice_Flag +2 more
Bill Rate Type
7 cols Rate_Type_RecID Rate_Type_ID Description Last_Update Updated_By Sort_Order +1 more
Billable Options
10 cols Billable_Options_RecID Option_Text Option_ID Billable_Flag Invoice_Flag Time_Flag +4 more
Billing Cycle
12 cols Bill_Cycle_ID Bill_Cycle_RecID Bill_Cycle_Desc Default_Flag Inactive_Flag Updated_By +6 more
Billing Delivery
7 cols Billing_Delivery_RecID Description Default_Flag Email_Flag Updated_By Last_Update +1 more
Billing Setup
33 cols Billing_Setup_RecID Owner_Level_RecID Payable_Name Currency_RecID PreSuf_Flag Invoice_PreSuf +27 more
Billing Status
9 cols Billing_Status_RecID Description Default_Flag Inactive_Flag Closed_Flag Sent_Flag +3 more
Billing Terms
3 cols Billing_Terms_RecID Description Default_Flag
Billing Unit
5 cols Billing_Unit_RecID BusGroup Updated_By Last_Update Time_Zone
Billing Unit Location
11 cols Billing_Unit_Loc_RecID Billing_Unit_RecID Owner_Level_RecID Description Member_RecID Dispatch +5 more
Calendar
20 cols Office_Calendar_RecID Description Holiday_List_RecID Sunday_Start Sunday_End Monday_Start +14 more
Calendar Setup
14 cols Calendar_Setup_RecID Week_Start Updated_by Last_Update Adj1Start Adj1End +8 more
Campaign Status
7 cols Campaign_Status_RecID Description Default_Flag Inactive_Flag Last_Update Updated_By +1 more
Campaign Sub Type
6 cols Campaign_SubType_RecID Campaign_Type_RecID Description Last_Update Updated_By Time_Zone
Campaign Tracking
13 cols Marketing_Campaign_Tracking_RecID Marketing_Campaign_RecID Contact_RecID Opened_Count Date_First_Opened Date_Last_Opened +7 more
Campaign Type
6 cols Campaign_Type_RecID Description Default_Flag Last_Update Updated_By Time_Zone
Charge Code
16 cols TE_Charge_Code_RecID Description Updated_By Last_Update Time_Zone Expense_Flag +10 more
Communication Type
9 cols Communication_Type_RecID Communication_Name Default_flag Phone_Flag Fax_Flag Email_Flag +3 more
Company
89 cols Company_RecID Company_ID Company_Name Company_Type_RecID Company_Type_Desc Company_Status_RecID +83 more
Company Address
25 cols Company_Address_RecID Company_RecID Company_Name Company_ID Site_Name Address_Line1 +19 more
Company Company Type Descriptions
2 cols Company_RecID Company_Types
Company Company Types
7 cols Company_RecID Company_ID Company_Name Company_Type_RecID Description Service_Alert_Flag +1 more
Company Contact Communication
35 cols Contact_RecID Reportsto_Name Company_ID Company_Phone Company_Name Company_Fax +29 more
Company Custom Fields
10 cols User_Defined_Field_RecID Pod_RecID customfield_podID Company_RecID Company_ID company_customfield +4 more
Company Entity Type
2 cols Entity_Type_RecID Description
Company Group
10 cols Company_Group_RecID Group_Type_RecID Group_Type_Desc Company_RecID DefaultContact_Flag AllContacts_Flag +4 more
Company Markets
7 cols Market_RecID MarketDescription Company_Name Company_RecID Updated_By Last_Update +1 more
Company Mgmt
15 cols Company_Mgmt_RecID Company_RecID Company_Name Company_ID Mgmt_It_Setup_RecID Mgmt_Setup_Name +9 more
Company Profile Userfields
10 cols Company_Userfield_1 Company_Userfield_2 Company_Userfield_3 Company_Userfield_4 Company_Userfield_5 Company_Userfield_6 +4 more
Company State Tax Rate
5 cols Company_RecID Company_ID Company_Name Tax_Code_RecID State_Rate
Company Status
15 cols Company_Status_RecID Company_Status_Desc Default_Flag Inactive_Flag Import_Flag Notify_Flag +9 more
Company Team
15 cols Company_Team_RecID Company_RecID Updated_By Description Member_RecID AcctMgr_Flag +9 more
Company Type
8 cols Company_Type_RecID Company_Type_Desc Import_Flag Default_Flag Updated_By Last_Update +2 more
Company Work Roles
16 cols Billing_Rate_RecID Company_RecID Date_Effective Date_Ending Rate_Type Activity_Class_RecID +10 more
Company Work Types
24 cols Activity_Type_RecID Company_RecID Company_Address_RecID Hours_Max Hours_Min Rate_Type +18 more
Config Custom Fields
10 cols User_Defined_Field_RecID Pod_RecID customfield_podID Config_RecID Config_Name config_customfield +4 more
Config Statuses
7 cols Config_Status_Recid ConfigStatus_Desc Closed_Flag Default_Flag Updated_By Last_Update +1 more
Config Types
9 cols Portal_Config_RecID CS_Survey_RecID ConfigType Instructions Inactive_Flag System_Flag +3 more
Configs
44 cols Id ConfigurationTypeId StatusId ConfigurationType Status ConfigurationName +38 more
Configuration
38 cols CS_Survey_RecID Config_Type Config_Name Manufacturer Serial_Number Model_Number +32 more
Configuration Agreement
14 cols AgreementName AgreementType AgrTypeRecId AgreementRecId ConfigurationRecId ConfigurationName +8 more
Configuration Type
7 cols RecID Name Instructions Inactive_Flag Updated_By Last_Update +1 more
Configuration Type Question
12 cols CS_Survey_RecID CS_Survey_Detail_RecID Question Seq_Nbr Field_Type Entry_Type +6 more
Connect Wise Hosted Api Screen
2 cols Presenter_Identifier_Client_Api_RecID Client_Api_ID
Contact
64 cols Contact_RecID Company_RecID Company_ID Company_Name First_Name Last_Name +58 more
Contact Communication
10 cols Contact_Communication_RecID Contact_RecID Communication_Type_RecID Communication_Name Default_Flag Contact_Communication_Desc +4 more
Contact Contact Type Descriptions
2 cols Contact_RecID Contact_Types
Contact Contact Types
7 cols Contact_RecID First_Name Last_Name Contact_Type_RecID Description Service_Alert_Flag +1 more
Contact Custom Fields
11 cols User_Defined_Field_RecID Pod_RecID customfield_podID Contact_RecID First_Name Last_Name +5 more
Contact Group
12 cols Contact_Group_RecID Group_Type_RecID Group_Type_Desc Contact_RecID Unsubscribe_Flag Public_Flag +6 more
Contact Name
6 cols First_Name Last_Name Contact_RecID Updated_By Last_Update Time_Zone
Contact Presence
6 cols Contact_Presence_RecID Contact_Presence_Type_RecID Contact_RecID Updated_By Last_Update_UTC Time_Zone
Contact Relationship
5 cols Relationship_RecID Relationship Updated_By Last_Update Time_Zone
Contact Type
7 cols Contact_Type_RecID Contact_Type_ID Description Default_Flag Updated_By Last_Update +1 more
Contacts
24 cols Contact_RecID First_Name Last_Name Company_Name Phone Email +18 more
Conversion History
9 cols Conversion_History_RecID Conversion_Type_ID Converstion_Type_Desc Converted_To_RecID Parent_Type_ID Parent_Type_Desc +3 more
Countries
11 cols Country_RecID Country City_Caption State_Caption Zip_Caption Updated_By +5 more
Currency
10 cols Currency_RecID Currency_ID Description Currency_Symbol DisplayID_Flag DisplaySymbol_Flag +4 more
Custom Caption
5 cols Field_Name Caption Updated_By Last_Update Time_Zone
Custom Fields
11 cols customfield_recid customfield_caption customfield_type customfield_nbrdecimals customfield_screenID customfield_podID +5 more
Custom Fields Options
6 cols customfield_recid customfield_caption customfield_option_recid option_value Default_Flag Inactive_Flag
Cw Start Detail
16 cols CW_Start_Detail_RecID Teams_Audio_Visual_Flag Teams_Cloud_Service_Provider_Flag Teams_Internal_It_Flag Teams_Managed_Security_Flag Teams_Managed_Services_Flag +10 more
Department
5 cols Department_RecID Department_Name Last_Update Updated_By Time_Zone
Document
25 cols DM_Document_RecID DM_Relationship_RecID Title Filename ServerFilename Path +19 more
Expense
44 cols EX_Detail_RecID Member_RecID Member_ID First_Name Last_Name Owner_Level_RecID +38 more
Expense Classification
6 cols EX_Class_RecID Description Multiplier Default_Flag Company_Flag Employee_Flag
Expense Custom Fields
10 cols User_Defined_Field_RecID Pod_RecID customfield_podID EX_Detail_RecID EX_Header_RecID expense_customfield +4 more
Expense Payment Method
8 cols EX_Payment_RecID Description Company_Flag Updated_By Last_Update Default_Flag +2 more
Expense Reports
11 cols TE_Period_RecID TE_Status_ID Description Period Date_Start Date_End +5 more
Expense Tax
7 cols EX_Detail_RecID EX_Detail_Tax_RecID EX_Tax_Type_RecID EX_Tax_Type_Desc Tax_Amount Last_Update_UTC +1 more
Expense Tax Type
5 cols EX_Tax_Type_RecID EX_Tax_Type_Desc Inactive_Flag Last_Update_UTC Updated_By
Expense Type
16 cols EX_Type_RecID Description Mileage_Flag Quantity_Flag Reimbursement_Rate Amount_Caption +10 more
Group Type
10 cols Group_Type_RecID Company_Group_Name Company_Flag Contact_Flag Inactive_Flag Public_Flag +4 more
Holiday
9 cols Holiday_List_RecID Holiday_List_Name Holiday_Date Time_Start Time_End Description +3 more
IVCategory
6 cols IV_Cat_RecID IV_Cat_Desc Inactive_Flag Updated_By Last_Update Time_Zone
IVClass
2 cols IV_Class_ID IV_Class_Desc
IVPrice Attribute
4 cols IV_Price_Attribute_RecID IV_Price_Attribute_ID Description Default_Flag
IVProduct Bundle
13 cols IV_Product_Bundle_RecID IV_Product_RecID Parent_RecID Sequence_Number Quantity Hide_Price_Flag +7 more
IVSub Category
7 cols IV_SubCat_RecID IV_Cat_RecID IV_SubCat_Desc Inactive_Flag Updated_By Last_Update +1 more
IVType
7 cols IV_Type_RecID IV_Type_Desc Inactive_Flag Item_Type_Xref Updated_By Last_Update +1 more
IVUom
7 cols IV_UOM_RecID IV_Uom_Desc Default_Flag Inactive_Flag Updated_By Last_Update +1 more
Inventory Balance
3 cols inv_type total val_date
Inventory Balance With Shipped Not Invoiced
5 cols inv_type total val_date billing_log_recid date_created
Inventory Item
34 cols IV_Item_RecID Item_ID Description IV_Type_RecID IV_SubCat_RecID Short_Name +28 more
Inventory Movement
9 cols Date Type Ref Customer ProductId Description +3 more
Invoice Agreement Additions
22 cols Billing_Log_RecID Type IV_Item_RecID Line_Desc IV_Product_RecID AGR_Detail_RecID +16 more
Invoice Custom Fields
10 cols User_Defined_Field_RecID Pod_RecID customfield_podID Billing_Log_RecID Invoice_Number invoice_customfield +4 more
Invoice Email Template
8 cols Email_Template_RecID Template_Name Billing_Status_RecID Subject Default_Flag Updated_By +2 more
Invoice Expense
30 cols EX_Detail_RecID Member_RecID Member_ID First_Name Last_Name Billing_Log_RecID +24 more
Invoice Header
120 cols Billing_Log_RecID Invoice_Number Billing_Unit_RecID Company_Address_RecID Company_RecID Company_Name +114 more
Invoice Payments
10 cols Billing_Application_RecID Billing_Log_RecID Credit_Memo_RecID Invoice_Number Applied_Amount Payment_Type +4 more
Invoice Product
29 cols IV_Product_RecID IV_Item_RecID Item_ID Item_Desc Billing_Log_RecID Billable_Flag +23 more
Invoice Template
4 cols Template_Name BL_InvTemplate_RecID BL_InvTemplate_Setup_RecID BL_InvTemplate_Custom_RecID
Invoice Time
42 cols Billing_Log_RecID Invoice_Number Time_RecID Notes Member_ID First_Name +36 more
Invoice Types
3 cols Billing_Type_ID InvoiceType_Desc Downpayment_Flag
Invoices
92 cols Billing_Log_RecID Invoice_Number Invoice_Type Billing_Type_ID Company_RecID CompanyRecId +86 more
Kb Resolution Audit Trail
16 cols KB_Resolution_RecID KB_Category_RecID KB_SubCategory_RecID Summary Company_RecId Owner_Level_RecID +10 more
Knowledgebase Category
7 cols KB_Category_RecID Description Owner_Level_RecID Billing_Unit_RecID Last_Update Updated_By +1 more
Knowledgebase Sub Category
8 cols KB_SubCategory_RecID Description KB_Category_RecID Owner_Level_RecID Billing_Unit_RecID Last_Update +2 more
Link
7 cols Screen_Link_RecID Link_Name Screen_Link_Table_RecID Link_Definition Updated_By Last_Update +1 more
Link Tokens
6 cols Token_RecID Token Token_Description Service_Flag Company_Flag Contact_Flag
Locale
3 cols Locale_RecID Locale Default_Flag
Location Bus Group
8 cols Owner_Level_RecID Location Billing_Unit_RecID BusGroup Updated_By Last_Update +2 more
Managed Device XRef
15 cols Mgmt_It_Setup_RecID Mgmt_Solution_Name Mgmt_It_Levels_RecID Level Type CS_Survey_RecID +9 more
Management Report Setup
5 cols Company_Mgmt_Setup_RecID Company_RecID Scheduled_Report_Disabled Last_Update Updated_By
Manufacturer
7 cols Manufacturer_RecID Manufacturer_Name Inactive_Flag Updated_By Last_Update Time_Zone +1 more
Market
3 cols MarketId MarketName Last_Update_UTC
Marketing Campaign
33 cols Marketing_Campaign_RecID Marketing_ID Inactive_Flag Campaign_Subtype_RecID Campaign_Status_RecID Date_Start +27 more
Marketing Emails Opened
5 cols Marketing_Manager_Email_Opened_RecID Marketing_Campaign_RecID Contact_RecID Date_Opened Time_Zone
Marketing Forms Submitted
12 cols Marketing_Manager_Form_Submitted_RecID Marketing_Campaign_RecID Contact_RecID Date_Submitted URL QueryString +6 more
Marketing Links Clicked
7 cols Marketing_Manager_Link_Clicked_RecID Marketing_Campaign_RecID Contact_RecID Date_Clicked URL QueryString +1 more
Marketing ROI
18 cols Campaign Campaign_Type Campaign_SubType Start_Date End_Date Location +12 more
Meeting Audit
12 cols Meeting_RecID Meeting_Audit_RecID Audit_Text Audit_Source_ID Created_By Date_Entered_UTC +6 more
Member
97 cols Member_RecID Member_ID First_Name Middle_Initial Last_Name Title +91 more
Member Audit
8 cols Member_RecID Member_Audit_RecID Audit_Text Locale Audit_Source Audit_Type +2 more
Member Certifications
15 cols RM_Cert_Mbr_RecID RM_Cert_RecID Company_RecID Company_Name Cert_Name Member_RecID +9 more
Member Security Roles
11 cols FO_Role_Security_RecID Member_ID Module_ID Module_Name Add_Level Edit_Level +5 more
Member Skills
16 cols RM_Skill_Mbr_RecID Member_RecID RM_Skill_Cat_RecID Cat_Name RM_Skill_RecID Skill_Name +10 more
My Account Custom Fields
10 cols User_Defined_Field_RecID Pod_RecID customfield_podID Member_RecID Member_ID myaccount_customfield +4 more
My Company
16 cols Internal_Company_RecID President_RecID COO_RecID Controller_RecID Dispatch_RecID ServiceManager_RecID +10 more
Note Type
8 cols Description Default_Flag Updated_By Last_Update Time_Zone Note_Type_RecID +2 more
Notify Who
5 cols WF_NotifyWho_RecID WF_NotifyWho_ID Notify_Description External_Flag Service_Flag
Opportunity
54 cols Opportunity_RecID Opportunity_Name so_type_recid Date_Became_Lead so_Type Opportunity_Desc +48 more
Opportunity Custom Fields
10 cols customfield_podID Opportunity_RecID Opportunity_Name opportunity_customfield opportunity_customvalue opportunity_fieldtype +4 more
Opportunity Interest
7 cols SO_Interest_RecID SO_Interest_Desc Sort_Order Updated_By Last_Update Time_Zone +1 more
Opportunity Note
10 cols SO_Notes_RecID Opportunity_RecID Seq_Nbr Note_Type_RecID Notes SO_Flag +4 more
Opportunity Pipeline
8 cols SO_Pipeline_RecID Seq_Nbr SO_Pipeline_Desc SO_Probability_RecID Updated_By Last_Update +2 more
Opportunity Probability
6 cols SO_Probability_RecID Probability Updated_By Last_Update Time_Zone Last_Update_UTC
Opportunity Sales Role
5 cols SO_Role_RecID Description Last_Update Updated_By Time_Zone
Opportunity Status
13 cols SO_Opp_Status_RecID SO_Opp_Status_Desc Won_Flag Lost_Flag Closed_Flag Inactive_Flag +7 more
Opportunity Type
7 cols SO_Type_RecID SO_Type_Desc Update_By Last_Update Time_Zone Last_Update_UTC +1 more
Opportunity Urgency
4 cols SO_Urgency_RecID SO_Urgency_Desc Sort_Order Default_Flag
Opportunity Restricted
55 cols Opportunity_RecID Opportunity_Name so_type_recid Date_Became_Lead so_Type Opportunity_Desc +49 more
Owner Level
26 cols Owner_Level_RecID Location Location_Flag Updated_By Last_Update Time_Zone +20 more
Ownership Type
5 cols Ownership_Type_RecID Description Updated_By Last_Update Time_Zone
Phase Status
7 cols Phase_Status_RecID Description Default_Flag Inactive_Flag Closed_Flag Last_Update_UTC +1 more
Pod
6 cols Pod_RecID PodID ScreenID Locale_Key_RecID Last_Update_UTC Updated_By
Portal Agr Type
13 cols Portal_Config_RecID AGR_Type_RecID AGR_Type_Desc AGR_Inactive_Flag Owner_Level_RecID OL_Restrict_Flag +7 more
Portal Config Names
7 cols Portal_Name Company_RecID Company_Name Default_Flag Updated_By Last_Update +1 more
Portal Config Service Boards
5 cols Portal_Config_RecID Portal_Name SR_Board_RecID Board_Name Portal_Config_SR_Board_RecID
Portal Invoices
41 cols Billing_Log_RecID Invoice_Number Invoice_Type Billing_Type_ID Company_RecID CompanyRecId +35 more
Portal Project
27 cols ProjectNbr ProjectName CompanyRecId ProjectType_Desc PM_Billing_Method_ID BillingMethod_Desc +21 more
Portal Security
12 cols Portal_Security_RecID Function_Id Function_Description Level1 Level2 Level3 +6 more
Portal Security Captions
5 cols Security_Level Caption Updated_By Last_Update Time_Zone
Portal Service
63 cols TicketNbr Rec_Type owner_level_recid Location billing_unit_recid SR_Board_RecID +57 more
Portal Ticket Type Description
5 cols Portal_Config_RecID PortalTicketType_Desc SR_Board_RecID Board_Name SR_Portal_Type_RecID
Portal Ticket Types
13 cols recid Portal_Config_RecID CompanyID PortalTicketType_Desc Summary Problem +7 more
Price Header
8 cols IV_Price_Header_RecID Price_Schedule_Name Owner_Level_RecID Location Inactive_Flag Updated_By +2 more
Pricing Schedule
31 cols IV_Price_Header_RecID Price_Schedule_Name Owner_Level_RecID Inactive_Flag Default_Flag IV_Price_Detail_RecID +25 more
Product
55 cols Sub_Number IsParent parent_recid IV_Product_RecID iv_item_recid item_id +49 more
Product Detail
18 cols IV_Product_Detail_RecID IV_Product_RecID IV_Product_Description Line_Number Serial_Number Tracking_Number +12 more
Product Entity Type
3 cols Customer_Usage_Type_RecID Customer_Usage_Type_Code Description
Project
85 cols Rec_Type ProjectNbr ProjectName ProjectManager Phase wbs_code +79 more
Project Audit
9 cols PM_Project_RecID Last_Updated_utc Audit_Type_RecId Audit_Text Audit_Source member_recid +3 more
Project Billing Methods
5 cols PM_Billing_Method_RecID PM_Billing_Method_ID BillingMethod_Desc Default_Flag Override_Flag
Project Board
10 cols ProjectBoardName ProjectBoardRecId Inactive Updated_By Last_Update Time_Zone +4 more
Project Contact
7 cols PM_Contact_RecID PM_Project_RecID Contact_RecID PM_Role_RecID Updated_By Last_Update +1 more
Project Custom Fields
10 cols User_Defined_Field_RecID Pod_RecID customfield_podID PM_Project_RecID Project_ID project_customfield +4 more
Project Header
43 cols Owner_ID PM_Project_RecID Company_RecID Company_Name Project_Name Project_Manager +37 more
Project Note
9 cols PM_Note_RecID PM_Project_RecID Note_Type_RecID Notes Red_Flag Entered_By +3 more
Project Role
7 cols PM_Role_RecID PM_Role_ID Manager_Flag Default_Contact_Flag Updated_By Last_Update +1 more
Project Status
8 cols ProjectName ProjectRecId StatusName StatusRecId Updated_By Last_Update +2 more
Project Statuses
9 cols PM_Status_RecID ProjectStatus_Desc Default_flag Inactive_Flag No_Time_Flag Closed_Flag +3 more
Project Team Member
13 cols PM_Team_RecID PM_Project_RecID PM_Role_RecID Team_Flag RecID Member_ID +7 more
Project Template
7 cols PM_Tmp_Project_RecID Template_Name PM_Type_RecID Notes Updated_By Last_Update +1 more
Project Types
7 cols PM_Type_RecID ProjectType_Desc Default_Flag Inactive_Flag Updated_By Last_Update +1 more
Purchase Order
63 cols Purchase_Order_RecID PO_Number Purchase_Date Billing_Terms_RecID Billint_Terms_Description Total +57 more
Purchase Order Statuses
10 cols PO_Status_RecID Description Default_Flag Closed_Flag Inactive_Flag Updated_By +4 more
Purchase Order Template
81 cols Purchase_Order_RecID PO_Number Purchase_Date Billing_Terms_RecID Billing_Terms_Description Total +75 more
Purchase Order Template Products
11 cols Item_ID Customer_PO Mfg_SKU Vendor_SKU Product_Description ItemUOM +5 more
Purchase Order With Line Items
25 cols IV_Item_RecID Item_ID Serialized_Flag Description Quantity Received_Qty +19 more
RMATag
5 cols RMA_Tag_RecID Product_Description Updated_By Last_Update Time_Zone
Reminder Minutes
8 cols ReminderTimeId Reminder_Time ReminderDescription Default_Flag Updated_By Last_Update +2 more
SICCode
4 cols SIC_Code_RecID SIC_Code_ID Description SIC_Category
SLA
17 cols SR_SLA_RecID SLA_Name Responded_Hours ResPlan_Hours Resolution_Hours Responded_Pct +11 more
SLAPriority
11 cols SR_SLA_RecID Responded_Hours ResPlan_Hours Resolution_Hours Responded_Pct ResPlan_Pct +5 more
Sales Commission
14 cols Billing_Commission_RecID Member_RecID Company_RecID Type Type_Id Invoice_Number +8 more
Sales Order
9 cols Order_Header_RecID Description Order_Date Order_Due_Date Company_RecID Company_Address_RecID +3 more
Sales Order Custom Fields
10 cols User_Defined_Field_RecID Pod_RecID customfield_podID Order_Header_RecID Purchase_Order_Number sales_order_customfield +4 more
Sales Order Status
8 cols Order_Status_RecID Description Default_Flag Closed_Flag Inactive_Flag Sort_Order +2 more
Sales Team
11 cols Sales_Team_RecID Sales_Team_ID Owner_Level_recid Sales_Team_Member_RecID Member_ID Member_RecID +5 more
Schedule
42 cols Table_Reference Display_Color System_Flag Reminder_Time_Desc Schedule_RecID RecID +36 more
Schedule Location
6 cols LocationId LocationDescription Default_Flag Updated_By Last_Update Time_Zone
Schedule Span
3 cols SpanId SpanIdentifier SpanDescription
Schedule Status
7 cols ScheduleStatusId StatusDescription Default_Flag Updated_By Last_Update Time_Zone +1 more
Schedule Type
10 cols Schedule_Type_RecID Schedule_Type_ID Description Updated_By Last_Update Time_Zone +4 more
Screen Connect Session
5 cols ScreenConnect_Session_RecID SR_Service_RecID Config_RecID Member_RecID Session_GUID
Screen Link Table Reference
2 cols Screen_Link_Table_RecID Table_Reference
Service
104 cols TicketNbr owner_level_recid Location billing_unit_recid BusGroup SR_Board_RecID +98 more
Service Audit
9 cols TicketNbr SR_Audit_RecID Audit_Text Audit_Source Email_Address Updated_By +3 more
Service Board
33 cols Board_Name SR_Board_RecID Owner_Level_RecID Location billing_unit_recid BusGroup +27 more
Service Board Members
6 cols SR_BoardMbr_RecID SR_Board_RecID Member_RecID Updated_By Last_Update Time_Zone
Service Code
9 cols SR_Code_RecID Owner_Level_RecID Billing_Unit_RecID SR_Board_RecID ServiceCodeName ServiceCodeDesc +3 more
Service Custom Fields
10 cols User_Defined_Field_RecID Pod_RecID customfield_podID SR_Service_RecID Summary service_customfield +4 more
Service Item
17 cols SR_SubTypeItem_RecID ServiceItemDesc SR_Board_RecID Board_Name Inactive_Flag SR_SubType_RecID +11 more
Service KPICount By Hour
6 cols Date_Entered_UTC Day_Entered_UTC Hour_Entered_UTC Hour_Nbr_UTC SR_Board_RecID TicketCount
Service Location
8 cols Company_Address_RecID Company_RecID ServiceLocation_Desc Inactive_Flag Updated_By Last_Update +2 more
Service Metrics Aging
5 cols SR_Service_RecID IsClosed_Flag Age Age_Group Past_Required_Date
Service Metrics Counts
5 cols SR_Service_RecID Closed_Flag Configuration_Count Resources_Remaining_Count Time_Entry_Count
Service Note
13 cols RecID SR_Service_RecID Notes Detail_Description_Flag Internal_Analysis_Flag Resolution_Flag +7 more
Service Priority
9 cols SR_Urgency_RecID Service_Priority_Desc Sort_Order Color Default_Flag Updated_By +3 more
Service Signoff
3 cols SR_Signoff_RecID SR_Signoff_Name Default_Flag
Service Signoff Custom Field
5 cols Sequence_Number SR_Signoff_Custom_Field_RecID SR_Signoff_RecID Display_Section User_Defined_Field_RecID
Service Status
18 cols SR_Status_RecID Service_Status_Desc Board_Name Sort_Order Default_Flag Inactive_Flag +12 more
Service Sub Type
15 cols SR_SubType_RecID ServiceSubTypeDesc SR_Board_RecID Board_Name Inactive_Flag SR_Type_RecID +9 more
Service Sub Type Item Template
7 cols SR_Type_SubType_SubTypeItem_Template_RecID SR_Type_RecID SR_SubType_RecID SR_SubTypeItem_RecID SRT_Service_RecID Auto_Apply +1 more
Service Sub Type Item Template Option
7 cols SR_Type_SubType_SubTypeItem_Template_Option_RecID SR_Type_SubType_SubTypeItem_Template_RecID Option_Name Append_Flag Overwrite_Flag Ignore_Flag +1 more
Service Task
14 cols SR_Task_RecID SR_Service_RecID SR_Code_RecID Notes Assign_To_RecID Closed_Flag +8 more
Service Team
14 cols SR_Team_RecID ServiceTeam SR_Board_RecID Board_Name Default_Flag DeleteNotify_Flag +8 more
Service Template
12 cols SRT_Service_RecID SRT_Template_Name Summary Board_Name SR_Board_RecID SR_Type_RecID +6 more
Service Template Task
10 cols SRT_Task_RecID SRT_Service_RecID Priority SR_Code_RecID Parent_SRT_Task_RecID Notes +4 more
Service Type
15 cols SR_Type_RecID ServiceType SR_Board_RecID Board_Name Inactive_Flag Owner_Level_RecID +9 more
Service Open
99 cols TicketNbr owner_level_recid Location billing_unit_recid BusGroup SR_Board_RecID +93 more
Service SLA
33 cols SR_Service_RecID Summary SR_SLA_RecID SLA_Name Responded_Minutes Responded_Hours +27 more
Service Source
9 cols SR_Source_RecID Service_Source_Desc Default_Flag Updated_By Last_Update Time_Zone +3 more
Service Summary
100 cols TicketNbr owner_level_recid Location billing_unit_recid BusGroup SR_Board_RecID +94 more
Service Summary Open
97 cols TicketNbr owner_level_recid Location billing_unit_recid BusGroup SR_Board_RecID +91 more
Shipment Method
5 cols ShipmentMethod_RecID ShipMethodDescription Last_Update Time_Zone Last_Update_UTC
States
7 cols State_RecID State_ID State_Desc Updated_By Last_Update Time_Zone +1 more
Surveys
17 cols SurveyYr SurveyQtr SurveyName CompanyName Email Ticket +11 more
Surveys By Ticket
12 cols SR_Service_RecID Rec_Type Closed_Flag Date_Sent Surveys_Sent Date_Completed +6 more
System Menus
5 cols system_menus_recid menu_id description favorites_flag sort_order
Tax Code
86 cols Tax_Code_ID Tax_Code_RecID Tax_Code_Desc Default_Flag State_ID Country_RecID +80 more
Team Role
5 cols Team_Role_RecID Role_Desc Updated_By Last_Update Time_Zone
Ticket Audit
12 cols SR_Service_RecID SR_Service_Audit_RecID Audit_Text Audit_Source_ID Created_By Date_Entered_UTC +6 more
Time
68 cols Time_RecID member_recid member_id first_name last_name Owner_Level_RecID +62 more
Time Audit
10 cols Time_RecID Time_Audit_RecID Audit_Text Audit_Source_ID Created_By Date_Entered_UTC +4 more
Time Entry Custom Fields
10 cols User_Defined_Field_RecID Pod_RecID customfield_podID Time_RecID Time_Sheet_RecID time_entry_customfield +4 more
Time Sheet Audit
10 cols Time_Audit_RecID Time_Sheet_RecID Member_Identifier Member_Name Submitted_By Date_Start +4 more
Time Sheets
11 cols TE_Period_RecID TE_Status_ID Description Period Date_Start Date_End +5 more
Time Status
4 cols TE_Status_RecID TE_Status_ID Description Action
Time Zone
10 cols Time_Zone_RecID Time_Zone_Name Hours_Offset Default_Flag Last_Update Time_Zone +4 more
Track
6 cols WF_Track_Header_RecID Description Inactive_Flag Updated_By Last_Update Time_Zone
Transaction
53 cols GL_Entry_RecID GL_BatchID GL_BatchID_RecID Billing_Log_RecID Invoice_Number Owner_Level_RecID +47 more
Unposted Expense
35 cols Date_Expense Owner_Level_RecID Owner_Level_Name RecID GL_Entry_RecID Last_Update +29 more
Unposted Invoice
34 cols Invoice_Number Date_Invoice RecID GL_Entry_RecID GL_Description GL_Amount +28 more
Unposted Procurement
26 cols GL_Entry_RecID RecID RecType GL_Description Date GL_Amount +20 more
User Defined Entry Type
3 cols SF_Entry_Type_RecID SF_Entry_Type_ID SF_Entry_Name
User Defined Field
21 cols User_Defined_Field_RecID SF_Field_TypeIdentifier SF_Entry_TypeIdentifier Nbr_Decimals Caption Required_Flag +15 more
User Defined Field Billing Units
5 cols User_Defined_Field_Billing_Unit_RecID User_Defined_Field_RecID Billing_Unit_RecID Updated_By Last_Update_UTC
User Defined Field Option
8 cols User_Defined_Field_Option_RecID User_Defined_Field_RecID User_Defined_Field_Option Sort_Order Default_Flag Last_Update_UTC +2 more
User Defined Field Owner Levels
5 cols User_Defined_Field_Owner_Level_RecID User_Defined_Field_RecID Owner_Level_RecID Updated_By Last_Update_UTC
User Defined Field Type
10 cols SF_Field_Type_RecID SF_Field_Type_ID SF_Name Display_Info Decimals_Flag Default_Decimals +4 more
User Defined Required Field
7 cols User_Defined_Required_Field_RecID Pod_RecID Field_ID Required_Flag Display_Flag Last_Update_UTC +1 more
Warehouse
16 cols Warehouse_RecID Owner_Level_RecID Location Billing_Unit_RecID BusGroup Company_RecID +10 more
Warehouse Bin
20 cols Warehouse_Bin_RecID Warehouse_RecID Warehouse_Bin_Desc Owner_Level_RecID Location BusGroup +14 more
Work Roles
11 cols Activity_Class_RecID work_role Inactive_Flag Hourly_Cost Hourly_Rate taxexempt_flag +5 more
Work Roles Location
7 cols Activity_Class_Loc_RecID Activity_Class_RecID Owner_Level_RecID Hourly_Rate Updated_By Last_Update +1 more
Work Types
20 cols Activity_Type_RecID work_type Hours_Min Hours_Max Default_Flag Multiplier_Flag +14 more
No reports match your search.