Stores availability for discount.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
ALLOWMONDAY
|
bit
|
false
|
|
Indicates if the discount is available on Mondays.
|
|
ALLOWTUESDAY
|
bit
|
false
|
|
Indicates if the discount is available on Tuesdays.
|
|
ALLOWWEDNESDAY
|
bit
|
false
|
|
Indicates if the discount is available on Wednesdays.
|
|
ALLOWFRIDAY
|
bit
|
false
|
|
Indicates if the discount is available on Fridays.
|
|
ALLOWSATURDAY
|
bit
|
false
|
|
Indicates if the discount is available on Saturdays.
|
|
ALLOWSUNDAY
|
bit
|
false
|
|
Indicates if the discount is available on Sundays.
|
|
ALLOWDISCOUNTDATEFROM
|
date
|
true
|
|
Indicates the beginning date the discount is valid.
|
|
ALLOWDISCOUNTDATETO
|
date
|
true
|
|
Indicates the end date the discount is valid.
|
|
ALLOWDISCOUNTTIMEFROM
|
UDT_HOURMINUTE
|
false
|
|
Indicates the beginning time of day the discount is valid.
|
|
ALLOWDISCOUNTTIMETO
|
UDT_HOURMINUTE
|
false
|
|
Indicates the end time of day the discount is valid.
|
|
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.
|
|
ALLOWTHURSDAY
|
bit
|
false
|
|
Indicates if the discount is available on Thursdays.
|
|
SEQUENCE
|
int
|
false
|
|
The sequence for availability records.
|
