Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Location or branch office where an organization does business. An organization can have multiple sites.
Messages
The following table lists the messages for the Site table. Messages represent operations that can be performed on the table. They may also be events.
| Name Is Event? |
Web API Operation | SDK for .NET |
|---|---|---|
AssociateEvent: True |
Associate records | Associate records |
CreateEvent: True |
POST /sitesSee Create |
Create records |
CreateMultipleEvent: True |
CreateMultiple | CreateMultipleRequest |
DeleteEvent: True |
DELETE /sites(siteid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
RetrieveEvent: True |
GET /sites(siteid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /sitesSee Query data |
Query data |
UpdateEvent: True |
PATCH /sites(siteid)See Update |
Update records |
UpdateMultipleEvent: True |
UpdateMultiple | UpdateMultipleRequest |
UpsertEvent: False |
PATCH /sites(siteid)See Upsert a table row |
UpsertRequest |
UpsertMultipleEvent: False |
UpsertMultiple | UpsertMultipleRequest |
Properties
The following table lists selected properties for the Site table.
| Property | Value |
|---|---|
| DisplayName | Site |
| DisplayCollectionName | Sites |
| SchemaName | Site |
| CollectionSchemaName | Sites |
| EntitySetName | sites |
| LogicalName | site |
| LogicalCollectionName | sites |
| PrimaryIdAttribute | siteid |
| PrimaryNameAttribute | name |
| TableType | Standard |
| OwnershipType | OrganizationOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- Address1_AddressId
- Address1_AddressTypeCode
- Address1_City
- Address1_Country
- Address1_County
- Address1_Fax
- Address1_Latitude
- Address1_Line1
- Address1_Line2
- Address1_Line3
- Address1_Longitude
- Address1_Name
- Address1_PostalCode
- Address1_PostOfficeBox
- Address1_ShippingMethodCode
- Address1_StateOrProvince
- Address1_Telephone1
- Address1_Telephone2
- Address1_Telephone3
- Address1_UPSZone
- Address1_UTCOffset
- Address2_AddressId
- Address2_AddressTypeCode
- Address2_City
- Address2_Country
- Address2_County
- Address2_Fax
- Address2_Latitude
- Address2_Line1
- Address2_Line2
- Address2_Line3
- Address2_Longitude
- Address2_Name
- Address2_PostalCode
- Address2_PostOfficeBox
- Address2_ShippingMethodCode
- Address2_StateOrProvince
- Address2_Telephone1
- Address2_Telephone2
- Address2_Telephone3
- Address2_UPSZone
- Address2_UTCOffset
- EMailAddress
- ImportSequenceNumber
- Name
- OverriddenCreatedOn
- SiteId
- TimeZoneCode
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
Address1_AddressId
| Property | Value |
|---|---|
| Description | Unique identifier for address 1. |
| DisplayName | Address 1: ID |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_addressid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
Address1_AddressTypeCode
| Property | Value |
|---|---|
| Description | Type of address for address 1, such as billing, shipping, or primary address. |
| DisplayName | Address 1: Address Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_addresstypecode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 1 |
| GlobalChoiceName | site_address1_addresstypecode |
Address1_AddressTypeCode Choices/Options
| Value | Label |
|---|---|
| 1 | Default Value |
Address1_City
| Property | Value |
|---|---|
| Description | City name for address 1. |
| DisplayName | City |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_city |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 80 |
Address1_Country
| Property | Value |
|---|---|
| Description | Country/region name for address 1. |
| DisplayName | Country/Region |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_country |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 80 |
Address1_County
| Property | Value |
|---|---|
| Description | County name for address 1. |
| DisplayName | Address 1: County |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_county |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address1_Fax
| Property | Value |
|---|---|
| Description | Fax number for address 1. |
| DisplayName | Fax |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_fax |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address1_Latitude
| Property | Value |
|---|---|
| Description | Latitude for address 1. |
| DisplayName | Address 1: Latitude |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_latitude |
| RequiredLevel | None |
| Type | Double |
| ImeMode | Disabled |
| MaxValue | 90 |
| MinValue | -90 |
| Precision | 5 |
Address1_Line1
| Property | Value |
|---|---|
| Description | First line for entering address 1 information. |
| DisplayName | Street 1 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_line1 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 250 |
Address1_Line2
| Property | Value |
|---|---|
| Description | Second line for entering address 1 information. |
| DisplayName | Street 2 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_line2 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 250 |
Address1_Line3
| Property | Value |
|---|---|
| Description | Third line for entering address 1 information. |
| DisplayName | Street 3 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_line3 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 250 |
Address1_Longitude
| Property | Value |
|---|---|
| Description | Longitude for address 1. |
| DisplayName | Address 1: Longitude |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_longitude |
| RequiredLevel | None |
| Type | Double |
| ImeMode | Disabled |
| MaxValue | 180 |
| MinValue | -180 |
| Precision | 5 |
Address1_Name
| Property | Value |
|---|---|
| Description | Name to enter for address 1. |
| DisplayName | Address 1: Name |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_name |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
Address1_PostalCode
| Property | Value |
|---|---|
| Description | ZIP Code or postal code for address 1. |
| DisplayName | ZIP/Postal Code |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_postalcode |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 20 |
Address1_PostOfficeBox
| Property | Value |
|---|---|
| Description | Post office box number for address 1. |
| DisplayName | Address 1: Post Office Box |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_postofficebox |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 20 |
Address1_ShippingMethodCode
| Property | Value |
|---|---|
| Description | Method of shipment for address 1. |
| DisplayName | Address 1: Shipping Method |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_shippingmethodcode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 1 |
| GlobalChoiceName | site_address1_shippingmethodcode |
Address1_ShippingMethodCode Choices/Options
| Value | Label |
|---|---|
| 1 | Default Value |
Address1_StateOrProvince
| Property | Value |
|---|---|
| Description | State or province for address 1. |
| DisplayName | State/Province |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_stateorprovince |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address1_Telephone1
| Property | Value |
|---|---|
| Description | First telephone number associated with address 1. |
| DisplayName | Main Phone |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_telephone1 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address1_Telephone2
| Property | Value |
|---|---|
| Description | Second telephone number associated with address 1. |
| DisplayName | Other Phone |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_telephone2 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address1_Telephone3
| Property | Value |
|---|---|
| Description | Third telephone number associated with address 1. |
| DisplayName | Address 1: Telephone 3 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_telephone3 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address1_UPSZone
| Property | Value |
|---|---|
| Description | United Parcel Service (UPS) zone for address 1. |
| DisplayName | Address 1: UPS Zone |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_upszone |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 4 |
Address1_UTCOffset
| Property | Value |
|---|---|
| Description | UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time. |
| DisplayName | Address 1: UTC Offset |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_utcoffset |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1500 |
| MinValue | -1500 |
Address2_AddressId
| Property | Value |
|---|---|
| Description | Unique identifier for address 2. |
| DisplayName | Address 2: ID |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_addressid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
Address2_AddressTypeCode
| Property | Value |
|---|---|
| Description | Type of address for address 2, such as billing, shipping, or primary address. |
| DisplayName | Address 2: Address Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_addresstypecode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 1 |
| GlobalChoiceName | site_address2_addresstypecode |
Address2_AddressTypeCode Choices/Options
| Value | Label |
|---|---|
| 1 | Default Value |
Address2_City
| Property | Value |
|---|---|
| Description | City name for address 2. |
| DisplayName | Address 2: City |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_city |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 80 |
Address2_Country
| Property | Value |
|---|---|
| Description | Country/region name for address 2. |
| DisplayName | Address 2: Country/Region |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_country |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 80 |
Address2_County
| Property | Value |
|---|---|
| Description | County name for address 2. |
| DisplayName | Address 2: County |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_county |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address2_Fax
| Property | Value |
|---|---|
| Description | Fax number for address 2. |
| DisplayName | Address 2: Fax |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_fax |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address2_Latitude
| Property | Value |
|---|---|
| Description | Latitude for address 2. |
| DisplayName | Address 2: Latitude |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_latitude |
| RequiredLevel | None |
| Type | Double |
| ImeMode | Disabled |
| MaxValue | 90 |
| MinValue | -90 |
| Precision | 5 |
Address2_Line1
| Property | Value |
|---|---|
| Description | First line for entering address 2 information. |
| DisplayName | Address 2: Street 1 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_line1 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 250 |
Address2_Line2
| Property | Value |
|---|---|
| Description | Second line for entering address 2 information. |
| DisplayName | Address 2: Street 2 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_line2 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 250 |
Address2_Line3
| Property | Value |
|---|---|
| Description | Third line for entering address 2 information. |
| DisplayName | Address 2: Street 3 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_line3 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 250 |
Address2_Longitude
| Property | Value |
|---|---|
| Description | Longitude for address 2. |
| DisplayName | Address 2: Longitude |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_longitude |
| RequiredLevel | None |
| Type | Double |
| ImeMode | Disabled |
| MaxValue | 180 |
| MinValue | -180 |
| Precision | 5 |
Address2_Name
| Property | Value |
|---|---|
| Description | Name to enter for address 2. |
| DisplayName | Address 2: Name |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_name |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
Address2_PostalCode
| Property | Value |
|---|---|
| Description | ZIP Code or postal code for address 2. |
| DisplayName | Address 2: ZIP/Postal Code |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_postalcode |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 20 |
Address2_PostOfficeBox
| Property | Value |
|---|---|
| Description | Post office box number for address 2. |
| DisplayName | Address 2: Post Office Box |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_postofficebox |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 20 |
Address2_ShippingMethodCode
| Property | Value |
|---|---|
| Description | Method of shipment for address 2. |
| DisplayName | Address 2: Shipping Method |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_shippingmethodcode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 1 |
| GlobalChoiceName | site_address2_shippingmethodcode |
Address2_ShippingMethodCode Choices/Options
| Value | Label |
|---|---|
| 1 | Default Value |
Address2_StateOrProvince
| Property | Value |
|---|---|
| Description | State or province for address 2. |
| DisplayName | Address 2: State/Province |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_stateorprovince |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address2_Telephone1
| Property | Value |
|---|---|
| Description | First telephone number associated with address 2. |
| DisplayName | Address 2: Telephone 1 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_telephone1 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address2_Telephone2
| Property | Value |
|---|---|
| Description | Second telephone number associated with address 2. |
| DisplayName | Address 2: Telephone 2 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_telephone2 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address2_Telephone3
| Property | Value |
|---|---|
| Description | Third telephone number associated with address 2. |
| DisplayName | Address 2: Telephone 3 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_telephone3 |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
Address2_UPSZone
| Property | Value |
|---|---|
| Description | United Parcel Service (UPS) zone for address 2. |
| DisplayName | Address 2: UPS Zone |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_upszone |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 4 |
Address2_UTCOffset
| Property | Value |
|---|---|
| Description | UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time. |
| DisplayName | Address 2: UTC Offset |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_utcoffset |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1500 |
| MinValue | -1500 |
EMailAddress
| Property | Value |
|---|---|
| Description | Email address for the site. |
| DisplayName | |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | emailaddress |
| RequiredLevel | None |
| Type | String |
| Format | |
| FormatName | |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | importsequencenumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
Name
| Property | Value |
|---|---|
| Description | Name of the site. |
| DisplayName | Name |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | name |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 160 |
OverriddenCreatedOn
| Property | Value |
|---|---|
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
SiteId
| Property | Value |
|---|---|
| Description | Unique identifier of the site. |
| DisplayName | Site |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | siteid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
TimeZoneCode
| Property | Value |
|---|---|
| Description | Local time zone for the site. |
| DisplayName | Time Zone |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | timezonecode |
| RequiredLevel | SystemRequired |
| Type | Integer |
| MaxValue | 1500 |
| MinValue | -1500 |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OrganizationId
- VersionNumber
CreatedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who created the site. |
| DisplayName | Created By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
CreatedOn
| Property | Value |
|---|---|
| Description | Date and time when the site was created. |
| DisplayName | Created On |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who created the site. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
ModifiedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who last modified the site. |
| DisplayName | Modified By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
ModifiedOn
| Property | Value |
|---|---|
| Description | Date and time when the site was last modified. |
| DisplayName | Modified On |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who last modified the site. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
OrganizationId
| Property | Value |
|---|---|
| Description | Unique identifier for the organization |
| DisplayName | Organization Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationid |
| RequiredLevel | SystemRequired |
| Type | Lookup |
| Targets | organization |
VersionNumber
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| RequiredLevel | None |
| Type | BigInt |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- lk_site_createdonbehalfby
- lk_site_modifiedonbehalfby
- lk_sitebase_createdby
- lk_sitebase_modifiedby
- organization_sites
lk_site_createdonbehalfby
One-To-Many Relationship: systemuser lk_site_createdonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdonbehalfby |
| ReferencingEntityNavigationPropertyName | createdonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_site_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_site_modifiedonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedonbehalfby |
| ReferencingEntityNavigationPropertyName | modifiedonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_sitebase_createdby
One-To-Many Relationship: systemuser lk_sitebase_createdby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdby |
| ReferencingEntityNavigationPropertyName | createdby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_sitebase_modifiedby
One-To-Many Relationship: systemuser lk_sitebase_modifiedby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedby |
| ReferencingEntityNavigationPropertyName | modifiedby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
organization_sites
One-To-Many Relationship: organization organization_sites
| Property | Value |
|---|---|
| ReferencedEntity | organization |
| ReferencedAttribute | organizationid |
| ReferencingAttribute | organizationid |
| ReferencingEntityNavigationPropertyName | organizationid_organization |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- site_ActivityPointers
- site_adx_inviteredemptions
- site_adx_portalcomments
- site_Appointments
- Site_AsyncOperations
- Site_BulkDeleteFailures
- site_chats
- site_Emails
- site_equipment
- site_Faxes
- site_Letters
- site_MailboxTrackingFolders
- site_msdyn_copilottranscripts
- site_msdyn_ocliveworkitems
- site_msdyn_ocsessions
- site_msfp_alerts
- site_msfp_surveyinvites
- site_msfp_surveyresponses
- site_OpportunityCloses
- site_OrderCloses
- site_PhoneCalls
- site_PrincipalObjectAttributeAccesses
- Site_ProcessSessions
- site_QuoteCloses
- site_RecurringAppointmentMasters
- site_resources
- site_service_appointments
- site_ServiceAppointments
- site_SocialActivities
- Site_SyncErrors
- site_system_users
- site_Tasks
site_ActivityPointers
Many-To-One Relationship: activitypointer site_ActivityPointers
| Property | Value |
|---|---|
| ReferencingEntity | activitypointer |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_ActivityPointers |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_adx_inviteredemptions
Many-To-One Relationship: adx_inviteredemption site_adx_inviteredemptions
| Property | Value |
|---|---|
| ReferencingEntity | adx_inviteredemption |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_adx_inviteredemptions |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_adx_portalcomments
Many-To-One Relationship: adx_portalcomment site_adx_portalcomments
| Property | Value |
|---|---|
| ReferencingEntity | adx_portalcomment |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_adx_portalcomments |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_Appointments
Many-To-One Relationship: appointment site_Appointments
| Property | Value |
|---|---|
| ReferencingEntity | appointment |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_Appointments |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Site_AsyncOperations
Many-To-One Relationship: asyncoperation Site_AsyncOperations
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Site_AsyncOperations |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Site_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure Site_BulkDeleteFailures
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Site_BulkDeleteFailures |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_chats
Many-To-One Relationship: chat site_chats
| Property | Value |
|---|---|
| ReferencingEntity | chat |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_chats |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_Emails
Many-To-One Relationship: email site_Emails
| Property | Value |
|---|---|
| ReferencingEntity | email |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_Emails |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_equipment
Many-To-One Relationship: equipment site_equipment
| Property | Value |
|---|---|
| ReferencingEntity | equipment |
| ReferencingAttribute | siteid |
| ReferencedEntityNavigationPropertyName | site_equipment |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_Faxes
Many-To-One Relationship: fax site_Faxes
| Property | Value |
|---|---|
| ReferencingEntity | fax |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_Faxes |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_Letters
Many-To-One Relationship: letter site_Letters
| Property | Value |
|---|---|
| ReferencingEntity | letter |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_Letters |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_MailboxTrackingFolders
Many-To-One Relationship: mailboxtrackingfolder site_MailboxTrackingFolders
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_MailboxTrackingFolders |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_msdyn_copilottranscripts
Many-To-One Relationship: msdyn_copilottranscript site_msdyn_copilottranscripts
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_copilottranscript |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_msdyn_copilottranscripts |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_msdyn_ocliveworkitems
Many-To-One Relationship: msdyn_ocliveworkitem site_msdyn_ocliveworkitems
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_ocliveworkitem |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_msdyn_ocliveworkitems |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_msdyn_ocsessions
Many-To-One Relationship: msdyn_ocsession site_msdyn_ocsessions
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_ocsession |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_msdyn_ocsessions |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_msfp_alerts
Many-To-One Relationship: msfp_alert site_msfp_alerts
| Property | Value |
|---|---|
| ReferencingEntity | msfp_alert |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_msfp_alerts |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_msfp_surveyinvites
Many-To-One Relationship: msfp_surveyinvite site_msfp_surveyinvites
| Property | Value |
|---|---|
| ReferencingEntity | msfp_surveyinvite |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_msfp_surveyinvites |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_msfp_surveyresponses
Many-To-One Relationship: msfp_surveyresponse site_msfp_surveyresponses
| Property | Value |
|---|---|
| ReferencingEntity | msfp_surveyresponse |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_msfp_surveyresponses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_OpportunityCloses
Many-To-One Relationship: opportunityclose site_OpportunityCloses
| Property | Value |
|---|---|
| ReferencingEntity | opportunityclose |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_OpportunityCloses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_OrderCloses
Many-To-One Relationship: orderclose site_OrderCloses
| Property | Value |
|---|---|
| ReferencingEntity | orderclose |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_OrderCloses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_PhoneCalls
Many-To-One Relationship: phonecall site_PhoneCalls
| Property | Value |
|---|---|
| ReferencingEntity | phonecall |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_PhoneCalls |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_PrincipalObjectAttributeAccesses
Many-To-One Relationship: principalobjectattributeaccess site_PrincipalObjectAttributeAccesses
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | site_PrincipalObjectAttributeAccesses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Site_ProcessSessions
Many-To-One Relationship: processsession Site_ProcessSessions
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Site_ProcessSessions |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 110 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_QuoteCloses
Many-To-One Relationship: quoteclose site_QuoteCloses
| Property | Value |
|---|---|
| ReferencingEntity | quoteclose |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_QuoteCloses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_RecurringAppointmentMasters
Many-To-One Relationship: recurringappointmentmaster site_RecurringAppointmentMasters
| Property | Value |
|---|---|
| ReferencingEntity | recurringappointmentmaster |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_RecurringAppointmentMasters |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_resources
Many-To-One Relationship: resource site_resources
| Property | Value |
|---|---|
| ReferencingEntity | resource |
| ReferencingAttribute | siteid |
| ReferencedEntityNavigationPropertyName | site_resources |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: SMSite.RetrieveMembersViewId: 43997469-f8f0-4abd-87ee-2194f731a6b2 |
site_service_appointments
Many-To-One Relationship: serviceappointment site_service_appointments
| Property | Value |
|---|---|
| ReferencingEntity | serviceappointment |
| ReferencingAttribute | siteid |
| ReferencedEntityNavigationPropertyName | site_service_appointments |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_ServiceAppointments
Many-To-One Relationship: serviceappointment site_ServiceAppointments
| Property | Value |
|---|---|
| ReferencingEntity | serviceappointment |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_ServiceAppointments |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_SocialActivities
Many-To-One Relationship: socialactivity site_SocialActivities
| Property | Value |
|---|---|
| ReferencingEntity | socialactivity |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_SocialActivities |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Site_SyncErrors
Many-To-One Relationship: syncerror Site_SyncErrors
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Site_SyncErrors |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_system_users
Many-To-One Relationship: systemuser site_system_users
| Property | Value |
|---|---|
| ReferencingEntity | systemuser |
| ReferencingAttribute | siteid |
| ReferencedEntityNavigationPropertyName | site_system_users |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
site_Tasks
Many-To-One Relationship: task site_Tasks
| Property | Value |
|---|---|
| ReferencingEntity | task |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | site_Tasks |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference