PublisherAddress table/entity reference

아티클
02/22/2024

Note

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

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

Messages

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

Properties

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

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
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	addressnumber
MaxValue	1000000000
MinValue	0
RequiredLevel	None
Type	Integer

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

AddressTypeCode Choices/Options

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

City

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

Country

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

County

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

Fax

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

FreightTermsCode

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

FreightTermsCode Choices/Options

Value	Label	Description
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
Format	None
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	importsequencenumber
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

Latitude

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

Line1

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

Line2

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

Line3

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

Longitude

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

Name

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

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
Targets	publisher
Type	Lookup

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
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	postalcode
MaxLength	20
RequiredLevel	None
Type	String

PostOfficeBox

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

PrimaryContactName

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

PublisherAddressId

Property	Value
Description	Unique identifier of the publisher address.
DisplayName	Address
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
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

ShippingMethodCode Choices/Options

Value	Label	Description
1	Default

StateOrProvince

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

Telephone1

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

Telephone2

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

Telephone3

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

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

UPSZone

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

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

UTCOffset

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

Read-only columns/attributes

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

CreatedBy
CreatedByName
CreatedByYomiName
CreatedOn
CreatedOnBehalfBy
CreatedOnBehalfByName
CreatedOnBehalfByYomiName
ModifiedBy
ModifiedByName
ModifiedByYomiName
ModifiedOn
ModifiedOnBehalfBy
ModifiedOnBehalfByName
ModifiedOnBehalfByYomiName
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
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

CreatedByYomiName

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

CreatedOn

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

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
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

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
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

ModifiedByYomiName

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

ModifiedOn

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

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
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

VersionNumber

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

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_publisheraddressbase_modifiedonbehalfby
lk_publisheraddressbase_createdonbehalfby
Publisher_PublisherAddress
lk_publisheraddressbase_createdby
lk_publisheraddressbase_modifiedby

lk_publisheraddressbase_modifiedonbehalfby

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

lk_publisheraddressbase_createdonbehalfby

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

Publisher_PublisherAddress

See the Publisher_PublisherAddress one-to-many relationship for the publisher table/entity.

lk_publisheraddressbase_createdby

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

lk_publisheraddressbase_modifiedby

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