Publisher table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

A publisher of a CRM solution.

Messages

Message Web API Operation SDK class or method
Create POST /publishers
See Create
CreateRequest or
Create
Delete DELETE /publishers(publisherid)
See Delete
DeleteRequest or
Delete
Retrieve GET /publishers(publisherid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET /publishers
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
Update PATCH /publishers(publisherid)
See Update
UpdateRequest or
Update

Properties

Property Value
CollectionSchemaName Publishers
DisplayCollectionName Publishers
DisplayName Publisher
EntitySetName publishers
IsBPFEntity False
LogicalCollectionName publishers
LogicalName publisher
OwnershipType OrganizationOwned
PrimaryIdAttribute publisherid
PrimaryNameAttribute friendlyname
SchemaName Publisher

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

Address1_AddressId

Property Value
Description Unique identifier for address 1.
DisplayName Address 1: ID
IsValidForForm False
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

Address1_AddressTypeCode Choices/Options

Value Label Description
1 Default Value

Address1_City

Property Value
Description City name for address 1.
DisplayName City
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_city
MaxLength 80
RequiredLevel None
Type String

Address1_Country

Property Value
Description Country/region name for address 1.
DisplayName Country/Region
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_country
MaxLength 80
RequiredLevel None
Type String

Address1_County

Property Value
Description County name for address 1.
DisplayName Address 1: County
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_county
MaxLength 50
RequiredLevel None
Type String

Address1_Fax

Property Value
Description Fax number for address 1.
DisplayName Address 1: Fax
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_fax
MaxLength 50
RequiredLevel None
Type String

Address1_Latitude

Property Value
Description Latitude for address 1.
DisplayName Address 1: Latitude
IsValidForForm True
IsValidForRead True
LogicalName address1_latitude
MaxValue 90
MinValue -90
Precision 5
RequiredLevel None
Type Double

Address1_Line1

Property Value
Description First line for entering address 1 information.
DisplayName Street 1
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_line1
MaxLength 50
RequiredLevel None
Type String

Address1_Line2

Property Value
Description Second line for entering address 1 information.
DisplayName Street 2
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_line2
MaxLength 50
RequiredLevel None
Type String

Address1_Line3

Property Value
Description Third line for entering address 1 information.
DisplayName Street 3
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_line3
MaxLength 50
RequiredLevel None
Type String

Address1_Longitude

Property Value
Description Longitude for address 1.
DisplayName Address 1: Longitude
IsValidForForm True
IsValidForRead True
LogicalName address1_longitude
MaxValue 180
MinValue -180
Precision 5
RequiredLevel None
Type Double

Address1_Name

Property Value
Description Name to enter for address 1.
DisplayName Address 1: Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_name
MaxLength 100
RequiredLevel None
Type String

Address1_PostalCode

Property Value
Description ZIP Code or postal code for address 1.
DisplayName ZIP/Postal Code
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_postalcode
MaxLength 20
RequiredLevel None
Type String

Address1_PostOfficeBox

Property Value
Description Post office box number for address 1.
DisplayName Address 1: Post Office Box
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_postofficebox
MaxLength 20
RequiredLevel None
Type String

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

Address1_ShippingMethodCode Choices/Options

Value Label Description
1 Default Value

Address1_StateOrProvince

Property Value
Description State or province for address 1.
DisplayName State/Province
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_stateorprovince
MaxLength 50
RequiredLevel None
Type String

Address1_Telephone1

Property Value
Description First telephone number associated with address 1.
DisplayName Phone
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_telephone1
MaxLength 50
RequiredLevel None
Type String

Address1_Telephone2

Property Value
Description Second telephone number associated with address 1.
DisplayName Address 1: Telephone 2
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_telephone2
MaxLength 50
RequiredLevel None
Type String

Address1_Telephone3

Property Value
Description Third telephone number associated with address 1.
DisplayName Address 1: Telephone 3
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_telephone3
MaxLength 50
RequiredLevel None
Type String

Address1_UPSZone

Property Value
Description United Parcel Service (UPS) zone for address 1.
DisplayName Address 1: UPS Zone
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_upszone
MaxLength 4
RequiredLevel None
Type String

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
Format TimeZone
IsValidForForm True
IsValidForRead True
LogicalName address1_utcoffset
MaxValue 1500
MinValue -1500
RequiredLevel None
Type Integer

Address2_AddressId

Property Value
Description Unique identifier for address 2.
DisplayName Address 2: ID
IsValidForForm False
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

Address2_AddressTypeCode Choices/Options

Value Label Description
1 Default Value

Address2_City

Property Value
Description City name for address 2.
DisplayName Address 2: City
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_city
MaxLength 80
RequiredLevel None
Type String

Address2_Country

Property Value
Description Country/region name for address 2.
DisplayName Address 2: Country/Region
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_country
MaxLength 80
RequiredLevel None
Type String

Address2_County

Property Value
Description County name for address 2.
DisplayName Address 2: County
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_county
MaxLength 50
RequiredLevel None
Type String

Address2_Fax

Property Value
Description Fax number for address 2.
DisplayName Address 2: Fax
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_fax
MaxLength 50
RequiredLevel None
Type String

Address2_Latitude

Property Value
Description Latitude for address 2.
DisplayName Address 2: Latitude
IsValidForForm True
IsValidForRead True
LogicalName address2_latitude
MaxValue 90
MinValue -90
Precision 5
RequiredLevel None
Type Double

Address2_Line1

Property Value
Description First line for entering address 2 information.
DisplayName Address 2: Street 1
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_line1
MaxLength 50
RequiredLevel None
Type String

Address2_Line2

Property Value
Description Second line for entering address 2 information.
DisplayName Address 2: Street 2
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_line2
MaxLength 50
RequiredLevel None
Type String

Address2_Line3

Property Value
Description Third line for entering address 2 information.
DisplayName Address 2: Street 3
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_line3
MaxLength 50
RequiredLevel None
Type String

Address2_Longitude

Property Value
Description Longitude for address 2.
DisplayName Address 2: Longitude
IsValidForForm True
IsValidForRead True
LogicalName address2_longitude
MaxValue 180
MinValue -180
Precision 5
RequiredLevel None
Type Double

Address2_Name

Property Value
Description Name to enter for address 2.
DisplayName Address 2: Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_name
MaxLength 100
RequiredLevel None
Type String

Address2_PostalCode

Property Value
Description ZIP Code or postal code for address 2.
DisplayName Address 2: ZIP/Postal Code
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_postalcode
MaxLength 20
RequiredLevel None
Type String

Address2_PostOfficeBox

Property Value
Description Post office box number for address 2.
DisplayName Address 2: Post Office Box
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_postofficebox
MaxLength 20
RequiredLevel None
Type String

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

Address2_ShippingMethodCode Choices/Options

Value Label Description
1 Default Value

Address2_StateOrProvince

Property Value
Description State or province for address 2.
DisplayName Address 2: State/Province
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_stateorprovince
MaxLength 50
RequiredLevel None
Type String

Address2_Telephone1

Property Value
Description First telephone number associated with address 2.
DisplayName Address 2: Telephone 1
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_telephone1
MaxLength 50
RequiredLevel None
Type String

Address2_Telephone2

Property Value
Description Second telephone number associated with address 2.
DisplayName Address 2: Telephone 2
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_telephone2
MaxLength 50
RequiredLevel None
Type String

Address2_Telephone3

Property Value
Description Third telephone number associated with address 2.
DisplayName Address 2: Telephone 3
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_telephone3
MaxLength 50
RequiredLevel None
Type String

Address2_UPSZone

Property Value
Description United Parcel Service (UPS) zone for address 2.
DisplayName Address 2: UPS Zone
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_upszone
MaxLength 4
RequiredLevel None
Type String

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
Format TimeZone
IsValidForForm True
IsValidForRead True
LogicalName address2_utcoffset
MaxValue 1500
MinValue -1500
RequiredLevel None
Type Integer

CustomizationOptionValuePrefix

Property Value
Description Default option value prefix used for newly created options for solutions associated with this publisher.
DisplayName Option Value Prefix
Format None
IsValidForForm False
IsValidForRead True
LogicalName customizationoptionvalueprefix
MaxValue 99999
MinValue 10000
RequiredLevel SystemRequired
Type Integer

CustomizationPrefix

Property Value
Description Prefix used for new entities, attributes, and entity relationships for solutions associated with this publisher.
DisplayName Prefix
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName customizationprefix
MaxLength 8
RequiredLevel SystemRequired
Type String

Description

Property Value
Description Description of the solution.
DisplayName Description
FormatName TextArea
IsLocalizable True
IsValidForForm True
IsValidForRead True
LogicalName description
MaxLength 2000
RequiredLevel None
Type String

EMailAddress

Property Value
Description Email address for the publisher.
DisplayName Email
FormatName Email
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName emailaddress
MaxLength 100
RequiredLevel None
Type String

EntityImage

Property Value
Description Shows the default image for the record.
DisplayName Entity Image
IsPrimaryImage True
IsValidForForm False
IsValidForRead True
LogicalName entityimage
MaxHeight 144
MaxWidth 144
RequiredLevel None
Type Image

FriendlyName

Property Value
Description User display name for this publisher.
DisplayName Display Name
FormatName Text
IsLocalizable True
IsValidForForm True
IsValidForRead True
LogicalName friendlyname
MaxLength 256
RequiredLevel SystemRequired
Type String

PublisherId

Property Value
Description Unique identifier of the publisher.
DisplayName Publisher Identifier
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName publisherid
RequiredLevel SystemRequired
Type Uniqueidentifier

SupportingWebsiteUrl

Property Value
Description URL for the supporting website of this publisher.
DisplayName Website
FormatName Url
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName supportingwebsiteurl
MaxLength 200
RequiredLevel None
Type String

UniqueName

Property Value
Description The unique name of this publisher.
DisplayName Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName uniquename
MaxLength 256
RequiredLevel SystemRequired
Type String

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

CreatedBy

Property Value
Description Unique identifier of the user who created the publisher.
DisplayName Created By
IsValidForForm False
IsValidForRead True
LogicalName createdby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the publisher was created.
DisplayName Created On
Format DateAndTime
IsValidForForm False
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

CreatedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who created the publisher.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

EntityImage_Timestamp

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName entityimage_timestamp
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

EntityImage_URL

Property Value
Description
DisplayName
FormatName Url
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName entityimage_url
MaxLength 200
RequiredLevel None
Type String

EntityImageId

Property Value
Description For internal use only.
DisplayName Entity Image Id
IsValidForForm False
IsValidForRead True
LogicalName entityimageid
RequiredLevel None
Type Uniqueidentifier

IsReadonly

Property Value
Description Indicates whether the publisher was created as part of a managed solution installation.
DisplayName Is Read-Only Publisher
IsValidForForm False
IsValidForRead True
LogicalName isreadonly
RequiredLevel SystemRequired
Type Boolean

IsReadonly Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

ModifiedBy

Property Value
Description Unique identifier of the user who last modified the publisher.
DisplayName Modified By
IsValidForForm False
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the publisher was last modified.
DisplayName Modified On
Format DateAndTime
IsValidForForm False
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who modified the publisher.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

OrganizationId

Property Value
Description Unique identifier of the organization associated with the publisher.
DisplayName Organization
IsValidForForm False
IsValidForRead True
LogicalName organizationid
RequiredLevel SystemRequired
Targets organization
Type Lookup

OrganizationIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName organizationidname
MaxLength 100
RequiredLevel SystemRequired
Type String

PinpointPublisherDefaultLocale

Property Value
Description Default locale of the publisher in Microsoft Pinpoint.
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName pinpointpublisherdefaultlocale
MaxLength 16
RequiredLevel None
Type String

PinpointPublisherId

Property Value
Description Identifier of the publisher in Microsoft Pinpoint.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName pinpointpublisherid
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

VersionNumber

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

One-To-Many Relationships

Listed by SchemaName.

Publisher_PublisherAddress

Same as the Publisher_PublisherAddress many-to-one relationship for the publisheraddress table/entity.

Property Value
ReferencingEntity publisheraddress
ReferencingAttribute parentid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Publisher_PublisherAddress
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Publisher_DuplicateBaseRecord

Same as the Publisher_DuplicateBaseRecord many-to-one relationship for the duplicaterecord table/entity.

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute baserecordid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Publisher_DuplicateBaseRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Publisher_DuplicateMatchingRecord

Same as the Publisher_DuplicateMatchingRecord many-to-one relationship for the duplicaterecord table/entity.

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute duplicaterecordid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Publisher_DuplicateMatchingRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

publisher_solution

Same as the publisher_solution many-to-one relationship for the solution table/entity.

Property Value
ReferencingEntity solution
ReferencingAttribute publisherid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName publisher_solution
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Restrict
Merge: NoCascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

Publisher_SyncErrors

Same as the Publisher_SyncErrors many-to-one relationship for the syncerror table/entity.

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Publisher_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

publisher_appmodule

Same as the publisher_appmodule many-to-one relationship for the appmodule table/entity.

Property Value
ReferencingEntity appmodule
ReferencingAttribute publisherid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName publisher_appmodule
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Restrict
Merge: NoCascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

lk_publisher_createdby

See the lk_publisher_createdby one-to-many relationship for the systemuser table/entity.

lk_publisher_modifiedby

See the lk_publisher_modifiedby one-to-many relationship for the systemuser table/entity.

organization_publisher

See the organization_publisher one-to-many relationship for the organization table/entity.

lk_publisherbase_modifiedonbehalfby

See the lk_publisherbase_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.

lk_publisherbase_createdonbehalfby

See the lk_publisherbase_createdonbehalfby one-to-many relationship for the systemuser table/entity.

See also

Dataverse table/entity reference
Web API Reference
publisher EntityType