AR
DiscountSequenceDetail
Represents one of the two discount breakpoint records created for each DiscountDetail records. The record stores (depending on the value of the IsLast flag) either the current or the pending break quantity or amount, and either the current or the pending discount percentage or amount. The entities of this type cannot be edited directly, but are aggregated into discount breakpoint records on the Discounts (AR209500) form, which corresponds to the ARDiscountSequenceMaint graph.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Amount | decimal | Break Amount | - | |
Description:No description available | ||||
AmountTo | decimal | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Discount | decimal | Discount Amount | - | |
Description:No description available | ||||
DiscountDetailsID | int | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | DiscountSequence | ||
Description:No description available | ||||
DiscountPercentNonexistent in DB | decimal? | Discount Percent | - | |
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | DiscountSequence | ||
Description:No description available | ||||
FreeItemQty | decimal | Free Item Qty. | - | |
Description:No description available | ||||
IsActive | bit | Active | - | |
Description:No description available | ||||
IsLast | bit | - | ||
Description:No description available | ||||
LastDate | datetime | Effective Date | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbr | int | - | ||
Description:No description available | ||||
PendingAmount | decimal | Pending Break Amount | - | |
Description:No description available | ||||
PendingDate | datetime | Pending Date | - | |
Description:No description available | ||||
PendingDiscount | decimal | Pending Discount Amount | - | |
Description:No description available | ||||
PendingDiscountPercentNonexistent in DB | decimal? | Pending Discount Percent | - | |
Description:No description available | ||||
PendingFreeItemQty | decimal | Pending Free Item Qty. | - | |
Description:No description available | ||||
PendingQuantity | decimal | Pending Break Quantity | - | |
Description:No description available | ||||
Quantity | decimal | Break Quantity | - | |
Description:No description available | ||||
QuantityTo | decimal | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||