/*
================================================================================
档案代号:vaj_file
档案名称:aps实体库存
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vaj_file
(
vaj01       varchar2(40) DEFAULT '' NOT NULL, /*料号*/
vaj02       varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/
vaj03       varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/
vaj04       number(15,3),            /*可用量                                 */
vaj05       varchar2(60)             /*库房位置                               */
);

create unique index vaj_pk on vaj_file (vaj01,vaj02,vaj03);
alter table vaj_file add  constraint vaj_pk primary key  (vaj01,vaj02,vaj03) enable validate;
grant select on vaj_file to public;
grant index on vaj_file to public;
grant update on vaj_file to public;
grant delete on vaj_file to public;
grant insert on vaj_file to public;