Table price_sheets

Table price_sheets holds the default inventory pricing formulas used for setting prices. Zero or more price sheets may be entered as needed for customers or quantities. Revisoin levels are included to allow for setting effective dates for pricing revisions.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
sheet_name varchar(32) NOT NULL Short name of the price sheet
inactive 0, 1 0 Status of the price sheet
revision float 0 Revision level
effective_date date 0000-00-00 Effective date of the price sheet
expiration_date date NULL Expiration date, when the price sheet is inactive (usually so a new one can take its place)
default_sheet 0, 1 0, 1 Specifies the default sheet used for pricing
default_levels varchar(255) NOT NULL Encoded price sheet formula for determining price levels