/*
================================================================================
档案代号:aec_file
档案名称:异动别分类帐档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aec_file
(
aec00       varchar2(5),             /*帐别                                   */
aec01       varchar2(24),            /*科目编号                               */
aec02       date,                    /*传票日期                               */
aec03       varchar2(16),            /*传票编号                               */
aec04       number(5),               /*项次                                   */
aec05       varchar2(30),            /*异动码                                 */
aec051      varchar2(2),             /*异动码顺序                             */
aec052      varchar2(10)             /*异动码类型代号                         */
                                     /*#FUN-5C0015                            */
);

create        index aec_01 on aec_file (aec01,aec05,aec02);
create        index aec_02 on aec_file (aec05,aec01,aec02);
create        index aec_03 on aec_file (aec03,aec04);
grant select on aec_file to public;
grant index on aec_file to public;
grant update on aec_file to public;
grant delete on aec_file to public;
grant insert on aec_file to public;