/*
================================================================================
档案代号:vax_file
档案名称:aps(制令领料状况)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vax_file
(
vax01       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
vax02       varchar2(40) DEFAULT '' NOT NULL, /*元件编号*/
vax03       varchar2(60) DEFAULT '' NOT NULL, /*元件序号*/
vax04       varchar2(60),            /*加工序号                               */
vax05       number(15,3),            /*元件已领用量                           */
vax06       varchar2(10),            /*库房编号                               */
vax07       number(15,3),            /*元件需求量                             */
vax08       varchar2(10),            /*库房储位                               */
vax09       number(1),               /*是否为客供料(0:不是 1:是)              */
vax10       varchar2(6)              /*备注1                                  */
);

create unique index vax_pk on vax_file (vax01,vax02,vax03);
alter table vax_file add  constraint vax_pk primary key  (vax01,vax02,vax03) enable validate;
grant select on vax_file to public;
grant index on vax_file to public;
grant update on vax_file to public;
grant delete on vax_file to public;
grant insert on vax_file to public;