Import Source File (ImportFile) table/entity reference (Microsoft Dataverse)

2025-08-28

File name of file used for import.

Messages

The following table lists the messages for the Import Source File (ImportFile) 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
`Assign` Event: False	`PATCH` /importfiles(importfileid) Update the `ownerid` property.	AssignRequest
`Associate` Event: True	Associate records	Associate records
`Create` Event: False	`POST` /importfiles See Create	Create records
`Delete` Event: False	`DELETE` /importfiles(importfileid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`GetDistinctValuesImportFile` Event: False	GetDistinctValuesImportFile	GetDistinctValuesImportFileRequest
`GetHeaderColumnsImportFile` Event: False	GetHeaderColumnsImportFile	GetHeaderColumnsImportFileRequest
`GrantAccess` Event: False	GrantAccess	GrantAccessRequest
`ModifyAccess` Event: False	ModifyAccess	ModifyAccessRequest
`Retrieve` Event: False	`GET` /importfiles(importfileid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: False	`GET` /importfiles See Query data	Query data
`RetrieveParsedDataImportFile` Event: False	RetrieveParsedDataImportFile	RetrieveParsedDataImportFileRequest
`RetrievePrincipalAccess` Event: False	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
`RetrieveSharedPrincipalsAndAccess` Event: False	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
`RevokeAccess` Event: False	RevokeAccess	RevokeAccessRequest
`Update` Event: False	`PATCH` /importfiles(importfileid) See Update	Update records
`Upsert` Event: False	`PATCH` /importfiles(importfileid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Import Source File (ImportFile) table.

Property	Value
DisplayName	Import Source File
DisplayCollectionName	Imports
SchemaName	`ImportFile`
CollectionSchemaName	`ImportFiles`
EntitySetName	`importfiles`
LogicalName	`importfile`
LogicalCollectionName	`importfiles`
PrimaryIdAttribute	`importfileid`
PrimaryNameAttribute	`name`
TableType	`Standard`
OwnershipType	`UserOwned`

Writable columns/attributes

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

Content
DataDelimiterCode
EnableDuplicateDetection
EntityKeyId
FieldDelimiterCode
FileTypeCode
ImportFileId
ImportId
ImportMapId
IsFirstRowHeader
Name
OwnerId
OwnerIdType
ProcessCode
RecordsOwnerId
RecordsOwnerIdType
RelatedEntityColumns
Size
Source
SourceEntityName
StateCode
StatusCode
TargetEntityName
TimeZoneRuleVersionNumber
UpsertModeCode
UseSystemMap
UTCConversionTimeZoneCode

Content

Property	Value
Description	Stores the content of the import file, stored as comma-separated values.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`content`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

DataDelimiterCode

Property	Value
Description	Select the single-character data delimiter used in the import file. This is typically a single or double quotation mark.
DisplayName	Data Delimiter
IsValidForForm	True
IsValidForRead	True
LogicalName	`datadelimitercode`
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`importfile_datadelimitercode`

DataDelimiterCode Choices/Options

Value	Label
1	DoubleQuote
2	None
3	SingleQuote

EnableDuplicateDetection

Property	Value
Description	Select whether duplicate-detection rules should be run against the import job.
DisplayName	Enable Duplicate Detection
IsValidForForm	True
IsValidForRead	True
LogicalName	`enableduplicatedetection`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`importfile_enableduplicatedetection`
DefaultValue	False
True Label	Yes
False Label	No

EntityKeyId

Property	Value
Description	Unique identifier of the Alternate key Id
DisplayName	Entity Key ID
IsValidForForm	False
IsValidForRead	True
LogicalName	`entitykeyid`
RequiredLevel	None
Type	Uniqueidentifier

FieldDelimiterCode

Property	Value
Description	Select the character that is used to separate each field in the import file. Typically, it is a comma.
DisplayName	Field Delimiter
IsValidForForm	True
IsValidForRead	True
LogicalName	`fielddelimitercode`
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`importfile_fielddelimitercode`

FieldDelimiterCode Choices/Options

Value	Label
1	Colon
2	Comma
3	Tab
4	Semicolon

FileTypeCode

Property	Value
Description	Shows the type of source file that is uploaded for import.
DisplayName	File Type
IsValidForForm	True
IsValidForRead	True
LogicalName	`filetypecode`
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`importfile_filetypecode`

FileTypeCode Choices/Options

Value	Label
0	CSV
1	XML Spreadsheet 2003
2	Attachment
3	XLSX

ImportFileId

Property	Value
Description	Unique identifier of the import file.
DisplayName	Import
IsValidForForm	False
IsValidForRead	True
LogicalName	`importfileid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ImportId

Property	Value
Description	Choose the import job that the file was uploaded for.
DisplayName	Import Job ID
IsValidForForm	True
IsValidForRead	True
LogicalName	`importid`
RequiredLevel	SystemRequired
Type	Lookup
Targets	import

ImportMapId

Property	Value
Description	Choose a data map to match the import file and its column headers with the record types and fields in Microsoft Dynamics 365. If the column headers in the file match the display names of the target fields in Microsoft Dynamics 365, we import the data automatically. If not, you can manually define matches during import.
DisplayName	Data Map
IsValidForForm	True
IsValidForRead	True
LogicalName	`importmapid`
RequiredLevel	None
Type	Lookup
Targets	importmap

IsFirstRowHeader

Property	Value
Description	Select whether the first row of the import file contains column headings, which are used for data mapping during the import job.
DisplayName	Is First Row Header
IsValidForForm	True
IsValidForRead	True
LogicalName	`isfirstrowheader`
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	`importfile_isfirstrowheader`
DefaultValue	False
True Label	Yes
False Label	No

Name

Property	Value
Description	Shows the name of the import file. This name is based on the name of the uploaded file.
DisplayName	Import Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

OwnerId

Property	Value
Description	Enter the user who is assigned to follow up with or manage the import file. This field is updated every time the import file is assigned to a different user.
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	`ownerid`
RequiredLevel	SystemRequired
Type	Owner
Targets	systemuser, team

OwnerIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridtype`
RequiredLevel	SystemRequired
Type	EntityName

ProcessCode

Property	Value
Description	Tells whether the import file should be ignored or processed during the import.
DisplayName	Process Code
IsValidForForm	True
IsValidForRead	True
LogicalName	`processcode`
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	`importfile_processcode`

ProcessCode Choices/Options

Value	Label
1	Process
2	Ignore
3	Internal

RecordsOwnerId

Property	Value
Description	Choose the user that the records created during the import job should be assigned to.
DisplayName	Records Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	`recordsownerid`
RequiredLevel	None
Type	Lookup
Targets	systemuser, team

RecordsOwnerIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`recordsowneridtype`
RequiredLevel	SystemRequired
Type	EntityName

RelatedEntityColumns

Property	Value
Description	Shows the columns that are mapped to a related record type (entity) of the primary record type (entity) included in the import file.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`relatedentitycolumns`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

Size

Property	Value
Description	Shows the size of the import file, in kilobytes.
DisplayName	Size
IsValidForForm	True
IsValidForRead	True
LogicalName	`size`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

Source

Property	Value
Description	Shows the name of the data source file uploaded in the import job.
DisplayName	Source
IsValidForForm	True
IsValidForRead	True
LogicalName	`source`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

SourceEntityName

Property	Value
Description	Shows the record type (entity) of the source data.
DisplayName	Source Entity
IsValidForForm	True
IsValidForRead	True
LogicalName	`sourceentityname`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

StateCode

Property	Value
Description	Shows the status of the import file record. By default, all records are active and can't be deactivated.
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	`importfile_statecode`

StateCode Choices/Options

Value	Details
0	Label: Active DefaultStatus: 0 InvariantName: `Active`

StatusCode

Property	Value
Description	Shows the reason code that explains the import file's status to identify the stage of the import process, from parsing the data to completed.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	`statuscode`
RequiredLevel	None
Type	Status
DefaultFormValue	-1
GlobalChoiceName	`importfile_statuscode`

StatusCode Choices/Options

Value	Details
0	Label: Submitted State:0 TransitionData: None
1	Label: Parsing State:0 TransitionData: None
2	Label: Transforming State:0 TransitionData: None
3	Label: Importing State:0 TransitionData: None
4	Label: Completed State:0 TransitionData: None
5	Label: Failed State:0 TransitionData: None

TargetEntityName

Property	Value
Description	Select the target record type (entity) for the records that will be created during the import job.
DisplayName	Target Entity
IsValidForForm	True
IsValidForRead	True
LogicalName	`targetentityname`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`timezoneruleversionnumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

UpsertModeCode

Property	Value
Description	Select the value which is used for identify the upsert mode. By Default, it is a Create.
DisplayName	Upsert Mode
IsValidForForm	True
IsValidForRead	True
LogicalName	`upsertmodecode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	0
GlobalChoiceName	`importfile_upsertmodecode`

UpsertModeCode Choices/Options

Value	Label
0	Create
1	Update
2	Ignore

UseSystemMap

Property	Value
Description	Tells whether an automatic system map was applied to the import file, which automatically maps the import data to the target entity in Microsoft Dynamics 365.
DisplayName	Use System Map
IsValidForForm	True
IsValidForRead	True
LogicalName	`usesystemmap`
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	`importfile_usesystemmap`
DefaultValue	False
True Label	Yes
False Label	No

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName
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.

AdditionalHeaderRow
CompletedOn
CreatedBy
CreatedOn
CreatedOnBehalfBy
FailureCount
HeaderRow
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OwnerIdName
OwnerIdYomiName
OwningBusinessUnit
OwningTeam
OwningUser
ParsedTableColumnPrefix
ParsedTableColumnsNumber
ParsedTableName
PartialFailureCount
ProcessingStatus
ProgressCounter
SuccessCount
TotalCount

AdditionalHeaderRow

Property	Value
Description	Shows the secondary column headers. The additional headers are used during the process of transforming the import file into import data records.
DisplayName	Additional Header
IsValidForForm	True
IsValidForRead	True
LogicalName	`additionalheaderrow`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100000

CompletedOn

Property	Value
Description	Shows the date and time when the import associated with the import file was completed.
DisplayName	Completed On
IsValidForForm	False
IsValidForRead	True
LogicalName	`completedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

CreatedBy

Property	Value
Description	Shows who created the record.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
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	Shows who created the record on behalf of another user.
DisplayName	Created By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

FailureCount

Property	Value
Description	Shows the number of records in the import file that cannot be imported.
DisplayName	Errors
IsValidForForm	True
IsValidForRead	True
LogicalName	`failurecount`
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

HeaderRow

Property	Value
Description	Shows a list of each column header in the import file separated by a comma. The header is used for parsing the file during the import job.
DisplayName	Header
IsValidForForm	True
IsValidForRead	True
LogicalName	`headerrow`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

ModifiedBy

Property	Value
Description	Shows who last updated the record.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Shows who created the record on behalf of another user.
DisplayName	Modified By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

OwnerIdName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridname`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwnerIdYomiName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridyominame`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwningBusinessUnit

Property	Value
Description	Shows the business unit that the record owner belongs to.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`owningbusinessunit`
RequiredLevel	None
Type	Lookup
Targets	businessunit

OwningTeam

Property	Value
Description	Unique identifier of the team who owns the import file.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	`owningteam`
RequiredLevel	None
Type	Lookup
Targets	team

OwningUser

Property	Value
Description	Unique identifier of the user who owns the import file.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	`owninguser`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ParsedTableColumnPrefix

Property	Value
Description	Shows the prefix applied to each column after the import file is parsed.
DisplayName	Parse Table Column Prefix
IsValidForForm	False
IsValidForRead	True
LogicalName	`parsedtablecolumnprefix`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

ParsedTableColumnsNumber

Property	Value
Description	Shows the number of columns included in the parsed import file.
DisplayName	Parse Table Column Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`parsedtablecolumnsnumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

ParsedTableName

Property	Value
Description	Shows the name of the table that contains the parsed data from the import file.
DisplayName	Parse Table
IsValidForForm	False
IsValidForRead	True
LogicalName	`parsedtablename`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

PartialFailureCount

Property	Value
Description	Shows the number of records in this file that had failures during the import.
DisplayName	Partial Failures
IsValidForForm	True
IsValidForRead	True
LogicalName	`partialfailurecount`
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

ProcessingStatus

Property	Value
Description	Shows the import file's processing status code. This indicates whether the data in the import file has been parsed, transformed, or imported.
DisplayName	Processing Status
IsValidForForm	False
IsValidForRead	True
LogicalName	`processingstatus`
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`importfile_processingstatus`

ProcessingStatus Choices/Options

Value	Label
1	Not Started
2	Parsing
3	Parsing Complete
4	Complex Transformation
5	Lookup Transformation
6	Picklist Transformation
7	Owner Transformation
8	Transformation Complete
9	Import Pass 1
10	Import Pass 2
11	Import Complete
12	Primary Key Transformation

ProgressCounter

Property	Value
Description	Shows the progress code for the processing of the import file. This field is used when a paused import job is resumed.
DisplayName	Progress Counter
IsValidForForm	False
IsValidForRead	True
LogicalName	`progresscounter`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

SuccessCount

Property	Value
Description	Shows the number of records in the import file that are imported successfully.
DisplayName	Successes
IsValidForForm	True
IsValidForRead	True
LogicalName	`successcount`
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

TotalCount

Property	Value
Description	Shows the total number of records in the import file.
DisplayName	Total Processed
IsValidForForm	True
IsValidForRead	True
LogicalName	`totalcount`
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

BusinessUnit_ImportFiles
Import_ImportFile
ImportFile_SystemUser
ImportFile_Team
ImportMap_ImportFile
lk_importfilebase_createdby
lk_importfilebase_createdonbehalfby
lk_importfilebase_modifiedby
lk_importfilebase_modifiedonbehalfby
owner_importfiles
SystemUser_ImportFiles
team_ImportFiles

BusinessUnit_ImportFiles

One-To-Many Relationship: businessunit BusinessUnit_ImportFiles

Property	Value
ReferencedEntity	`businessunit`
ReferencedAttribute	`businessunitid`
ReferencingAttribute	`owningbusinessunit`
ReferencingEntityNavigationPropertyName	`owningbusinessunit`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

Import_ImportFile

One-To-Many Relationship: import Import_ImportFile

Property	Value
ReferencedEntity	`import`
ReferencedAttribute	`importid`
ReferencingAttribute	`importid`
ReferencingEntityNavigationPropertyName	`importid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

ImportFile_SystemUser

One-To-Many Relationship: systemuser ImportFile_SystemUser

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

ImportFile_Team

One-To-Many Relationship: team ImportFile_Team

Property	Value
ReferencedEntity	`team`
ReferencedAttribute	`teamid`
ReferencingAttribute	`recordsownerid`
ReferencingEntityNavigationPropertyName	`recordsownerid_team`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

ImportMap_ImportFile

One-To-Many Relationship: importmap ImportMap_ImportFile

Property	Value
ReferencedEntity	`importmap`
ReferencedAttribute	`importmapid`
ReferencingAttribute	`importmapid`
ReferencingEntityNavigationPropertyName	`importmapid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_importfilebase_createdby

One-To-Many Relationship: systemuser lk_importfilebase_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_importfilebase_createdonbehalfby

One-To-Many Relationship: systemuser lk_importfilebase_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_importfilebase_modifiedby

One-To-Many Relationship: systemuser lk_importfilebase_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_importfilebase_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_importfilebase_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`

owner_importfiles

One-To-Many Relationship: owner owner_importfiles

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`

SystemUser_ImportFiles

One-To-Many Relationship: systemuser SystemUser_ImportFiles

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`

team_ImportFiles

One-To-Many Relationship: team team_ImportFiles

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 relationships

These relationships are one-to-many. Listed by SchemaName.

ImportFile_AsyncOperations
ImportFile_BulkDeleteFailures
ImportFile_ImportData
ImportLog_ImportFile

ImportFile_AsyncOperations

Many-To-One Relationship: asyncoperation ImportFile_AsyncOperations

Property	Value
ReferencingEntity	`asyncoperation`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`ImportFile_AsyncOperations`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

ImportFile_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure ImportFile_BulkDeleteFailures

Property	Value
ReferencingEntity	`bulkdeletefailure`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`ImportFile_BulkDeleteFailures`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

ImportFile_ImportData

Many-To-One Relationship: importdata ImportFile_ImportData

Property	Value
ReferencingEntity	`importdata`
ReferencingAttribute	`importfileid`
ReferencedEntityNavigationPropertyName	`ImportFile_ImportData`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

ImportLog_ImportFile

Many-To-One Relationship: importlog ImportLog_ImportFile

Property	Value
ReferencingEntity	`importlog`
ReferencingAttribute	`importfileid`
ReferencedEntityNavigationPropertyName	`ImportLog_ImportFile`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Feedback

Was this page helpful?