/*
================================================================================
档案代号:oan_file
档案名称:多角贸易抛转单别设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oan_file
(
oan01       varchar2(5) NOT NULL,    /*出货单别                               */
oan02       varchar2(5),             /*收货单别                               */
oan03       varchar2(5),             /*入库单别                               */
oan04       varchar2(5),             /*AR单别                                 */
                                     /*AR单别                     No.8084     */
oan05       varchar2(5)              /*AP单别                                 */
                                     /*AP单别                     No.8084     */
);

create unique index oan_pk on oan_file (oan01);
alter table oan_file add  constraint oan_pk primary key  (oan01) enable validate;
grant select on oan_file to public;
grant index on oan_file to public;
grant update on oan_file to public;
grant delete on oan_file to public;
grant insert on oan_file to public;