/*
================================================================================
档案代号:vna_file
档案名称:aps 存货预配记录维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vna_file
(
vna01       varchar2(40) DEFAULT '' NOT NULL, /*料号*/
vna02       varchar2(60) DEFAULT '' NOT NULL, /*配给对象*/
vna03       varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/
vna04       varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/
vna05       number(15,3),            /*分配量                                 */
vna06       number(15,3),            /*需求数量                               */
vna09       number(1)                /*锁定                                   */
);

create unique index vna_pk on vna_file (vna01,vna02,vna03,vna04);
alter table vna_file add  constraint vna_pk primary key  (vna01,vna02,vna03,vna04) enable validate;
grant select on vna_file to public;
grant index on vna_file to public;
grant update on vna_file to public;
grant delete on vna_file to public;
grant insert on vna_file to public;