Home > Technical > Table Definitions > DISCLOCATIONUSAGE
Column |
Type |
Description |
LINTDISCOUNTCODE |
INT(4) |
The code which identifies the DISCHDR this record belongs to. |
STRSTORECODE |
VARCHAR(10) |
The location where the item is held. |
YSNACTIVEEARLY |
VARCHAR(1) |
The discount can be used this early, if a location chooses. This is an optional date. If a location does not indicate the discount should be used during this period, the discount won't start until the main start date. |
YSNACTIVECORE |
VARCHAR(1) |
If this option is checked on, it means that by default the discount will be used during the main date range. The store will be able to control the discount usage during the date range but by default it will be on. If the Must Use During Core Date is checked on, it will override this option. |
YSNACTIVELATE |
VARCHAR(1) |
The discount can be used up until this date, if the location chooses. This is an optional date. If a location does not indicate the discount should be used during this period, the discount will end on the main end date. |
Primary Key: LINTDISCOUNTCODE + STRSTORECODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |