/*
================================================================================
档案代号:rvbs_file
档案名称:入库序号明细
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table rvbs_file
(
rvbs00      varchar2(10) NOT NULL,   /*类别                                   */
rvbs01      varchar2(16) NOT NULL,   /*入库单号                               */
rvbs02      number(5) NOT NULL,      /*项次                                   */
rvbs03      varchar2(30) NOT NULL,   /*序号                                   */
rvbs04      varchar2(30) NOT NULL,   /*外部批号                               */
rvbs05      date,                    /*厂商制造日期                           */
rvbs06      number(15,3),            /*数量                                   */
rvbs07      varchar2(1),             /*归属类别                               */
rvbs08      varchar2(16) NOT NULL,   /*归属单号                               */
rvbs021     varchar2(40),            /*料件编号                               */
rvbs022     number(5) DEFAULT '0' NOT NULL, /*项次*/
rvbs09      number(5) NOT NULL       /*属性                                   */
);

create unique index rvbs_pk on rvbs_file (rvbs00,rvbs01,rvbs02,rvbs022,rvbs09);
alter table rvbs_file add  constraint rvbs_pk primary key  (rvbs00,rvbs01,rvbs02,rvbs022,rvbs09) enable 
validate;
grant select on rvbs_file to public;
grant index on rvbs_file to public;
grant update on rvbs_file to public;
grant delete on rvbs_file to public;
grant insert on rvbs_file to public;