Table: CougTmp
==============
1)
DROP TABLE TMP_STOCK_PRICE
 
2)
CREATE TABLE TMP_STOCK_PRICE (
  M_PLUCODE D_PLUCODE NOT NULL,
  M_LINKCODE D_LINKCODE NOT NULL,
  M_LEVEL D_CODE NOT NULL,
  M_PRICE D_MONEY DEFAULT 0,
  M_DATEFROM D_DATE,
  M_DATETO D_DATE,
  M_TIMEFROM D_DATE,
  M_TIMETO D_DATE,
  M_DISCPRICE D_MONEY DEFAULT 0,
  M_DATEACTIVE D_FLAG DEFAULT '',
  M_TIMEACTIVE D_FLAG DEFAULT '',
  M_QTY D_QTY DEFAULT 0 NOT NULL,
  M_OFQTY D_QTY DEFAULT 0 NOT NULL,
  M_PROFIT D_MONEY DEFAULT 0,
  M_MARKUP D_RATE DEFAULT 0,
  M_MARKDOWN D_RATE DEFAULT 0,
  M_DISCPERC D_RATE DEFAULT 0,
  M_DISCAMT D_MONEY DEFAULT 0,
  M_PLULINKID D_PLUID NOT NULL,
  M_MIX_MATCH D_STATUS DEFAULT 'N',
  M_USER D_NCODE,
  M_UPDATE_PRICE D_DATE,
  M_PRICE_OLD D_MONEY DEFAULT 0,
  M_PRICE_FROM D_SHORTDESC,
  M_USER_DISCPRICE D_NCODE,
  M_UPDATE_DISCPRICE D_DATE,
  M_DISCPRICE_OLD D_MONEY DEFAULT 0,
  M_DISCPRICE_FROM D_SHORTDESC,
  M_STATUS D_SHORTDESC,
  M_DATEACTIVE2 D_FLAG DEFAULT 'F',
  M_DATEFROM2 D_DATE,
  M_DATETO2 D_DATE,
  M_TIMEACTIVE2 D_FLAG DEFAULT 'F',
  M_TIMEFROM2 D_DATE,
  M_TIMETO2 D_DATE,
  M_DISCAMT2 D_MONEY DEFAULT 0,
  M_DISCPRICE2 D_MONEY DEFAULT 0,
  M_DISCPERC2 D_RATE DEFAULT 0,
  M_PROMTYPE D_STATUS2 DEFAULT '',
  M_PROMCODE D_NCODE DEFAULT '',
  M_PROMDESC D_SHORTDESC DEFAULT '',
  M_SALES_TAX CHAR(15) DEFAULT '',
  M_TAX_AMT D_MONEY DEFAULT 0,
  M_TAX_RATE D_MONEY DEFAULT 0,
  M_TAX_INCLUSIVE D_FLAG DEFAULT 'F',
  M_SUBTOTAL D_MONEY DEFAULT 0
)