Project

Project

85 columns Fetched February 27, 2026

Related Reports

Service 7 shared Service Open 7 shared Service Summary 7 shared Service Summary Open 7 shared Portal Service 5 shared

n8n

Columns

Rec_Type Text nullable
ProjectNbr Numeric
ProjectName Text
ProjectManager Text nullable
Phase Text nullable
wbs_code Text nullable
TicketNbr Numeric nullable
owner_level_recid Numeric nullable
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 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 Service Summary Open
Board_Name Text nullable
sr_status_recid Numeric nullable
Status_SortOrder Numeric nullable
Status_Description Text nullable
ClosedDesc Text
date_closed DateTime nullable
closed_by Text nullable
Type_RecID Numeric nullable
Also in 5 reports
Portal Service Service Service Open Service Summary Service Summary Open
ServiceType Text
company_name Text nullable
company_recid Numeric
contact_name Text nullable
Address_Line1 Text
Address_Line2 Text
City Text
State Text
PostalCode Text
Summary Text nullable
Detail_Description Text nullable
Internal_Analysis Text nullable
Resolution Text nullable
service_location 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 Header Service 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
Date_Required DateTime 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 Text
Updated_By Text nullable
Last_Update DateTime
Time_Zone Text nullable
ProjectStatus Text nullable
ProjectType Text nullable
ProjectStartDate DateTime
ProjectEndDate DateTime
PM_Project_RecID Numeric
Also in 16 reports
Document Expense Invoice Expense Invoice Header Invoice Product Invoice Time Invoices Portal Invoices Project Audit Project Contact Project Custom Fields Project Header Project Note Project Team Member Time Transaction
Age Numeric nullable
Hours_Remaining Numeric nullable
Hours_Actual Numeric nullable
Percent_Complete_PerTicket Numeric nullable
PM_Phase_RecID Numeric nullable
Also in 9 reports
Expense Invoice Expense Invoice Header Invoices Service Service Open Service Summary Service Summary Open Transaction
Priority Text nullable
ProjectCloseDate Numeric nullable
Resource_List Text nullable
ServiceSubType Text nullable
ServiceSubTypeItem Text nullable
SR_Service_RecID Numeric nullable
Also in 21 reports
Document Expense Invoice Expense Invoice Product Invoice Time Schedule Screen Connect Session Service 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
SR_Type_RecID Numeric nullable
Also in 5 reports
Service Item Service Sub Type Service Sub Type Item Template Service Template Service Type
SubType_RecID Numeric nullable
Also in 5 reports
Portal Service Service Service Open Service Summary Service Summary Open
SubTypeItem_RecID Numeric nullable
Also in 5 reports
Portal Service Service Service Open Service Summary Service Summary Open
Closed_Flag Boolean nullable
ProjectManagerMemberID Text nullable
ProjectManagerRecID Numeric nullable
Last_Update_UTC DateTime
PM_Billing_Method_RecID Numeric nullable
Also in 1 report
Project Billing Methods
PM_Billing_Method_ID Text nullable
ProjectBillingMethod Text nullable
ProjectCloseDateUTC DateTime nullable
TicketWbsSequence Numeric nullable
PhaseWbsSequence Numeric nullable
PhaseWbsCode Text nullable
PhaseStatus Text nullable
Priority_Level Text nullable