Publisher Address (PublisherAddress) table/entity reference

Articolo
08/31/2024

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
`Create` Event: False	`POST` /publisheraddresses See Create	Create records
`Delete` Event: True	`DELETE` /publisheraddresses(publisheraddressid) See Delete	Delete 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`

Condividi tramite