/*
================================================================================
档案代号:aps_srm
档案名称:APS 供给法则维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_srm
(
rid         varchar2(32) NOT NULL,   /*供给法则编号                           */
sply_typ    number(4) NOT NULL,      /*供给型态                               */
wh_id       varchar2(32) NOT NULL,   /*库房编号                               */
stk_loc     varchar2(32) NOT NULL,   /*库房储位                               */
priority    number(10)               /*优先顺序                               */
);

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