/*
================================================================================
档案代号:ogbi_file
档案名称:出货单单身档(行业别档)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ogbi_file
(
ogbi01      varchar2(16) DEFAULT '' NOT NULL, /*出货单号*/
ogbi03      number(5) DEFAULT '0' NOT NULL, /*项次*/
ogbiicd01   varchar2(1),             /*转仓                                   */
ogbiicd02   number(9,4),             /*备品比率                               */
ogbiicd03   varchar2(1),             /*型态                                   */
                                     /*0:一般 ; 1:样品 ; 2:Spare Part         */
ogbiicd04   varchar2(20)             /*Tape Reel                              */
);

create unique index ogbi_pk on ogbi_file (ogbi01,ogbi03);
alter table ogbi_file add  constraint ogbi_pk primary key  (ogbi01,ogbi03) enable validate;
grant select on ogbi_file to public;
grant index on ogbi_file to public;
grant update on ogbi_file to public;
grant delete on ogbi_file to public;
grant insert on ogbi_file to public;