/*
================================================================================
档案代号:icz_file
档案名称:库存Hold批Log档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table icz_file
(
icz01       varchar2(40) DEFAULT '' NOT NULL, /*料件编号*/
icz02       varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/
icz03       varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/
icz04       varchar2(24) DEFAULT '' NOT NULL, /*批号*/
icz05       varchar2(1),             /*状态                                   */
                                     /*1.Hold 2.Relase                        */
icz06       varchar2(255),           /*说明                                   */
icz07       date,                    /*异动日期                               */
icz08       varchar2(1),             /*no use                                 */
icz09       varchar2(40),            /*母体料号                               */
icz10       varchar2(24),            /*母批                                   */
iczdate     date,                    /*最近修改日                             */
iczgrup     varchar2(10),            /*资料所有部门                           */
iczmodu     varchar2(10),            /*资料修改者                             */
iczuser     varchar2(10)             /*资料所有者                             */
);

create unique index icz_pk on icz_file (icz01,icz02,icz03,icz04);
alter table icz_file add  constraint icz_pk primary key  (icz01,icz02,icz03,icz04) enable validate;
grant select on icz_file to public;
grant index on icz_file to public;
grant update on icz_file to public;
grant delete on icz_file to public;
grant insert on icz_file to public;