/*
================================================================================
档案代号:aas_file
档案名称:会计科目每日余额档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aas_file
(
aas00       varchar2(5) NOT NULL,    /*帐别编号                               */
aas01       varchar2(24) NOT NULL,   /*科目编号                               */
aas02       date NOT NULL,           /*日期                                   */
aas04       number(20,6),            /*借方金额                               */
aas05       number(20,6),            /*贷方金额                               */
aas06       number(10),              /*借方笔数                               */
aas07       number(10)               /*贷方笔数                               */
);

create unique index aas_pk on aas_file (aas01,aas02,aas00);
alter table aas_file add  constraint aas_pk primary key  (aas01,aas02,aas00) enable validate;
grant select on aas_file to public;
grant index on aas_file to public;
grant update on aas_file to public;
grant delete on aas_file to public;
grant insert on aas_file to public;