/*
================================================================================
档案代号:apsmrm
档案名称:APS 制令领料状况
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apsmrm
(
mo_id       varchar2(32) NOT NULL,   /*制令编号                               */
in_pid      varchar2(40) NOT NULL,   /*元件编号                               */
seq_txt     varchar2(32) NOT NULL,   /*元件序号                               */
sequ_num    varchar2(32) NOT NULL,   /*途程序号                               */
in_pqty     number(16,4),            /*元件已领用量                           */
wh_id       varchar2(32),            /*库房编号                               */
in_dmqty    number(16,4),            /*元件需求量                             */
stk_loc     varchar2(32),            /*库房储位                               */
is_cnsn     number(4),               /*是否为客供料(0:不是 1:是)              */
rm1         varchar2(32)             /*备注1                                  */
);

create unique index apsmrm_pk on apsmrm (mo_id,in_pid,seq_txt,sequ_num);
alter table apsmrm add  constraint apsmrm_pk primary key  (mo_id,in_pid,seq_txt,sequ_num) enable validate;
grant select on apsmrm to public;
grant index on apsmrm to public;
grant update on apsmrm to public;
grant delete on apsmrm to public;
grant insert on apsmrm to public;