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 |