Service

Service

104 columns Fetched February 27, 2026

Related Reports

Service Open 16 shared Service Summary 16 shared Service Summary 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 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 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 Open Service Summary Service Summary Open
ServiceType Text
SubType_RecID Numeric nullable
Also in 5 reports
Portal Service Project Service Open Service Summary Service Summary Open
ServiceSubType Text
SubTypeItem_RecID Numeric nullable
Also in 5 reports
Portal Service Project Service Open Service Summary Service Summary Open
ServiceSubTypeItem Text
company_name Text nullable
company_recid Numeric nullable
contact_name Text nullable
contact_recid Numeric
Address_Line1 Text
Address_Line2 Text
City Text
State Text
PostalCode Text
Country Text nullable
Summary Text nullable
Detail_Description Text nullable
Internal_Analysis Text nullable
Resolution 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 Open Service Summary 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 DateTime nullable
Last_Update_UTC 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 Open Service Summary Service Summary Open
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 nullable
Minutes_Waiting Numeric nullable
Overall_Start_Date_UTC DateTime nullable
Previous_SR_Status_RecID Numeric nullable
Also in 3 reports
Service Open Service Summary Service Summary Open
Resolved_By Text nullable
Resolved_Minutes Numeric nullable
Resplan_Minutes Numeric nullable
Resplan_Skipped_Minutes Numeric nullable
Responded_By Text nullable
Responded_Minutes Numeric nullable
Responded_Skipped_Minutes Numeric nullable
Waiting_Flag Boolean nullable
Severity Text nullable
SR_Severity_RecID Numeric nullable
Also in 3 reports
Service Open Service Summary Service Summary Open
Impact Text nullable
SR_Impact_RecID Numeric nullable
Also in 3 reports
Service Open Service Summary 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 Open Service Summary Service Summary Open Time
SR_Service_RecID Numeric
Also in 21 reports
Document Expense Invoice Expense Invoice Product Invoice Time Project Schedule Screen Connect Session Service Custom Fields Service Metrics Aging Service Metrics Counts Service Note Service Task Service Open Service SLA Service Summary 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 Open Service Summary Service Summary Open
SR_Billing_Method_ID Text nullable
ServiceBillingMethod Text nullable
config_recids Text nullable
PM_Phase_RecID Numeric nullable
Also in 9 reports
Expense Invoice Expense Invoice Header Invoices Project Service Open Service Summary Service Summary Open Transaction
Priority_Description Text nullable
Priority_Sort_Order Numeric nullable
Ticket_Owner_RecID Numeric nullable
Also in 3 reports
Service Open Service Summary Service Summary Open
SR_SLA_RecID Numeric nullable
Also in 8 reports
Agr Type Configs SLA SLAPriority Service Open Service SLA Service Summary Service Summary Open
Est_Start_Date_UTC DateTime nullable
SR_Urgency_RecID Numeric
Also in 6 reports
Agr Type SLAPriority Service Priority Service Open Service Summary Service Summary Open
Initial_Description Text nullable
Ticket_Owner_First_Name Text nullable
Ticket_Owner_Last_Name Text nullable
Closed_Age Numeric nullable
Priority_Level Text nullable