Home > Technical > Table Definitions > PRICELEVELSCHED

PRICELEVELSCHED

This table contains the schedule for automatically changing price levels.

Column Type Description

CTRCODE

INT(4)

A unique number assigned by the system.

INTDAYOFWEEK

INT(4)

The day of the week that the schedule is for.0=Sunday.

DTMSTARTTIME

DATETIME(8)

The time that this new price level is due to start.

STRSTORECODE

VARCHAR(10)

The location that will receive the price level change.

TRADUNIT.strTradeCode

INTLEVEL

INT(4)

The new price level to take effect. This is a number from 1-5.

YSNACTIVE

CHAR(1)

T if this is the current active schedule record.

 

Primary Key: CTRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)