/*
================================================================================
档案代号:apsuim
档案名称:APS 实体库存
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apsuim
(
pid         varchar2(40) NOT NULL,   /*料号                                   */
wh_id       varchar2(32) NOT NULL,   /*库房编号                               */
stk_loc     varchar2(32) NOT NULL,   /*库房储位                               */
unalcqty    number(16,4),            /*可用量                                 */
location    varchar2(32)             /*库房位置                               */
);

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