/*
================================================================================
档案代号:abc_file
档案名称:会计传票额外摘要档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table abc_file
(
abc00       varchar2(5) NOT NULL,    /*帐别                                   */
abc01       varchar2(16) NOT NULL,   /*传票编号                               */
abc02       number(5) NOT NULL,      /*项次                                   */
abc03       number(5) NOT NULL,      /*行序                                   */
abc04       varchar2(80)             /*摘要                                   */
);

create unique index abc_pk on abc_file (abc01,abc02,abc03,abc00);
alter table abc_file add  constraint abc_pk primary key  (abc01,abc02,abc03,abc00) enable validate;
grant select on abc_file to public;
grant index on abc_file to public;
grant update on abc_file to public;
grant delete on abc_file to public;
grant insert on abc_file to public;