Discount table/entity reference (Microsoft Dynamics 365)

2025-08-29

Price reduction made from the list price of a product or service based on the quantity purchased.

Messages

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` /discounts See 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` /discounts See 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

Properties

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`

Writable columns/attributes

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

Amount

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)

DiscountId

Property	Value
Description	Unique identifier of the discount.
DisplayName	Discount
IsValidForForm	False
IsValidForRead	True
LogicalName	`discountid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

DiscountTypeId

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

HighQuantity

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

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

LowQuantity

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

Name

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

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

Percentage

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

StatusCode

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`

StatusCode Choices/Options

Value	Details

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

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.

Amount_Base
CreatedBy
CreatedOn
CreatedOnBehalfBy
ExchangeRate
IsAmountType
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OrganizationId
TransactionCurrencyId
VersionNumber

Amount_Base

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)

CreatedBy

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

CreatedOn

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

CreatedOnBehalfBy

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

ExchangeRate

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

IsAmountType

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

ModifiedBy

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

ModifiedOn

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

ModifiedOnBehalfBy

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

OrganizationId

Property	Value
Description	Unique identifier of the organization associated with the discount.
DisplayName	Organization
IsValidForForm	False
IsValidForRead	True
LogicalName	`organizationid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

TransactionCurrencyId

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

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.

discount_type_discounts
lk_discount_createdonbehalfby
lk_discount_modifiedonbehalfby
lk_discountbase_createdby
lk_discountbase_modifiedby
transactioncurrency_discount

discount_type_discounts

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`

lk_discount_createdonbehalfby

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`

lk_discount_modifiedonbehalfby

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`

lk_discountbase_createdby

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`

lk_discountbase_modifiedby

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`

transactioncurrency_discount

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`

One-to-Many relationships

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

Discount_AsyncOperations
Discount_BulkDeleteFailures
discount_MailboxTrackingFolders
discount_PrincipalObjectAttributeAccesses
Discount_ProcessSessions
Discount_SyncErrors

Discount_AsyncOperations

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`

Discount_BulkDeleteFailures

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`

discount_MailboxTrackingFolders

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`

discount_PrincipalObjectAttributeAccesses

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`

Discount_ProcessSessions

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`

Discount_SyncErrors

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`

Feedback

Was this page helpful?