Support table for auto apply discounts - Keeps track of scenarios that have been completed so they are not duplicated.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
DISCOUNTSCENARIOID
|
uniqueidentifier
|
false
|
|
Foreign key to a discount scenario in the SALESORDERITEMDISCOUNTOPTION table.
|
|
SALESORDERITEMID
|
uniqueidentifier
|
false
|
|
Foreign key to a SALESORDERITEM table.
|
|
QUANTITY
|
int
|
false
|
|
Number of order items in scenario.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
