Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Provides ability to store details about service agreements you have with your customers
Messages
The following table lists the messages for the Agreement (msdyn_agreement) 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 |
|---|---|---|
AssignEvent: True |
PATCH /msdyn_agreements(msdyn_agreementid)Update the ownerid property. |
AssignRequest |
AssociateEvent: True |
Associate records | Associate records |
BulkRetainEvent: True |
BulkRetain | Learn to use messages with the SDK for .NET |
CreateEvent: True |
POST /msdyn_agreementsSee Create |
Create records |
CreateMultipleEvent: True |
CreateMultiple | CreateMultipleRequest |
DeleteEvent: True |
DELETE /msdyn_agreements(msdyn_agreementid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
GrantAccessEvent: True |
GrantAccess | GrantAccessRequest |
IsValidStateTransitionEvent: False |
IsValidStateTransition | IsValidStateTransitionRequest |
ModifyAccessEvent: True |
ModifyAccess | ModifyAccessRequest |
msdyn_FieldServiceAgreementSystemStatusActionEvent: False |
msdyn_FieldServiceAgreementSystemStatusAction action | Learn to use messages with the SDK for .NET |
PurgeRetainedContentEvent: True |
PurgeRetainedContent | Learn to use messages with the SDK for .NET |
RestoreEvent: True |
Restore | Learn to use messages with the SDK for .NET |
RetainEvent: True |
Retain | Learn to use messages with the SDK for .NET |
RetrieveEvent: True |
GET /msdyn_agreements(msdyn_agreementid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /msdyn_agreementsSee Query data |
Query data |
RetrievePrincipalAccessEvent: True |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccessEvent: True |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccessEvent: True |
RevokeAccess | RevokeAccessRequest |
RollbackRetainEvent: True |
RollbackRetain | Learn to use messages with the SDK for .NET |
SetStateEvent: True |
PATCH /msdyn_agreements(msdyn_agreementid)Update the statecode and statuscode properties. |
SetStateRequest |
UpdateEvent: True |
PATCH /msdyn_agreements(msdyn_agreementid)See Update |
Update records |
UpdateMultipleEvent: True |
UpdateMultiple | UpdateMultipleRequest |
UpsertEvent: False |
PATCH /msdyn_agreements(msdyn_agreementid)See Upsert a table row |
UpsertRequest |
UpsertMultipleEvent: False |
UpsertMultiple | UpsertMultipleRequest |
ValidateRetentionConfigEvent: True |
ValidateRetentionConfig | Learn to use messages with the SDK for .NET |
Properties
The following table lists selected properties for the Agreement (msdyn_agreement) table.
| Property | Value |
|---|---|
| DisplayName | Agreement |
| DisplayCollectionName | Agreements |
| SchemaName | msdyn_agreement |
| CollectionSchemaName | msdyn_agreements |
| EntitySetName | msdyn_agreements |
| LogicalName | msdyn_agreement |
| LogicalCollectionName | msdyn_agreements |
| PrimaryIdAttribute | msdyn_agreementid |
| PrimaryNameAttribute | msdyn_name |
| TableType | Standard |
| OwnershipType | UserOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ImportSequenceNumber
- msdyn_AgreementDetails
- msdyn_agreementId
- msdyn_AgreementRecordGeneration
- msdyn_AutoNumbering
- msdyn_BillingAccount
- msdyn_ChildIndex
- msdyn_DateCanceled
- msdyn_Description
- msdyn_Duration
- msdyn_EndDate
- msdyn_name
- msdyn_OriginatingAgreement
- msdyn_PriceList
- msdyn_ProcessStartedOn
- msdyn_SalesTaxCode
- msdyn_ServiceAccount
- msdyn_ServiceTerritory
- msdyn_StartDate
- msdyn_SubStatus
- msdyn_SystemStatus
- msdyn_Taxable
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- processid
- stageid
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- traversedpath
- UTCConversionTimeZoneCode
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Shows the 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 |
msdyn_AgreementDetails
| Property | Value |
|---|---|
| Description | Shows the details of this agreement, as presented to the customer |
| DisplayName | Agreement Details |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_agreementdetails |
| RequiredLevel | None |
| Type | Memo |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100000 |
msdyn_agreementId
| Property | Value |
|---|---|
| Description | Shows the entity instances. |
| DisplayName | Agreement |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_agreementid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
msdyn_AgreementRecordGeneration
| Property | Value |
|---|---|
| Description | This field defines the time of day when Work Orders and Invoices are generated by the Agreement Booking Setups and Agreement Invoice Setups defined on this Agreement. If this field is blank, the logic will look to the overall setting on the Field Service Settings record. |
| DisplayName | Agreement Record Generation |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_agreementrecordgeneration |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | True |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Auto |
| SourceTypeMask | 0 |
msdyn_AutoNumbering
| Property | Value |
|---|---|
| Description | Internal field used to generate the next name upon entity creation. It is optionally copied to the msdyn_name field. |
| DisplayName | Auto-Numbering |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_autonumbering |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
msdyn_BillingAccount
| Property | Value |
|---|---|
| Description | Account to be billed. If a billing account has been set on service account it will be populated by default. Otherwise, the billing account will be the same as the service account. |
| DisplayName | Billing Account |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_billingaccount |
| RequiredLevel | None |
| Type | Lookup |
| Targets | account |
msdyn_ChildIndex
| Property | Value |
|---|---|
| Description | |
| DisplayName | Child Index |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_childindex |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
msdyn_DateCanceled
| Property | Value |
|---|---|
| Description | Enter the date this agreement was canceled. |
| DisplayName | Date Canceled |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_datecanceled |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | True |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Auto |
| SourceTypeMask | 0 |
msdyn_Description
| Property | Value |
|---|---|
| Description | Type a description of the agreement. |
| DisplayName | Description |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_description |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 200 |
msdyn_Duration
| Property | Value |
|---|---|
| Description | Shows the duration how long this agreement is active. |
| DisplayName | Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_duration |
| RequiredLevel | ApplicationRequired |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
msdyn_EndDate
| Property | Value |
|---|---|
| Description | Enter the date when this agreement is no longer active. |
| DisplayName | End Date |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_enddate |
| RequiredLevel | ApplicationRequired |
| Type | DateTime |
| CanChangeDateTimeBehavior | True |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Auto |
| SourceTypeMask | 0 |
msdyn_name
| Property | Value |
|---|---|
| Description | |
| DisplayName | Agreement Number |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_name |
| RequiredLevel | ApplicationRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
msdyn_OriginatingAgreement
| Property | Value |
|---|---|
| Description | If this agreement originates from another agreement, you should specify the originating agreement here |
| DisplayName | Originating Agreement |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_originatingagreement |
| RequiredLevel | None |
| Type | Lookup |
| Targets | msdyn_agreement |
msdyn_PriceList
| Property | Value |
|---|---|
| Description | Price List that controls pricing for products added to this Agreement. By default the system will use the Price List specified on the account |
| DisplayName | Price List |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_pricelist |
| RequiredLevel | ApplicationRequired |
| Type | Lookup |
| Targets | pricelevel |
msdyn_ProcessStartedOn
| Property | Value |
|---|---|
| Description | For internal use only |
| DisplayName | Process Started On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_processstartedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | True |
| DateTimeBehavior | TimeZoneIndependent |
| Format | DateAndTime |
| ImeMode | Auto |
| SourceTypeMask | 0 |
msdyn_SalesTaxCode
| Property | Value |
|---|---|
| Description | Tax Code to be used to calculate tax when Agreement is taxable. By default the system will use the tax code specified on the service account |
| DisplayName | Sales Tax Code |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_salestaxcode |
| RequiredLevel | None |
| Type | Lookup |
| Targets | msdyn_taxcode |
msdyn_ServiceAccount
| Property | Value |
|---|---|
| Description | Account to be serviced |
| DisplayName | Service Account |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_serviceaccount |
| RequiredLevel | ApplicationRequired |
| Type | Lookup |
| Targets | account |
msdyn_ServiceTerritory
| Property | Value |
|---|---|
| Description | The service territory this Agreement relates to. By default this will be set to the Service Territory defined on the service account |
| DisplayName | Service Territory |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_serviceterritory |
| RequiredLevel | None |
| Type | Lookup |
| Targets | territory |
msdyn_StartDate
| Property | Value |
|---|---|
| Description | Enter the date from when this agreement is active. |
| DisplayName | Start Date |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_startdate |
| RequiredLevel | ApplicationRequired |
| Type | DateTime |
| CanChangeDateTimeBehavior | True |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Auto |
| SourceTypeMask | 0 |
msdyn_SubStatus
| Property | Value |
|---|---|
| Description | Agreement Substatus |
| DisplayName | Substatus |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_substatus |
| RequiredLevel | None |
| Type | Lookup |
| Targets | msdyn_agreementsubstatus |
msdyn_SystemStatus
| Property | Value |
|---|---|
| Description | Tracks the current system status. |
| DisplayName | System Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_systemstatus |
| RequiredLevel | ApplicationRequired |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | msdyn_agreementsystemstatus |
msdyn_SystemStatus Choices/Options
| Value | Label |
|---|---|
| 690970000 | Estimate |
| 690970001 | Active |
| 690970002 | Expired |
| 690970003 | Canceled |
msdyn_Taxable
| Property | Value |
|---|---|
| Description | Specify if Agreement is taxable. By default an Agreement is taxable if billing account is not tax exempt, and Agreement type is taxable. If any of the above is false it will be set to non-taxable. |
| DisplayName | Taxable |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_taxable |
| RequiredLevel | ApplicationRequired |
| Type | Boolean |
| GlobalChoiceName | msdyn_agreement_msdyn_taxable |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
OverriddenCreatedOn
| Property | Value |
|---|---|
| Description | Shows the 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 |
OwnerId
| Property | Value |
|---|---|
| Description | Owner Id |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Type | Owner |
| Targets | systemuser, team |
OwnerIdType
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
processid
| Property | Value |
|---|---|
| Description | Contains the ID of the process associated with the entity. |
| DisplayName | Process Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | processid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
stageid
| Property | Value |
|---|---|
| Description | Contains the ID of the stage where the entity is located. |
| DisplayName | Stage Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | stageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
statecode
| Property | Value |
|---|---|
| Description | Status of the Agreement |
| DisplayName | Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
| DefaultFormValue | |
| GlobalChoiceName | msdyn_agreement_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 Agreement |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
| DefaultFormValue | |
| GlobalChoiceName | msdyn_agreement_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 |
traversedpath
| Property | Value |
|---|---|
| Description | Shows a comma-separated list of string values that represent the unique identifiers of stages in a business process flow instance in the order that they occur. |
| DisplayName | Traversed Path |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | traversedpath |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1250 |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Shows the 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
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- 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 | 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 | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
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 | 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 | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record on behalf of another user. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
OwnerIdName
| 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 |
OwnerIdYomiName
| 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 |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier for the business unit that owns the record |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Type | Lookup |
| Targets | businessunit |
OwningTeam
| 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 |
OwningUser
| 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 |
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.
- msdyn_account_msdyn_agreement_BillingAccount
- msdyn_account_msdyn_agreement_ServiceAccount
- msdyn_msdyn_agreement_msdyn_agreement_OriginatingAgreement
- msdyn_msdyn_agreementsubstatus_msdyn_agreement_SubStatus
- msdyn_msdyn_taxcode_msdyn_agreement_SalesTaxCode
- msdyn_territory_msdyn_agreement_ServiceTerritory
msdyn_account_msdyn_agreement_BillingAccount
One-To-Many Relationship: account msdyn_account_msdyn_agreement_BillingAccount
| Property | Value |
|---|---|
| ReferencedEntity | account |
| ReferencedAttribute | accountid |
| ReferencingAttribute | msdyn_billingaccount |
| ReferencingEntityNavigationPropertyName | msdyn_billingaccount |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: CascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_account_msdyn_agreement_ServiceAccount
One-To-Many Relationship: account msdyn_account_msdyn_agreement_ServiceAccount
| Property | Value |
|---|---|
| ReferencedEntity | account |
| ReferencedAttribute | accountid |
| ReferencingAttribute | msdyn_serviceaccount |
| ReferencingEntityNavigationPropertyName | msdyn_serviceaccount |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: CascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_msdyn_agreement_msdyn_agreement_OriginatingAgreement
One-To-Many Relationship: msdyn_agreement msdyn_msdyn_agreement_msdyn_agreement_OriginatingAgreement
| Property | Value |
|---|---|
| ReferencedEntity | msdyn_agreement |
| ReferencedAttribute | msdyn_agreementid |
| ReferencingAttribute | msdyn_originatingagreement |
| ReferencingEntityNavigationPropertyName | msdyn_originatingagreement_msdyn_agreement |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_msdyn_agreementsubstatus_msdyn_agreement_SubStatus
One-To-Many Relationship: msdyn_agreementsubstatus msdyn_msdyn_agreementsubstatus_msdyn_agreement_SubStatus
| Property | Value |
|---|---|
| ReferencedEntity | msdyn_agreementsubstatus |
| ReferencedAttribute | msdyn_agreementsubstatusid |
| ReferencingAttribute | msdyn_substatus |
| ReferencingEntityNavigationPropertyName | msdyn_substatus |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_msdyn_taxcode_msdyn_agreement_SalesTaxCode
One-To-Many Relationship: msdyn_taxcode msdyn_msdyn_taxcode_msdyn_agreement_SalesTaxCode
| Property | Value |
|---|---|
| ReferencedEntity | msdyn_taxcode |
| ReferencedAttribute | msdyn_taxcodeid |
| ReferencingAttribute | msdyn_salestaxcode |
| ReferencingEntityNavigationPropertyName | msdyn_salestaxcode |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_territory_msdyn_agreement_ServiceTerritory
One-To-Many Relationship: territory msdyn_territory_msdyn_agreement_ServiceTerritory
| Property | Value |
|---|---|
| ReferencedEntity | territory |
| ReferencedAttribute | territoryid |
| ReferencingAttribute | msdyn_serviceterritory |
| ReferencingEntityNavigationPropertyName | msdyn_serviceterritory |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- msdyn_agreement_msdyn_bookingalerts
- msdyn_msdyn_agreement_msdyn_actual_Agreement
- msdyn_msdyn_agreement_msdyn_agreement_OriginatingAgreement
- msdyn_msdyn_agreement_msdyn_agreementbookingdate_Agreement
- msdyn_msdyn_agreement_msdyn_agreementbookingincident_Agreement
- msdyn_msdyn_agreement_msdyn_agreementbookingproduct_Agreement
- msdyn_msdyn_agreement_msdyn_agreementbookingservice_Agreement
- msdyn_msdyn_agreement_msdyn_agreementbookingservicetask_Agreement
- msdyn_msdyn_agreement_msdyn_agreementbookingsetup_Agreement
- msdyn_msdyn_agreement_msdyn_agreementinvoicedate_Agreement
- msdyn_msdyn_agreement_msdyn_agreementinvoiceproduct_Agreement
- msdyn_msdyn_agreement_msdyn_agreementinvoicesetup_Agreement
- msdyn_msdyn_agreement_msdyn_workorder_Agreement
msdyn_agreement_msdyn_bookingalerts
Many-To-One Relationship: msdyn_bookingalert msdyn_agreement_msdyn_bookingalerts
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_bookingalert |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | msdyn_agreement_msdyn_bookingalerts |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_actual_Agreement
Many-To-One Relationship: msdyn_actual msdyn_msdyn_agreement_msdyn_actual_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_actual |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_actual_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_agreement_OriginatingAgreement
Many-To-One Relationship: msdyn_agreement msdyn_msdyn_agreement_msdyn_agreement_OriginatingAgreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_agreement |
| ReferencingAttribute | msdyn_originatingagreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_agreement_OriginatingAgreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_agreementbookingdate_Agreement
Many-To-One Relationship: msdyn_agreementbookingdate msdyn_msdyn_agreement_msdyn_agreementbookingdate_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_agreementbookingdate |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_agreementbookingdate_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_agreementbookingincident_Agreement
Many-To-One Relationship: msdyn_agreementbookingincident msdyn_msdyn_agreement_msdyn_agreementbookingincident_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_agreementbookingincident |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_agreementbookingincident_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseLabelGroup: DetailsLabel: Agreement Booking Incidents MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_agreementbookingproduct_Agreement
Many-To-One Relationship: msdyn_agreementbookingproduct msdyn_msdyn_agreement_msdyn_agreementbookingproduct_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_agreementbookingproduct |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_agreementbookingproduct_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseLabelGroup: DetailsLabel: Agreement Booking Products MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_agreementbookingservice_Agreement
Many-To-One Relationship: msdyn_agreementbookingservice msdyn_msdyn_agreement_msdyn_agreementbookingservice_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_agreementbookingservice |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_agreementbookingservice_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseLabelGroup: DetailsLabel: Agreement Booking Services MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_agreementbookingservicetask_Agreement
Many-To-One Relationship: msdyn_agreementbookingservicetask msdyn_msdyn_agreement_msdyn_agreementbookingservicetask_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_agreementbookingservicetask |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_agreementbookingservicetask_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseLabelGroup: DetailsLabel: Agreement Booking Service Tasks MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_agreementbookingsetup_Agreement
Many-To-One Relationship: msdyn_agreementbookingsetup msdyn_msdyn_agreement_msdyn_agreementbookingsetup_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_agreementbookingsetup |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_agreementbookingsetup_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseLabelGroup: DetailsLabel: Agreement Bookings MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_agreementinvoicedate_Agreement
Many-To-One Relationship: msdyn_agreementinvoicedate msdyn_msdyn_agreement_msdyn_agreementinvoicedate_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_agreementinvoicedate |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_agreementinvoicedate_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseLabelGroup: DetailsLabel: Agreement MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_agreementinvoiceproduct_Agreement
Many-To-One Relationship: msdyn_agreementinvoiceproduct msdyn_msdyn_agreement_msdyn_agreementinvoiceproduct_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_agreementinvoiceproduct |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_agreementinvoiceproduct_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseLabelGroup: DetailsLabel: Agreement MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_agreementinvoicesetup_Agreement
Many-To-One Relationship: msdyn_agreementinvoicesetup msdyn_msdyn_agreement_msdyn_agreementinvoicesetup_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_agreementinvoicesetup |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_agreementinvoicesetup_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseLabelGroup: DetailsLabel: Agreement Invoices MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_agreement_msdyn_workorder_Agreement
Many-To-One Relationship: msdyn_workorder msdyn_msdyn_agreement_msdyn_workorder_Agreement
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_workorder |
| ReferencingAttribute | msdyn_agreement |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_agreement_msdyn_workorder_Agreement |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference