/*
================================================================================
档案代号:vmk_file
档案名称:aps料件供应商维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vmk_file
(
vmk01       varchar2(40) DEFAULT '' NOT NULL, /*料号*/
vmk02       varchar2(10) DEFAULT '' NOT NULL, /*供应商编号*/
vmk05       number(18,8),            /*最大采购量                             */
vmk10       number(18,8),            /*变动采购前置时间                       */
vmk11       number(18,8),            /*变动天数的基本数量                     */
vmk12       number(1),               /*合并尾批                               */
vmk13       number(18,8),            /*并单之判断比率                         */
vmk15       number(1),               /*批量开立规则                           */
vmk16       number(18,8),            /*关键料软性前置时间                     */
vmk17       number(18,8)             /*关键料软性变动前置时间                 */
);

create unique index vmk_pk on vmk_file (vmk01,vmk02);
alter table vmk_file add  constraint vmk_pk primary key  (vmk01,vmk02) enable validate;
grant select on vmk_file to public;
grant index on vmk_file to public;
grant update on vmk_file to public;
grant delete on vmk_file to public;
grant insert on vmk_file to public;