| 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 |