/*
================================================================================
档案代号:cda_file
档案名称:成本中心成本项目分摊方式资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cda_file
(
cda01       varchar2(10) DEFAULT '' NOT NULL, /*成本中心*/
cda02       varchar2(10) DEFAULT '' NOT NULL, /*成本项目*/
cda04       varchar2(1),             /*no use                                 */
cda05       varchar2(24) DEFAULT '' NOT NULL, /*会计科目*/
cda06       varchar2(1),             /*分摊方式                               */
cda07       number(9,4)              /*分摊权数                               */
);

create unique index cda_pk on cda_file (cda01,cda02,cda05);
alter table cda_file add  constraint cda_pk primary key  (cda01,cda02,cda05) enable validate;
grant select on cda_file to public;
grant index on cda_file to public;
grant update on cda_file to public;
grant delete on cda_file to public;
grant insert on cda_file to public;