JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

Discount

This is a table representing the Discount entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the discount.

Amount Double False

Amount of the discount, specified either as a percentage or as a monetary amount.

Amount_Base Double True

Base currency equivalent of the amount of the discount.

CreatedBy_Id String True

Unique identifier of the user who created the discount.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the discount was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the discount.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

DiscountId String False

Unique identifier of the discount.

DiscountTypeId_Id String False

Unique identifier of the discount list associated with the discount.

DiscountTypeId_LogicalName String False

DiscountTypeId_Name String False

ExchangeRate Double True

Exchange rate for the currency associated with the discount with respect to the base currency.

HighQuantity Double False

Upper boundary for the quantity range to which a particular discount can be applied.

ImportSequenceNumber Integer False

Unique identifier of the data import or data migration that created this record.

IsAmountType Boolean True

Specifies whether the discount is specified as a monetary amount or a percentage.

LowQuantity Double False

Lower boundary for the quantity range to which a particular discount is applied.

ModifiedBy_Id String True

Unique identifier of the user who last modified the discount.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the discount was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the discount.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

OrganizationId String True

Unique identifier of the organization associated with the discount.

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

Percentage Double False

Percentage discount value.

StatusCode String False

Reason for the status of the discount.

TransactionCurrencyId_Id String True

Unique identifier of the currency associated with the discount.

TransactionCurrencyId_LogicalName String True

TransactionCurrencyId_Name String True

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462