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

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