/*
================================================================================
档案代号:aps_pem
档案名称:APS 单据追溯维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_pem
(
fed_oid     varchar2(32),            /*此采购令供给的各个需求                 */
dm_qty      number(16,4),            /*需求数量                               */
feded_id    varchar2(32),            /*供给对象的单据编号                     */
is_do       number(4),               /*是否为需求订单                         */
fed_qty     number(16,4),            /*分配量                                 */
is_po       number(4),               /*采购令 or 制令                         */
sup_qty     number(16,4),            /*供给的最大量                           */
is_lock     number(4),               /*是否锁定                               */
pid         varchar2(40),            /*料号                                   */
p_alias     varchar2(32),            /*品号规格                               */
slack       number(16,4),            /*供给单据剩余量                         */
is_error    number(4),               /*是否有效                               */
err_msg     varchar2(32)             /*无效原因                               */
);

grant select on aps_pem to public;
grant index on aps_pem to public;
grant update on aps_pem to public;
grant delete on aps_pem to public;
grant insert on aps_pem to public;