/* ================================================================================ 档案代号: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; |