/*
================================================================================
档案代号:wsl_file
档案名称:EasyFlow 整合自动确认功能 log 档
档案目的:纪录单据程式执行确认过程中错误发生讯息, 供整合程式判断是否正确执行
上游档案:
下游档案:
============.========================.==========================================
*/
create table wsl_file
(
wsl01       varchar2(20) NOT NULL,   /*fglappserver/fglserver 的值            */
wsl02       varchar2(10) NOT NULL,   /*使用者代号                             */
wsl03       varchar2(20) NOT NULL,   /*程式代号                               */
wsl04       varchar2(7),             /*错误讯息代号                           */
wsl05       varchar2(255)            /*错误讯息内容                           */
);

create unique index wsl_pk on wsl_file (wsl01,wsl02,wsl03);
alter table wsl_file add  constraint wsl_pk primary key  (wsl01,wsl02,wsl03) enable validate;
grant select on wsl_file to public;
grant index on wsl_file to public;
grant update on wsl_file to public;
grant delete on wsl_file to public;
grant insert on wsl_file to public;