/*
================================================================================
档案代号:caj_file
档案名称:固定/变动成本分析资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table caj_file
(
caj01       number(5) NOT NULL,      /*年度                                   */
caj02       number(5) NOT NULL,      /*月份                                   */
caj04       varchar2(40) NOT NULL,   /*主件料号                               */
                                     /*需存在在料件基本资料主档               */
caj05       number(20,6),            /*本月投入金额                           */
caj06       number(20,6),            /*固定成本                               */
caj07       number(20,6)             /*变动成本                               */
);

create unique index caj_pk on caj_file (caj01,caj02,caj04);
alter table caj_file add  constraint caj_pk primary key  (caj01,caj02,caj04) enable validate;
grant select on caj_file to public;
grant index on caj_file to public;
grant update on caj_file to public;
grant delete on caj_file to public;
grant insert on caj_file to public;