Agreement List

AgreementList

41 columns Fetched February 27, 2026

Related Reports

Project Header 2 shared Agr Site 1 shared Agr Type 1 shared Agreement Audit 1 shared Agreement Invoice 1 shared

n8n

Columns

AGR_Name Text nullable
AGR_Header_RecID Numeric
Also in 20 reports
Agr Site Agreement Audit Agreement Invoice 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 Service Summary Open Time
agr_type_desc Text nullable
agr_type_recid Numeric
PM_Type_RecID Numeric
Also in 4 reports
Agr Type Project Header Project Template Project Types
CompanyRecId Numeric
company_recid Numeric
owner_level_recid Numeric nullable
billing_unit_recid Numeric nullable
TE_Billable_Flag Boolean
TE_Invoice_Flag Boolean
EX_Billable_Flag Boolean
EX_Invoice_Flag Boolean
IV_Billable_Flag Boolean
IV_Invoice_Flag Boolean
Valid_flag Boolean nullable
DateStart DateTime nullable
DateEnd DateTime nullable
Universal_Formatted_Date_Start DateTime nullable
Universal_Formatted_Date_End DateTime nullable
BalAvailable Numeric
AGR_Detail_Type_Desc Text nullable
UnlimitedFlag Boolean
Bill_Start_Date DateTime nullable
Location Numeric
Billing_CycleOption_RecID Numeric nullable
Billing_Cycle_Desc Text nullable
Nbr_Cycles Numeric nullable
Updated_By Text nullable
Last_Update DateTime nullable
Time_Zone Text nullable
Billing_Amount Numeric nullable
Agreement_Start_Date DateTime nullable
Agreement_Status Text
Parent_Agreement_RecID Numeric nullable
Parent_Agreement_Name Text nullable
Owner_Level_Name Text nullable
Billing_Unit_Name Text nullable
Company_Name Text nullable
BalRemaining Numeric
AGR_OneTime_Flag Boolean