/*
================================================================================
档案代号:msp_file
档案名称:MRP限定版别
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table msp_file
(
msp01       varchar2(10) NOT NULL,   /*版本编号                               */
msp02       number(5) NOT NULL,      /*版本序号                               */
msp03       varchar2(10),            /*仓库                                   */
msp04       varchar2(5),             /*单别                                   */
msp05       varchar2(10),            /*指送地址                               */
msp06       varchar2(1),             /*No Use                                 */
msp07       varchar2(1),             /*No Use                                 */
msp08       varchar2(1),             /*No Use                                 */
msp09       number(5)                /*No Use                                 */
);

create unique index msp_pk on msp_file (msp01,msp02);
alter table msp_file add  constraint msp_pk primary key  (msp01,msp02) enable validate;
grant select on msp_file to public;
grant index on msp_file to public;
grant update on msp_file to public;
grant delete on msp_file to public;
grant insert on msp_file to public;