Home > Technical > Table Definitions > PRICELEVEL

PRICELEVEL

This is used by the POS to determine what price level should be used for the sell price of an item.

Column Type Description
STRGUID VARCHAR(38) A unique code assigned by the system.
STRTRADECODE VARCHAR(10) The location to which this rule applies.
TRADUNIT.strTradeCode 
STRCUSTTYPE VARCHAR(10) The type of customer to which this rule applies.
INTDOW INT The day of the week the shifts apply. 0=Any day. 1=Sunday, 2=Monday,.... 7= Saturday
INTSHIFTCODE INT The code of the shift to which this rule applies. Set as -1 to apply to any shift.
SHIFTCODE.intCode
INTSALESMETHOD INT The code of the sales method to which this rule applies. Set as -1 to apply to any rule.
SALESMETHOD.intCode
INTPRICELEVEL INT A number from 1-5 to indicate which price level is to be used for this rule.
 

Primary Key: STRGUID

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