Sales Attachment (SalesLiteratureItem) table/entity reference

Note

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

Item in the sales literature collection.

Added by: Sales Solution

Messages

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

Properties

Property	Value
CollectionSchemaName	SalesLiteratureItems
DisplayCollectionName	Sales Attachments
DisplayName	Sales Attachment
EntitySetName	salesliteratureitems
IsBPFEntity	False
LogicalCollectionName	salesliteratureitems
LogicalName	salesliteratureitem
OwnershipType	None
PrimaryIdAttribute	salesliteratureitemid
PrimaryNameAttribute	title
SchemaName	SalesLiteratureItem

Writable columns/attributes

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

• Abstract
• AttachedDocumentUrl
• AuthorName
• DocumentBody
• FileName
• FileSize
• FileTypeCode
• ImportSequenceNumber
• IsCustomerViewable
• KeyWords
• MimeType
• Mode
• OverriddenCreatedOn
• SalesLiteratureId
• SalesLiteratureItemId
• TimeZoneRuleVersionNumber
• Title
• UTCConversionTimeZoneCode

Abstract

Property	Value
Description	Abstract of the document.
DisplayName	Abstract
Format	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	abstract
MaxLength	100000
RequiredLevel	None
Type	Memo

AttachedDocumentUrl

Property	Value
Description	URL of the Website on which the document is located.
DisplayName	Attached Document URL
FormatName	Url
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	attacheddocumenturl
MaxLength	500
RequiredLevel	None
Type	String

AuthorName

Property	Value
Description	Author name for the document.
DisplayName	Author Name
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	authorname
MaxLength	500
RequiredLevel	None
Type	String

DocumentBody

Property	Value
Description	Shows the encoded contents of the sales literature document attachment.
DisplayName
FormatName	TextArea
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	documentbody
MaxLength	1073741823
RequiredLevel	None
Type	String

FileName

Property	Value
Description	File name of the document.
DisplayName	File Name
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	filename
MaxLength	255
RequiredLevel	None
Type	String

FileSize

Property	Value
Description	File size of the document.
DisplayName	File Size (Bytes)
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	filesize
MaxValue	1000000000
MinValue	0
RequiredLevel	None
Type	Integer

FileTypeCode

Property	Value
Description	Select the file type of the document.
DisplayName	File Type
IsValidForForm	False
IsValidForRead	True
LogicalName	filetypecode
RequiredLevel	None
Type	Picklist

FileTypeCode Choices/Options

Value	Label	Description
1	Default Value

ImportSequenceNumber

Property	Value
Description	Sequence number of the import 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

IsCustomerViewable

Property	Value
Description	Tells whether the document can be shared with customers or is for internal use only.
DisplayName	Customer Viewable
IsValidForForm	False
IsValidForRead	True
LogicalName	iscustomerviewable
RequiredLevel	None
Type	Boolean

IsCustomerViewable Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

KeyWords

Property	Value
Description	Keywords to use for searches in documents.
DisplayName	Key Words
Format	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	keywords
MaxLength	100000
RequiredLevel	None
Type	Memo

MimeType

Property	Value
Description	Shows the file type of the sales literature document attachment, such as text or document.
DisplayName	Mime Type
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	mimetype
MaxLength	256
RequiredLevel	None
Type	String

Mode

Property	Value
Description	Defines the mode of the sales literature document attachment.
DisplayName	Mode
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	mode
MaxLength	256
RequiredLevel	None
Type	String

OverriddenCreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time that the record was migrated.
DisplayName	Record Created On
Format	DateOnly
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	overriddencreatedon
RequiredLevel	None
Type	DateTime

SalesLiteratureId

Property	Value
Description	Unique identifier of the sales literature that is associated with the individual item.
DisplayName	Sales Literature
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	salesliteratureid
RequiredLevel	SystemRequired
Targets	salesliterature
Type	Lookup

SalesLiteratureItemId

Property	Value
Description	Unique identifier for the document.
DisplayName	Sales Literature Item
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	salesliteratureitemid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

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

Title

Property	Value
Description	Type the title or name that describes the document.
DisplayName	Title
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	title
MaxLength	200
RequiredLevel	ApplicationRequired
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

Read-only columns/attributes

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

• CreatedBy
• CreatedByName
• CreatedByYomiName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• FileType
• ModifiedBy
• ModifiedByName
• ModifiedByYomiName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• OrganizationId
• SalesLiteratureIdName
• VersionNumber

CreatedBy

Property	Value
Description	Unique identifier of the user who created the document.
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

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 document 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 salesliteratureitem.
DisplayName	Created By (Delegate)
IsValidForForm	False
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

FileType

Property	Value
Description
DisplayName
Format	None
IsValidForForm	False
IsValidForRead	False
LogicalName	filetype
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the document.
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

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 document 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 last modified the salesliteratureitem.
DisplayName	Modified By (Delegate)
IsValidForForm	False
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 document.
DisplayName	Organization
IsValidForForm	False
IsValidForRead	True
LogicalName	organizationid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

SalesLiteratureIdName

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

VersionNumber

Property	Value
Description	Version Number
DisplayName	Version Number
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.

sales_literature_items

See the sales_literature_items one-to-many relationship for the salesliterature table/entity.

Related information

Dataverse table/entity reference
Web API Reference