/*
================================================================================
档案代号:aed_file
档案名称:科目异动码冲帐余额档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aed_file
(
aed00       varchar2(5) NOT NULL,    /*帐别                                   */
aed01       varchar2(24) NOT NULL,   /*科目编号                               */
                                     /*科目编号 (明细或独立科目)              */
aed011      varchar2(2) NOT NULL,    /*异动码顺序                             */
aed02       varchar2(30) NOT NULL,   /*异动码值                               */
aed03       number(5) NOT NULL,      /*会计年度                               */
aed04       number(5) NOT NULL,      /*期别                                   */
aed05       number(20,6),            /*借方总金额                             */
aed06       number(20,6),            /*贷方总金额                             */
aed07       number(5),               /*借方总笔数                             */
aed08       number(5),               /*贷方总笔数                             */
aed012      varchar2(10)             /*异动码类型代号                         */
                                     /*#FUN-5C0015                            */
);

create unique index aed_pk on aed_file (aed01,aed02,aed03,aed04,aed00,aed011);
alter table aed_file add  constraint aed_pk primary key  (aed01,aed02,aed03,aed04,aed00,aed011) enable 
validate;
grant select on aed_file to public;
grant index on aed_file to public;
grant update on aed_file to public;
grant delete on aed_file to public;
grant insert on aed_file to public;