/*
================================================================================
档案代号:ahf_file
档案名称:科目异动码弹性设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ahf_file
(
ahf00       varchar2(5) NOT NULL,    /*帐别                                   */
ahf01       varchar2(24) NOT NULL,   /*科目编号                               */
ahf02       varchar2(20) NOT NULL,   /*交易作业代号                           */
ahf03       varchar2(2) NOT NULL,    /*异动码顺序                             */
ahf04       varchar2(20)             /*预设值栏位                             */
);

create unique index ahf_pk on ahf_file (ahf00,ahf01,ahf02,ahf03);
alter table ahf_file add  constraint ahf_pk primary key  (ahf00,ahf01,ahf02,ahf03) enable validate;
grant select on ahf_file to public;
grant index on ahf_file to public;
grant update on ahf_file to public;
grant delete on ahf_file to public;
grant insert on ahf_file to public;