<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'>The below SQL is for auditing of passwords, the same report can be found in the online repository by searching for "Password Audits"</p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><br></p><p id="isPasted" style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">select</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;">apfid [ID]</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;">, nhd_user.username [Name]</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;">, apfdate [Date] </span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;">, </span><span style="font-size:11pt;font-family:Consolas;color:blue;">CASE</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">when</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:#098658;">1</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">then</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:red;">'Asset'</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">when</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:#098658;">2</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">then</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:red;">'Site'</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">when</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">then</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:red;">'Custom Field'</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">when</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:#098658;">4</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">then</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:red;">'Supplier'</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">end</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">as</span><span style="font-size:11pt;font-family:Consolas;color:black;"> [Field Type]</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;">, </span><span style="font-size:11pt;font-family:Consolas;color:blue;">CASE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">1</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> dinvno </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> device </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> did </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid)</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">2</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> sdesc </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> site </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> ssitenum </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid)</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">1</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Ticket - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> faultid </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> faults </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> faultid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">2</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Customer - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> aareadesc </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> area </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> aarea </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Site - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> sdesc </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> site </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> Ssitenum </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">4</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'User - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> uusername </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> users </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> uid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">5</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Asset - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> dinvno </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> device </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> did </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">6</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Agreeement - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> CHcontractRef </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> contractheader </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> chid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">7</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Action - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> faultid </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> faults </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> faultid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">8</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Product - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> idesc </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> item </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> iid</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">9</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Vendor - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> cdesc </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> company </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> Cnum </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">1001</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Vendor Agreement - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> cncontractcode </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> contract </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> cnid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">1002</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Agent - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> uname </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> uname </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> unum </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">1003</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Organisation - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> treedesc </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> tree </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> treeid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">998</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'PO - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> SHPORef </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> SUPPLIERORDERHEADER </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> shid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">997</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Quote - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> QHid </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> QUOTATIONHEADER </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> qhid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">996</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Sales Order - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> ohid </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> ORDERHEAD </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> OHid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiusage </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid) </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">995</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">concat</span><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:red;">'Invoice - '</span><span style="font-size:11pt;font-family:Consolas;color:black;">, (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#C700C7;">isnull</span><span style="font-size:11pt;font-family:Consolas;color:black;">(IH3rdPartyInvoiceNumber, ihid) </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> INVOICEHEADER </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> ihid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjectid))</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">4</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">THEN</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:red;">'Supplier Portal Password'</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">ELSE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:red;">'Please ask Support to correct this report'</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">END</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">AS</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:red;">'Entity'</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;">, </span><span style="font-size:11pt;font-family:Consolas;color:blue;">CASE</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">when</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:#098658;">1</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">then</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;">(</span><span style="font-size:11pt;font-family:Consolas;color:blue;">select</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">top</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">1</span><span style="font-size:11pt;font-family:Consolas;color:black;"> yname </span><span style="font-size:11pt;font-family:Consolas;color:blue;">from</span><span style="font-size:11pt;font-family:Consolas;color:black;"> device </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">join</span><span style="font-size:11pt;font-family:Consolas;color:black;"> xtype </span><span style="font-size:11pt;font-family:Consolas;color:blue;">on</span><span style="font-size:11pt;font-family:Consolas;color:black;"> ttypenum</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;">dtype </span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">join</span><span style="font-size:11pt;font-family:Consolas;color:black;"> typeinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">on</span><span style="font-size:11pt;font-family:Consolas;color:black;"> ttypenum</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;">xnum </span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">join</span><span style="font-size:11pt;font-family:Consolas;color:black;"> field </span><span style="font-size:11pt;font-family:Consolas;color:blue;">on</span><span style="font-size:11pt;font-family:Consolas;color:black;"> ykind</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:red;">'t'</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">and</span><span style="font-size:11pt;font-family:Consolas;color:black;"> yseq</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;">xfieldnos </span><span style="font-size:11pt;font-family:Consolas;color:blue;">where</span><span style="font-size:11pt;font-family:Consolas;color:black;"> xfieldnos</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;">apffieldid)</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">when</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:#098658;">2</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">then</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">SELECT</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">top</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:#098658;">1</span><span style="font-size:11pt;font-family:Consolas;color:black;"> yname </span><span style="font-size:11pt;font-family:Consolas;color:blue;">FROM</span><span style="font-size:11pt;font-family:Consolas;color:black;"> field </span><span style="font-size:11pt;font-family:Consolas;color:blue;">WHERE</span><span style="font-size:11pt;font-family:Consolas;color:black;"> yseq </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apffieldid </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">AND</span><span style="font-size:11pt;font-family:Consolas;color:black;"> ykind </span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:red;">'s'</span><span style="font-size:11pt;font-family:Consolas;color:black;">)</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">when</span><span style="font-size:11pt;font-family:Consolas;color:black;"> apfobjecttype</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:#098658;">3</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">then</span><span style="font-size:11pt;font-family:Consolas;color:black;"> (</span><span style="font-size:11pt;font-family:Consolas;color:blue;">select</span><span style="font-size:11pt;font-family:Consolas;color:black;"> filabel </span><span style="font-size:11pt;font-family:Consolas;color:blue;">from</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fieldinfo </span><span style="font-size:11pt;font-family:Consolas;color:blue;">where</span><span style="font-size:11pt;font-family:Consolas;color:black;"> fiid</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;">apffieldid)</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">end</span><span style="font-size:11pt;font-family:Consolas;color:black;"> </span><span style="font-size:11pt;font-family:Consolas;color:blue;">as</span><span style="font-size:11pt;font-family:Consolas;color:black;"> [Field]</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:blue;">from</span><span style="font-size:11pt;font-family:Consolas;color:black;"> auditpasswordfield</span></p><p style='margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;line-height:14.25pt;font-size:11pt;font-family:"Calibri",sans-serif;background:#FFFFFE;'><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">join</span><span style="font-size:11pt;font-family:Consolas;color:black;"> nhd_user </span><span style="font-size:11pt;font-family:Consolas;color:blue;">on</span><span style="font-size:11pt;font-family:Consolas;color:black;"> ID</span><span style="font-size:11pt;font-family:Consolas;color:lightslategray;">=</span><span style="font-size:11pt;font-family:Consolas;color:black;">apfnhd_user_id</span></p>
