/*
================================================================================
档案代号:vah_file
档案名称:aps供给法则
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vah_file
(
vah01       varchar2(60) DEFAULT '' NOT NULL, /*供给法则编号*/
vah02       number(9) DEFAULT '0' NOT NULL, /*供给型态*/
vah03       varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/
vah04       varchar2(10) DEFAULT '' NOT NULL, /*储位*/
vah05       number(5)                /*优先顺序                               */
);

create unique index vah_pk on vah_file (vah01,vah02,vah03,vah04);
alter table vah_file add  constraint vah_pk primary key  (vah01,vah02,vah03,vah04) enable validate;
grant select on vah_file to public;
grant index on vah_file to public;
grant update on vah_file to public;
grant delete on vah_file to public;
grant insert on vah_file to public;