/*
================================================================================
档案代号:wsp_file
档案名称:ERP 参考栏位设定档
档案目的:提供呼叫erp服务取得参考栏位资料
上游档案:
下游档案:
============.========================.==========================================
*/
create table wsp_file
(
wsp01       varchar2(80) NOT NULL,   /*服务代码                               */
wsp02       varchar2(15) NOT NULL,   /*table名称                              */
wsp03       varchar2(15) NOT NULL,   /*他系统代码                             */
wsp04       varchar2(20) NOT NULL,   /*erp栏位名称                            */
wsp05       varchar2(255) NOT NULL   /*参考栏位sql指令                        */
);

create unique index wsp_pk on wsp_file (wsp01,wsp02,wsp03,wsp04);
alter table wsp_file add  constraint wsp_pk primary key  (wsp01,wsp02,wsp03,wsp04) enable validate;
grant select on wsp_file to public;
grant index on wsp_file to public;
grant update on wsp_file to public;
grant delete on wsp_file to public;
grant insert on wsp_file to public;