Physical nameDatatypeCross-RefDescription
CATEGORY_IDSMALLINTCATEGORY, PRODUCT 
CATEGORY_NAMEVARCHAR (30)CATEGORY 
FLAGSMALLINTSALEInternal flag.
MONTH_IDDECIMAL (6,0)MONTH, SALEMonth identification in the YYYYMM form.
MONTH_NAMEVARCHAR (20)MONTHUnique month name in the following form:
Monthname YYYY
PCSINTEGERSALE 
PRICEDECIMAL (9,2)SALEAverage price in the given period.
PRODUCT_IDINTEGERPRODUCT, SALE 
PRODUCT_NAMEVARCHAR (30)PRODUCT 
REGION_IDSMALLINTREGION, SALE, STORE 
REGION_NAMEVARCHAR (30)REGION 
REVENUEDECIMAL (9,2)SALE 
STORE_IDINTEGERSALE, STORE 
STORE_NAMEVARCHAR (30)STORE 
STREETVARCHAR (30)STORE 
YEAR_IDSMALLINTMONTH, SALE, YEARYear in the YYYY form.
YEAR_NAMEVARCHAR (10)YEARYear name in the following form: Year YYYY