/*
================================================================================
档案代号:ahc_file
档案名称:常用传票额外摘要档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ahc_file
(
ahc00       varchar2(5) NOT NULL,    /*帐别                                   */
ahc000      varchar2(1) NOT NULL,    /*常用传票性质                           */
ahc01       varchar2(16) NOT NULL,   /*常用传票编号                           */
ahc02       number(5) NOT NULL,      /*项次                                   */
ahc03       number(5) NOT NULL,      /*行序                                   */
ahc04       varchar2(80)             /*摘要                                   */
);

create unique index ahc_pk on ahc_file (ahc01,ahc02,ahc03,ahc00,ahc000);
alter table ahc_file add  constraint ahc_pk primary key  (ahc01,ahc02,ahc03,ahc00,ahc000) enable validate;
grant select on ahc_file to public;
grant index on ahc_file to public;
grant update on ahc_file to public;
grant delete on ahc_file to public;
grant insert on ahc_file to public;