package table/entity reference
Messages
The following table lists the messages for the package 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: True |
POST /packagesSee Create |
Create records |
Delete Event: True |
DELETE /packages(packageid)See Delete |
Delete records |
IsValidStateTransition Event: False |
IsValidStateTransition | IsValidStateTransitionRequest |
Retrieve Event: True |
GET /packages(packageid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: True |
GET /packagesSee Query data |
Query data |
SetState Event: True |
PATCH /packages(packageid)Update the statecode and statuscode properties. |
SetStateRequest |
Update Event: True |
PATCH /packages(packageid)See Update |
Update records |
Upsert Event: False |
PATCH /packages(packageid)See Upsert a table row |
UpsertRequest |
Properties
The following table lists selected properties for the package table.
Property | Value |
---|---|
DisplayName | Package |
DisplayCollectionName | Packages |
SchemaName | package |
CollectionSchemaName | packages |
EntitySetName | packages |
LogicalName | package |
LogicalCollectionName | packages |
PrimaryIdAttribute | packageid |
PrimaryNameAttribute | packageuniquename |
TableType | Standard |
OwnershipType | OrganizationOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- AppId
- ApplicationName
- CatalogId
- ImportSequenceNumber
- InstalledOn
- OverriddenCreatedOn
- packageId
- PackageInstanceId
- PackageInstanceOperationId
- PackageUniqueName
- PackageVersion
- PublisherId
- PublisherName
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- TPSPackageId
- UTCConversionTimeZoneCode
AppId
Property | Value |
---|---|
Description | |
DisplayName | AppId |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | appid |
RequiredLevel | None |
Type | Uniqueidentifier |
ApplicationName
Property | Value |
---|---|
Description | |
DisplayName | ApplicationName |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | applicationname |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
CatalogId
Property | Value |
---|---|
Description | The Catalog identifier for packages installed from a Catalog |
DisplayName | Catalog Id |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | catalogid |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
ImportSequenceNumber
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 |
InstalledOn
Property | Value |
---|---|
Description | Date and time when the package was first installed. |
DisplayName | Installed On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | installedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
OverriddenCreatedOn
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 |
packageId
Property | Value |
---|---|
Description | Unique identifier for entity instances |
DisplayName | PackageId |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | packageid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
PackageInstanceId
Property | Value |
---|---|
Description | |
DisplayName | PackageInstanceId |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | packageinstanceid |
RequiredLevel | None |
Type | Uniqueidentifier |
PackageInstanceOperationId
Property | Value |
---|---|
Description | |
DisplayName | PackageInstanceOperationId |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | packageinstanceoperationid |
RequiredLevel | None |
Type | Uniqueidentifier |
PackageUniqueName
Property | Value |
---|---|
Description | The unique name of the package. |
DisplayName | Package Unique Name |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | packageuniquename |
RequiredLevel | ApplicationRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
PackageVersion
Property | Value |
---|---|
Description | |
DisplayName | PackageVersion |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | packageversion |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
PublisherId
Property | Value |
---|---|
Description | |
DisplayName | PublisherId |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | publisherid |
RequiredLevel | None |
Type | Uniqueidentifier |
PublisherName
Property | Value |
---|---|
Description | |
DisplayName | PublisherName |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | publishername |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
statecode
Property | Value |
---|---|
Description | Status of the Package |
DisplayName | Status |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
DefaultFormValue | |
GlobalChoiceName | package_statecode |
statecode Choices/Options
Value | Details |
---|---|
0 | Label: Active DefaultStatus: 1 InvariantName: Active |
1 | Label: Inactive DefaultStatus: 2 InvariantName: Inactive |
statuscode
Property | Value |
---|---|
Description | Reason for the status of the Package |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
DefaultFormValue | |
GlobalChoiceName | package_statuscode |
statuscode Choices/Options
Value | Details |
---|---|
1 | Label: Active State:0 TransitionData: None |
2 | Label: Inactive State:1 TransitionData: None |
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 |
TPSPackageId
Property | Value |
---|---|
Description | |
DisplayName | TPSPackageId |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | tpspackageid |
RequiredLevel | None |
Type | Uniqueidentifier |
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 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- DeploymentLog
- DeploymentLog_Name
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OrganizationId
- VersionNumber
CreatedBy
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 |
CreatedOn
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 |
CreatedOnBehalfBy
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 |
DeploymentLog
Property | Value |
---|---|
Description | Stores the package deployment logs for an installation |
DisplayName | Deployment Log |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | deploymentlog |
RequiredLevel | None |
Type | File |
MaxSizeInKB | 256000 |
DeploymentLog_Name
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | deploymentlog_name |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Disabled |
IsLocalizable | False |
MaxLength | 200 |
ModifiedBy
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 |
ModifiedOn
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 |
ModifiedOnBehalfBy
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 |
OrganizationId
Property | Value |
---|---|
Description | Unique identifier for the organization |
DisplayName | Organization Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | organizationid |
RequiredLevel | None |
Type | Lookup |
Targets | organization |
VersionNumber
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.
- FileAttachment_package_DeploymentLog
- lk_package_createdby
- lk_package_createdonbehalfby
- lk_package_modifiedby
- lk_package_modifiedonbehalfby
- organization_package
FileAttachment_package_DeploymentLog
One-To-Many Relationship: fileattachment FileAttachment_package_DeploymentLog
Property | Value |
---|---|
ReferencedEntity | fileattachment |
ReferencedAttribute | fileattachmentid |
ReferencingAttribute | deploymentlog |
ReferencingEntityNavigationPropertyName | deploymentlog |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
lk_package_createdby
One-To-Many Relationship: systemuser lk_package_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_package_createdonbehalfby
One-To-Many Relationship: systemuser lk_package_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_package_modifiedby
One-To-Many Relationship: systemuser lk_package_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_package_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_package_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 |
organization_package
One-To-Many Relationship: organization organization_package
Property | Value |
---|---|
ReferencedEntity | organization |
ReferencedAttribute | organizationid |
ReferencingAttribute | organizationid |
ReferencingEntityNavigationPropertyName | organizationid |
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.
- package_AsyncOperations
- package_BulkDeleteFailures
- package_DuplicateBaseRecord
- package_DuplicateMatchingRecord
- package_FileAttachments
- package_MailboxTrackingFolders
- package_PrincipalObjectAttributeAccesses
- package_ProcessSession
- package_SyncErrors
package_AsyncOperations
Many-To-One Relationship: asyncoperation package_AsyncOperations
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | package_AsyncOperations |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
package_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure package_BulkDeleteFailures
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | package_BulkDeleteFailures |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
package_DuplicateBaseRecord
Many-To-One Relationship: duplicaterecord package_DuplicateBaseRecord
Property | Value |
---|---|
ReferencingEntity | duplicaterecord |
ReferencingAttribute | baserecordid |
ReferencedEntityNavigationPropertyName | package_DuplicateBaseRecord |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
package_DuplicateMatchingRecord
Many-To-One Relationship: duplicaterecord package_DuplicateMatchingRecord
Property | Value |
---|---|
ReferencingEntity | duplicaterecord |
ReferencingAttribute | duplicaterecordid |
ReferencedEntityNavigationPropertyName | package_DuplicateMatchingRecord |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
package_FileAttachments
Many-To-One Relationship: fileattachment package_FileAttachments
Property | Value |
---|---|
ReferencingEntity | fileattachment |
ReferencingAttribute | objectid |
ReferencedEntityNavigationPropertyName | package_FileAttachments |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
package_MailboxTrackingFolders
Many-To-One Relationship: mailboxtrackingfolder package_MailboxTrackingFolders
Property | Value |
---|---|
ReferencingEntity | mailboxtrackingfolder |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | package_MailboxTrackingFolders |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
package_PrincipalObjectAttributeAccesses
Many-To-One Relationship: principalobjectattributeaccess package_PrincipalObjectAttributeAccesses
Property | Value |
---|---|
ReferencingEntity | principalobjectattributeaccess |
ReferencingAttribute | objectid |
ReferencedEntityNavigationPropertyName | package_PrincipalObjectAttributeAccesses |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
package_ProcessSession
Many-To-One Relationship: processsession package_ProcessSession
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | package_ProcessSession |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
package_SyncErrors
Many-To-One Relationship: syncerror package_SyncErrors
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | package_SyncErrors |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-to-Many relationships
These relationships are many-to-many. Listed by SchemaName.
package_solution
See solution package_solution Many-To-Many Relationship
Property | Value |
---|---|
IntersectEntityName | package_solution |
IsCustomizable | False |
SchemaName | package_solution |
IntersectAttribute | packageid |
NavigationPropertyName | package_solution |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference
package