/*
================================================================================
档案代号:vmf_file
档案名称:aps仓库维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vmf_file
(
vmf01       varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/
vmf04       number(1),               /*存货不可移转                           */
vmf05       number(1)                /*主仓储                                 */
);

create unique index vmf_pk on vmf_file (vmf01);
alter table vmf_file add  constraint vmf_pk primary key  (vmf01) enable validate;
grant select on vmf_file to public;
grant index on vmf_file to public;
grant update on vmf_file to public;
grant delete on vmf_file to public;
grant insert on vmf_file to public;