Exported Excel (exportedexcel) table/entity reference (Microsoft Dataverse)
Artykuł 21.01.2025
Współautorzy: 2
Opinia
W tym artykule
Messages
Properties
Writable columns/attributes
Read-only columns/attributes
Many-to-One relationships
One-to-Many relationships
Pokaż jeszcze 2
A Place holder entity to save excel file for each exportretaineddata custom api requests.
The following table lists the messages for the Exported Excel (exportedexcel) table.
Messages represent operations that can be performed on the table. They may also be events.
Rozwiń tabelę
The following table lists selected properties for the Exported Excel (exportedexcel) table.
Rozwiń tabelę
Property
Value
DisplayName
Exported Excel
DisplayCollectionName
Exported Excels
SchemaName
exportedexcel
CollectionSchemaName
exportedexcels
EntitySetName
exportedexcels
LogicalName
exportedexcel
LogicalCollectionName
exportedexcels
PrimaryIdAttribute
exportedexcelid
PrimaryNameAttribute
name
TableType
Standard
OwnershipType
UserOwned
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName .
Rozwiń tabelę
Property
Value
Description
Unique identifier for entity instances
DisplayName
Exported Excel
IsValidForForm
False
IsValidForRead
True
LogicalName
exportedexcelid
RequiredLevel
SystemRequired
Type
Uniqueidentifier
Rozwiń tabelę
Property
Value
Description
Sequence number of the import that created this record.
DisplayName
Import Sequence Number
IsValidForForm
False
IsValidForRead
True
LogicalName
importsequencenumber
RequiredLevel
None
Type
Integer
MaxValue
2147483647
MinValue
-2147483648
Rozwiń tabelę
Property
Value
Description
For internal use only.
DisplayName
Is Customizable
IsValidForForm
False
IsValidForRead
True
LogicalName
iscustomizable
RequiredLevel
SystemRequired
Type
ManagedProperty
Rozwiń tabelę
Property
Value
Description
The name of the custom entity.
DisplayName
Name
IsValidForForm
True
IsValidForRead
True
LogicalName
name
RequiredLevel
ApplicationRequired
Type
String
Format
Text
FormatName
Text
ImeMode
Auto
IsLocalizable
False
MaxLength
100
Rozwiń tabelę
Property
Value
Description
Date and time that the record was migrated.
DisplayName
Record Created On
IsValidForForm
False
IsValidForRead
True
LogicalName
overriddencreatedon
RequiredLevel
None
Type
DateTime
CanChangeDateTimeBehavior
False
DateTimeBehavior
UserLocal
Format
DateOnly
ImeMode
Inactive
SourceTypeMask
0
Rozwiń tabelę
Property
Value
Description
Owner Id
DisplayName
Owner
IsValidForForm
True
IsValidForRead
True
LogicalName
ownerid
RequiredLevel
SystemRequired
Type
Owner
Targets
systemuser, team
Rozwiń tabelę
Property
Value
Description
Owner Id Type
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
owneridtype
RequiredLevel
SystemRequired
Type
EntityName
Rozwiń tabelę
Property
Value
Description
Status of the Exported Excel
DisplayName
Status
IsValidForForm
True
IsValidForRead
True
LogicalName
statecode
RequiredLevel
SystemRequired
Type
State
DefaultFormValue
GlobalChoiceName
exportedexcel_statecode
statecode Choices/Options
Rozwiń tabelę
Value
Details
0
Label: Active DefaultStatus: 1 InvariantName: Active
1
Label: Inactive DefaultStatus: 2 InvariantName: Inactive
Rozwiń tabelę
Property
Value
Description
Reason for the status of the Exported Excel
DisplayName
Status Reason
IsValidForForm
True
IsValidForRead
True
LogicalName
statuscode
RequiredLevel
None
Type
Status
DefaultFormValue
GlobalChoiceName
exportedexcel_statuscode
statuscode Choices/Options
Rozwiń tabelę
Value
Details
1
Label: Active State:0 TransitionData: None
2
Label: Inactive State:1 TransitionData: None
TimeZoneRuleVersionNumber
Rozwiń tabelę
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
UTCConversionTimeZoneCode
Rozwiń tabelę
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
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate . Listed by SchemaName .
Rozwiń tabelę
Property
Value
Description
For internal use only.
DisplayName
Row id unique
IsValidForForm
False
IsValidForRead
True
LogicalName
componentidunique
RequiredLevel
SystemRequired
Type
Uniqueidentifier
Rozwiń tabelę
Property
Value
Description
For internal use only.
DisplayName
Component State
IsValidForForm
False
IsValidForRead
True
LogicalName
componentstate
RequiredLevel
SystemRequired
Type
Picklist
DefaultFormValue
GlobalChoiceName
componentstate
ComponentState Choices/Options
Rozwiń tabelę
Value
Label
0
Published
1
Unpublished
2
Deleted
3
Deleted Unpublished
Rozwiń tabelę
Property
Value
Description
Unique identifier of the user who created the record.
DisplayName
Created By
IsValidForForm
True
IsValidForRead
True
LogicalName
createdby
RequiredLevel
None
Type
Lookup
Targets
systemuser
Rozwiń tabelę
Property
Value
Description
Date and time when the record 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
Rozwiń tabelę
Property
Value
Description
Unique identifier of the delegate user who created the record.
DisplayName
Created By (Delegate)
IsValidForForm
True
IsValidForRead
True
LogicalName
createdonbehalfby
RequiredLevel
None
Type
Lookup
Targets
systemuser
Rozwiń tabelę
Property
Value
Description
DisplayName
ExcelContent
IsValidForForm
True
IsValidForRead
True
LogicalName
excelcontent
RequiredLevel
None
Type
File
MaxSizeInKB
32768
Rozwiń tabelę
Property
Value
Description
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
excelcontent_name
RequiredLevel
None
Type
String
Format
Text
FormatName
Text
ImeMode
Disabled
IsLocalizable
False
MaxLength
200
Rozwiń tabelę
Property
Value
Description
Indicates whether the solution component is part of a managed solution.
DisplayName
Is Managed
IsValidForForm
False
IsValidForRead
True
LogicalName
ismanaged
RequiredLevel
SystemRequired
Type
Boolean
GlobalChoiceName
ismanaged
DefaultValue
False
True Label
Managed
False Label
Unmanaged
Rozwiń tabelę
Property
Value
Description
Unique identifier of the user who modified the record.
DisplayName
Modified By
IsValidForForm
True
IsValidForRead
True
LogicalName
modifiedby
RequiredLevel
None
Type
Lookup
Targets
systemuser
Rozwiń tabelę
Property
Value
Description
Date and time when the record was modified.
DisplayName
Modified On
IsValidForForm
True
IsValidForRead
True
LogicalName
modifiedon
RequiredLevel
None
Type
DateTime
CanChangeDateTimeBehavior
False
DateTimeBehavior
UserLocal
Format
DateAndTime
ImeMode
Inactive
SourceTypeMask
0
Rozwiń tabelę
Property
Value
Description
Unique identifier of the delegate user who modified the record.
DisplayName
Modified By (Delegate)
IsValidForForm
True
IsValidForRead
True
LogicalName
modifiedonbehalfby
RequiredLevel
None
Type
Lookup
Targets
systemuser
Rozwiń tabelę
Property
Value
Description
For internal use only.
DisplayName
Record Overwrite Time
IsValidForForm
False
IsValidForRead
True
LogicalName
overwritetime
RequiredLevel
SystemRequired
Type
DateTime
CanChangeDateTimeBehavior
False
DateTimeBehavior
UserLocal
Format
DateAndTime
ImeMode
Inactive
SourceTypeMask
0
Rozwiń tabelę
Property
Value
Description
Name of the owner
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
owneridname
RequiredLevel
SystemRequired
Type
String
Format
Text
FormatName
Text
ImeMode
Auto
IsLocalizable
False
MaxLength
100
Rozwiń tabelę
Property
Value
Description
Yomi name of the owner
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
owneridyominame
RequiredLevel
SystemRequired
Type
String
Format
Text
FormatName
Text
ImeMode
Auto
IsLocalizable
False
MaxLength
100
Rozwiń tabelę
Property
Value
Description
Unique identifier for the business unit that owns the record
DisplayName
Owning Business Unit
IsValidForForm
True
IsValidForRead
True
LogicalName
owningbusinessunit
RequiredLevel
SystemRequired
Type
Lookup
Targets
businessunit
Rozwiń tabelę
Property
Value
Description
Unique identifier for the team that owns the record.
DisplayName
Owning Team
IsValidForForm
False
IsValidForRead
True
LogicalName
owningteam
RequiredLevel
None
Type
Lookup
Targets
team
Rozwiń tabelę
Property
Value
Description
Unique identifier for the user that owns the record.
DisplayName
Owning User
IsValidForForm
False
IsValidForRead
True
LogicalName
owninguser
RequiredLevel
None
Type
Lookup
Targets
systemuser
Rozwiń tabelę
Property
Value
Description
Unique identifier of the associated solution.
DisplayName
Solution
IsValidForForm
False
IsValidForRead
True
LogicalName
solutionid
RequiredLevel
SystemRequired
Type
Uniqueidentifier
Rozwiń tabelę
Property
Value
Description
For internal use only.
DisplayName
Solution
IsValidForForm
False
IsValidForRead
False
LogicalName
supportingsolutionid
RequiredLevel
None
Type
Uniqueidentifier
Rozwiń tabelę
Property
Value
Description
Version Number
DisplayName
Version Number
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 .
business_unit_exportedexcel
One-To-Many Relationship: businessunit business_unit_exportedexcel
Rozwiń tabelę
Property
Value
ReferencedEntity
businessunit
ReferencedAttribute
businessunitid
ReferencingAttribute
owningbusinessunit
ReferencingEntityNavigationPropertyName
owningbusinessunit
IsHierarchical
CascadeConfiguration
Archive: Restrict
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade
FileAttachment_exportedexcel_ExcelContent
One-To-Many Relationship: fileattachment FileAttachment_exportedexcel_ExcelContent
Rozwiń tabelę
Property
Value
ReferencedEntity
fileattachment
ReferencedAttribute
fileattachmentid
ReferencingAttribute
excelcontent
ReferencingEntityNavigationPropertyName
excelcontent
IsHierarchical
CascadeConfiguration
Archive: RemoveLink
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade
lk_exportedexcel_createdby
One-To-Many Relationship: systemuser lk_exportedexcel_createdby
Rozwiń tabelę
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_exportedexcel_createdonbehalfby
One-To-Many Relationship: systemuser lk_exportedexcel_createdonbehalfby
Rozwiń tabelę
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_exportedexcel_modifiedby
One-To-Many Relationship: systemuser lk_exportedexcel_modifiedby
Rozwiń tabelę
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_exportedexcel_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_exportedexcel_modifiedonbehalfby
Rozwiń tabelę
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
One-To-Many Relationship: owner owner_exportedexcel
Rozwiń tabelę
Property
Value
ReferencedEntity
owner
ReferencedAttribute
ownerid
ReferencingAttribute
ownerid
ReferencingEntityNavigationPropertyName
ownerid
IsHierarchical
CascadeConfiguration
Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade
One-To-Many Relationship: team team_exportedexcel
Rozwiń tabelę
Property
Value
ReferencedEntity
team
ReferencedAttribute
teamid
ReferencingAttribute
owningteam
ReferencingEntityNavigationPropertyName
owningteam
IsHierarchical
CascadeConfiguration
Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade
One-To-Many Relationship: systemuser user_exportedexcel
Rozwiń tabelę
Property
Value
ReferencedEntity
systemuser
ReferencedAttribute
systemuserid
ReferencingAttribute
owninguser
ReferencingEntityNavigationPropertyName
owninguser
IsHierarchical
CascadeConfiguration
Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName .
exportedexcel_AsyncOperations
Many-To-One Relationship: asyncoperation exportedexcel_AsyncOperations
Rozwiń tabelę
Property
Value
ReferencingEntity
asyncoperation
ReferencingAttribute
regardingobjectid
ReferencedEntityNavigationPropertyName
exportedexcel_AsyncOperations
IsCustomizable
True
AssociatedMenuConfiguration
AvailableOffline: True Behavior: DoNotDisplay
Group: Details
Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000
exportedexcel_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure exportedexcel_BulkDeleteFailures
Rozwiń tabelę
Property
Value
ReferencingEntity
bulkdeletefailure
ReferencingAttribute
regardingobjectid
ReferencedEntityNavigationPropertyName
exportedexcel_BulkDeleteFailures
IsCustomizable
True
AssociatedMenuConfiguration
AvailableOffline: True Behavior: DoNotDisplay
Group: Details
Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000
exportedexcel_DuplicateBaseRecord
Many-To-One Relationship: duplicaterecord exportedexcel_DuplicateBaseRecord
Rozwiń tabelę
Property
Value
ReferencingEntity
duplicaterecord
ReferencingAttribute
baserecordid
ReferencedEntityNavigationPropertyName
exportedexcel_DuplicateBaseRecord
IsCustomizable
True
AssociatedMenuConfiguration
AvailableOffline: True Behavior: DoNotDisplay
Group: Details
Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000
exportedexcel_DuplicateMatchingRecord
Many-To-One Relationship: duplicaterecord exportedexcel_DuplicateMatchingRecord
Rozwiń tabelę
Property
Value
ReferencingEntity
duplicaterecord
ReferencingAttribute
duplicaterecordid
ReferencedEntityNavigationPropertyName
exportedexcel_DuplicateMatchingRecord
IsCustomizable
True
AssociatedMenuConfiguration
AvailableOffline: True Behavior: DoNotDisplay
Group: Details
Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000
exportedexcel_FileAttachments
Many-To-One Relationship: fileattachment exportedexcel_FileAttachments
Rozwiń tabelę
Property
Value
ReferencingEntity
fileattachment
ReferencingAttribute
objectid
ReferencedEntityNavigationPropertyName
exportedexcel_FileAttachments
IsCustomizable
True
AssociatedMenuConfiguration
AvailableOffline: True Behavior: DoNotDisplay
Group: Details
Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000
exportedexcel_MailboxTrackingFolders
Many-To-One Relationship: mailboxtrackingfolder exportedexcel_MailboxTrackingFolders
Rozwiń tabelę
Property
Value
ReferencingEntity
mailboxtrackingfolder
ReferencingAttribute
regardingobjectid
ReferencedEntityNavigationPropertyName
exportedexcel_MailboxTrackingFolders
IsCustomizable
True
AssociatedMenuConfiguration
AvailableOffline: True Behavior: DoNotDisplay
Group: Details
Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000
exportedexcel_PrincipalObjectAttributeAccesses
Many-To-One Relationship: principalobjectattributeaccess exportedexcel_PrincipalObjectAttributeAccesses
Rozwiń tabelę
Property
Value
ReferencingEntity
principalobjectattributeaccess
ReferencingAttribute
objectid
ReferencedEntityNavigationPropertyName
exportedexcel_PrincipalObjectAttributeAccesses
IsCustomizable
True
AssociatedMenuConfiguration
AvailableOffline: True Behavior: DoNotDisplay
Group: Details
Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000
exportedexcel_ProcessSession
Many-To-One Relationship: processsession exportedexcel_ProcessSession
Rozwiń tabelę
Property
Value
ReferencingEntity
processsession
ReferencingAttribute
regardingobjectid
ReferencedEntityNavigationPropertyName
exportedexcel_ProcessSession
IsCustomizable
True
AssociatedMenuConfiguration
AvailableOffline: True Behavior: DoNotDisplay
Group: Details
Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000
Many-To-One Relationship: syncerror exportedexcel_SyncErrors
Rozwiń tabelę
Property
Value
ReferencingEntity
syncerror
ReferencingAttribute
regardingobjectid
ReferencedEntityNavigationPropertyName
exportedexcel_SyncErrors
IsCustomizable
True
AssociatedMenuConfiguration
AvailableOffline: True Behavior: DoNotDisplay
Group: Details
Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000
Dataverse table/entity reference
Dataverse Web API Reference
exportedexcel