/*
================================================================================
档案代号:aeg_file
档案名称:专案别分类帐档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aeg_file
(
aeg00       varchar2(5),             /*帐别                                   */
aeg01       varchar2(24),            /*科目编号                               */
aeg02       date,                    /*传票日期                               */
aeg03       varchar2(16),            /*传票编号                               */
aeg04       number(5),               /*项次                                   */
aeg05       varchar2(10)             /*专案编号                               */
);

create        index aeg_01 on aeg_file (aeg01,aeg05,aeg02);
create        index aeg_02 on aeg_file (aeg05,aeg01,aeg02);
create        index aeg_03 on aeg_file (aeg03,aeg04);
grant select on aeg_file to public;
grant index on aeg_file to public;
grant update on aeg_file to public;
grant delete on aeg_file to public;
grant insert on aeg_file to public;