/*
================================================================================
档案代号:oov_file
档案名称:应收帐款待扺冲帐记录档
档案目的: 储存应收帐款待扺冲帐(预付或借支)记录档
上游档案:
下游档案:
============.========================.==========================================
*/
create table oov_file
(
oov01       varchar2(16) NOT NULL,   /*帐款单号                               */
oov02       number(5) NOT NULL,      /*项次                                   */
oov03       varchar2(16),            /*应收帐款编号                           */
oov04f      number(20,6),            /*原币冲帐金额                           */
oov04       number(20,6),            /*本币冲帐金额                           */
oov05       number(5)                /*子帐期项次                             */
);

create        index oov_02 on oov_file (oov03);
create unique index oov_pk on oov_file (oov01,oov02);
alter table oov_file add  constraint oov_pk primary key  (oov01,oov02) enable validate;
grant select on oov_file to public;
grant index on oov_file to public;
grant update on oov_file to public;
grant delete on oov_file to public;
grant insert on oov_file to public;