Sites
Physical or logical sites (locations) associated with clients in HaloServiceDesk.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| Name | String | ||
| ClientId | Integer |
Clients.Id | |
| ClientName | String | ||
| ClientSiteName | String | ||
| Colour | String | ||
| Guid | String | ||
| Use | String | ||
| Timezone | String | ||
| CountryCode | String | ||
| PhoneNumber | String | ||
| AccountsEmailAddress | String | ||
| AccountsId | String | ||
| AccountsFirstName | String | ||
| AccountsLastName | String | ||
| AccountsCcEmailAddress | String | ||
| AccountsBccEmailAddress | String | ||
| ITGlueId | String | ||
| MainContactName | String | ||
| ClientToInvoiceName | String | ||
| ClientToInvoiceSiteName | String | ||
| ClientToInvoiceRecurringName | String | ||
| ClientToInvoiceRecurringSiteName | String | ||
| ServiceNowId | String | ||
| DattoId | String | ||
| DattoUrl | String | ||
| AzureTenantId | String | ||
| PagerDutyWildcard | String | ||
| AuvikId | String | ||
| SLAId | Integer | ||
| LanguageId | Integer | ||
| MessageGroupId | Integer | ||
| MainContactId | Integer | ||
| LinkedOrganisationId | Integer | ||
| ClientToInvoiceId | Integer |
Clients.Id | |
| ClientToInvoiceRecurringId | Integer |
Clients.Id | |
| SiteKey | Integer | ||
| TableType | Integer | ||
| RefNumber | Integer | ||
| DefaultStockLocationId | Integer | ||
| RegionCode | Integer | ||
| Sequence | Integer | ||
| IsTaxable | Boolean | ||
| SiteItemTaxCode | Integer | ||
| SiteServiceTaxCode | Integer | ||
| SitePrepayTaxCode | Integer | ||
| SiteContractTaxCode | Integer | ||
| SitePurchaseTaxCode | Integer | ||
| DefaultCurrencyCode | Integer | ||
| DefaultClientCurrencyCode | Integer | ||
| ConnectWiseAutomateId | Integer | ||
| NinjaRmmId | Integer | ||
| Device42Id | Integer | ||
| DattoAlternateId | Integer | ||
| ConnectWiseId | Integer | ||
| AutotaskId | Integer | ||
| AteraId | Integer | ||
| SyncroId | Integer | ||
| GfiSiteId | Integer | ||
| IsStopped | Boolean | ||
| GeoCoord1 | Decimal | ||
| GeoCoord2 | Decimal | ||
| Style | Decimal | ||
| UpWho | Decimal | ||
| DateCreated | Datetime | ||
| SiteLastUpdate | Datetime | ||
| LastUpdated | Datetime | ||
| ContractLastChecked | Datetime | ||
| IsInactive | Boolean | ||
| IsInvoiceSite | Boolean | ||
| IsStockLocation | Boolean | ||
| IsDefaultDelivery | Boolean | ||
| IsInvoiceAddressDelivery | Boolean | ||
| IsLocked | Boolean | ||
| IsNhServerEmailDefault | Boolean | ||
| IsAllFaqListsAllowed | Boolean | ||
| Client | String | ||
| DeliveryAddress | String | ||
| InvoiceAddress | String | ||
| PopupNotes | String | ||
| Fields | String | ||
| CustomFields | String | ||
| CustomButtons | String |