Service Summary

Service_Summary

100 columns Fetched February 27, 2026

Related Reports

Service Summary Open 17 shared Service 16 shared Service Open 16 shared Project 7 shared Portal Service 5 shared

n8n

Columns

TicketNbr Numeric
owner_level_recid Numeric
Location Text nullable
billing_unit_recid Numeric nullable
BusGroup Text nullable
SR_Board_RecID Numeric nullable
Also in 21 reports
Kb Resolution Audit Trail Member Portal Config Service Boards Portal Project Portal Service Portal Ticket Type Description Project Project Header Service Service Board Service Board Members Service Code Service Item Service KPICount By Hour Service Status Service Sub Type Service Team Service Template Service Type Service Open Service Summary Open
Board_Name Text nullable
Site_Name Text nullable
sr_status_recid Numeric
Urgency Text nullable
service_location Text nullable
Status_SortOrder Numeric nullable
status_description Text nullable
Source Text nullable
Closed_Flag Boolean nullable
ClosedDesc Text
date_closed DateTime nullable
closed_by Text nullable
Type_RecID Numeric nullable
Also in 5 reports
Portal Service Project Service Service Open Service Summary Open
ServiceType Text
SubType_RecID Numeric nullable
Also in 5 reports
Portal Service Project Service Service Open Service Summary Open
ServiceSubType Text
SubTypeItem_RecID Numeric nullable
Also in 5 reports
Portal Service Project Service Service Open Service Summary Open
ServiceSubTypeItem Text
Company_Name Text nullable
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 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 Open Time Unposted Expense Unposted Invoice Warehouse
Contact_Name Text nullable
contact_recid Numeric
Address_Line1 Text
Country Text
Summary Text nullable
AGR_Header_RecID Numeric nullable
Also in 20 reports
Agr Site Agreement Audit Agreement Invoice Agreement List Company Mgmt Company Work Roles Company Work Types Document Invoice Agreement Additions Invoice Header Invoice Product Invoices Portal Invoices Portal Service Project Project Header Service Service Open Service Summary Open Time
agreement_name Text
team_name Text
Territory Text nullable
territory_recid Numeric nullable
Territory_Manager Text nullable
date_entered DateTime nullable
entered_by Text nullable
Approved Boolean
Last_Update_UTC DateTime nullable
Last_Update DateTime nullable
Time_Zone Text nullable
Updated_By Text nullable
Date_Required DateTime nullable
Hours_Actual Numeric nullable
Hours_Budget Numeric nullable
Hours_Scheduled Numeric nullable
Hours_Billable Numeric nullable
Hours_NonBillable Numeric nullable
Hours_Invoiced Numeric nullable
Hours_Agreement Numeric nullable
Parent Numeric nullable
resource_list Text nullable
Assigned_By_RecID Numeric nullable
Also in 3 reports
Service Service Open Service Summary Open
Opportunity_RecID Numeric nullable
Also in 12 reports
Agreement Additions Document Invoice Product Opportunity Opportunity Custom Fields Opportunity Note Opportunity Restricted Product Service Service Open Service Summary Open Time
config_recids Text nullable
Address_Line2 Text
City Text
State Text
PostalCode Text
Age Numeric nullable
Date_Resolved_UTC DateTime nullable
Date_Resplan_UTC DateTime nullable
Date_Responded_UTC DateTime nullable
Date_Status_Changed_UTC DateTime nullable
Escalation_Start_Date_UTC DateTime nullable
Minutes_Before_Waiting Numeric
Minutes_Waiting Numeric
Overall_Start_Date_UTC DateTime nullable
Previous_SR_Status_RecID Numeric nullable
Also in 3 reports
Service Service Open Service Summary Open
Resolved_By Text nullable
Resolved_Minutes Numeric
Resplan_Minutes Numeric
Resplan_Skipped_Minutes Numeric
Responded_By Text nullable
Responded_Minutes Numeric
Responded_Skipped_Minutes Numeric
Waiting_Flag Boolean
Severity Text nullable
SR_Severity_RecID Numeric nullable
Also in 3 reports
Service Service Open Service Summary Open
Impact Text nullable
SR_Impact_RecID Numeric nullable
Also in 3 reports
Service Service Open Service Summary Open
SR_Service_RecID Numeric
Also in 21 reports
Document Expense Invoice Expense Invoice Product Invoice Time Project Schedule Screen Connect Session Service Service Custom Fields Service Metrics Aging Service Metrics Counts Service Note Service Task Service Open Service SLA Service Summary Open Surveys By Ticket Ticket Audit Time Transaction
Date_Entered_UTC DateTime nullable
Date_Closed_UTC DateTime nullable
SR_Billing_Method_RecID Numeric nullable
Also in 3 reports
Service Service Open Service Summary Open
SR_Billing_Method_ID Text nullable
ServiceBillingMethod Text nullable
PM_Phase_RecID Numeric nullable
Also in 9 reports
Expense Invoice Expense Invoice Header Invoices Project Service Service Open Service Summary Open Transaction
Priority_Description Text nullable
Priority_Sort_Order Numeric nullable
Ticket_Owner_RecID Numeric nullable
Also in 3 reports
Service Service Open Service Summary Open
SR_SLA_RecID Numeric nullable
Also in 8 reports
Agr Type Configs SLA SLAPriority Service Service Open Service SLA Service Summary Open
Est_Start_Date_UTC DateTime nullable
SR_Urgency_RecID Numeric
Also in 6 reports
Agr Type SLAPriority Service Service Priority Service Open Service Summary Open
Ticket_Owner_First_Name Text nullable
Ticket_Owner_Last_Name Text nullable
Closed_Age Numeric nullable
Priority_Level Text nullable