Discount table/entity reference (Microsoft Dynamics 365)
Price reduction made from the list price of a product or service based on the quantity purchased.
The following table lists the messages for the Discount 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 |
---|---|---|
Associate Event: True |
Associate records | Associate records |
Create Event: True |
POST /discountsSee Create |
Create records |
Delete Event: True |
DELETE /discounts(discountid)See Delete |
Delete records |
Disassociate Event: True |
Disassociate records | Disassociate records |
Retrieve Event: True |
GET /discounts(discountid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: True |
GET /discountsSee Query data |
Query data |
Update Event: True |
PATCH /discounts(discountid)See Update |
Update records |
Upsert Event: False |
PATCH /discounts(discountid)See Upsert a table row |
UpsertRequest |
The following table lists selected properties for the Discount table.
Property | Value |
---|---|
DisplayName | Discount |
DisplayCollectionName | Discounts |
SchemaName | Discount |
CollectionSchemaName | Discounts |
EntitySetName | discounts |
LogicalName | discount |
LogicalCollectionName | discounts |
PrimaryIdAttribute | discountid |
PrimaryNameAttribute | name |
TableType | Standard |
OwnershipType | None |
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- Amount
- DiscountId
- DiscountTypeId
- HighQuantity
- ImportSequenceNumber
- LowQuantity
- Name
- OverriddenCreatedOn
- Percentage
- StatusCode
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
Property | Value |
---|---|
Description | Amount of the discount, specified either as a percentage or as a monetary amount. |
DisplayName | Amount |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | amount |
RequiredLevel | ApplicationRequired |
Type | Money |
ImeMode | Disabled |
IsBaseCurrency | False |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 4 |
PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
Property | Value |
---|---|
Description | Unique identifier of the discount. |
DisplayName | Discount |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | discountid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
Property | Value |
---|---|
Description | Unique identifier of the discount list associated with the discount. |
DisplayName | Discount Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | discounttypeid |
RequiredLevel | SystemRequired |
Type | Lookup |
Targets | discounttype |
Property | Value |
---|---|
Description | Upper boundary for the quantity range to which a particular discount can be applied. |
DisplayName | End Quantity |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | highquantity |
RequiredLevel | SystemRequired |
Type | Decimal |
ImeMode | Disabled |
MaxValue | 100000000000 |
MinValue | 1E-05 |
Precision | 5 |
SourceTypeMask | 0 |
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 |
Property | Value |
---|---|
Description | Lower boundary for the quantity range to which a particular discount is applied. |
DisplayName | Begin Quantity |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | lowquantity |
RequiredLevel | SystemRequired |
Type | Decimal |
ImeMode | Disabled |
MaxValue | 100000000000 |
MinValue | 1E-05 |
Precision | 5 |
SourceTypeMask | 0 |
Property | Value |
---|---|
Description | name |
DisplayName | name |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
RequiredLevel | ApplicationRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
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 |
Property | Value |
---|---|
Description | Percentage discount value. |
DisplayName | Percentage |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | percentage |
RequiredLevel | ApplicationRequired |
Type | Decimal |
ImeMode | Disabled |
MaxValue | 1000000000 |
MinValue | 0 |
Precision | 5 |
SourceTypeMask | 0 |
Property | Value |
---|---|
Description | Select the discount's status. |
DisplayName | Status Reason |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
DefaultFormValue | -1 |
GlobalChoiceName | discount_statuscode |
Value | Details |
---|
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 |
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 |
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- Amount_Base
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- ExchangeRate
- IsAmountType
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OrganizationId
- TransactionCurrencyId
- VersionNumber
Property | Value |
---|---|
Description | Value of the Amount in base currency. |
DisplayName | Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | amount_base |
RequiredLevel | None |
Type | Money |
ImeMode | Disabled |
IsBaseCurrency | True |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
Property | Value |
---|---|
Description | Unique identifier of the user who created the discount. |
DisplayName | Created By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Date and time when the discount was created. |
DisplayName | Created On |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
Property | Value |
---|---|
Description | Unique identifier of the delegate user who created the discount. |
DisplayName | Created By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
DisplayName | Exchange Rate |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | exchangerate |
RequiredLevel | None |
Type | Decimal |
ImeMode | Disabled |
MaxValue | 100000000000 |
MinValue | 1E-12 |
Precision | 12 |
SourceTypeMask | 0 |
Property | Value |
---|---|
Description | Specifies whether the discount is specified as a monetary amount or a percentage. |
DisplayName | Amount Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | isamounttype |
RequiredLevel | ApplicationRequired |
Type | Boolean |
GlobalChoiceName | discount_isamounttype |
DefaultValue | False |
True Label | Yes |
False Label | No |
Property | Value |
---|---|
Description | Unique identifier of the user who last modified the discount. |
DisplayName | Modified By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Date and time when the discount was last modified. |
DisplayName | Modified On |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
Property | Value |
---|---|
Description | Unique identifier of the delegate user who last modified the discount. |
DisplayName | Modified By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Unique identifier of the organization associated with the discount. |
DisplayName | Organization |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | organizationid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
Property | Value |
---|---|
Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
DisplayName | Currency |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | transactioncurrencyid |
RequiredLevel | None |
Type | Lookup |
Targets | transactioncurrency |
Property | Value |
---|---|
Description | Version Number |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
RequiredLevel | None |
Type | BigInt |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
These relationships are many-to-one. Listed by SchemaName.
- discount_type_discounts
- lk_discount_createdonbehalfby
- lk_discount_modifiedonbehalfby
- lk_discountbase_createdby
- lk_discountbase_modifiedby
- transactioncurrency_discount
One-To-Many Relationship: discounttype discount_type_discounts
Property | Value |
---|---|
ReferencedEntity | discounttype |
ReferencedAttribute | discounttypeid |
ReferencingAttribute | discounttypeid |
ReferencingEntityNavigationPropertyName | discounttypeid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: systemuser lk_discount_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 |
One-To-Many Relationship: systemuser lk_discount_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 |
One-To-Many Relationship: systemuser lk_discountbase_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 |
One-To-Many Relationship: systemuser lk_discountbase_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 |
One-To-Many Relationship: transactioncurrency transactioncurrency_discount
Property | Value |
---|---|
ReferencedEntity | transactioncurrency |
ReferencedAttribute | transactioncurrencyid |
ReferencingAttribute | transactioncurrencyid |
ReferencingEntityNavigationPropertyName | transactioncurrencyid |
IsHierarchical | |
CascadeConfiguration | Archive: Restrict Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
These relationships are one-to-many. Listed by SchemaName.
- Discount_AsyncOperations
- Discount_BulkDeleteFailures
- discount_MailboxTrackingFolders
- discount_PrincipalObjectAttributeAccesses
- Discount_ProcessSessions
- Discount_SyncErrors
Many-To-One Relationship: asyncoperation Discount_AsyncOperations
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | Discount_AsyncOperations |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: bulkdeletefailure Discount_BulkDeleteFailures
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | Discount_BulkDeleteFailures |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: mailboxtrackingfolder discount_MailboxTrackingFolders
Property | Value |
---|---|
ReferencingEntity | mailboxtrackingfolder |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | discount_MailboxTrackingFolders |
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: principalobjectattributeaccess discount_PrincipalObjectAttributeAccesses
Property | Value |
---|---|
ReferencingEntity | principalobjectattributeaccess |
ReferencingAttribute | objectid |
ReferencedEntityNavigationPropertyName | discount_PrincipalObjectAttributeAccesses |
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: processsession Discount_ProcessSessions
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | Discount_ProcessSessions |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 110 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: syncerror Discount_SyncErrors
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | Discount_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