/*
================================================================================
档案代号:aps_sim
档案名称:APS 供应商维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_sim
(
pid         varchar2(40) NOT NULL,   /*料号                                   */
sup_id      varchar2(32) NOT NULL,   /*供应商编号                             */
max_lot     number(16,4),            /*最大采购量                             */
var_lt      number(16,4),            /*变动采购前置时间                       */
base_qty    number(16,4),            /*变动天数的基本数量                     */
lst_cmb     number(4),               /*是否合并尾批(0:否 1:是)                */
lst_cblm    number(16,4),            /*是否并于前批单据之判断比率             */
lot_rule    number(4),               /*批量开立规则                           */
sfx_lt      number(16,4),            /*关键料软性前置时间                     */
svr_lt      number(16,4)             /*关键料软性变动前置时间                 */
);

create unique index aps_sim_pk on aps_sim (pid,sup_id);
alter table aps_sim add  constraint aps_sim_pk primary key  (pid,sup_id) enable validate;
grant select on aps_sim to public;
grant index on aps_sim to public;
grant update on aps_sim to public;
grant delete on aps_sim to public;
grant insert on aps_sim to public;