<?xml version="1.0" encoding="UTF-8" ?>
<JDERequest Distinct="N" Operation="SELECT" DBOperation="INSERT ">
<TABLE LIBRARY="JDFDATA">
<ACTION>SPECIFIED</ACTION>
<NAME>F4201</NAME>
<ROW>
<SHDOCO Visible="Y" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
<WHERE>
<OPERATOR>=</OPERATOR>
<VALUE>112891 </VALUE>
</WHERE>
</SHDOCO>
<SHDCTO Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
<WHERE>
<OPERATOR>=</OPERATOR>
<VALUE>SO</VALUE>
</WHERE>
</SHDCTO>
<SHVR01 Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</SHVR01>
<SHSHAN Visible="" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
</SHSHAN>
<SHAN8 Visible="Y" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
</SHAN8>
</ROW>
</TABLE> <TABLE LIBRARY="JDFDATA">
<ACTION>SPECIFIED</ACTION>
<NAME>F4211</NAME>
<TABLEJOIN SIDE="">INNER</TABLEJOIN>
<ROW>
<SDDOCO Visible="Y" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
<FROM>
<JOIN>F4201.SHDOCO</JOIN>
</FROM>
</SDDOCO>
<SDDCTO Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
<FROM>
<JOIN>F4201.SHDCTO</JOIN>
</FROM>
</SDDCTO>
<SDRCD Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</SDRCD>
<SDCARS Visible="Y" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
</SDCARS>
<SDSOQS Visible="Y" order="" group="">
<NAME />
<TYPE>DECIMAL</TYPE>
<VALUE />
</SDSOQS>
<SDUORG Visible="Y" order="" group="">
<NAME />
<TYPE>DECIMAL</TYPE>
<VALUE />
</SDUORG>
<SDLITM Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</SDLITM>
<SDDRQJ Visible="Y" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
</SDDRQJ>
<SDLNID Visible="Y" order="" group="">
<NAME />
<TYPE>DECIMAL</TYPE>
<VALUE />
<WHERE>
<OPERATOR>=</OPERATOR>
<VALUE>1000</VALUE>
</WHERE>
</SDLNID>
<SDUPRC Visible="Y" order="" group="">
<NAME />
<TYPE>DECIMAL</TYPE>
<VALUE />
</SDUPRC>
<SDMCU Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</SDMCU>
<SDADDJ Visible="Y" order="" group="">
<NAME />
<TYPE>NUM</TYPE>
<VALUE />
</SDADDJ>
<SDAEXP Visible="Y" order="" group="">
<NAME />
<TYPE>DECIMAL</TYPE>
<VALUE />
</SDAEXP>
<SDOGNO Visible="Y" order="" group="">
<NAME />
<TYPE>DECIMAL</TYPE>
<VALUE />
</SDOGNO>
<SDCNID Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</SDCNID>
<SDSHAN Visible="Y" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
</SDSHAN>
<SDAN8 Visible="" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
</SDAN8>
</ROW>
</TABLE>
<TABLE LIBRARY="JDFDATA">
<ACTION>SPECIFIED</ACTION>
<NAME>F0311</NAME>
<TABLEJOIN SIDE="LEFT">OUTER</TABLEJOIN>
<ROW>
<RPDOC Visible="" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
<FROM>
<JOIN>F4211.SDDOCO</JOIN>
</FROM>
</RPDOC>
<RPDCT Visible="" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
<FROM>
<JOIN>F4211.SDDCTO</JOIN>
</FROM>
</RPDCT>
<RPSTAM Visible="Y" order="" group="">
<NAME />
<TYPE>DECIMAL</TYPE>
<VALUE />
</RPSTAM>
</ROW>
</TABLE>
<TABLE LIBRARY="JDFDATA">
<ACTION>SPECIFIED</ACTION>
<NAME>F0101</NAME>
<TABLEJOIN SIDE="LEFT">OUTER</TABLEJOIN>
<ROW>
<ABAN8 Visible="" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
<FROM>
<JOIN>F4211.SDAN8</JOIN>
</FROM>
</ABAN8>
<ABALPH Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</ABALPH>
</ROW>
</TABLE>
<TABLE LIBRARY="JDFDATA">
<ACTION>SPECIFIED</ACTION>
<NAME ALIAS="F0116A">F0116</NAME>
<TABLEJOIN SIDE="LEFT">OUTER</TABLEJOIN>
<ROW>
<ALADD1 Visible="Y" order="" group="">
<NAME>ALADD1A</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALADD1>
<ALADD2 Visible="Y" order="" group="">
<NAME>ALADD2A</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALADD2>
<ALADD3 Visible="Y" order="" group="">
<NAME>ALADD3A</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALADD3>
<ALAN8 Visible="Y" order="" group="">
<NAME>ALAN8A</NAME>
<TYPE>NUMERIC</TYPE>
<VALUE />
<FROM>
<JOIN>F4201.SHAN8</JOIN>
</FROM>
</ALAN8>
<ALCTY1 Visible="Y" order="" group="">
<NAME>ALCTY1A</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALCTY1>
<ALADDS Visible="Y" order="" group="">
<NAME>ALADDSA</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALADDS>
<ALADDZ Visible="Y" order="" group="">
<NAME>ALADDZA</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALADDZ>
<ALEFTB Visible="Y" order="" group="">
<NAME>ALEFTBA</NAME>
<TYPE>NUMERIC</TYPE>
<VALUE />
</ALEFTB>
</ROW>
<TABLEWHERE EXIST="NO">
<VALUE>(Select 1 From JDFDATA.F0116 F0116Z Where
F0116A.ALAN8= F0116Z.ALAN8 and F0116Z.ALEFTB > F0116A.ALEFTB)</VALUE>
</TABLEWHERE>
</TABLE>
<TABLE LIBRARY="JDFDATA">
<ACTION>SPECIFIED</ACTION>
<NAME>F4006</NAME>
<TABLEJOIN SIDE="LEFT">OUTER</TABLEJOIN>
<ROW>
<OADOCO Visible="Y" order="" group="">
<NAME />
<TYPE>NUMERIC</TYPE>
<VALUE />
<FROM>
<JOIN>F4211.SDDOCO</JOIN>
</FROM>
</OADOCO>
<OADCTO Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
<FROM>
<JOIN>F4211.SDDCTO</JOIN>
</FROM>
</OADCTO>
<OAADD1 Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</OAADD1>
<OAADD2 Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</OAADD2>
<OAADD3 Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</OAADD3>
<OAADD4 Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</OAADD4>
<OAADDZ Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</OAADDZ>
<OACTY1 Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</OACTY1>
<OAADDS Visible="Y" order="" group="">
<NAME />
<TYPE>CHAR</TYPE>
<VALUE />
</OAADDS>
</ROW>
</TABLE>
<TABLE LIBRARY="JDFDATA">
<ACTION>SPECIFIED</ACTION>
<NAME ALIAS="F0116B">F0116</NAME>
<TABLEJOIN SIDE="LEFT">OUTER</TABLEJOIN>
<ROW>
<ALADD1 Visible="Y" order="" group="">
<NAME>ALADD1B</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALADD1>
<ALADD2 Visible="Y" order="" group="">
<NAME>ALADD2B</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALADD2>
<ALADD3 Visible="Y" order="" group="">
<NAME>ALADD3B</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALADD3>
<ALAN8 Visible="Y" order="" group="">
<NAME>ALAN8B</NAME>
<TYPE>NUMERIC</TYPE>
<VALUE />
<FROM>
<JOIN>F4211.SDSHAN</JOIN>
</FROM>
</ALAN8>
<ALCTY1 Visible="Y" order="" group="">
<NAME>ALCTY1B</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALCTY1>
<ALADDS Visible="Y" order="" group="">
<NAME>ALADDSB</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALADDS>
<ALADDZ Visible="Y" order="" group="">
<NAME>ALADDZB</NAME>
<TYPE>CHAR</TYPE>
<VALUE />
</ALADDZ>
<ALEFTB Visible="Y" order="" group="">
<NAME>ALEFTBB</NAME>
<TYPE>NUMERIC</TYPE>
<VALUE />
</ALEFTB>
</ROW>
<TABLEWHERE EXIST="NO">
<VALUE>(Select 1 From JDFDATA.F0116 F0116Z Where
F0116B.ALAN8= F0116Z.ALAN8 and F0116Z.ALEFTB > F0116B.ALEFTB)</VALUE>
</TABLEWHERE>
</TABLE>
</JDERequest>