/*
================================================================================
档案代号:rvvi_file
档案名称:入库/退扣单异动档(行业别档)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table rvvi_file
(
rvvi01      varchar2(16) DEFAULT '' NOT NULL, /*入库单号/退货单号*/
rvvi02      number(5) DEFAULT '0' NOT NULL, /*项次*/
rvviicd01   varchar2(10),            /*ICD作业编号                            */
rvviicd02   varchar2(80),            /*Datecode                               */
rvviicd03   varchar2(40),            /*内编母体料号                           */
rvviicd04   varchar2(40),            /*产品型号                               */
rvviicd05   varchar2(24),            /*母批                                   */
rvviicd06   varchar2(20),            /*Tape Reel                              */
rvviicd07   varchar2(1)              /*委外TKY非最终站否(Y:委外TKY非          */
);

create unique index rvvi_pk on rvvi_file (rvvi01,rvvi02);
alter table rvvi_file add  constraint rvvi_pk primary key  (rvvi01,rvvi02) enable validate;
grant select on rvvi_file to public;
grant index on rvvi_file to public;
grant update on rvvi_file to public;
grant delete on rvvi_file to public;
grant insert on rvvi_file to public;