| Physical name | Datatype | Cross-Ref | Description |
| CATEGORY_ID | SMALLINT | CATEGORY, PRODUCT | |
| CATEGORY_NAME | VARCHAR (30) | CATEGORY | |
| FLAG | SMALLINT | SALE | Internal flag. |
| MONTH_ID | DECIMAL (6,0) | MONTH, SALE | Month identification in the YYYYMM form. |
| MONTH_NAME | VARCHAR (20) | MONTH | Unique month name in the following form: Monthname YYYY |
| PCS | INTEGER | SALE | |
| PRICE | DECIMAL (9,2) | SALE | Average price in the given period. |
| PRODUCT_ID | INTEGER | PRODUCT, SALE | |
| PRODUCT_NAME | VARCHAR (30) | PRODUCT | |
| REGION_ID | SMALLINT | REGION, SALE, STORE | |
| REGION_NAME | VARCHAR (30) | REGION | |
| REVENUE | DECIMAL (9,2) | SALE | |
| STORE_ID | INTEGER | SALE, STORE | |
| STORE_NAME | VARCHAR (30) | STORE | |
| STREET | VARCHAR (30) | STORE | |
| YEAR_ID | SMALLINT | MONTH, SALE, YEAR | Year in the YYYY form. |
| YEAR_NAME | VARCHAR (10) | YEAR | Year name in the following form: Year YYYY |