/*
================================================================================
档案代号:cme_file
档案名称:料件分类毛利费用率维护
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cme_file
(
cme01       number(5) NOT NULL,      /*年度                                   */
cme02       number(5) NOT NULL,      /*月份                                   */
cme03       varchar2(10) NOT NULL,   /*成本分群                               */
cme04       number(15,3),            /*销售费用率                             */
cme05       number(15,3),            /*销售毛利率                             */
cme031      varchar2(10) DEFAULT '' NOT NULL, /*产品分类*/
cme06       varchar2(1) DEFAULT '1' NOT NULL /*料件分类来源*/
);

create unique index cme_pk on cme_file (cme01,cme02,cme03,cme031,cme06);
alter table cme_file add  constraint cme_pk primary key  (cme01,cme02,cme03,cme031,cme06) enable validate;
grant select on cme_file to public;
grant index on cme_file to public;
grant update on cme_file to public;
grant delete on cme_file to public;
grant insert on cme_file to public;