Generated by XERFUN TEST

MONTH
PKYEAR_IDSMALLINT
class cMONTH {
cNumber   m_YEAR_ID;
cNumber   m_MONTH_ID;
cString   m_MONTH_NAME;
};
PKMONTH_IDDECIMAL (6,0)
 MONTH_NAMEVARCHAR (20)
REGION
PKREGION_IDSMALLINT
class cREGION {
cNumber   m_REGION_ID;
cString   m_REGION_NAME;
};
 REGION_NAMEVARCHAR (30)
SALE
PKPRODUCT_IDINTEGER
class cSALE {
cNumber   m_PRODUCT_ID;
cUnknown  m_STORE_ID;
cNumber   m_YEAR_ID;
cNumber   m_MONTH_ID;
cNumber   m_PCS;
cUnknown  m_PRICE;
cUnknown  m_REVENUE;
cNumber   m_FLAG;
cNumber   m_REGION_ID;
};
PKSTORE_IDTCustNo
PKYEAR_IDSMALLINT
PKMONTH_IDDECIMAL (6,0)
 PCSINTEGER
 PRICETPrice
 REVENUETPrice
 FLAGSMALLINT
 REGION_IDSMALLINT
STORE
PKSTORE_IDTCustNo
class cSTORE {
cUnknown  m_STORE_ID;
cNumber   m_REGION_ID;
cString   m_STORE_NAME;
cString   m_ADDRESS;
};
NNREGION_IDSMALLINT
 STORE_NAMEVARCHAR (30)
 ADDRESSVARCHAR (30)
YEAR
PKYEAR_IDSMALLINT
class cYEAR {
cNumber   m_YEAR_ID;
cString   m_YEAR_NAME;
};
 YEAR_NAMEVARCHAR (10)
CATEGORY
PKCATEGORY_IDSMALLINT
class cCATEGORY {
cNumber   m_CATEGORY_ID;
cString   m_CATEGORY_NAME;
};
 CATEGORY_NAMEVARCHAR (30)
PRODUCT
PKPRODUCT_IDINTEGER
class cPRODUCT {
cNumber   m_PRODUCT_ID;
cNumber   m_CATEGORY_ID;
cString   m_PRODUCT_NAME;
};
NNCATEGORY_IDSMALLINT
 PRODUCT_NAMEVARCHAR (30)