ConnectWise Entities, Properties and related Types cached by TimeSanity

Waruna Kirimetiyawa Updated by Waruna Kirimetiyawa

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

How did we do?

Aggregate Email Notifications

Contact