Publisher Address (PublisherAddress) table/entity reference (Microsoft Dataverse)

Address and shipping information. Used to store additional addresses for a publisher.

Messages

The following table lists the messages for the Publisher Address (PublisherAddress) 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
Associate Event: True	Associate records	Associate records
Create Event: False	POST /publisheraddresses See Create	Create records
Delete Event: True	DELETE /publisheraddresses(publisheraddressid) See Delete	Delete records
Disassociate Event: True	Disassociate records	Disassociate records
Retrieve Event: True	GET /publisheraddresses(publisheraddressid) See Retrieve	Retrieve records
RetrieveMultiple Event: True	GET /publisheraddresses See Query data	Query data
Update Event: False	PATCH /publisheraddresses(publisheraddressid) See Update	Update records
Upsert Event: False	PATCH /publisheraddresses(publisheraddressid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Publisher Address (PublisherAddress) table.

Property	Value
DisplayName	Publisher Address
DisplayCollectionName	Publisher Addresses
SchemaName	PublisherAddress
CollectionSchemaName	PublisherAddresses
EntitySetName	publisheraddresses
LogicalName	publisheraddress
LogicalCollectionName	publisheraddresses
PrimaryIdAttribute	publisheraddressid
PrimaryNameAttribute	name
TableType	Standard
OwnershipType	None

Writable columns/attributes

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

• AddressNumber
• AddressTypeCode
• City
• Country
• County
• Fax
• FreightTermsCode
• ImportSequenceNumber
• Latitude
• Line1
• Line2
• Line3
• Longitude
• Name
• ParentId
• ParentIdTypeCode
• PostalCode
• PostOfficeBox
• PrimaryContactName
• PublisherAddressId
• ShippingMethodCode
• StateOrProvince
• Telephone1
• Telephone2
• Telephone3
• TimeZoneRuleVersionNumber
• UPSZone
• UTCConversionTimeZoneCode
• UTCOffset

AddressNumber

Property	Value
Description	Specifies which publisher address is applicable.
DisplayName	Address Number
IsValidForForm	True
IsValidForRead	True
LogicalName	addressnumber
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

AddressTypeCode

Property	Value
Description	Type of address for the publisher, such as billing, shipping, or primary address.
DisplayName	Address Type
IsValidForForm	True
IsValidForRead	True
LogicalName	addresstypecode
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	publisheraddress_addresstypecode

AddressTypeCode Choices/Options

Value	Label
1	Bill To
2	Ship To
3	Primary
4	Other

City

Property	Value
Description	City name in the publisher address.
DisplayName	City
IsValidForForm	True
IsValidForRead	True
LogicalName	city
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	80

Country

Property	Value
Description	Country/region name in the publisher address.
DisplayName	Country
IsValidForForm	False
IsValidForRead	True
LogicalName	country
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	80

County

Property	Value
Description	County name in the publisher address.
DisplayName	County
IsValidForForm	True
IsValidForRead	True
LogicalName	county
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	50

Fax

Property	Value
Description	Fax number for the publisher address.
DisplayName	Fax
IsValidForForm	True
IsValidForRead	True
LogicalName	fax
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

FreightTermsCode

Property	Value
Description	Freight terms for the publisher address.
DisplayName	Freight Terms
IsValidForForm	True
IsValidForRead	True
LogicalName	freighttermscode
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	publisheraddress_freighttermscode

FreightTermsCode Choices/Options

Value	Label
1	FOB
2	No Charge

ImportSequenceNumber

Property	Value
Description	Unique identifier of the data import or data migration that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	importsequencenumber
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

Latitude

Property	Value
Description	Latitude for the publisher address.
DisplayName	Latitude
IsValidForForm	True
IsValidForRead	True
LogicalName	latitude
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	90
MinValue	-90
Precision	5

Line1

Property	Value
Description	First line for entering address information.
DisplayName	Street 1
IsValidForForm	True
IsValidForRead	True
LogicalName	line1
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	50

Line2

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

Line3

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

Longitude

Property	Value
Description	Longitude for the publisher address.
DisplayName	Longitude
IsValidForForm	True
IsValidForRead	True
LogicalName	longitude
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	180
MinValue	-180
Precision	5

Name

Property	Value
Description	Name used to identify the publisher address.
DisplayName	Address Name
IsValidForForm	True
IsValidForRead	True
LogicalName	name
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

ParentId

Property	Value
Description	Unique identifier of the parent object with which the publisher address is associated.
DisplayName	Parent
IsValidForForm	True
IsValidForRead	True
LogicalName	parentid
RequiredLevel	SystemRequired
Type	Lookup
Targets	publisher

ParentIdTypeCode

Property	Value
Description
DisplayName	Parent Object Type
IsValidForForm	False
IsValidForRead	True
LogicalName	parentidtypecode
RequiredLevel	None
Type	EntityName

PostalCode

Property	Value
Description	ZIP Code or postal code in the publisher address.
DisplayName	ZIP/Postal Code
IsValidForForm	True
IsValidForRead	True
LogicalName	postalcode
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	20

PostOfficeBox

Property	Value
Description	Post office box number in the publisher address.
DisplayName	Post Office Box
IsValidForForm	True
IsValidForRead	True
LogicalName	postofficebox
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	20

PrimaryContactName

Property	Value
Description	Name of the primary contact at the publisher address.
DisplayName	Address Contact
IsValidForForm	True
IsValidForRead	True
LogicalName	primarycontactname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	150

PublisherAddressId

Property	Value
Description	Unique identifier of the publisher address.
DisplayName	Address
IsValidForForm	False
IsValidForRead	True
LogicalName	publisheraddressid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ShippingMethodCode

Property	Value
Description	Method of shipment for the publisher address.
DisplayName	Shipping Method
IsValidForForm	True
IsValidForRead	True
LogicalName	shippingmethodcode
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	publisheraddress_shippingmethodcode

ShippingMethodCode Choices/Options

Value	Label
1	Default

StateOrProvince

Property	Value
Description	State or province in the publisher address.
DisplayName	State/Province
IsValidForForm	True
IsValidForRead	True
LogicalName	stateorprovince
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	50

Telephone1

Property	Value
Description	First telephone number for the publisher address.
DisplayName	Main Phone
IsValidForForm	True
IsValidForRead	True
LogicalName	telephone1
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

Telephone2

Property	Value
Description	Second telephone number for the publisher address.
DisplayName	Phone 2
IsValidForForm	True
IsValidForRead	True
LogicalName	telephone2
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

Telephone3

Property	Value
Description	Third telephone number for the publisher address.
DisplayName	Telephone 3
IsValidForForm	True
IsValidForRead	True
LogicalName	telephone3
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

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

UPSZone

Property	Value
Description	United Parcel Service (UPS) zone for the address of the publisher.
DisplayName	UPS Zone
IsValidForForm	True
IsValidForRead	True
LogicalName	upszone
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	4

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

UTCOffset

Property	Value
Description	UTC offset for the address. This is the difference between local time and standard Coordinated Universal Time.
DisplayName	UTC Offset
IsValidForForm	True
IsValidForRead	True
LogicalName	utcoffset
RequiredLevel	None
Type	Integer
MaxValue	1500
MinValue	-1500

Read-only columns/attributes

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

• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• VersionNumber

CreatedBy

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

CreatedOn

Property	Value
Description	Date and time when the publisher address was created.
DisplayName	Created On
IsValidForForm	True
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 publisher address.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedBy

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

ModifiedOn

Property	Value
Description	Date and time when the publisher address was last modified.
DisplayName	Modified On
IsValidForForm	True
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 modified the publisher address.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

VersionNumber

Property	Value
Description
DisplayName
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_publisheraddressbase_createdby
• lk_publisheraddressbase_createdonbehalfby
• lk_publisheraddressbase_modifiedby
• lk_publisheraddressbase_modifiedonbehalfby
• Publisher_PublisherAddress

lk_publisheraddressbase_createdby

One-To-Many Relationship: systemuser lk_publisheraddressbase_createdby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	createdby
ReferencingEntityNavigationPropertyName	createdby
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_publisheraddressbase_createdonbehalfby

One-To-Many Relationship: systemuser lk_publisheraddressbase_createdonbehalfby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	createdonbehalfby
ReferencingEntityNavigationPropertyName	createdonbehalfby
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_publisheraddressbase_modifiedby

One-To-Many Relationship: systemuser lk_publisheraddressbase_modifiedby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	modifiedby
ReferencingEntityNavigationPropertyName	modifiedby
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_publisheraddressbase_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_publisheraddressbase_modifiedonbehalfby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	modifiedonbehalfby
ReferencingEntityNavigationPropertyName	modifiedonbehalfby
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

Publisher_PublisherAddress

One-To-Many Relationship: publisher Publisher_PublisherAddress

Property	Value
ReferencedEntity	publisher
ReferencedAttribute	publisherid
ReferencingAttribute	parentid
ReferencingEntityNavigationPropertyName	parentid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

See also

Dataverse table/entity reference
Dataverse Web API Reference
publisheraddress