/*
================================================================================
档案代号:apv_file
档案名称:请款时直接冲帐记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apv_file
(
apv01       varchar2(16) NOT NULL,   /*帐款单号                               */
apv02       number(5) NOT NULL,      /*项次                                   */
apv03       varchar2(16),            /*待抵帐款编号                           */
apv04f      number(20,6) NOT NULL,   /*原币冲款金额                           */
apv04       number(20,6) NOT NULL,   /*本币冲款金额                           */
apv05       number(5)                /*子帐期项次                             */
);

create        index apv_02 on apv_file (apv03);
create unique index apv_pk on apv_file (apv01,apv02);
alter table apv_file add  constraint apv_pk primary key  (apv01,apv02) enable validate;
grant select on apv_file to public;
grant index on apv_file to public;
grant update on apv_file to public;
grant delete on apv_file to public;
grant insert on apv_file to public;