/*
================================================================================
档案代号:cmc_file
档案名称:LCM 料件数量入库异动档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cmc_file
(
cmc01       varchar2(40) NOT NULL,   /*料件编号                               */
cmc02       date,                    /*计算基准日                             */
cmc03       date NOT NULL,           /*异动日期                               */
cmc04       number(15,5)             /*数量                                   */
                                     /*数量   (不含除外仓之入库量)            */
);

create unique index cmc_pk on cmc_file (cmc01,cmc03);
alter table cmc_file add  constraint cmc_pk primary key  (cmc01,cmc03) enable validate;
grant select on cmc_file to public;
grant index on cmc_file to public;
grant update on cmc_file to public;
grant delete on cmc_file to public;
grant insert on cmc_file to public;