Location: PHPKode > projects > ERPSOD > erpsod/docsys/ERPSOD_manual.htm
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns:st1="urn:schemas-microsoft-com:office:smarttags"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 11">
<meta name=Originator content="Microsoft Word 11">
<link rel=File-List href="ERPSOD_manual_files/filelist.xml">
<link rel=Edit-Time-Data href="ERPSOD_manual_files/editdata.mso">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>ERPSOD</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
 name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
 name="City"/>
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>Cas Nuy</o:Author>
  <o:Template>Normal</o:Template>
  <o:LastAuthor>Cas Nuy</o:LastAuthor>
  <o:Revision>2</o:Revision>
  <o:TotalTime>1416</o:TotalTime>
  <o:LastPrinted>2009-11-05T10:04:00Z</o:LastPrinted>
  <o:Created>2010-06-14T09:51:00Z</o:Created>
  <o:LastSaved>2010-06-14T09:51:00Z</o:LastSaved>
  <o:Pages>1</o:Pages>
  <o:Words>3120</o:Words>
  <o:Characters>17784</o:Characters>
  <o:Company>Stahl Holdings BV</o:Company>
  <o:Lines>148</o:Lines>
  <o:Paragraphs>41</o:Paragraphs>
  <o:CharactersWithSpaces>20863</o:CharactersWithSpaces>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:PunctuationKerning/>
  <w:ValidateAgainstSchemas/>
  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
  <w:Compatibility>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>
   <w:UseAsianBreakRules/>
   <w:DontGrowAutofit/>
  </w:Compatibility>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:LatentStyles DefLockedState="false" LatentStyleCount="156">
 </w:LatentStyles>
</xml><![endif]--><!--[if !mso]><object
 classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object>
<style>
st1\:*{behavior:url(#ieooui) }
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Wingdings;
	panose-1:5 0 0 0 0 0 0 0 0 0;
	mso-font-charset:2;
	mso-generic-font-family:auto;
	mso-font-pitch:variable;
	mso-font-signature:0 268435456 0 0 -2147483648 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0cm;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;
	text-underline:single;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;
	mso-header-margin:35.4pt;
	mso-footer-margin:35.4pt;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
 /* List Definitions */
 @list l0
	{mso-list-id:656881470;
	mso-list-type:hybrid;
	mso-list-template-ids:-1793812216 1786550350 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
	{mso-level-number-format:bullet;
	mso-level-text:-;
	mso-level-tab-stop:36.0pt;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
@list l0:level2
	{mso-level-number-format:bullet;
	mso-level-text:o;
	mso-level-tab-stop:72.0pt;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:"Courier New";}
@list l1
	{mso-list-id:968440705;
	mso-list-template-ids:1097755004;}
@list l1:level1
	{mso-level-text:%1;
	mso-level-tab-stop:36.0pt;
	mso-level-number-position:left;
	text-indent:-36.0pt;}
@list l1:level2
	{mso-level-start-at:30;
	mso-level-text:"%1\.%2";
	mso-level-tab-stop:36.0pt;
	mso-level-number-position:left;
	margin-left:36.0pt;
	text-indent:-36.0pt;}
@list l1:level3
	{mso-level-text:"%1\.%2\.%3";
	mso-level-tab-stop:36.0pt;
	mso-level-number-position:left;
	margin-left:36.0pt;
	text-indent:-36.0pt;}
@list l1:level4
	{mso-level-text:"%1\.%2\.%3\.%4";
	mso-level-tab-stop:36.0pt;
	mso-level-number-position:left;
	margin-left:36.0pt;
	text-indent:-36.0pt;}
@list l1:level5
	{mso-level-text:"%1\.%2\.%3\.%4\.%5";
	mso-level-tab-stop:54.0pt;
	mso-level-number-position:left;
	margin-left:54.0pt;
	text-indent:-54.0pt;}
@list l1:level6
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6";
	mso-level-tab-stop:54.0pt;
	mso-level-number-position:left;
	margin-left:54.0pt;
	text-indent:-54.0pt;}
@list l1:level7
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7";
	mso-level-tab-stop:72.0pt;
	mso-level-number-position:left;
	margin-left:72.0pt;
	text-indent:-72.0pt;}
@list l1:level8
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8";
	mso-level-tab-stop:72.0pt;
	mso-level-number-position:left;
	margin-left:72.0pt;
	text-indent:-72.0pt;}
@list l1:level9
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9";
	mso-level-tab-stop:90.0pt;
	mso-level-number-position:left;
	margin-left:90.0pt;
	text-indent:-90.0pt;}
@list l2
	{mso-list-id:1392121469;
	mso-list-template-ids:-522692566;}
@list l2:level1
	{mso-level-text:%1;
	mso-level-tab-stop:36.0pt;
	mso-level-number-position:left;
	text-indent:-36.0pt;}
@list l2:level2
	{mso-level-start-at:22;
	mso-level-text:"%1\.%2";
	mso-level-tab-stop:36.0pt;
	mso-level-number-position:left;
	margin-left:36.0pt;
	text-indent:-36.0pt;}
@list l2:level3
	{mso-level-text:"%1\.%2\.%3";
	mso-level-tab-stop:36.0pt;
	mso-level-number-position:left;
	margin-left:36.0pt;
	text-indent:-36.0pt;}
@list l2:level4
	{mso-level-text:"%1\.%2\.%3\.%4";
	mso-level-tab-stop:36.0pt;
	mso-level-number-position:left;
	margin-left:36.0pt;
	text-indent:-36.0pt;}
@list l2:level5
	{mso-level-text:"%1\.%2\.%3\.%4\.%5";
	mso-level-tab-stop:54.0pt;
	mso-level-number-position:left;
	margin-left:54.0pt;
	text-indent:-54.0pt;}
@list l2:level6
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6";
	mso-level-tab-stop:54.0pt;
	mso-level-number-position:left;
	margin-left:54.0pt;
	text-indent:-54.0pt;}
@list l2:level7
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7";
	mso-level-tab-stop:72.0pt;
	mso-level-number-position:left;
	margin-left:72.0pt;
	text-indent:-72.0pt;}
@list l2:level8
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8";
	mso-level-tab-stop:72.0pt;
	mso-level-number-position:left;
	margin-left:72.0pt;
	text-indent:-72.0pt;}
@list l2:level9
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9";
	mso-level-tab-stop:90.0pt;
	mso-level-number-position:left;
	margin-left:90.0pt;
	text-indent:-90.0pt;}
@list l3
	{mso-list-id:1819414396;
	mso-list-type:hybrid;
	mso-list-template-ids:-1495867314 -875923052 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l3:level1
	{mso-level-start-at:5;
	mso-level-number-format:bullet;
	mso-level-text:-;
	mso-level-tab-stop:36.0pt;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
ol
	{margin-bottom:0cm;}
ul
	{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 10]>
<style>
 /* Style Definitions */
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
	mso-para-margin:0cm;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";
	mso-ansi-language:#0400;
	mso-fareast-language:#0400;
	mso-bidi-language:#0400;}
table.MsoTableGrid
	{mso-style-name:"Table Grid";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	border:solid windowtext 1.0pt;
	mso-border-alt:solid windowtext .5pt;
	mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
	mso-border-insideh:.5pt solid windowtext;
	mso-border-insidev:.5pt solid windowtext;
	mso-para-margin:0cm;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";
	mso-ansi-language:#0400;
	mso-fareast-language:#0400;
	mso-bidi-language:#0400;}
</style>
<![endif]--><!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="2050"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1"/>
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=EN-US link=blue vlink=purple style='tab-interval:36.0pt'>

<div class=Section1>

<p class=MsoNormal align=center style='text-align:center'><b style='mso-bidi-font-weight:
normal'><u><span style='font-size:48.0pt'>ERPSOD<o:p></o:p></span></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal align=center style='text-align:center'><span
style='font-size:18.0pt'>Segregation Of Duties Analysis tool<o:p></o:p></span></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Author<span style='mso-tab-count:2'>              </span>Cas
Nuy</p>

<p class=MsoNormal>Copyright<span style='mso-tab-count:1'>         </span>Stahl
Holdings bv</p>

<p class=MsoNormal>License<span style='mso-tab-count:1'> </span>GNU General
Public License</p>

<p class=MsoNormal>Date<span style='mso-tab-count:2'>                 </span>1-11-2009</p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u>Contents<o:p></o:p></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Introduction</p>

<p class=MsoNormal>Changes</p>

<p class=MsoNormal>Installation</p>

<p class=MsoNormal>Users</p>

<p class=MsoNormal>License</p>

<p class=MsoNormal>Manual</p>

<p class=MsoNormal>Technical</p>

<p class=MsoNormal>Appendices</p>

<p class=MsoNormal>- Config.php</p>

<p class=MsoNormal>- File definitions<span style='mso-tab-count:1'>            </span></p>

<p class=MsoNormal>- Import file definitions</p>

<p class=MsoNormal>- System tables<span style='mso-tab-count:1'> </span></p>

<p class=MsoNormal>- SQL definitions</p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u>Introduction<o:p></o:p></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>This purpose of this tool is to manage SOD conflicts within an
ERP environment (in our case of SAP).<span style='mso-spacerun:yes'> 
</span>Segregation of Duties (SOD) is an important tool in ensuring that a
business is under control from an auditing perspective.</p>

<p class=MsoNormal>Quite often employees are found to have authorizations which
impose a so called SOD conflict. This could lead to accidental damage but also
to fraud.</p>

<p class=MsoNormal>The authorizations options are very complex and insight on
these possible conflicts is not given by such erp-solutions.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>This system is build around the following concepts:</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>users are given tasks</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>tasks consist out of transactions</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>conflicts are defined at task-level (n:n)</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>conflicts can be mitigated</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Conflicts only have to be defined in one way, the system
will handle the opposite conflict automatically.</p>

<p class=MsoNormal>Thus in case task A has a conflict with task B, one only
defines this conflict. The system however will ensure also the conflict of B
with A is handled properly.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>As soon as all data is loaded, existing conflicts become
visible through a traffic light mechanism:</p>

<p class=MsoNormal>- Green<span style='mso-tab-count:1'>            </span>No
issue</p>

<p class=MsoNormal>- Orange<span style='mso-tab-count:1'>          </span>Conflict
but mitigated</p>

<p class=MsoNormal>- Red<span style='mso-tab-count:2'>               </span>Conflict
not mitigated</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>For each possible conflict the following can de defined:</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Reason of conflict</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Mitigated Yes/No</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Process for mitigation</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Formal document of approval of mitigated process</p>

<p class=MsoNormal>The system can be defined such that a conflict is only
mitigated if an official document is attached.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>The system allows for instant simulation. In case a request
is made to extend the authorization for a user, it can be simulated in the
application in order to verify if this extension might lead to SOD conflicts.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u>Changes<o:p></o:p></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>1.01<span style='mso-tab-count:1'>     </span>Initial
release</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>** Released
28-10-2009</p>

<p class=MsoNormal>1.20<span style='mso-tab-count:1'>     </span>Added
reason-field for SOD conflicts (also for initial load)</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Added
Role-field to ERPUSER</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Changed
Department and Unit fields within ERPUSER (relational)</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Added table
for Units</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Added table
for Departments</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Added table
for Roles</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Added menu
for user section</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Added
&quot;Search user&quot;</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Added
Systeminfo option under Tools</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Avoided
loading double SOD's</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Avoided
loading double usertasks</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Added
option for second display column in dropdownlists</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>Fixed
download of User SOD's</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>** Released
29-10-2009</p>

<p class=MsoNormal>1.21<span style='mso-tab-count:1'>     </span>Added option
to attach SOD-form</p>

<p class=MsoNormal><span style='mso-tab-count:1'>            </span>** Released
30-10-2009</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-36.0pt;mso-list:l2 level2 lfo3;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>1.22<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Moved copyright data to config.php</p>

<p class=MsoNormal style='margin-left:36.0pt'>Added documentation</p>

<p class=MsoNormal style='margin-left:36.0pt'>Made application frameless</p>

<p class=MsoNormal style='margin-left:36.0pt'>Added java-menu</p>

<p class=MsoNormal style='margin-left:36.0pt'>Added authorization levels for </p>

<p class=MsoNormal style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:l0 level2 lfo1;
tab-stops:list 72.0pt'><![if !supportLists]><span style='font-family:"Courier New";
mso-fareast-font-family:"Courier New"'><span style='mso-list:Ignore'>o<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><![endif]>Loading
of data</p>

<p class=MsoNormal style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:l0 level2 lfo1;
tab-stops:list 72.0pt'><![if !supportLists]><span style='font-family:"Courier New";
mso-fareast-font-family:"Courier New"'><span style='mso-list:Ignore'>o<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><![endif]>Maintaining
tables</p>

<p class=MsoNormal style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:l0 level2 lfo1;
tab-stops:list 72.0pt'><![if !supportLists]><span style='font-family:"Courier New";
mso-fareast-font-family:"Courier New"'><span style='mso-list:Ignore'>o<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><![endif]>Viewing
of data</p>

<p class=MsoNormal style='margin-left:36.0pt'>** Released 4-11-2009</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-36.0pt;mso-list:l2 level2 lfo3;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>1.23<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Made cookie lifetime variable via setting in config.php</p>

<p class=MsoNormal style='margin-left:36.0pt'>Added tracking of system access</p>

<p class=MsoNormal style='margin-left:36.0pt'>Added option to change password</p>

<p class=MsoNormal style='margin-left:36.0pt'>Added integrated logon with AD</p>

<p class=MsoNormal style='margin-left:36.0pt'>** Released 6-11-2009</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-36.0pt;mso-list:l2 level2 lfo3;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>1.24<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Cosmetic changes</p>

<p class=MsoNormal style='margin-left:36.0pt'>Protected remaining <span
style='mso-spacerun:yes'> </span>pages with authentication check.</p>

<p class=MsoNormal style='margin-left:36.0pt'>System users can be
(de)activated.</p>

<p class=MsoNormal style='margin-left:36.0pt'>Online manual now in PDF format</p>

<p class=MsoNormal style='margin-left:36.0pt'>Fixed bug in trans_edit .php
(thanks to <span style='font-size:10.0pt;font-family:Arial;color:black'>Nicolas
Rollin)<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:36.0pt'>** Released NEVER</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-36.0pt;mso-list:l1 level2 lfo4;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>1.30<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Added reference task to usertasks</p>

<p class=MsoNormal style='text-indent:36.0pt'>Interim release</p>

<p class=MsoNormal style='text-indent:36.0pt'>Bug fixes</p>

<p class=MsoNormal style='margin-left:36.0pt'>** Released 10-06-2010</p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";background:silver;mso-highlight:silver;mso-ansi-language:
EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA'><br clear=all
style='page-break-before:always'>
</span>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-36.0pt;mso-list:l1 level2 lfo4;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>1.31<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Added reference task-field to<span
style='mso-spacerun:yes'>  </span>task table</p>

<p class=MsoNormal style='margin-left:36.0pt'>SOD conflicts now only need to be
connected with referenced task</p>

<p class=MsoNormal style='margin-left:36.0pt'>Added table to show missing tasks
(taskerrors) when importing users including export function.</p>

<p class=MsoNormal style='margin-left:36.0pt'>** Released 14-06-2010</p>

<p class=MsoNormal style='margin-left:36.0pt'><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u>Installation<o:p></o:p></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Copy the contents of the zip-file into a directory of your
choice within your web environment.</p>

<p class=MsoNormal>Examples:</p>

<p class=MsoNormal>Inetpub\wwwroot\erpsod</p>

<p class=MsoNormal>Htdocs\erpsod</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Create a database ERPSOD within your MySQL server.</p>

<p class=MsoNormal>Next create the tables by executing erpsod.sql which can be
found in the docsys directory.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Final step is to adjust some settings within config.php
which can be found in the root of your installation.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Config.php lines to be adjusted:</p>

<p class=MsoNormal>$username<span style='mso-spacerun:yes'>     </span><span
style='mso-tab-count:1'>   </span>= 'YOUR DATABASE USER';<span
style='mso-tab-count:3'>                                   </span>1</p>

<p class=MsoNormal>$password<span style='mso-tab-count:1'>       </span>= 'THE
PASSWORD OF THIS USER';<span style='mso-tab-count:2'>                      </span>2</p>

<p class=MsoNormal>$form_needed = &quot;Y&quot;;<span style='mso-tab-count:
1'>    </span><span style='mso-tab-count:1'>            </span><span
style='mso-tab-count:5'>                                                            </span>3</p>

<p class=MsoNormal>$style<span style='mso-tab-count:2'>               </span>=
&quot;css/erpsod.css&quot; ;<span style='mso-tab-count:5'>                                                      </span>4</p>

<p class=MsoNormal>define('_DIR_HOME', '/xampp/htdocs/erpsod/');<span
style='mso-tab-count:3'>                                  </span>5</p>

<p class=MsoNormal>$cyear<span style='mso-tab-count:2'>              </span>= <span
style='mso-spacerun:yes'> </span>“2009 “;<span style='mso-tab-count:6'>                                                                   </span>6</p>

<p class=MsoNormal>$cname<span style='mso-tab-count:1'>            </span>=
&quot;Stahl Holdings bv&quot;;<span style='mso-tab-count:4'>                                       </span>6</p>

<p class=MsoNormal>$clink<span style='mso-tab-count:2'>               </span>=
&quot;http://www.stahl.com&quot;;<span style='mso-tab-count:4'>                                             </span>6</p>

<p class=MsoNormal>$cookietime<span style='mso-spacerun:yes'>    </span>= 3600;<span
style='mso-tab-count:6'>                                                             </span>7</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>1). This needs to hold an existing user with full rights on
the database. </p>

<p class=MsoNormal>2). Here provide the password of this user</p>

<p class=MsoNormal>3). If set to “Y” a conflict will only be validated as
mitigated if also the official approval form is available.</p>

<p class=MsoNormal>4). You may define your own stylesheet.</p>

<p class=MsoNormal>5). The<span style='mso-spacerun:yes'>  </span>absolute path
to your installation, under windows something like :</p>

<p class=MsoNormal style='text-indent:36.0pt'>define(‘_DIR_HOME’,’g:/inetpub/wwwroot/erpsod/’);</p>

<p class=MsoNormal>6). Here you can define your copyright data</p>

<p class=MsoNormal>6). How long is the cookie valid in seconds</p>

<p class=MsoNormal style='text-indent:36.0pt'><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>If you have problems handling step 1 and/or 2, please visit <a
href="http://www.mysql.com/">http://www.mysql.com</a></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><span lang=EN-GB style='mso-ansi-language:EN-GB'>If you
install ERPSOD under IIS and want to have single signon with AD, all you need
to do is the following: <br>
1. Disable Anonymous access for the ERPSOD website <br>
2. Ensure Integrated Windows Authentication is ticked</span><span lang=EN-GB
style='font-size:7.5pt;mso-ansi-language:EN-GB'> </span><br clear=all
style='page-break-before:always'>
<b style='mso-bidi-font-weight:normal'><u><span style='font-size:18.0pt'>Users<o:p></o:p></span></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Users in the system:</p>

<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0
 style='border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt;
 mso-yfti-tbllook:480;mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-border-insideh:
 .5pt solid windowtext;mso-border-insidev:.5pt solid windowtext'>
 <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
  <td width=197 valign=top style='width:147.6pt;border:solid windowtext 1.0pt;
  mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal><b style='mso-bidi-font-weight:normal'>User<o:p></o:p></b></p>
  </td>
  <td width=197 valign=top style='width:147.6pt;border:solid windowtext 1.0pt;
  border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
  solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal><b style='mso-bidi-font-weight:normal'>Password<o:p></o:p></b></p>
  </td>
  <td width=197 valign=top style='width:147.6pt;border:solid windowtext 1.0pt;
  border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
  solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal><b style='mso-bidi-font-weight:normal'>Role<o:p></o:p></b></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:1'>
  <td width=197 valign=top style='width:147.6pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal>Admin</p>
  </td>
  <td width=197 valign=top style='width:147.6pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal>ErpSod</p>
  </td>
  <td width=197 valign=top style='width:147.6pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal>Admin</p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:2'>
  <td width=197 valign=top style='width:147.6pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal>Updater</p>
  </td>
  <td width=197 valign=top style='width:147.6pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal>Erpsod</p>
  </td>
  <td width=197 valign=top style='width:147.6pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal>Updater</p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes'>
  <td width=197 valign=top style='width:147.6pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal>Viewer</p>
  </td>
  <td width=197 valign=top style='width:147.6pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal>Erpsod</p>
  </td>
  <td width=197 valign=top style='width:147.6pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal>Viewer</p>
  </td>
 </tr>
</table>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Admin has all rights in the system, including loading fresh
data and maintaining system users.</p>

<p class=MsoNormal>Updater has the authority to make changes to:</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Tasks</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Transactions<b style='mso-bidi-font-weight:normal'><u><o:p></o:p></u></b></p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>SOD’s<b style='mso-bidi-font-weight:normal'><u><o:p></o:p></u></b></p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Users<b style='mso-bidi-font-weight:normal'><u><o:p></o:p></u></b></p>

<p class=MsoNormal>Viewer has only view access and cannot change data</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u><o:p><span
 style='text-decoration:none'>&nbsp;</span></o:p></u></b></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]><b style='mso-bidi-font-weight:normal'><u>License<o:p></o:p></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>This application is developed under the GPL umbrella. Feel
free to use this source and adjust in any way suitable for your
company/environment.</p>

<p class=MsoNormal>The copyright message can be adjusted by altering the data
in config.php.</p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal align=center style='text-align:center'><b style='mso-bidi-font-weight:
normal'><u><span style='font-size:26.0pt'>Manual<o:p></o:p></span></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><u>Login<o:p></o:p></u></p>

<p class=MsoNormal><u><o:p><span style='text-decoration:none'>&nbsp;</span></o:p></u></p>

<p class=MsoNormal>As soon as someone visits the website, the logon screen is
presented. Based upon the role of the user (Admin/Update/Viewer), functionality
is given to the user.</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600"
 o:spt="75" o:preferrelative="t" path="hide@address.com@hide@address.com@hide@address.com@hide@address.com@5xe" filled="f"
 stroked="f">
 <v:stroke joinstyle="miter"/>
 <v:formulas>
  <v:f eqn="if lineDrawn pixelLineWidth 0"/>
  <v:f eqn="sum @0 1 0"/>
  <v:f eqn="sum 0 0 @1"/>
  <v:f eqn="prod @2 1 2"/>
  <v:f eqn="prod @3 21600 pixelWidth"/>
  <v:f eqn="prod @3 21600 pixelHeight"/>
  <v:f eqn="sum @0 0 1"/>
  <v:f eqn="prod @6 1 2"/>
  <v:f eqn="prod @7 21600 pixelWidth"/>
  <v:f eqn="sum @8 21600 0"/>
  <v:f eqn="prod @7 21600 pixelHeight"/>
  <v:f eqn="sum @10 21600 0"/>
 </v:formulas>
 <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
 <o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:391.5pt;
 height:143.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image001.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=522 height=191
src="ERPSOD_manual_files/image002.jpg" v:shapes="_x0000_i1025"><![endif]><span
style='mso-spacerun:yes'> </span></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>In case someone selects an option for which no authorization
exists, the following screen will indicate so:</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u><!--[if gte vml 1]><v:shape
 id="_x0000_i1026" type="#_x0000_t75" style='width:431.25pt;height:237.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image003.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=575 height=317
src="ERPSOD_manual_files/image004.jpg" v:shapes="_x0000_i1026"><![endif]></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<u><span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span></u>

<p class=MsoNormal><u>Main Menu<o:p></o:p></u></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>After logging on, the following screen is default. One can
always return to this screen via ‘Home’.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1027" type="#_x0000_t75"
 style='width:6in;height:225.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image005.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=301
src="ERPSOD_manual_files/image006.jpg" v:shapes="_x0000_i1027"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal><u>Tasks<o:p></o:p></u></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Upon selecting Tasks from the main menu, the screen below is
presented. For users with the ‘Viewer’ role, only ‘Edit’ will be visible. No
changes to the database will be made in that case.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1028" type="#_x0000_t75"
 style='width:6in;height:184.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image007.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=246
src="ERPSOD_manual_files/image008.jpg" v:shapes="_x0000_i1028"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>To add a task, simply select ‘New’ and the following screen
will popup:</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1029" type="#_x0000_t75"
 style='width:6in;height:170.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image009.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=227
src="ERPSOD_manual_files/image010.jpg" v:shapes="_x0000_i1029"><![endif]></p>

<p class=MsoNormal>Fill in the details and click on Submit. Additional
activities are placed under the ‘Edit’ button</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>In case you select ‘Delete’ a popup will appear asking if
you are sure about this activity.</p>

<p class=MsoNormal>Be aware that the results of this action can not be
reverted.</p>

<p class=MsoNormal align=center style='text-align:center'><!--[if gte vml 1]><v:shape
 id="_x0000_i1030" type="#_x0000_t75" style='width:135pt;height:88.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image011.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=180 height=118
src="ERPSOD_manual_files/image012.jpg" v:shapes="_x0000_i1030"><![endif]></p>

<p class=MsoNormal>Upon ‘OK’ the Task and its dependencies will be removed from
the database.</p>

<p class=MsoNormal>Selecting ‘Edit’ from the task-form will launch the
edit-form:</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1031" type="#_x0000_t75"
 style='width:6in;height:147.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image013.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=197
src="ERPSOD_manual_files/image014.jpg" v:shapes="_x0000_i1031"><![endif]></p>

<p class=MsoNormal>Apart from showing the name &amp; description, it also shows
which tasks in the system have a conflict with this specific task. If colored <st1:place
w:st="on"><st1:City w:st="on">Orange</st1:City></st1:place>, it means the
conflict is mitigated, Red means that this conflict is not mitigated and that
therefore this combination should not be given to a user.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>In order to offer full information, one can see which users
have this task. Simply select ‘View users for this task:</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1032" type="#_x0000_t75"
 style='width:6in;height:180pt'>
 <v:imagedata src="ERPSOD_manual_files/image015.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=240
src="ERPSOD_manual_files/image016.jpg" v:shapes="_x0000_i1032"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>Using View/maintain Transactions, the transactions combined
within this task can be managed.<span style='mso-spacerun:yes'>  </span>Again
when deleting, a popup will ask f you are sure and upon OK the transaction will
be removed from the task.</p>

<p class=MsoNormal>Adding a transaction, works as expected. When selecting Add,
a list is shown of all available transactions. Just select one and click
submit.</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1033" type="#_x0000_t75"
 style='width:6in;height:197.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image017.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=263
src="ERPSOD_manual_files/image018.jpg" v:shapes="_x0000_i1033"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Now we come to the most important part, we can define which
tasks are conflicting with the task we are maintaining. This is only available
if the task and Reference task are identical.</p>

<p class=MsoNormal>Simply click on maintaining conflicting tasks to reach:</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1034" type="#_x0000_t75"
 style='width:6in;height:168.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image019.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=225
src="ERPSOD_manual_files/image020.jpg" v:shapes="_x0000_i1034"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Again when deleting, a popup will ask f you are sure and
upon OK the task will be removed from the list.</p>

<p class=MsoNormal>Adding a tasks, again works as expected. When selecting Add,
a list is shown of all available tasks. Just select one and click submit.</p>

<p class=MsoNormal>The system will automatically also register the reverse
combination so there is no need to define this yourself.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>Next step in the process is to further define the 2
conflicting tasks. So select the conflicting task you want to handle and click
on Mitigate.</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1035" type="#_x0000_t75"
 style='width:431.25pt;height:232.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image021.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=575 height=310
src="ERPSOD_manual_files/image022.jpg" v:shapes="_x0000_i1035"><![endif]></p>

<p class=MsoNormal>Here you must define the following details:</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>The reason for the conflict</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Has the conflict been mitigated Y/N</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Describe the mitigation process if applicable</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Attach a formal document that proves that the
mitigation process has been authorized.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Depending on a setting in the system, a conflict will be
accepted as mitigated:</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Only when stated Mitigated = “Yes”</p>

<p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1;
tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Like above and a formal document should be attached.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Any changes made here, are also made by the system on the
reverse combination.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>When selecting users from the top-menu, the system will ask
you to be patient while retrieving all possible SOD conflicts in the system.</p>

<p class=MsoNormal>Then a list-box like below is presented where users without
conflict are presented in Green, users with a conflict in Red and users with
mitigated conflicts in <st1:City w:st="on"><st1:place w:st="on">Orange</st1:place></st1:City>.</p>

<p class=MsoNormal>It will only be orange if all conflicts for a user have been
mitigated.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1036" type="#_x0000_t75"
 style='width:6in;height:178.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image023.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=238
src="ERPSOD_manual_files/image024.jpg" v:shapes="_x0000_i1036"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>When selecting “New’ simply fill in the details of the new
user and select Submit.</p>

<p class=MsoNormal>Additional activities are placed under the ‘Edit’ button</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>In case you select ‘Delete’ a popup will appear asking if
you are sure about this activity.</p>

<p class=MsoNormal>Be aware that the results of this action can not be
reverted.</p>

<p class=MsoNormal align=center style='text-align:center'><!--[if gte vml 1]><v:shape
 id="_x0000_i1037" type="#_x0000_t75" style='width:135pt;height:88.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image011.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=180 height=118
src="ERPSOD_manual_files/image012.jpg" v:shapes="_x0000_i1037"><![endif]></p>

<p class=MsoNormal>Upon ‘OK’ the User and its dependencies will be removed from
the database.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>Selecting a user and clicking on the Edit button, will bring
the following screen:</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1038" type="#_x0000_t75"
 style='width:431.25pt;height:450.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image025.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=575 height=601
src="ERPSOD_manual_files/image026.jpg" v:shapes="_x0000_i1038"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Apart from showing the users details, you instantly see
which tasks are causing a problem for this user. The same color codes as
previously described, apply here.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>Maintenance of the allocated tasks for this user can be done
by clicking on Maintain tasks for this user.</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1039" type="#_x0000_t75"
 style='width:6in;height:168.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image027.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=225
src="ERPSOD_manual_files/image028.jpg" v:shapes="_x0000_i1039"><![endif]></p>

<p class=MsoNormal>When deleting you are asked to confirm, when adding you
first select a task, click on submit and you will return to the use screen.
Immediately you will see if this allocation leads to a possible conflict.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>The system comes with a number of exports. All data can<span
style='mso-spacerun:yes'>  </span>be exported to CSV files for your
convenience. </p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1040" type="#_x0000_t75"
 style='width:84.75pt;height:21.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image029.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=113 height=29
src="ERPSOD_manual_files/image030.jpg" v:shapes="_x0000_i1040"><![endif]></p>

<p class=MsoNormal>When opening the above menu item, one can choose to export
each individual table. In addition all (User) Registered SOD Conflicts can be
exported.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Upon slection and execution, you will get the following
screen:</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1041" type="#_x0000_t75"
 style='width:292.5pt;height:196.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image031.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=390 height=262
src="ERPSOD_manual_files/image032.jpg" v:shapes="_x0000_i1041"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Save the file where ever you like and use the data.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Only when exporting users with SOD, you will be presented
initially with a selection screen.</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1042" type="#_x0000_t75"
 style='width:6in;height:214.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image033.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=286
src="ERPSOD_manual_files/image034.jpg" v:shapes="_x0000_i1042"><![endif]></p>

<p class=MsoNormal>Make your choices, click submit and the rest is like above.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>On the following pages you will find screenshots for
maintaining various system tables.</p>

<p class=MsoNormal>All work along the same principles as described above.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Transactions</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1043" type="#_x0000_t75"
 style='width:431.25pt;height:218.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image035.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=575 height=291
src="ERPSOD_manual_files/image036.jpg" v:shapes="_x0000_i1043"><![endif]></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1044" type="#_x0000_t75"
 style='width:6in;height:154.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image037.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=206
src="ERPSOD_manual_files/image038.jpg" v:shapes="_x0000_i1044"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>Units</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1045" type="#_x0000_t75"
 style='width:6in;height:222.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image039.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=297
src="ERPSOD_manual_files/image040.jpg" v:shapes="_x0000_i1045"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1046" type="#_x0000_t75"
 style='width:431.25pt;height:138.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image041.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=575 height=185
src="ERPSOD_manual_files/image042.jpg" v:shapes="_x0000_i1046"><![endif]></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>Departments</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1047" type="#_x0000_t75"
 style='width:6in;height:180.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image043.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=241
src="ERPSOD_manual_files/image044.jpg" v:shapes="_x0000_i1047"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1048" type="#_x0000_t75"
 style='width:6in;height:132pt'>
 <v:imagedata src="ERPSOD_manual_files/image045.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=176
src="ERPSOD_manual_files/image046.jpg" v:shapes="_x0000_i1048"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>Roles</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1049" type="#_x0000_t75"
 style='width:6in;height:180.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image047.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=241
src="ERPSOD_manual_files/image048.jpg" v:shapes="_x0000_i1049"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1050" type="#_x0000_t75"
 style='width:6in;height:146.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image049.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=195
src="ERPSOD_manual_files/image050.jpg" v:shapes="_x0000_i1050"><![endif]></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>System users</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1051" type="#_x0000_t75"
 style='width:6in;height:187.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image051.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=250
src="ERPSOD_manual_files/image052.jpg" v:shapes="_x0000_i1051"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1052" type="#_x0000_t75"
 style='width:6in;height:236.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image053.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=315
src="ERPSOD_manual_files/image054.jpg" v:shapes="_x0000_i1052"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>System info</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1053" type="#_x0000_t75"
 style='width:6in;height:132.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image055.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=177
src="ERPSOD_manual_files/image056.jpg" v:shapes="_x0000_i1053"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>This option is only there for convenience to verify various
system settings.<br clear=all style='page-break-before:always'>
Manual</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1054" type="#_x0000_t75"
 style='width:6in;height:306.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image057.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=409
src="ERPSOD_manual_files/image058.jpg" v:shapes="_x0000_i1054"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>When selecting the Manual, a new window will open holding
the pdf-version of the documentation.<br clear=all style='page-break-before:
always'>
The options under Tools/Loading are only accessible for someone with the Admin
role.</p>

<p class=MsoNormal>These are all used to load the system.</p>

<p class=MsoNormal>Be aware that existing data is removed and if no backup is
made, there is no option to revert this action.</p>

<p class=MsoNormal>Normally these are only used during system setup.</p>

<p class=MsoNormal>The only exceptions are users and the user/task combination.
These could be refreshed on a regular base.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>After selecting a file and clicking on Load, you are asked
to confirm and off it goes.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>In the last appendix, an overview is available for the
lay-out of each of these load sheets.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1055" type="#_x0000_t75"
 style='width:6in;height:112.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image059.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=150
src="ERPSOD_manual_files/image060.jpg" v:shapes="_x0000_i1055"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1056" type="#_x0000_t75"
 style='width:6in;height:113.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image061.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=151
src="ERPSOD_manual_files/image062.jpg" v:shapes="_x0000_i1056"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1057" type="#_x0000_t75"
 style='width:431.25pt;height:114.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image063.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=575 height=153
src="ERPSOD_manual_files/image064.jpg" v:shapes="_x0000_i1057"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1058" type="#_x0000_t75"
 style='width:431.25pt;height:115.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image065.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=575 height=154
src="ERPSOD_manual_files/image066.jpg" v:shapes="_x0000_i1058"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1059" type="#_x0000_t75"
 style='width:431.25pt;height:117.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image067.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=575 height=157
src="ERPSOD_manual_files/image068.jpg" v:shapes="_x0000_i1059"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1060" type="#_x0000_t75"
 style='width:6in;height:114.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image069.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=153
src="ERPSOD_manual_files/image070.jpg" v:shapes="_x0000_i1060"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>After loading Usertasks, the system will let you know if it
found “unknown” transactions.</p>

<p class=MsoNormal>If so, they can be downloaded under Exports/Tables/Tasks not
found.</p>

<p class=MsoNormal>Please identify your actions and reload if applicable.</p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>Users can change their password by selecting the last option
on the tools menu.</p>

<p class=MsoNormal>Upon change you will need to login again.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1061" type="#_x0000_t75"
 style='width:6in;height:149.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image071.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=199
src="ERPSOD_manual_files/image072.jpg" v:shapes="_x0000_i1061"><![endif]><br
clear=all style='page-break-before:always'>
<b style='mso-bidi-font-weight:normal'><u>Technical information</u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>The application is written in PHP using a MySQL database and
has been tested on the Apache and IIS6 platform.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Language<span style='mso-tab-count:1'>          </span>PHP 5
or above</p>

<p class=MsoNormal>Database<span style='mso-tab-count:1'>          </span>MySQL
5 or above</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>The menu is made with a simple Java script from Coolmenu:</p>

<p class=MsoNormal><a href="http://www.dhtmlcentral.com/projects/coolmenus/">http://www.dhtmlcentral.com/projects/coolmenus/</a></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>The application can be installed anywhere in your web
structure.</p>

<p class=MsoNormal>The directory structure when installed looks like:</p>

<p class=MsoNormal>- CSS<span style='mso-tab-count:3'>                          </span>holds
the stylesheets</p>

<p class=MsoNormal>- DOC<span style='mso-tab-count:3'>                         </span>holds
attached documents<span style='mso-tab-count:2'>                     </span>***</p>

<p class=MsoNormal>- CSV_BIN<span style='mso-tab-count:2'>                 </span>holds
uploaded files for loading<span style='mso-tab-count:1'> </span>***</p>

<p class=MsoNormal>- DOCSYS<span style='mso-tab-count:2'>                  </span>holds
system documentation</p>

<p class=MsoNormal>*** these directories will be created when needed if
authorization permits.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Tables in use:</p>

<p class=MsoNormal>- ERPUSER<span style='mso-tab-count:2'>                 </span>contains
user information</p>

<p class=MsoNormal>- ERPUNIT<span style='mso-tab-count:2'>                 </span>contains
list of available units</p>

<p class=MsoNormal>- ERPDEPT<span style='mso-tab-count:2'>                 </span>contains
list of available departments</p>

<p class=MsoNormal>- ERPROLE<span style='mso-tab-count:2'>                 </span>contains
list of available roles</p>

<p class=MsoNormal>- ERPTASK<span style='mso-tab-count:2'>                </span>holds
all available tasks</p>

<p class=MsoNormal>- ERPTRANS<span style='mso-tab-count:2'>              </span>holds
all available transactions</p>

<p class=MsoNormal>- TASKTRANS<span style='mso-tab-count:1'>           </span>holds
all combinations of tasks &amp; transactions</p>

<p class=MsoNormal>- USERTASK<span style='mso-tab-count:2'>              </span>holds
all combinations of users &amp; tasks</p>

<p class=MsoNormal>- TASKERRORS<span style='mso-tab-count:1'>        </span>holds
missing tasks when loading usertasks</p>

<p class=MsoNormal>- TASKSOD<span style='mso-tab-count:2'>               </span>holds
all defined SOD conflicts</p>

<p class=MsoNormal>- USERS<span style='mso-tab-count:2'>                      </span>holds
all users of the system</p>

<p class=MsoNormal>- USERLOG<span style='mso-tab-count:2'>                </span>holds
all user logons by date/time</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>- TASKTRANSTEMP<span style='mso-tab-count:1'>            </span>temporary
table used for loading TASKTRANS</p>

<p class=MsoNormal>- USERTASKTEMP<span style='mso-tab-count:2'>               </span>temporary
table used for loading USERTASK</p>

<p class=MsoNormal>- TASKSODTEMP<span style='mso-tab-count:2'>                 </span>temporary
table used for loading TASKSOD</p>

<p class=MsoNormal>- TASKTEMP<span style='mso-tab-count:3'>                         </span>temporary
table for loading tasks</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Lay-out of each table to be found in the appendices.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u><span
style='font-size:18.0pt'>Appendix<span style='mso-tab-count:1'>        </span>Config.php<o:p></o:p></span></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>&lt;?PHP</p>

<p class=MsoNormal>// database info</p>

<p class=MsoNormal>$hostname<span style='mso-spacerun:yes'>       </span>=
'localhost';</p>

<p class=MsoNormal>$database<span style='mso-tab-count:1'>         </span>= 'ERPSOD';</p>

<p class=MsoNormal>$username<span style='mso-spacerun:yes'>     </span><span
style='mso-tab-count:1'>   </span>= 'your-user';</p>

<p class=MsoNormal>$password<span style='mso-tab-count:1'>       </span>=
'his-password';</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>// Only mitigated if form included</p>

<p class=MsoNormal>$form_needed = &quot;Y&quot;;</p>

<p class=MsoNormal>//define stylesheet to be used</p>

<p class=MsoNormal>$style<span style='mso-tab-count:2'>               </span>=
&quot;css/erpsod.css&quot; ;</p>

<p class=MsoNormal>// Define cookie-time</p>

<p class=MsoNormal>$cookietime= 3600;</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>//<span style='mso-spacerun:yes'>  </span>Absolute path to
index.php *WITH* trailing slash</p>

<p class=MsoNormal>define('_DIR_HOME', '/xampp/htdocs/erpsod/');</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>// Define copyright data</p>

<p class=MsoNormal>$cyear<span style='mso-tab-count:1'>  </span><span
style='mso-tab-count:1'>            </span>= “2009 “;</p>

<p class=MsoNormal>$cname<span style='mso-tab-count:1'>            </span>=
&quot;Stahl Holdings bv&quot;;</p>

<p class=MsoNormal>$clink<span style='mso-tab-count:1'>   </span><span
style='mso-tab-count:1'>            </span>= &quot;http://www.stahl.com&quot;;</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>//<span style='mso-spacerun:yes'>  </span>Directory where
uploaded CSV files will be stored (with trailing slash)</p>

<p class=MsoNormal>define('_DIR_UPLOAD', 'csv_bin/');</p>

<p class=MsoNormal>//<span style='mso-spacerun:yes'>  </span>Directory where
uploaded documents will be stored (with trailing slash)</p>

<p class=MsoNormal>define('_DIR_DOC', 'doc/');</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>// general stuff</p>

<p class=MsoNormal>$version <span style='mso-tab-count:2'>                      </span>=
&quot;1.22&quot; ;</p>

<p class=MsoNormal>$link = mysql_connect(&quot;$hostname&quot;,
&quot;$username&quot;,&quot;$password&quot;);</p>

<p class=MsoNormal>if (!$link) {</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>   </span><span
style='mso-spacerun:yes'> </span>die('Could not connect to server: ' .
mysql_error());</p>

<p class=MsoNormal>}</p>

<p class=MsoNormal>$link = mysql_select_db(&quot;$database&quot;);</p>

<p class=MsoNormal>if (!$link) {</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>    </span>die('Could not
connect to database: ' . mysql_error());</p>

<p class=MsoNormal>}</p>

<p class=MsoNormal>include_once(&quot;erpsod_api.php&quot;);</p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u><span
style='font-size:18.0pt'>Appendix File-definitions<o:p></o:p></span></u></b></p>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u><span
style='font-size:14.0pt'><o:p><span style='text-decoration:none'>&nbsp;</span></o:p></span></u></b></p>

<p class=MsoNormal>ERPUSER</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1062" type="#_x0000_t75"
 style='width:400.5pt;height:117pt'>
 <v:imagedata src="ERPSOD_manual_files/image073.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=534 height=156
src="ERPSOD_manual_files/image074.jpg" v:shapes="_x0000_i1062"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>ERPUNIT</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1063" type="#_x0000_t75"
 style='width:399pt;height:46.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image075.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=532 height=62
src="ERPSOD_manual_files/image076.jpg" v:shapes="_x0000_i1063"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>ERPDEPT</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1064" type="#_x0000_t75"
 style='width:402pt;height:51pt'>
 <v:imagedata src="ERPSOD_manual_files/image077.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=536 height=68
src="ERPSOD_manual_files/image078.jpg" v:shapes="_x0000_i1064"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>ERPROLE</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1065" type="#_x0000_t75"
 style='width:405pt;height:51pt'>
 <v:imagedata src="ERPSOD_manual_files/image079.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=540 height=68
src="ERPSOD_manual_files/image080.jpg" v:shapes="_x0000_i1065"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>ERPTASK</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1066" type="#_x0000_t75"
 style='width:6in;height:126pt'>
 <v:imagedata src="ERPSOD_manual_files/image081.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=576 height=168
src="ERPSOD_manual_files/image082.jpg" v:shapes="_x0000_i1066"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>ERPTRANS</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1067" type="#_x0000_t75"
 style='width:406.5pt;height:70.5pt'>
 <v:imagedata src="ERPSOD_manual_files/image083.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=542 height=94
src="ERPSOD_manual_files/image084.jpg" v:shapes="_x0000_i1067"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>TASKSOD</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1068" type="#_x0000_t75"
 style='width:405.75pt;height:131.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image085.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=541 height=175
src="ERPSOD_manual_files/image086.jpg" v:shapes="_x0000_i1068"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>TASKTRANS</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1069" type="#_x0000_t75"
 style='width:303.75pt;height:51.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image087.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=405 height=69
src="ERPSOD_manual_files/image088.jpg" v:shapes="_x0000_i1069"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>USERTASK</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1070" type="#_x0000_t75"
 style='width:317.25pt;height:51pt'>
 <v:imagedata src="ERPSOD_manual_files/image089.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=423 height=68
src="ERPSOD_manual_files/image090.jpg" v:shapes="_x0000_i1070"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>TAKERRORS</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1071" type="#_x0000_t75"
 style='width:391.5pt;height:77.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image091.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=522 height=103
src="ERPSOD_manual_files/image092.jpg" v:shapes="_x0000_i1071"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<b style='mso-bidi-font-weight:normal'><u><span style='font-size:14.0pt;
font-family:"Times New Roman";mso-fareast-font-family:"Times New Roman";
mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA'><br
clear=all style='page-break-before:always'>
</span></u></b>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u><span
style='font-size:14.0pt'>File-definitions for temp tables while loading<o:p></o:p></span></u></b></p>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u><span
style='font-size:14.0pt'><o:p><span style='text-decoration:none'>&nbsp;</span></o:p></span></u></b></p>

<p class=MsoNormal>TASKSODTEMP</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1072" type="#_x0000_t75"
 style='width:358.5pt;height:71.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image093.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=478 height=95
src="ERPSOD_manual_files/image094.jpg" v:shapes="_x0000_i1072"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>TASKTRANSTEMP</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1073" type="#_x0000_t75"
 style='width:369pt;height:51.75pt'>
 <v:imagedata src="ERPSOD_manual_files/image095.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=492 height=69
src="ERPSOD_manual_files/image096.jpg" v:shapes="_x0000_i1073"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>USERTASKTEMP</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1074" type="#_x0000_t75"
 style='width:367.5pt;height:71.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image097.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=490 height=95
src="ERPSOD_manual_files/image098.jpg" v:shapes="_x0000_i1074"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>TASKTEMP</p>

<p class=MsoNormal><span style='font-size:14.0pt'><!--[if gte vml 1]><v:shape
 id="_x0000_i1075" type="#_x0000_t75" style='width:400.5pt;height:108pt'>
 <v:imagedata src="ERPSOD_manual_files/image099.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=534 height=144
src="ERPSOD_manual_files/image100.jpg" v:shapes="_x0000_i1075"><![endif]><o:p></o:p></span></p>

<b style='mso-bidi-font-weight:normal'><u><span style='font-size:14.0pt;
font-family:"Times New Roman";mso-fareast-font-family:"Times New Roman";
mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA'><br
clear=all style='page-break-before:always'>
</span></u></b>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u><span
style='font-size:14.0pt'>System tables<o:p></o:p></span></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>USERS</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1076" type="#_x0000_t75"
 style='width:417pt;height:89.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image101.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=556 height=119
src="ERPSOD_manual_files/image102.jpg" v:shapes="_x0000_i1076"><![endif]></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>USERLOG</p>

<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1077" type="#_x0000_t75"
 style='width:365.25pt;height:56.25pt'>
 <v:imagedata src="ERPSOD_manual_files/image103.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=487 height=75
src="ERPSOD_manual_files/image104.jpg" v:shapes="_x0000_i1077"><![endif]><br
clear=all style='page-break-before:always'>
<b style='mso-bidi-font-weight:normal'><u><span style='font-size:18.0pt'>Appendix
File-definitions for upload sheets<o:p></o:p></span></u></b></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>All files are intended to be CSV files without headers.</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><u>Loading tasks:<o:p></o:p></u></p>

<p class=MsoNormal>Task name</p>

<p class=MsoNormal>Task description</p>

<p class=MsoNormal>Taskname2 (Reference task for user task)</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><u>Loading transactions:<o:p></o:p></u></p>

<p class=MsoNormal>Transaction name</p>

<p class=MsoNormal>Transaction description</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><u>Loading Tasks/Transactions:<o:p></o:p></u></p>

<p class=MsoNormal>Task name</p>

<p class=MsoNormal>Transaction name</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><u>Loading SOD conflicts:<o:p></o:p></u></p>

<p class=MsoNormal>Task Name</p>

<p class=MsoNormal>Conflicting Task Name</p>

<p class=MsoNormal>Reason for conflict</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><u>Loading users:<o:p></o:p></u></p>

<p class=MsoNormal>Username</p>

<p class=MsoNormal>Full name</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><u>Loading Users/Tasks:<o:p></o:p></u></p>

<p class=MsoNormal>Username</p>

<p class=MsoNormal>Task name</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<b style='mso-bidi-font-weight:normal'><u><span style='font-size:18.0pt;
font-family:"Times New Roman";mso-fareast-font-family:"Times New Roman";
mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA'><br
clear=all style='page-break-before:always'>
</span></u></b>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u><span
style='font-size:18.0pt'>Appendix SQL-definitions<o:p></o:p></span></u></b></p>

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><u><span
style='font-size:18.0pt'><o:p><span style='text-decoration:none'>&nbsp;</span></o:p></span></u></b></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `erpdept` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`deptid` int(11) NOT
NULL auto_increment,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span><span lang=FR
style='mso-ansi-language:FR'>`deptdesc` varchar(50) collate utf8_unicode_ci NOT
NULL,<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span></span>PRIMARY KEY<span
style='mso-spacerun:yes'>  </span>(`deptid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>UNIQUE KEY
`deptdesc` (`deptdesc`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>)
ENGINE=MyISAM<span style='mso-spacerun:yes'>  </span>DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `erprole` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`roleid` int(15) NOT
NULL auto_increment,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`rolename`
varchar(50) collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>PRIMARY KEY<span
style='mso-spacerun:yes'>  </span>(`roleid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `rolename`
(`rolename`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>)
ENGINE=MyISAM<span style='mso-spacerun:yes'>  </span>DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;<o:p></o:p></span></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `erptask` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskid` int(15) NOT
NULL auto_increment,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskname`
varchar(50) collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskdesc`
varchar(150) collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`reftaskid` int(15)
NOT NULL default '0',</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>PRIMARY KEY<span
style='mso-spacerun:yes'>  </span>(`taskid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `taskname`
(`taskname`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>)
ENGINE=MyISAM<span style='mso-spacerun:yes'>  </span>DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;<o:p></o:p></span></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `erptrans` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`transid` int(15)
NOT NULL auto_increment,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span><span lang=FR
style='mso-ansi-language:FR'>`transname` varchar(50) collate utf8_unicode_ci
NOT NULL,<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span>`transdesc` varchar(50) collate
utf8_unicode_ci NOT NULL,<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span></span>PRIMARY KEY<span
style='mso-spacerun:yes'>  </span>(`transid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `transname`
(`transname`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>)
ENGINE=MyISAM<span style='mso-spacerun:yes'>  </span>DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;<o:p></o:p></span></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `erpunit` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`unitid` int(15) NOT
NULL auto_increment,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span><span lang=FR
style='mso-ansi-language:FR'>`unitdesc` varchar(50) collate utf8_unicode_ci NOT
NULL,<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span></span>PRIMARY KEY<span
style='mso-spacerun:yes'>  </span>(`unitid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `unitdesc`
(`unitdesc`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>)
ENGINE=MyISAM<span style='mso-spacerun:yes'>  </span>DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `erpuser` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`erpuserid` int(15)
NOT NULL auto_increment,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span><span lang=FR
style='mso-ansi-language:FR'>`logonid` varchar(25) collate utf8_unicode_ci NOT
NULL,<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span></span>`name` varchar(25) collate
utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`deptid` int(15) NOT
NULL default '1',</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`unitid` int(15) NOT
NULL default '1',</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`roleid` int(11) NOT
NULL default '1',</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>PRIMARY KEY<span
style='mso-spacerun:yes'>  </span>(`erpuserid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `logonid`
(`logonid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `name` (`name`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `dept`
(`deptid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `unit`
(`unitid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `roleid`
(`roleid`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>)
ENGINE=MyISAM<span style='mso-spacerun:yes'>  </span>DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;<o:p></o:p></span></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `taskerrors` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskname`
varchar(75) collate utf8_unicode_ci NOT NULL</p>

<p class=MsoNormal>) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `tasksod` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`tsid` int(15) NOT
NULL auto_increment,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskid` int(15) NOT
NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`sodid` int(15) NOT
NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`mitigated`
varchar(1) collate utf8_unicode_ci NOT NULL default 'N',</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`proces` longtext
collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`reason` longtext
collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span><span lang=FR
style='mso-ansi-language:FR'>`sodform` varchar(50) collate utf8_unicode_ci NOT
NULL,<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span></span>PRIMARY KEY<span
style='mso-spacerun:yes'>  </span>(`tsid`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>)
ENGINE=MyISAM<span style='mso-spacerun:yes'>  </span>DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;<o:p></o:p></span></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `tasksodtemp` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskname` varchar(50)
collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`sodname`
varchar(50) collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`reason` longtext
collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `taskname`
(`taskname`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `sodname`
(`sodname`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>) ENGINE=MyISAM
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;<o:p></o:p></span></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `tasktemp` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskname`
varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskdesc`
varchar(150) character set utf8 collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskname2`
varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL</p>

<p class=MsoNormal>) ENGINE=MyISAM DEFAULT CHARSET=latin1;</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `tasktrans` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskid` int(15) NOT
NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`transid` int(15)
NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `taskid`
(`taskid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `transid`
(`transid`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>) ENGINE=MyISAM
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;<o:p></o:p></span></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `tasktranstemp` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskname`
varchar(50) collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`transname`
varchar(50) collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `taskname`
(`taskname`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `transname` (`transname`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>FULLTEXT KEY
`transname_2` (`transname`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>) ENGINE=MyISAM
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;<o:p></o:p></span></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `userlog` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span><span lang=FR
style='mso-ansi-language:FR'>`username` varchar(60) collate utf8_unicode_ci NOT
NULL,<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span></span>`loggedin` datetime NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `username`
(`username`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `loggedin`
(`loggedin`)</p>

<p class=MsoNormal>) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `users` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`ID` mediumint(9)
NOT NULL auto_increment,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span><span lang=FR
style='mso-ansi-language:FR'>`username` varchar(60) collate utf8_unicode_ci
default NULL,<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span>`password` varchar(60) collate
utf8_unicode_ci default NULL,<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span>`sysrole` varchar(10) collate utf8_unicode_ci
NOT NULL default 'Viewer',<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span>`active` varchar(1) collate utf8_unicode_ci
NOT NULL default 'Y',<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span></span>PRIMARY KEY<span
style='mso-spacerun:yes'>  </span>(`ID`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>)
ENGINE=MyISAM<span style='mso-spacerun:yes'>  </span>DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `usertask` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`erpuserid` int(15)
NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskid` int(15) NOT
NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `erpuserid`
(`erpuserid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `taskid`
(`taskid`)</p>

<p class=MsoNormal>) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<span style='font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-US;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA'><br clear=all style='page-break-before:always'>
</span>

<p class=MsoNormal>CREATE TABLE IF NOT EXISTS `usertasktemp` (</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span><span lang=FR
style='mso-ansi-language:FR'>`logonid` varchar(25) collate utf8_unicode_ci NOT
NULL,<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><span
style='mso-spacerun:yes'>  </span></span>`taskname` varchar(50) collate
utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>`taskname2`
varchar(50) collate utf8_unicode_ci NOT NULL,</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `logonid`
(`logonid`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `taskname`
(`taskname`),</p>

<p class=MsoNormal><span style='mso-spacerun:yes'>  </span>KEY `taskname2`
(`taskname2`)</p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'>) ENGINE=MyISAM
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;<o:p></o:p></span></p>

<p class=MsoNormal><span lang=FR style='mso-ansi-language:FR'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal>INSERT INTO `users` (`ID`, `username`, `password`,
`sysrole`, `active`) VALUES</p>

<p class=MsoNormal>(1, 'Admin', 'e7e260a6c4486cbc6ab6f699d9fcbcf4', 'Admin',
'Y'),</p>

<p class=MsoNormal>(2, 'Viewer', '6736f81ef335042162c6024f37581ddc', 'Viewer',
'Y'),</p>

<p class=MsoNormal>(3, 'Updater', '7737747f1679f798aca257d8ad239c87', 'Viewer',
'Y');</p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

</div>

</body>

</html>
Return current item: ERPSOD