/*
================================================================================
档案代号:cmb_file
档案名称:LCM 料件价格单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cmb_file
(
cmb01       varchar2(40) NOT NULL,   /*料件编号                               */
cmb02       number(5) NOT NULL,      /*项次                                   */
cmb03       varchar2(2),             /*异动类别                               */
                                     /*销售: 1A,1B,1C                         */
                                     /*进货: 2A,2B,2C                         */
cmb04       date,                    /*异动日期-起值                          */
cmb05       date,                    /*异动日期-迄值                          */
cmb06       number(20,6)             /*异动单价                               */
);

create unique index cmb_pk on cmb_file (cmb01,cmb02);
alter table cmb_file add  constraint cmb_pk primary key  (cmb01,cmb02) enable validate;
grant select on cmb_file to public;
grant index on cmb_file to public;
grant update on cmb_file to public;
grant delete on cmb_file to public;
grant insert on cmb_file to public;