/*
================================================================================
档案代号:aee_file
档案名称:科目异动码名称档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aee_file
(
aee00       varchar2(5) NOT NULL,    /*帐别                                   */
aee01       varchar2(24) NOT NULL,   /*科目编号                               */
aee02       varchar2(2) NOT NULL,    /*异动码顺序                             */
aee03       varchar2(30) NOT NULL,   /*异动码值                               */
aee04       varchar2(80),            /*说明                                   */
aee05       varchar2(16),            /*原始传票编号                           */
aee06       date,                    /*原始传票日期                           */
aeeacti     varchar2(1),             /*资料有效码                             */
aeeuser     varchar2(10),            /*资料所有者                             */
aeegrup     varchar2(10),            /*资料所有群                             */
aeemodu     varchar2(10),            /*资料更改者                             */
aeedate     date,                    /*最近修改日                             */
aee021      varchar2(10)             /*异动码类型代号                         */
                                     /*#FUN-5C0015                            */
);

create unique index aee_pk on aee_file (aee00,aee01,aee02,aee03);
alter table aee_file add  constraint aee_pk primary key  (aee00,aee01,aee02,aee03) enable validate;
grant select on aee_file to public;
grant index on aee_file to public;
grant update on aee_file to public;
grant delete on aee_file to public;
grant insert on aee_file to public;