/*
================================================================================
档案代号:rvx_file
档案名称:入库采购金额变更异动档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table rvx_file
(
rvx01       varchar2(16) NOT NULL,   /*入库单号                               */
rvx02       number(5) NOT NULL,      /*项次                                   */
rvx03       date NOT NULL,           /*变更日期                               */
rvx04       number(20,6) NOT NULL,   /*变更前单价(未税)                       */
rvx04t      number(20,6),            /*变更前单价(含税)                       */
rvx05       number(20,6),            /*变更后单价(未税)                       */
rvx05t      number(20,6),            /*变更后单价(含税)                       */
rvx06       number(20,6),            /*变更后金额(未税)                       */
rvx06t      number(20,6),            /*变更后金额(含税)                       */
rvxuser     varchar2(10),            /*资料所有者                             */
rvx031      varchar2(8) DEFAULT '' NOT NULL /*作业时间*/
);

create unique index rvx_pk on rvx_file (rvx01,rvx02,rvx03,rvx031,rvx04);
alter table rvx_file add  constraint rvx_pk primary key  (rvx01,rvx02,rvx03,rvx031,rvx04) enable validate;
grant select on rvx_file to public;
grant index on rvx_file to public;
grant update on rvx_file to public;
grant delete on rvx_file to public;
grant insert on rvx_file to public;