ConnectWise Entities, Properties and related Types cached by TimeSanity
The following article details the ConnectWise Entities, Properties and their Types cached within TimeSanity and accessible for building rules.
We auto populate the Entities and their related Properties in our Rule builder so its simple for you to create rules quickly as shown below.
Entity Picker
Property Picker
Below is a full table of Entities, Properties and Types
| EntityName | Property Name | Type Name |
|---|---|---|
| Agreement | Id | Number |
| IsSingleCached | Boolean | |
| ChargeToFirm | Boolean | |
| BillToSite | CwReference | |
| BillToCompany | CwReference | |
| InvoicingCycle | String | |
| BillTermsId | Number | |
| BillOneTimeFlag | Boolean | |
| BillCycleId | Number | |
| CompLimitAmount | Number | |
| CompHourlyRate | Number | |
| EmployeeCompNotExceed | String | |
| EmployeeCompRate | String | |
| PeriodType | String | |
| ExpireWhenZero | Boolean | |
| Limit | Number | |
| BillAmount | Number | |
| Taxable | Boolean | |
| ProrateFirstBill | Number | |
| BillStartDate | DateTime | |
| BillableExpenseInvoice | Boolean | |
| BillableTimeInvoice | Boolean | |
| BillProducts | String | |
| BillExpenses | String | |
| BillTime | String | |
| InvoiceTemplateSetupId | Number | |
| ExpiredDays | Number | |
| ProjectTypeId | Number | |
| WorkRole | CwReference | |
| BottomComment | Boolean | |
| TopComment | Boolean | |
| InvoiceDescription | String | |
| RestrictDownPayment | Boolean | |
| TaxCodeId | Number | |
| WorkType | CwReference | |
| AllowOverruns | Boolean | |
| CarryOverUnused | Boolean | |
| CoverSalesTax | Boolean | |
| Name | String | |
| Type | CwReference | |
| Company | CwReference | |
| Contact | CwReference | |
| SubContractCompany | CwReference | |
| SubContractContact | CwReference | |
| ParentAgreementId | Number | |
| CustomerPO | String | |
| LocationId | Number | |
| BusinessUnitId | Number | |
| RestrictLocationFlag | Boolean | |
| RestrictDepartmentFlag | Boolean | |
| StartDate | DateTime | |
| EndDate | DateTime | |
| NoEndingDateFlag | Boolean | |
| Opportunity | CwReference | |
| CoverAgreementExpense | Boolean | |
| CoverAgreementProduct | Boolean | |
| CoverAgreementTime | Boolean | |
| OneTimeFlag | Boolean | |
| ApplicationUnlimitedFlag | Boolean | |
| ApplicationCycle | String | |
| BillableProductInvoice | Boolean | |
| ApplicationLimit | Number | |
| InternalNotes | String | |
| WorkOrder | String | |
| SlaId | Number | |
| ReasonCancelled | String | |
| DateCancelled | DateTime | |
| CancelledFlag | Boolean | |
| ApplicationUnits | String | |
| Entity Name | Property Name | Type Name |
| Location | Id | Number |
| Type | CwReference | |
| StructureLevel | Number | |
| Name | String | |
| Manager | CwReference | |
| ReportsTo | CwReference | |
| TimeZoneSetup | CwReference | |
| Calendar | CwReference | |
| OwaUrl | String | |
| LocationFlag | Boolean | |
| ClientFlag | Boolean | |
| IsSingleCached | Boolean | |
| Entity Name | Property Name | Type Name |
| Ticket | Id | Number |
| Summary | String | |
| RecordType | String | |
| Board | CwReference | |
| Status | CwReference | |
| Project | CwReference | |
| Phase | CwReference | |
| Company | CwReference | |
| Site | CwReference | |
| SiteName | String | |
| AddressLine1 | String | |
| AddressLine2 | String | |
| City | String | |
| StateIdentifier | String | |
| Zip | String | |
| Country | CwReference | |
| Contact | CwReference | |
| ContactPhoneNumber | String | |
| ContactPhoneExtension | String | |
| ContactEmailAddress | String | |
| Type | CwReference | |
| SubType | CwReference | |
| Item | CwReference | |
| Team | CwReference | |
| Owner | CwReference | |
| Priority | CwReference | |
| Source | CwReference | |
| RequiredDate | DateTime | |
| BudgetHours | Number | |
| Agreement | CwReference | |
| PoNumber | String | |
| CustomerUpdatedFlag | Boolean | |
| AutomaticEmailContactFlag | Boolean | |
| AutomaticEmailResourceFlag | Boolean | |
| AutomaticEmailCcFlag | Boolean | |
| AutomaticEmailCc | String | |
| ClosedDate | DateTime | |
| ClosedBy | String | |
| ClosedFlag | Boolean | |
| DateEntered | DateTime | |
| EnteredBy | String | |
| ActualHours | Number | |
| DateResolved | String | |
| ResolveMinutes | Number | |
| ResPlanMinutes | Number | |
| RespondMinutes | Number | |
| IsInSla | Boolean | |
| Resources | String | |
| ParentTicketId | Number | |
| HasChildTicket | Boolean | |
| BillTime | String | |
| BillExpenses | String | |
| BillProducts | String | |
| PredecessorType | String | |
| PredecessorId | Number | |
| PredecessorClosedFlag | Boolean | |
| LagDays | Number | |
| LagNonworkingDaysFlag | Boolean | |
| EstimatedStartDate | DateTime | |
| Duration | Number | |
| LocationId | Number | |
| BusinessUnitId | Number | |
| NoteLastUpdated | DateTime | |
| InitialResolution | String | |
| DateResplan | String | |
| SubDateAccepted | String | |
| SubBillingAmount | Number | |
| SubBillingMethod | String | |
| Approved | Boolean | |
| SkipCallback | Boolean | |
| ProcessNotifications | Boolean | |
| ContactEmailLookup | String | |
| InitialInternalAnalysis | String | |
| InitialDescription | String | |
| DateResponded | String | |
| MobileGuid | Guid | |
| KnowledgeBaseLinkType | String | |
| KnowledgeBaseLinkId | Number | |
| ContactName | String | |
| WbsCode | String | |
| ExternalXRef | String | |
| Impact | String | |
| Severity | String | |
| AllowAllClientsPortalView | Boolean | |
| KnowledgeBaseCategoryId | Number | |
| KnowledgeBaseSubCategoryId | Number | |
| Opportunity | CwReference | |
| ServiceLocation | CwReference | |
| Sla | CwReference | |
| Entity Name | Property Name | Type Name |
| TimeEntry | Id | Number |
| Company | CwReference | |
| ChargeToId | Number | |
| ChargeToType | String | |
| Member | CwReference | |
| LocationId | Number | |
| BusinessUnitId | Number | |
| WorkType | CwReference | |
| WorkRole | CwReference | |
| Agreement | CwReference | |
| TimeStart | DateTime | |
| TimeEnd | DateTime | |
| HoursDeduct | Number | |
| ActualHours | Number | |
| BillableOption | String | |
| Notes | String | |
| InternalNotes | String | |
| AddToDetailDescriptionFlag | Boolean | |
| AddToInternalAnalysisFlag | Boolean | |
| AddToResolutionFlag | Boolean | |
| EmailResourceFlag | Boolean | |
| EmailContactFlag | Boolean | |
| EmailCcFlag | Boolean | |
| EmailCc | String | |
| HoursBilled | Number | |
| EnteredBy | String | |
| DateEntered | DateTime | |
| Entity Name | Property Name | Type Name |
| Board | Id | Number |
| Name | String | |
| LocationId | Number | |
| BusinessUnitId | Number | |
| Inactive | Boolean | |
| SignOffTemplate | CwReference | |
| SendToContact | Boolean | |
| ContactTemplateId | Number | |
| SendToResource | Boolean | |
| ResourceTemplateId | Number | |
| ProjectFlag | Boolean | |
| ShowDependenciesFlag | Boolean | |
| ShowEstimatesFlag | Boolean | |
| BoardTypes | List | |
| BoardSubTypes | List | |
| BoardTeams | List | |
| Entity Name | Property Name | Type Name |
| Company | Id | Number |
| CalendarId | Number | |
| UserDefinedField3 | String | |
| UserDefinedField4 | String | |
| UserDefinedField5 | String | |
| UserDefinedField6 | String | |
| UserDefinedField7 | String | |
| UserDefinedField8 | String | |
| UserDefinedField9 | String | |
| UserDefinedField10 | String | |
| VendorIdentifier | String | |
| TaxIdentifier | String | |
| TaxCode | CwReference | |
| BillingTerms | CwReference | |
| InvoiceTemplate | CwReference | |
| PricingSchedule | CwReference | |
| CompanyEntityType | CwReference | |
| BillToCompany | CwReference | |
| BillingSite | CwReference | |
| BillingContact | CwReference | |
| InvoiceDeliveryMethod | CwReference | |
| InvoiceToEmailAddress | String | |
| InvoiceCCEmailAddress | String | |
| DeletedFlag | Boolean | |
| DateDeleted | DateTime | |
| DeletedBy | String | |
| MobileGuid | Guid | |
| Currency | CwReference | |
| TerritoryManager | CwReference | |
| UserDefinedField2 | String | |
| UserDefinedField1 | String | |
| UnsubscribeFlag | Boolean | |
| Identifier | String | |
| Name | String | |
| Status | CwReference | |
| Type | CwReference | |
| AddressLine1 | String | |
| AddressLine2 | String | |
| City | String | |
| State | String | |
| Zip | String | |
| Country | CwReference | |
| PhoneNumber | String | |
| FaxNumber | String | |
| Website | String | |
| TerritoryId | Number | |
| MarketId | Number | |
| AccountNumber | String | |
| DefaultContact | CwReference | |
| DateAcquired | DateTime | |
| SicCode | CwReference | |
| ParentCompany | CwReference | |
| AnnualRevenue | Number | |
| NumberOfEmployees | Number | |
| OwnershipType | CwReference | |
| TimeZone | CwReference | |
| LeadSource | String | |
| LeadFlag | Boolean | |
| Entity Name | Property Name | Type Name |
| Member | Id | Number |
| OfficeExtension | String | |
| RestrictServiceDefaultLocationFlag | Boolean | |
| RestrictServiceDefaultDepartmentFlag | Boolean | |
| RestrictScheduleFlag | Boolean | |
| RestrictProjectDefaultLocationFlag | Boolean | |
| RestrictProjectDefaultDepartmentFlag | Boolean | |
| RestrictLocationFlag | Boolean | |
| RestrictDepartmentFlag | Boolean | |
| RestrictDefaultWarehouseFlag | Boolean | |
| RestrictDefaultWarehouseBinFlag | Boolean | |
| RestrictDefaultSalesTerritoryFlag | Boolean | |
| RequireTimeSheetEntryFlag | Boolean | |
| RequireStartAndEndTimeOnTimeEntryFlag | Boolean | |
| RequireExpenseEntryFlag | Boolean | |
| ReportsTo | CwReference | |
| ProjectDefaultLocationId | Number | |
| ProjectDefaultDepartmentId | Number | |
| ProjectDefaultBoard | CwReference | |
| OfficePhone | String | |
| SalesDefaultLocationId | Number | |
| ScheduleCapacity | Number | |
| ScheduleDefaultDepartmentId | Number | |
| ScheduleDefaultLocationId | Number | |
| WorkRole | CwReference | |
| WarehouseBin | CwReference | |
| Warehouse | CwReference | |
| VendorNumber | String | |
| Type | CwReference | |
| Title | String | |
| TimeZone | CwReference | |
| TimeSheetStartDate | DateTime | |
| System_Flag | Boolean | |
| TimeReminderEmailFlag | Boolean | |
| ServiceTeams | List | |
| ServiceLocation | CwReference | |
| ServiceDefaultLocationId | Number | |
| ServiceDefaultDepartmentId | Number | |
| ServiceDefaultBoard | CwReference | |
| SecurityRole | CwReference | |
| SecurityLocationId | Number | |
| SecurityLevel | String | |
| TimeApprover | CwReference | |
| OfficeEmail | String | |
| Notes | String | |
| MobilePhone | String | |
| EnterTimeAgainstCompanyFlag | Boolean | |
| EnableMobileGpsFlag | Boolean | |
| EnableMobileFlag | Boolean | |
| EnableLdapAuthenticationFlag | Boolean | |
| DisableOnlineFlag | Boolean | |
| DefaultPhone | String | |
| DefaultLocationId | Number | |
| DefaultEmail | String | |
| ExpenseApprover | CwReference | |
| DefaultDepartmentId | Number | |
| DailyCapacity | Number | |
| Country | CwReference | |
| CalendarSyncIntegrationFlag | Boolean | |
| Calendar | CwReference | |
| BillableForecast | Number | |
| AllowInCellEntryOnTimeSheet | Boolean | |
| AllowExpensesEnteredAgainstCompaniesFlag | Boolean | |
| AdminFlag | Boolean | |
| DaysTolerance | Number | |
| WorkType | CwReference | |
| FirstName | String | |
| HireDate | DateTime | |
| MobileExtension | String | |
| MobileEmail | String | |
| MinimumHours | Number | |
| MiddleInitial | String | |
| MapiName | String | |
| LicenseClass | String | |
| LastName | String | |
| LastLogin | String | |
| HideMemberInDispatchPortalFlag | Boolean | |
| IncludeInUtilizationReportingFlag | Boolean | |
| InactiveDate | DateTime | |
| Identifier | String | |
| HourlyRate | Number | |
| HourlyCost | Number | |
| HomePhone | String | |
| HomeExtension | String | |
| HomeEmail | String | |
| InactiveFlag | Boolean | |
| Entity Name | Property Name | Type Name |
| Project | Id | Number |
| Downpayment | Number | |
| Type | CwReference | |
| EstimatedEnd | DateTime | |
| EstimatedExpenseRevenue | Number | |
| EstimatedHours | Number | |
| EstimatedProductRevenue | Number | |
| EstimatedStart | DateTime | |
| EstimatedTimeRevenue | Number | |
| ExpenseApprover | CwReference | |
| IncludeDependenciesFlag | Boolean | |
| IncludeEstimatesFlag | Boolean | |
| LocationId | Number | |
| Manager | CwReference | |
| Name | String | |
| Opportunity | CwReference | |
| ProjectTemplateId | Number | |
| RestrictDownPaymentFlag | Boolean | |
| ScheduledEnd | String | |
| ScheduledHours | Number | |
| ScheduledStart | String | |
| ShipToCompany | CwReference | |
| ShipToContact | CwReference | |
| ShipToSite | CwReference | |
| Site | CwReference | |
| Description | String | |
| CustomerPO | String | |
| Contact | CwReference | |
| Company | CwReference | |
| ActualEnd | String | |
| ActualHours | Number | |
| ActualStart | String | |
| Agreement | CwReference | |
| BillExpenses | String | |
| BillingAmount | Number | |
| BillingAttention | String | |
| BillingMethod | String | |
| BillingRateType | String | |
| Status | CwReference | |
| BillingTerms | CwReference | |
| BillProjectAfterClosedFlag | Boolean | |
| BillTime | String | |
| BillToCompany | CwReference | |
| BillToContact | CwReference | |
| BillToSite | CwReference | |
| BillUnapprovedTimeAndExpense | Boolean | |
| Board | CwReference | |
| BudgetAnalysis | String | |
| BudgetFlag | Boolean | |
| BudgetHours | Number | |
| BusinessUnitId | Number | |
| BillProducts | String | |
| TimeApprover | CwReference |
