/*
================================================================================
档案代号:aps_ime
档案名称:APS 储位维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_ime
(
wh_id       varchar2(32) NOT NULL,   /*库房编号                               */
stk_loc     varchar2(32) NOT NULL,   /*库房储位                               */
is_cnsn     number(4)                /*是否为客供料(0:不是 1:是)              */
);

create unique index aps_ime_pk on aps_ime (wh_id,stk_loc);
alter table aps_ime add  constraint aps_ime_pk primary key  (wh_id,stk_loc) enable validate;
grant select on aps_ime to public;
grant index on aps_ime to public;
grant update on aps_ime to public;
grant delete on aps_ime to public;
grant insert on aps_ime to public;