/*
================================================================================
档案代号:ahd_file
档案名称:常用及分摊传票比率科目资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ahd_file
(
ahd00       varchar2(5) NOT NULL,    /*帐别                                   */
ahd000      varchar2(1) NOT NULL,    /*性质(1)固定金额常用传票                */
                                     /*        (2)固定比率分摊传票            */
                                     /*        (3)变动比率分摊传票            */
ahd01       varchar2(8) NOT NULL,    /*原始编号                               */
ahd02       number(5) NOT NULL,      /*项次                                   */
ahd03       varchar2(24),            /*分摊金额来源科目                       */
ahd04       varchar2(10)             /*分摊金额来源部门                       */
);

create unique index ahd_pk on ahd_file (ahd01,ahd02,ahd00,ahd000);
alter table ahd_file add  constraint ahd_pk primary key  (ahd01,ahd02,ahd00,ahd000) enable validate;
grant select on ahd_file to public;
grant index on ahd_file to public;
grant update on ahd_file to public;
grant delete on ahd_file to public;
grant insert on ahd_file to public;