/*
================================================================================
档案代号:fae_file
档案名称:多部门折旧费用分摊单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fae_file
(
fae01       number(5) NOT NULL,      /*资料年度                               */
fae02       number(5) NOT NULL,      /*资料月份                               */
fae03       varchar2(24) NOT NULL,   /*折旧会计科目                           */
fae04       varchar2(10) NOT NULL,   /*分摊类别                               */
fae05       number(5) NOT NULL,      /*项次                                   */
fae06       varchar2(10),            /*分摊部门                               */
fae07       varchar2(24),            /*折旧科目                               */
fae08       number(9,4),             /*分摊比率                               */
fae09       varchar2(24),            /*变动比率分子科目                       */
fae071      varchar2(24)             /*折旧科目二                             */
);

create unique index fae_pk on fae_file (fae01,fae02,fae03,fae04,fae05);
alter table fae_file add  constraint fae_pk primary key  (fae01,fae02,fae03,fae04,fae05) enable validate;
grant select on fae_file to public;
grant index on fae_file to public;
grant update on fae_file to public;
grant delete on fae_file to public;
grant insert on fae_file to public;