CREATE TABLE POS_ACTIVITIES (
    OR_DATE D_DATE NOT NULL,
    OR_STORE D_CODE NOT NULL,
    OR_CTRNO D_CODE NOT NULL,
    OR_CODE D_CODE NOT NULL,
    OR_STATUS D_STATUS NOT NULL,
    OR_OPERID D_CODE NOT NULL,
    OR_SHIFT D_CODE NOT NULL,
    OR_TRANSNO D_TRANSNO NOT NULL,
    OR_RCPTNO D_RCPTNO NOT NULL,
    OR_SEQNO D_SMALLCODE NOT NULL,
    OR_DATETIME D_DATE NOT NULL,
    OR_DESCRIPTION D_DESC,
    OR_CUSTOMERID D_CUSTOMERID,
    OR_FRMPRICELVL D_NCODE,
    OR_TOPRICELVL D_NCODE,
    OR_SUMDISCBYPCN D_DOUBLE  DEFAULT 0,
    OR_SUMDISCBYMNY D_DOUBLE  DEFAULT 0,
    OR_GROSS D_DOUBLE  DEFAULT 0,
    OR_NETSALES D_DOUBLE  DEFAULT 0,
    OR_SALESPREMIUM D_DOUBLE  DEFAULT 0,
    OR_SALESPREMIUMPCN D_DOUBLE  DEFAULT 0,
    OR_SALESSUBTOTALDISCPCN D_DOUBLE  DEFAULT 0,
    OR_SALESSUBTOTALDISCMNY D_DOUBLE  DEFAULT 0,
    OR_SALESDISCOUNTABLEAMT D_DOUBLE  DEFAULT 0,
    OR_PLUNO D_PLUNO,
    OR_BARCODE D_BARCODE,
    OR_ALU D_ALU,
    OR_SHORTDESC D_DESC,
    OR_ITEMQTY D_DOUBLE,
    OR_ITEMSELLPRICE D_CURRENCY  DEFAULT 0,
    OR_ITEMTYPE D_STATUS2,
    OR_ITEMUOM D_NCODE,
    OR_ITEMUNITCOST D_DOUBLE  DEFAULT 0,
    OR_ITEMDISCOUNTABLE D_FLAG  DEFAULT 'T',
    OR_ITEMDISCBYPCN D_DOUBLE  DEFAULT 0,
    OR_ITEMDISCBYMNY D_CURRENCY  DEFAULT 0,
    OR_ITEMDISCSUBTOTAL D_DOUBLE  DEFAULT 0,
    OR_ITEMDISCAMT D_DOUBLE  DEFAULT 0,
    OR_ITEMNETPRICE D_DOUBLE  DEFAULT 0,
    OR_ITEMCHANGEPRICE D_FLAG  DEFAULT 'F',
    OR_ITEMCHANGEPRC D_CURRENCY  DEFAULT 0,
    OR_ITEMCOLORSIZE CHAR(25),
    OR_ITEMPROMOTERID D_NCODE,
    OR_ITEMCOMMISSION D_CURRENCY  DEFAULT 0,
    OR_ITEMCOMMTYPE D_STATUS2,
    OR_ITEMMIXMATCH D_FLAG  DEFAULT 'F',
    OR_ITEMPLULINKID D_PLUID,
    OR_TOTAL D_DOUBLE  DEFAULT 0,
    OR_AUTHORISEID D_NCODE,
    OR_REMARK1 D_DESC,
    OR_REMARK2 D_DESC ,
    PRIMARY KEY (OR_DATE, OR_STORE, OR_CTRNO, OR_CODE, OR_STATUS, OR_OPERID, OR_SHIFT, OR_TRANSNO, OR_RCPTNO, OR_SEQNO, OR_DATETIME)
)