PIXES scripts for testing for AES Vendor Verification

AES Site

The following scripts generate X12 601 (U. S. Customs Export Shipment Information) Version 4010 transactions for the test suite described by the U.S. Customs AES Direct site.

  • Test Case 1
  • Test Case 2
  • Test Case 3
  • Test Case 4
  • Test Case 5
  • Test Case 6
  • Test Case 7
  • Test Case 8
  • Test Case 9
  • Test Case 10
  • Test Case 11
  • Test Case 12
  • Test Case 13

    Test Case 1

     Report a vessel export shipment, filling in all required fields correctly.
    <?xml version="1.0" encoding="UTF-8"?> <!-- OBOE release 3.5.0 written by Joe McVerry American Coders, Ltd. http://www.americancoders.com --> <process> <xmlProcessor className="com.americancoders.pixes.edi.ParserForOBOE"/> <connect driverClass="com.mysql.jdbc.Driver" dbConnection="jdbc:mysql://localhost/edi_control"> <!--connect driverClass="COM.ibm.db2.jdbc.app.DB2Driver" dbConnection="jdbc:db2:edi"--> <set name="sendto">PUBLIC</set> <ediProcess mode="outbound" directory="openAS2/outgoing" > <envelope format="x12" > <select fields="nextAvail" table="controlnumber" where="id='ISA'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ISA' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ISA"> <element position="1">00</element> <element position="2"> </element> <element position="3">00</element> <element position="4"> </element> <element position="5">ZZ</element> <element position="6">DMCOGDEN </element> <element position="7">ZZ</element> <element position="8">${sendto}</element> <element position="9">@com.americancoders.util.Util.currentDate()@</element> <element position="10">@com.americancoders.util.Util.currentTime()@</element> <element position="11">U</element> <element position="12">00401</element> <element position="13">${nextAvail}</element> <element position="14">1</element> <element position="15">T</element> <element position="16">&lt;</element> </segment> <functionalgroup> <select fields="nextAvail" table="controlnumber" where="id='GS'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='GS' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="GS"> <element position="1">SE</element> <element position="2">AE TEST 0001</element> <element position="3">${sendto}</element> <element position="4">@com.americancoders.util.Util.currentDate()@</element> <element position="5">@com.americancoders.util.Util.currentTime()@</element> <element position="6">${nextAvail}</element> <element position="7">X</element> <element position="8">004010</element> </segment> <transactionset id="601AES"> <table section="header"> <select fields="nextAvail" table="controlnumber" where="id='ST'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ST' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ST"> <element position="1">601</element> <element position="2">${nextAvail}</element> </segment> <segment id="BA1"> <element position="1">N</element> <element position="3">S</element> <element position="4">AU</element> <element position="5">Raleigh Shipping</element> <element position="7">US</element> <element position="8">NC</element> <element position="10">SCAC</element> <element position="12">Admiral Overboard</element> </segment> <segment id="YNQ"> <element position="1">RZ</element> <element position="2">N</element> </segment> <segment id="YNQ"> <element position="1">QQ</element> <element position="2">N</element> </segment> <segment id="DTM"> <element position="1">274</element> <element position="2">060401</element> </segment> <segment id="P5"> <element position="1">L</element> <element position="2">D</element> <element position="3">1501</element> </segment> <segment id="REF"> <element position="1">BN</element> <element position="2">Reference Number</element> </segment> <loop id="N1"> <segment id="N1"> <element position="1">EX</element> <element position="2">Raleigh Exporters</element> <element position="3">1</element> <element position="4">010000000</element> </segment> <segment id="N2"> <element position="1">Joe McVerry</element> </segment> <segment id="N3"> <element position="1">2801 South St.</element> </segment> <segment id="N4"> <element position="1">Raleigh</element> <element position="2">NC</element> <element position="3">27605</element> <element position="4">US</element> </segment> </loop> <loop id="L13"> <segment id="L13"> <element position="5">10</element> <element position="6">10000</element> <element position="10">K</element> <element position="11">10000</element> <element position="13">OI</element> </segment> </loop> <segment id="SE"/> </table> </transactionset> <segment id="GE"/> </functionalgroup> <segment id="IEA"/> </envelope> </ediProcess> </connect> </process>

    Click to see results of Test Case 1 Script.

    Test Case 2

    Report an air export shipment, filling in all required fields correctly.
    <?xml version="1.0" encoding="UTF-8"?> <!-- OBOE release 3.5.0 written by Joe McVerry American Coders, Ltd. http://www.americancoders.com --> <process> <xmlProcessor className="com.americancoders.pixes.edi.ParserForOBOE"/> <connect driverClass="com.mysql.jdbc.Driver" dbConnection="jdbc:mysql://localhost/edi_control"> <set name="sendto">PUBLIC</set> <ediProcess mode="outbound" directory="openAS2/outgoing" > <envelope format="x12"> <select fields="nextAvail" table="controlnumber" where="id='ISA'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ISA' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ISA"> <element position="1">00</element> <element position="2"> </element> <element position="3">00</element> <element position="4"> </element> <element position="5">ZZ</element> <element position="6">DMCOGDEN </element> <element position="7">ZZ</element> <element position="8">${sendto}</element> <element position="9">@com.americancoders.util.Util.currentDate()@</element> <element position="10">@com.americancoders.util.Util.currentTime)(@</element> <element position="11">U</element> <element position="12">00401</element> <element position="13">${nextAvail}</element> <element position="14">1</element> <element position="15">T</element> <element position="16">&lt;</element> </segment> <functionalgroup> <select fields="nextAvail" table="controlnumber" where="id='GS'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='GS' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="GS"> <element position="1">SE</element> <element position="2">HILLGW201401</element> <element position="3">${sendto}</element> <element position="4">@com.americancoders.util.Util.currentDate()@</element> <element position="5">@com.americancoders.util.Util.currentTime()@</element> <element position="6">${nextAvail}</element> <element position="7">X</element> <element position="8">004010</element> </segment> <transactionset id="601AES"> <table section="header"> <select fields="nextAvail" table="controlnumber" where="id='ST'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ST' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ST"> <element position="1">601</element> <element position="2">${nextAvail}</element> </segment> <segment id="BA1"> <element position="1">N</element> <element position="3">A</element> <element position="4">AU</element> <element position="5">Raleigh Shipping</element> <element position="7">US</element> <element position="8">NC</element> <element position="10">990</element> <element position="12">NNNNNNN</element> </segment> <segment id="YNQ"> <element position="1">RZ</element> <element position="2">N</element> </segment> <segment id="YNQ"> <element position="1">QQ</element> <element position="2">N</element> </segment> <segment id="DTM"> <element position="1">274</element> <element position="2">060401</element> </segment> <segment id="P5"> <element position="1">L</element> <element position="2">D</element> <element position="3">1501</element> </segment> <segment id="REF"> <element position="1">BN</element> <element position="2">RN000001</element> </segment> <loop id="N1"> <segment id="N1"> <element position="1">EX</element> <element position="2">Raleigh Exporters</element> <element position="3">1</element> <element position="4">010000000</element> </segment> <segment id="N2"> <element position="1">Joe McVerry</element> </segment> <segment id="N3"> <element position="1">2801 South St.</element> </segment> <segment id="N4"> <element position="1">Raleigh</element> <element position="2">NC</element> <element position="3">27605</element> <element position="4">US</element> </segment> </loop> <loop id="L13"> <segment id="L13"> <element position="5">10</element> <element position="6">10000</element> <element position="10">K</element> <element position="11">10000</element> <element position="13">OI</element> </segment> <segment id="X1"> <element position="6">C33</element> </segment> </loop> <segment id="SE"/> </table> </transactionset> <segment id="GE"/> </functionalgroup> <segment id="IEA"/> </envelope> </ediProcess> </connect> </process>

    Click to see results of Test Case 2 Script.

    Test Case 3

    Report a truck export shipment, filling in all required fields correctly.
    <?xml version="1.0" encoding="UTF-8"?> <!-- OBOE release 3.5.0 written by Joe McVerry American Coders, Ltd. http://www.americancoders.com --> <process> <xmlProcessor className="com.americancoders.pixes.edi.ParserForOBOE"/> <connect driverClass="com.mysql.jdbc.Driver" dbConnection="jdbc:mysql://localhost/edi_control"> <set name="sendto">PUBLIC</set> <ediProcess mode="outbound" directory="openAS2/outgoing" > <envelope format="x12"> <select fields="nextAvail" table="controlnumber" where="id='ISA'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ISA' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ISA"> <element position="1">00</element> <element position="2"> </element> <element position="3">00</element> <element position="4"> </element> <element position="5">ZZ</element> <element position="6">DMCOGDEN </element> <element position="7">ZZ</element> <element position="8">${sendto}</element> <element position="9">@com.americancoders.util.Util.currentDate()@</element> <element position="10">@com.americancoders.util.Util.currentTime()@</element> <element position="11">U</element> <element position="12">00401</element> <element position="13">${nextAvail}</element> <element position="14">1</element> <element position="15">T</element> <element position="16">&lt;</element> </segment> <functionalgroup> <select fields="nextAvail" table="controlnumber" where="id='GS'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='GS' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="GS"> <element position="1">SE</element> <element position="2">HILLGW201401</element> <element position="3">${sendto}</element> <element position="4">@com.americancoders.util.Util.currentDate()@</element> <element position="5">@com.americancoders.util.Util.currentTime()@</element> <element position="6">${nextAvail}</element> <element position="7">X</element> <element position="8">004010</element> </segment> <transactionset id="601AES"> <table section="header"> <select fields="nextAvail" table="controlnumber" where="id='ST'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ST' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ST"> <element position="1">601</element> <element position="2">${nextAvail}</element> </segment> <segment id="BA1"> <element position="1">N</element> <element position="3">J</element> <element position="4">CA</element> <element position="5">Raleigh Shipping</element> <element position="7">US</element> <element position="8">NC</element> <element position="10">990</element> <element position="12">NNNNNNN</element> </segment> <segment id="YNQ"> <element position="1">RZ</element> <element position="2">N</element> </segment> <segment id="YNQ"> <element position="1">QQ</element> <element position="2">N</element> </segment> <segment id="DTM"> <element position="1">274</element> <element position="2">060401</element> </segment> <segment id="P5"> <element position="1">L</element> <element position="2">D</element> <element position="3">1501</element> </segment> <segment id="REF"> <element position="1">BN</element> <element position="2">RN000001</element> </segment> <loop id="N1"> <segment id="N1"> <element position="1">EX</element> <element position="2">Raleigh Exporters</element> <element position="3">1</element> <element position="4">010000000</element> </segment> <segment id="N2"> <element position="1">Joe McVerry</element> </segment> <segment id="N3"> <element position="1">2801 South St.</element> </segment> <segment id="N4"> <element position="1">Raleigh</element> <element position="2">NC</element> <element position="3">27605</element> <element position="4">US</element> </segment> </loop> <loop id="L13"> <segment id="L13"> <element position="5">10</element> <element position="6">10000</element> <element position="10">K</element> <element position="11">10000</element> <element position="13">OI</element> </segment> <segment id="X1"> <element position="6">C33</element> </segment> </loop> <segment id="SE"/> </table> </transactionset> <segment id="GE"/> </functionalgroup> <segment id="IEA"/> </envelope> </ediProcess> </connect> </process>

    Click to see results of Test Case 3 Script.

    Test Case 4

    Report a rail export shipment, filling in all required fields correctly.
    Notes:
  • One of the four shipments above must report an export shipment that contains two different commodities.
  • One of the commodities must require two units of measure.
    <?xml version="1.0" encoding="UTF-8"?> <!-- OBOE release 3.5.0 written by Joe McVerry American Coders, Ltd. http://www.americancoders.com --> <process> <xmlProcessor className="com.americancoders.pixes.edi.ParserForOBOE"/> <connect driverClass="com.mysql.jdbc.Driver" dbConnection="jdbc:mysql://localhost/edi_control"> <set name="sendto">PUBLIC</set> <ediProcess mode="outbound" directory="openAS2/outgoing" > <envelope format="x12"> <select fields="nextAvail" table="controlnumber" where="id='ISA'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ISA' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ISA"> <element position="1">00</element> <element position="2"> </element> <element position="3">00</element> <element position="4"> </element> <element position="5">ZZ</element> <element position="6">DMCOGDEN </element> <element position="7">ZZ</element> <element position="8">${sendto}</element> <element position="9">@com.americancoders.util.Util.currentDate()@</element> <element position="10">@com.americancoders.util.Util.currentTime()@</element> <element position="11">U</element> <element position="12">00401</element> <element position="13">${nextAvail}</element> <element position="14">1</element> <element position="15">T</element> <element position="16">&lt;</element> </segment> <functionalgroup> <select fields="nextAvail" table="controlnumber" where="id='GS'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='GS' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="GS"> <element position="1">SE</element> <element position="2">HILLGW201401</element> <element position="3">${sendto}</element> <element position="4">@com.americancoders.util.Util.currentDate()@</element> <element position="5">@com.americancoders.util.Util.currentTime()@</element> <element position="6">${nextAvail}</element> <element position="7">X</element> <element position="8">004010</element> </segment> <transactionset id="601AES"> <table section="header"> <select fields="nextAvail" table="controlnumber" where="id='ST'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ST' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ST"> <element position="1">601</element> <element position="2">${nextAvail}</element> </segment> <segment id="BA1"> <element position="1">N</element> <element position="3">R</element> <element position="4">CA</element> <element position="5">Raleigh Shipping</element> <element position="7">US</element> <element position="8">NC</element> <element position="10">990</element> <element position="12">NNNNNNN</element> </segment> <segment id="YNQ"> <element position="1">RZ</element> <element position="2">N</element> </segment> <segment id="YNQ"> <element position="1">QQ</element> <element position="2">N</element> </segment> <segment id="DTM"> <element position="1">274</element> <element position="2">060401</element> </segment> <segment id="P5"> <element position="1">L</element> <element position="2">D</element> <element position="3">1501</element> </segment> <segment id="REF"> <element position="1">BN</element> <element position="2">RN000001</element> </segment> <loop id="N1"> <segment id="N1"> <element position="1">EX</element> <element position="2">Raleigh Exporters</element> <element position="3">1</element> <element position="4">010000000</element> </segment> <segment id="N2"> <element position="1">Joe McVerry</element> </segment> <segment id="N3"> <element position="1">2801 South St.</element> </segment> <segment id="N4"> <element position="1">Raleigh</element> <element position="2">NC</element> <element position="3">27605</element> <element position="4">US</element> </segment> </loop> <loop id="L13"> <segment id="L13"> <element position="5">10</element> <element position="6">10000</element> <element position="10">K</element> <element position="11">10000</element> <element position="13">OI</element> </segment> <segment id="X1"> <element position="6">C33</element> </segment> <segment id="L13"> <element position="5">10</element> <element position="6">10000</element> <element position="8">BBL</element> <element position="9">10000</element> <element position="10">K</element> <element position="11">10000</element> <element position="13">OI</element> </segment> <segment id="X1"> <element position="6">C33</element> </segment> </loop> <segment id="SE"/> </table> </transactionset> <segment id="GE"/> </functionalgroup> <segment id="IEA"/> </envelope> </ediProcess> </connect> </process>

    Click to see results of Test Case 4 Script.

    Test Case 5

    Report an export shipment that contains one commodity line with a first quantity greater than 100,000,000.
    <?xml version="1.0" encoding="UTF-8"?> <!-- OBOE release 3.5.0 written by Joe McVerry American Coders, Ltd. http://www.americancoders.com --> <process> <xmlProcessor className="com.americancoders.pixes.edi.ParserForOBOE"/> <connect driverClass="com.mysql.jdbc.Driver" dbConnection="jdbc:mysql://localhost/edi_control"> <set name="sendto">PUBLIC</set> <ediProcess mode="outbound" directory="openAS2/outgoing" > <envelope format="x12"> <select fields="nextAvail" table="controlnumber" where="id='ISA'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ISA' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ISA"> <element position="1">03</element> <element position="2">${sending}</element> <element position="3">00</element> <element position="4"> </element> <element position="5">01</element> <element position="6">${sending}</element> <element position="7">ZZ</element> <element position="8">${sendto}</element> <element position="9">@com.americancoders.util.Util.currentDate()@</element> <element position="10">@com.americancoders.util.Util.currentTime()@</element> <element position="11">U</element> <element position="12">00401</element> <element position="13">${nextAvail}</element> <element position="14">1</element> <element position="15">T</element> <element position="16">&lt;</element> </segment> <functionalgroup> <select fields="nextAvail" table="controlnumber" where="id='GS'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='GS' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="GS"> <element position="1">SE</element> <element position="2">${sending}</element> <element position="3">${sendto}</element> <element position="4">@com.americancoders.util.Util.currentDate()@</element> <element position="5">@com.americancoders.util.Util.currentTime()@</element> <element position="6">${nextAvail}</element> <element position="7">X</element> <element position="8">004010</element> </segment> <transactionset id="601AES"> <table section="header"> <select fields="nextAvail" table="controlnumber" where="id='ST'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ST' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ST"> <element position="1">601</element> <element position="2">${nextAvail}</element> </segment> <segment id="BA1"> <element position="1">N</element> <element position="3">R</element> <element position="4">MX</element> <element position="5">Raleigh Shipping</element> <element position="7">US</element> <element position="8">NC</element> <element position="10">AFLR</element> <element position="12">ALABAMA AND FLORIDA RAILROAD</element> </segment> <segment id="YNQ"> <element position="1">RZ</element> <element position="2">N</element> </segment> <segment id="YNQ"> <element position="1">QQ</element> <element position="2">N</element> </segment> <segment id="DTM"> <element position="1">274</element> <element position="2">@com.americancoders.util.Util.currentDate()@</element> </segment> <segment id="P5"> <element position="1">L</element> <element position="2">D</element> <element position="3">2402</element> </segment> <segment id="REF"> <element position="1">BN</element> <element position="2">RN00000${testCase}</element> </segment> <loop id="N1"> <segment id="N1"> <element position="1">EX</element> <element position="2">Raleigh Exporters</element> <element position="3">1</element> <element position="4">010000000</element> </segment> <segment id="N2"> <element position="1">Joe McVerry</element> <element position="2">9198462014</element> </segment> <segment id="N3"> <element position="1">2801 South St.</element> </segment> <segment id="N4"> <element position="1">Raleigh</element> <element position="2">NC</element> <element position="3">27605</element> <element position="4">US</element> </segment> </loop> <loop id="N1"> <segment id="N1"> <element position="1">CN</element> <element position="2">Furman Importers</element> <element position="3">ZZ</element> </segment> <segment id="N2"> <element position="1">Ignatz McVerry</element> <element position="2">00110099</element> </segment> <segment id="N3"> <element position="1">2801 North St.</element> </segment> <segment id="N4"> <element position="1">ACAPULCO</element> <element position="2">CM</element> <element position="4">MX</element> </segment> </loop> <loop id="L13"> <segment id="L13"> <element position="1">B</element> <element position="2">8482910050</element> <element position="3">KG</element> <element position="4">10000</element> <element position="5">10</element> <element position="6">10000</element> <element position="10">K</element> <element position="11">10000</element> <element position="12">TAPERED ROLLERS FOR ROLLER BEARINGS</element> <element position="13">CH</element> <element position="14">F</element> </segment> <segment id="MAN"> <element position="2">Script Test ${testCase}</element> </segment> <segment id="X1"> <element position="6">C33</element> </segment> </loop> <segment id="SE"/> </table> </transactionset> <segment id="GE"/> </functionalgroup> <segment id="IEA"/> </envelope> </ediProcess> </connect> </process>

    Click to see results of Test Case 5 Script.

    Test Case 6

    Step 5 generated a Census Warning. The warning message requires you to correct quantity 1. Correct quantity 1 and resend the transmission.
    <?xml version="1.0" encoding="UTF-8"?> <!-- OBOE release 3.5.0 written by Joe McVerry American Coders, Ltd. http://www.americancoders.com --> <process> <xmlProcessor className="com.americancoders.pixes.edi.ParserForOBOE"/> <connect driverClass="com.mysql.jdbc.Driver" dbConnection="jdbc:mysql://localhost/edi_control"> <!--connect driverClass="COM.ibm.db2.jdbc.app.DB2Driver" dbConnection="jdbc:db2:edi"--> <set name="sending">783563851</set> <set name="sendto">USCSAESTEST</set> <set name="testCase">6</set> <select fields="status" table="testcase" where="id='${testCase}'"> </select> <if test='${status}' operator='ne' to='0'> AESTest${testCase} already run <exit/> </if> <ediProcess mode="outbound" directory="openAS2/outgoing" > <envelope format="x12"> <select fields="nextAvail" table="controlnumber" where="id='ISA'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ISA' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ISA"> <element position="1">03</element> <element position="2">${sending}</element> <element position="3">00</element> <element position="4"> </element> <element position="5">01</element> <element position="6">${sending}</element> <element position="7">ZZ</element> <element position="8">${sendto}</element> <element position="9">@com.americancoders.util.Util.currentDate()@</element> <element position="10">@com.americancoders.util.Util.currentTime()@</element> <element position="11">U</element> <element position="12">00401</element> <element position="13">${nextAvail}</element> <element position="14">1</element> <element position="15">T</element> <element position="16">&lt;</element> </segment> <functionalgroup> <select fields="nextAvail" table="controlnumber" where="id='GS'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='GS' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="GS"> <element position="1">SE</element> <element position="2">${sending}</element> <element position="3">${sendto}</element> <element position="4">@com.americancoders.util.Util.currentDate()@</element> <element position="5">@com.americancoders.util.Util.currentTime()@</element> <element position="6">${nextAvail}</element> <element position="7">X</element> <element position="8">004010</element> </segment> <transactionset id="601AES"> <table section="header"> <select fields="nextAvail" table="controlnumber" where="id='ST'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ST' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ST"> <element position="1">601</element> <element position="2">${nextAvail}</element> </segment> <segment id="BA1"> <element position="1">N</element> <element position="3">S</element> <element position="4">MX</element> <element position="5">RH${nextAvail}</element> <element position="7">US</element> <element position="8">NC</element> <element position="10">CARU</element> <element position="12">Admiral Overboard</element> </segment> <segment id="YNQ"> <element position="1">RZ</element> <element position="2">N</element> </segment> <segment id="YNQ"> <element position="1">QQ</element> <element position="2">N</element> </segment> <segment id="DTM"> <element position="1">274</element> <element position="2">@com.americancoders.util.Util.currentDate()@</element> </segment> <segment id="P5"> <element position="1">L</element> <element position="2">D</element> <element position="3">1501</element> </segment> <segment id="P5"> <element position="1">D</element> <element position="2">K</element> <element position="3">20162</element> </segment> <segment id="REF"> <element position="1">BN</element> <element position="2">RN00000$6</element> </segment> <loop id="N1"> <segment id="N1"> <element position="1">EX</element> <element position="2">Raleigh Exporters</element> <element position="3">1</element> <element position="4">010000000</element> </segment> <segment id="N2"> <element position="1">Joe McVerry</element> <element position="2">9198462014</element> </segment> <segment id="N3"> <element position="1">2801 South St.</element> </segment> <segment id="N4"> <element position="1">Raleigh</element> <element position="2">NC</element> <element position="3">27605</element> <element position="4">US</element> </segment> </loop> <loop id="N1"> <segment id="N1"> <element position="1">CN</element> <element position="2">Furman Importers</element> <element position="3">ZZ</element> </segment> <segment id="N2"> <element position="1">John McVerry</element> <element position="2">00110099</element> </segment> <segment id="N3"> <element position="1">2801 North St.</element> </segment> <segment id="N4"> <element position="1">CANCUN</element> <element position="2">CM</element> <element position="4">MX</element> </segment> </loop> <loop id="L13"> <segment id="L13"> <element position="1">B</element> <element position="2">8482910050</element> <element position="3">KG</element> <element position="4">10000</element> <element position="5">10</element> <element position="6">10000</element> <element position="10">K</element> <element position="11">10000</element> <element position="12">TAPERED ROLLERS FOR ROLLER BEARINGS</element> <element position="13">CH</element> <element position="14">F</element> </segment> <segment id="MAN"> <element position="2">Script Test ${testCase}</element> </segment> <segment id="X1"> <element position="6">C33</element> </segment> </loop> <segment id="SE"/> </table> </transactionset> <segment id="GE"/> </functionalgroup> <segment id="IEA"/> </envelope> </ediProcess> <update table="testCase" fields="status" values="1" where="id='${testCase}'"/> </connect> </process>

    Click to see results of Test Case 6 Script.

    Test Case 7

    Report an export shipment and identify the contents of that shipment as household goods or other types of commodities that require the reporting of limited information.
    <?xml version="1.0" encoding="UTF-8"?> <!-- OBOE release 3.5.0 written by Joe McVerry American Coders, Ltd. http://www.americancoders.com --> <process> <xmlProcessor className="com.americancoders.pixes.edi.ParserForOBOE"/> <connect driverClass="com.mysql.jdbc.Driver" dbConnection="jdbc:mysql://localhost/edi_control"> <!--connect driverClass="COM.ibm.db2.jdbc.app.DB2Driver" dbConnection="jdbc:db2:edi"--> <set name="sending">783563851</set> <set name="sendto">USCSAESTEST</set> <set name="testCase">7</set> <select fields="status" table="testcase" where="id='${testCase}'"> </select> <if test='${status}' operator='ne' to='0'> AESTest${testCase} already run <exit/> </if> <ediProcess mode="outbound" directory="openAS2/outgoing" > <envelope format="x12"> <select fields="nextAvail" table="controlnumber" where="id='ISA'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ISA' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ISA"> <element position="1">03</element> <element position="2">${sending}</element> <element position="3">00</element> <element position="4"> </element> <element position="5">01</element> <element position="6">${sending}</element> <element position="7">ZZ</element> <element position="8">${sendto}</element> <element position="9">@com.americancoders.util.Util.currentDate()@</element> <element position="10">@com.americancoders.util.Util.currentTime()@</element> <element position="11">U</element> <element position="12">00401</element> <element position="13">${nextAvail}</element> <element position="14">1</element> <element position="15">T</element> <element position="16">&lt;</element> </segment> <functionalgroup> <select fields="nextAvail" table="controlnumber" where="id='GS'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='GS' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="GS"> <element position="1">SE</element> <element position="2">${sending}</element> <element position="3">${sendto}</element> <element position="4">@com.americancoders.util.Util.currentDate()@</element> <element position="5">@com.americancoders.util.Util.currentTime()@</element> <element position="6">${nextAvail}</element> <element position="7">X</element> <element position="8">004010</element> </segment> <transactionset id="601AES"> <table section="header"> <select fields="nextAvail" table="controlnumber" where="id='ST'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ST' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ST"> <element position="1">601</element> <element position="2">${nextAvail}</element> </segment> <segment id="BA1"> <element position="1">N</element> <element position="3">S</element> <element position="4">MX</element> <element position="5">RH${nextAvail}</element> <element position="7">US</element> <element position="8">NC</element> <element position="10">CARU</element> <element position="12">Admiral Overboard</element> </segment> <segment id="YNQ"> <element position="1">RZ</element> <element position="2">N</element> </segment> <segment id="YNQ"> <element position="1">QQ</element> <element position="2">N</element> </segment> <segment id="DTM"> <element position="1">274</element> <element position="2">@com.americancoders.util.Util.currentDate()@</element> </segment> <segment id="P5"> <element position="1">L</element> <element position="2">D</element> <element position="3">1501</element> </segment> <segment id="P5"> <element position="1">D</element> <element position="2">K</element> <element position="3">20162</element> </segment> <segment id="REF"> <element position="1">BN</element> <element position="2">RN00000$6</element> </segment> <loop id="N1"> <segment id="N1"> <element position="1">EX</element> <element position="2">Raleigh Exporters</element> <element position="3">1</element> <element position="4">010000000</element> </segment> <segment id="N2"> <element position="1">Joe McVerry</element> <element position="2">9198462014</element> </segment> <segment id="N3"> <element position="1">2801 South St.</element> </segment> <segment id="N4"> <element position="1">Raleigh</element> <element position="2">NC</element> <element position="3">27605</element> <element position="4">US</element> </segment> </loop> <loop id="N1"> <segment id="N1"> <element position="1">CN</element> <element position="2">Furman Importers</element> <element position="3">ZZ</element> </segment> <segment id="N2"> <element position="1">John McVerry</element> <element position="2">00110099</element> </segment> <segment id="N3"> <element position="1">2801 North St.</element> </segment> <segment id="N4"> <element position="1">CANCUN</element> <element position="2">CM</element> <element position="4">MX</element> </segment> </loop> <loop id="L13"> <segment id="L13"> <element position="1">B</element> <element position="2">3924905500</element> <element position="3">X</element> <element position="4">10000</element> <element position="5">10</element> <element position="6">100</element> <element position="10">K</element> <element position="11">100</element> <element position="12">HOUSEHOLD ARTICLES &amp; TOILET ARTICLES,OF PLASTIC,NESOI</element> <element position="13">CH</element> <element position="14">F</element> </segment> <segment id="MAN"> <element position="2">Script Test ${testCase}</element> </segment> <segment id="X1"> <element position="6">C33</element> </segment> </loop> <segment id="SE"/> </table> </transactionset> <segment id="GE"/> </functionalgroup> <segment id="IEA"/> </envelope> </ediProcess> <update table="testCase" fields="status" values="1" where="id='${testCase}'"/> </connect> </process>

    Click to see results of Test Case 7 Script.

    Test Case 8

    Report an export shipment that is accepted by AES and then delete that shipment.

    Click to see results of Test Case 8 Script.

    Test Case 9

    If you ship from Puerto Rico you must report an export shipment leaving a Customs port in Puerto Rico (example: San Juan, PR) and destined for the United States.

    Click to see results of Test Case 9 Script.

    Test Case 10

    If you ship to Puerto Rico, you must report an export shipment leaving a Customs port in the United States (example: New York, NY) and destined for Puerto Rico.

    Click to see results of Test Case 10 Script.

    Test Case 11

    If you handle BXA license shipments, you must send an export shipment that requires a BXA license and ECCN number.
    <?xml version="1.0" encoding="UTF-8"?> <!-- OBOE release 3.5.0 written by Joe McVerry American Coders, Ltd. http://www.americancoders.com --> <process> <xmlProcessor className="com.americancoders.pixes.edi.ParserForOBOE"/> <connect driverClass="com.mysql.jdbc.Driver" dbConnection="jdbc:mysql://localhost/edi_control"> <!--connect driverClass="COM.ibm.db2.jdbc.app.DB2Driver" dbConnection="jdbc:db2:edi"--> <ediProcess mode="outbound" directory="openAS2/outgoing" > <set name="sending">783563851</set> <set name="sendto">USCSAESTEST</set> <set name="testCase">11</set> <select fields="status" table="testcase" where="id='${testCase}'"> </select> <if test='${status}' operator='ne' to='0'> AESTest${testCase} already run <exit/> </if> <envelope format="x12"> <select fields="nextAvail" table="controlnumber" where="id='ISA'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ISA' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ISA"> <element position="1">03</element> <element position="2">${sending}</element> <element position="3">00</element> <element position="4"> </element> <element position="5">01</element> <element position="6">${sending}</element> <element position="7">ZZ</element> <element position="8">${sendto}</element> <element position="9">@com.americancoders.util.Util.currentDate()@</element> <element position="10">@com.americancoders.util.Util.currentTime()@</element> <element position="11">U</element> <element position="12">00401</element> <element position="13">${nextAvail}</element> <element position="14">1</element> <element position="15">T</element> <element position="16">&lt;</element> </segment> <functionalgroup> <select fields="nextAvail" table="controlnumber" where="id='GS'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='GS' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="GS"> <element position="1">SE</element> <element position="2">${sending}</element> <element position="3">${sendto}</element> <element position="4">@com.americancoders.util.Util.currentDate()@</element> <element position="5">@com.americancoders.util.Util.currentTime()@</element> <element position="6">${nextAvail}</element> <element position="7">X</element> <element position="8">004010</element> </segment> <transactionset id="601AES"> <table section="header"> <select fields="nextAvail" table="controlnumber" where="id='ST'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ST' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ST"> <element position="1">601</element> <element position="2">${nextAvail}</element> </segment> <segment id="BA1"> <element position="1">N</element> <element position="3">S</element> <element position="4">MX</element> <element position="5">RH${nextAvail}</element> <element position="7">US</element> <element position="8">NC</element> <element position="10">CARU</element> <element position="12">Admiral Overboard</element> </segment> <segment id="YNQ"> <element position="1">RZ</element> <element position="2">N</element> </segment> <segment id="YNQ"> <element position="1">QQ</element> <element position="2">N</element> </segment> <segment id="DTM"> <element position="1">274</element> <element position="2">@com.americancoders.util.Util.currentDate()@</element> </segment> <segment id="P5"> <element position="1">L</element> <element position="2">D</element> <element position="3">1501</element> </segment> <segment id="P5"> <element position="1">D</element> <element position="2">K</element> <element position="3">20162</element> </segment> <segment id="REF"> <element position="1">BN</element> <element position="2">RN00000$6</element> </segment> <loop id="N1"> <segment id="N1"> <element position="1">EX</element> <element position="2">Raleigh Exporters</element> <element position="3">1</element> <element position="4">010000000</element> </segment> <segment id="N2"> <element position="1">Joe McVerry</element> <element position="2">9198462014</element> </segment> <segment id="N3"> <element position="1">2801 South St.</element> </segment> <segment id="N4"> <element position="1">Raleigh</element> <element position="2">NC</element> <element position="3">27605</element> <element position="4">US</element> </segment> </loop> <loop id="N1"> <segment id="N1"> <element position="1">CN</element> <element position="2">Furman Importers</element> <element position="3">ZZ</element> </segment> <segment id="N2"> <element position="1">John McVerry</element> <element position="2">00110099</element> </segment> <segment id="N3"> <element position="1">2801 North St.</element> </segment> <segment id="N4"> <element position="1">CANCUN</element> <element position="2">CM</element> <element position="4">MX</element> </segment> </loop> <loop id="L13"> <segment id="L13"> <element position="1">B</element> <element position="2">8471100000</element> <element position="3">NO</element> <element position="4">13</element> <element position="5">10</element> <element position="6">100</element> <element position="10">K</element> <element position="11">100</element> <element position="12">Analog or hybrid automatic data processing machines</element> <element position="13">CH</element> <element position="14">F</element> </segment> <segment id="MAN"> <element position="2">Script Test ${testCase}</element> </segment> <segment id="X1"> <element position="2">1</element> <element position="3">4B994</element> <element position="6">C30</element> <element position="16">4B994</element> </segment> </loop> <segment id="SE"/> </table> </transactionset> <segment id="GE"/> </functionalgroup> <segment id="IEA"/> </envelope> <update table="testCase" fields="status" values="1" where="id='${testCase}'"/> </ediProcess> </connect> </process>

    Click to see results of Test Case 11 Script.

    Test Case 12

    If you handle State or ODTC license shipments you must send an export shipment that requires a State Department, Office of Defense Trade Controls (ODTC) License Number or License Exemption Citation. If you need license numbers for the purpose of testing, please use the following. Values must range from $2,501 and $3,000:
    For license type S05 use numbers ck1001 through ck1030
    For license type S61 use numbers ck1031 through ck1035
    For license type S73 use numbers ck1036 through ck1040
    <?xml version="1.0" encoding="UTF-8"?> <!-- OBOE release 3.5.0 written by Joe McVerry American Coders, Ltd. http://www.americancoders.com --> <process> <xmlProcessor className="com.americancoders.pixes.edi.ParserForOBOE"/> <connect driverClass="com.mysql.jdbc.Driver" dbConnection="jdbc:mysql://localhost/edi_control"> <!--connect driverClass="COM.ibm.db2.jdbc.app.DB2Driver" dbConnection="jdbc:db2:edi"--> <ediProcess mode="outbound" directory="openAS2/outgoing" > <set name="sending">783563851</set> <set name="sendto">USCSAESTEST</set> <set name="testCase">12</set> <select fields="status" table="testcase" where="id='${testCase}'"> </select> <if test='${status}' operator='ne' to='0'> AESTest${testCase} already run <exit/> </if> <envelope format="x12"> <select fields="nextAvail" table="controlnumber" where="id='ISA'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ISA' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ISA"> <element position="1">03</element> <element position="2">${sending}</element> <element position="3">00</element> <element position="4"> </element> <element position="5">01</element> <element position="6">${sending}</element> <element position="7">ZZ</element> <element position="8">${sendto}</element> <element position="9">@com.americancoders.util.Util.currentDate()@</element> <element position="10">@com.americancoders.util.Util.currentTime()@</element> <element position="11">U</element> <element position="12">00401</element> <element position="13">${nextAvail}</element> <element position="14">1</element> <element position="15">T</element> <element position="16">&lt;</element> </segment> <functionalgroup> <select fields="nextAvail" table="controlnumber" where="id='GS'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='GS' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="GS"> <element position="1">SE</element> <element position="2">${sending}</element> <element position="3">${sendto}</element> <element position="4">@com.americancoders.util.Util.currentDate()@</element> <element position="5">@com.americancoders.util.Util.currentTime()@</element> <element position="6">${nextAvail}</element> <element position="7">X</element> <element position="8">004010</element> </segment> <transactionset id="601AES"> <table section="header"> <select fields="nextAvail" table="controlnumber" where="id='ST'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ST' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ST"> <element position="1">601</element> <element position="2">${nextAvail}</element> </segment> <segment id="BA1"> <element position="1">N</element> <element position="3">S</element> <element position="4">MX</element> <element position="5">RH${nextAvail}</element> <element position="7">US</element> <element position="8">NC</element> <element position="10">CARU</element> <element position="12">Admiral Overboard</element> </segment> <segment id="YNQ"> <element position="1">RZ</element> <element position="2">N</element> </segment> <segment id="YNQ"> <element position="1">QQ</element> <element position="2">N</element> </segment> <segment id="DTM"> <element position="1">274</element> <element position="2">@com.americancoders.util.Util.currentDate()@</element> </segment> <segment id="P5"> <element position="1">L</element> <element position="2">D</element> <element position="3">1501</element> </segment> <segment id="P5"> <element position="1">D</element> <element position="2">K</element> <element position="3">20162</element> </segment> <segment id="REF"> <element position="1">BN</element> <element position="2">RN00000$6</element> </segment> <loop id="N1"> <segment id="N1"> <element position="1">EX</element> <element position="2">Raleigh Exporters</element> <element position="3">1</element> <element position="4">010000000</element> </segment> <segment id="N2"> <element position="1">Joe McVerry</element> <element position="2">9198462014</element> </segment> <segment id="N3"> <element position="1">2801 South St.</element> </segment> <segment id="N4"> <element position="1">Raleigh</element> <element position="2">NC</element> <element position="3">27605</element> <element position="4">US</element> </segment> </loop> <loop id="N1"> <segment id="N1"> <element position="1">CN</element> <element position="2">Furman Importers</element> <element position="3">ZZ</element> </segment> <segment id="N2"> <element position="1">John McVerry</element> <element position="2">00110099</element> </segment> <segment id="N3"> <element position="1">2801 North St.</element> </segment> <segment id="N4"> <element position="1">CANCUN</element> <element position="2">CM</element> <element position="4">MX</element> </segment> </loop> <loop id="L13"> <segment id="L13"> <element position="1">B</element> <element position="2">8471100000</element> <element position="3">NO</element> <element position="4">13</element> <element position="5">10</element> <element position="6">100</element> <element position="10">K</element> <element position="11">100</element> <element position="12">Analog or hybrid automatic data processing machines</element> <element position="13">CH</element> <element position="14">F</element> </segment> <segment id="MAN"> <element position="2">Script Test ${testCase}</element> </segment> <segment id="X1"> <element position="2">ck1001</element> <element position="3">1</element> <element position="5">11</element> <element position="6">S05</element> <element position="8">Reg No.</element> <element position="10">13</element> <element position="13">NUM</element> <element position="15">N</element> <element position="16">4B994</element> </segment> </loop> <segment id="SE"/> </table> </transactionset> <segment id="GE"/> </functionalgroup> <segment id="IEA"/> </envelope> <update table="testCase" fields="status" values="1" where="id='${testCase}'"/> </ediProcess> </connect> </process>

    Click to see results of Test Case 12 Script.

    Test Case 13

    If you ship used vehicles, you must send an export shipment that contains a commodity line identifying two used vehicles.
    The following VINs may be used for the purpose of this test: 1FDKF37M4NNA50519, 1G3BP83E2MW303505, 1G1BN69H3GY172453, and 1G1BL53E3PR123603.
    <?xml version="1.0" encoding="UTF-8"?> <!-- OBOE release 3.5.0 written by Joe McVerry American Coders, Ltd. http://www.americancoders.com --> <process> <xmlProcessor className="com.americancoders.pixes.edi.ParserForOBOE"/> <connect driverClass="com.mysql.jdbc.Driver" dbConnection="jdbc:mysql://localhost/edi_control"> <!--connect driverClass="COM.ibm.db2.jdbc.app.DB2Driver" dbConnection="jdbc:db2:edi"--> <ediProcess mode="outbound" directory="openAS2/outgoing" > <set name="sending">783563851</set> <set name="sendto">USCSAESTEST</set> <set name="testCase">13</set> <select fields="status" table="testcase" where="id='${testCase}'"> </select> <if test='${status}' operator='ne' to='0'> AESTest${testCase} already run <exit/> </if> <envelope format="x12"> <select fields="nextAvail" table="controlnumber" where="id='ISA'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ISA' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ISA"> <element position="1">03</element> <element position="2">${sending}</element> <element position="3">00</element> <element position="4"> </element> <element position="5">01</element> <element position="6">${sending}</element> <element position="7">ZZ</element> <element position="8">${sendto}</element> <element position="9">@com.americancoders.util.Util.currentDate()@</element> <element position="10">@com.americancoders.util.Util.currentTime()@</element> <element position="11">U</element> <element position="12">00401</element> <element position="13">${nextAvail}</element> <element position="14">1</element> <element position="15">T</element> <element position="16">&lt;</element> </segment> <functionalgroup> <select fields="nextAvail" table="controlnumber" where="id='GS'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='GS' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="GS"> <element position="1">SE</element> <element position="2">${sending}</element> <element position="3">${sendto}</element> <element position="4">@com.americancoders.util.Util.currentDate()@</element> <element position="5">@com.americancoders.util.Util.currentTime()@</element> <element position="6">${nextAvail}</element> <element position="7">X</element> <element position="8">004010</element> </segment> <transactionset id="601AES"> <table section="header"> <select fields="nextAvail" table="controlnumber" where="id='ST'"> <compute name="nextAvail">nextAvail+1</compute> <update table="controlnumber" fields="nextAvail" values="${nextAvail}" where="id='ST' and nextAvail = ${nextAvail}-1"/> <break/> </select> <segment id="ST"> <element position="1">601</element> <element position="2">${nextAvail}</element> </segment> <segment id="BA1"> <element position="1">N</element> <element position="3">S</element> <element position="4">MX</element> <element position="5">RH${nextAvail}</element> <element position="7">US</element> <element position="8">NC</element> <element position="10">CARU</element> <element position="12">Admiral Overboard</element> </segment> <segment id="YNQ"> <element position="1">RZ</element> <element position="2">N</element> </segment> <segment id="YNQ"> <element position="1">QQ</element> <element position="2">N</element> </segment> <segment id="DTM"> <element position="1">274</element> <element position="2">@com.americancoders.util.Util.currentDate()@</element> </segment> <segment id="P5"> <element position="1">L</element> <element position="2">D</element> <element position="3">1501</element> </segment> <segment id="P5"> <element position="1">D</element> <element position="2">K</element> <element position="3">20162</element> </segment> <segment id="REF"> <element position="1">BN</element> <element position="2">RN00000$6</element> </segment> <loop id="N1"> <segment id="N1"> <element position="1">EX</element> <element position="2">Raleigh Exporters</element> <element position="3">1</element> <element position="4">010000000</element> </segment> <segment id="N2"> <element position="1">Joe McVerry</element> <element position="2">9198462014</element> </segment> <segment id="N3"> <element position="1">2801 South St.</element> </segment> <segment id="N4"> <element position="1">Raleigh</element> <element position="2">NC</element> <element position="3">27605</element> <element position="4">US</element> </segment> </loop> <loop id="N1"> <segment id="N1"> <element position="1">CN</element> <element position="2">Furman Importers</element> <element position="3">ZZ</element> </segment> <segment id="N2"> <element position="1">John McVerry</element> <element position="2">00110099</element> </segment> <segment id="N3"> <element position="1">2801 North St.</element> </segment> <segment id="N4"> <element position="1">CANCUN</element> <element position="2">CM</element> <element position="4">MX</element> </segment> </loop> <loop id="L13"> <segment id="L13"> <element position="1">B</element> <element position="2">8707100020</element> <element position="3">NO</element> <element position="4">2</element> <element position="5">10</element> <element position="6">100</element> <element position="11">6000</element> <element position="12">Automobiles</element> <element position="13">CH</element> <element position="14">F</element> </segment> <segment id="MAN"> <element position="2">Script Test ${testCase}</element> </segment> <segment id="X1"> <element position="6">C33</element> </segment> <segment id="VEH"> <element position="2">1FDKF37M4NNA50519</element> <element position="5">V</element> <element position="9">NC00000001</element> <element position="10">NC</element> </segment> <segment id="VEH"> <element position="2">1G1BL53E3PR123603</element> <element position="5">V</element> <element position="9">NC00000002</element> <element position="10">NC</element> </segment> </loop> <segment id="SE"/> </table> </transactionset> <segment id="GE"/> </functionalgroup> <segment id="IEA"/> </envelope> <update table="testCase" fields="status" values="1" where="id='${testCase}'"/> </ediProcess> </connect> </process>

    Click to see results of Test Case 13 Script.