/*
================================================================================
档案代号:caa_file
档案名称:成本分摊方式资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table caa_file
(
caa01       varchar2(10) NOT NULL,   /*成本中心                               */
caa02       varchar2(10) NOT NULL,   /*成本项目                               */
caa04       varchar2(1) NOT NULL,    /*成本分类                               */
                                     /*1.人工成本                             */
                                     /*2.制造费用                             */
caa05       varchar2(24) NOT NULL,   /*会计科目                               */
caa06       varchar2(1)              /*分摊方式                               */
                                     /*1.实际工时                             */
                                     /*2.标准工时                             */
                                     /*3.产出数量x分摊权数                    */
);

create unique index caa_pk on caa_file (caa01,caa02,caa04,caa05);
alter table caa_file add  constraint caa_pk primary key  (caa01,caa02,caa04,caa05) enable validate;
grant select on caa_file to public;
grant index on caa_file to public;
grant update on caa_file to public;
grant delete on caa_file to public;
grant insert on caa_file to public;