/*
================================================================================
档案代号:aps_spm
档案名称:APS 采购令维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_spm
(
po_id       varchar2(32) NOT NULL,   /*采购单编号                             */
is_hold     number(4),               /*否为保留状态                           */
sply_rid    varchar2(32)             /*供给法则编号                           */
);

create unique index aps_spm_pk on aps_spm (po_id);
alter table aps_spm add  constraint aps_spm_pk primary key  (po_id) enable validate;
grant select on aps_spm to public;
grant index on aps_spm to public;
grant update on aps_spm to public;
grant delete on aps_spm to public;
grant insert on aps_spm to public;