/*
================================================================================
档案代号:oaq_file
档案名称:销退单/仓退单抛转单别设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oaq_file
(
oaq01       varchar2(5) NOT NULL,    /*销退单别                               */
oaq02       varchar2(5),             /*仓退单别                               */
oaq03       varchar2(5),             /*AR 单别                                */
oaq04       varchar2(5),             /*AP 单别                                */
oaq05       varchar2(3)              /*No Use                                 */
);

create unique index oaq_pk on oaq_file (oaq01);
alter table oaq_file add  constraint oaq_pk primary key  (oaq01) enable validate;
grant select on oaq_file to public;
grant index on oaq_file to public;
grant update on oaq_file to public;
grant delete on oaq_file to public;
grant insert on oaq_file to public;