Home > Technical > Table Definitions > DISCLOCATIONUSAGE

DISCLOCATIONUSAGE

Column

Type

Description

LINTDISCOUNTCODE

INT(4)

The code which identifies the DISCHDR this record belongs to.

DISCHDR.ctrCode

STRSTORECODE

VARCHAR(10)

The location where the item is held.

TRADUNIT.strTradeCode

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)