var myobj = [
    {"orderid":"515","customerid":"1234","customer":"Durlock S.A.","invaddr":"Av. Corrientes 327, 3rd Floor,Buenos Aires - C1043AAD,ARGENTINA","delivaddr":"","deliverydate":"6-10-2020","respsalesperson":"Kim Berner","comment":"please send as soon as possible","totalprice":"371.82",
        "products": [
            {"code":"AC100/E17", "product":"Npt Stainless Steel Connector External Thread Barb Hose Nozzle Hose Measurement: 3/8 Inch X 15Mm", "description":"Color: Silver Measurement: Nominal Bore(inch) X Outer Diameter(mm) 3/8 inch x 15 mm Package Included: 1 x Male Thread Pipe Fitting Note:Light shooting and different displays may", "suppliercode":"E17", "qty":"3", "unit_price":"2.03", "shelf_pos":"A5.23"},
            {"code":"FF12M-08BSP", "product":"Flat Face Hydraulic Quick Connect Male Coupler, 1/2鈥� BSP Thread", "description":"Flat Face Hydraulic Quick Connect Male Coupler, 1/2鈥� BSP Thread", "suppliercode":"S432", "qty":"6", "unit_price":"8.24", "shelf_pos":"A5.26"},
            {"code":"HFSKM13IRAE", "product":"1/2 female hydraulic hose quick connector", "description":"1/2 female hydraulic hose quick connector", "suppliercode":"M428", "qty":"6", "unit_price":"7.22", "shelf_pos":"A5.27"},
            {"code":"RK2PTS-4", "product":"2PTS-4 hydraulic cylinder repair set", "description":"", "suppliercode":"Q3245", "qty":"3", "unit_price":"22.04", "shelf_pos":"A3.272"},
            {"code":"ML58470210", "product":"2x6mm hole mounting base", "description":"", "suppliercode":"S462G54", "qty":"2", "unit_price":"22.4", "shelf_pos":"A10.33"},
            {"code":"G1253-S60KA6000670", "product":"Axel w/o brakes #60 6xM18x1,5 ADR", "description":"", "suppliercode":"FG2534W", "qty":"1", "unit_price":"64.03", "shelf_pos":"T3.212"},
            {"code":"BCB2075R", "product":"Brake cylinder è„´ BCB2075R", "description":"", "suppliercode":"FG23421G", "qty":"1", "unit_price":"98.02", "shelf_pos":"T2.432"}
        ]
    },
    {"orderid":"723","customerid":"4100","customer":"Eternit Argentina S.A.","invaddr":"Av. Corrientes 327, 3rd Floor,Buenos Aires - C1043AAD,ARGENTINA","delivaddr":"","deliverydate":"7-11-2020","respsalesperson":"Matthew Smith","comment":"","totalprice":"1330.98",
        "products": [
            {"code":"014406", "product":"T3-2-15435/Z", "description":"Cam-switch T3; Form Z", "suppliercode":"MA.143-19", "qty":"2", "unit_price":"65", "shelf_pos":"Q89.78"},
            {"code":"466-652", "product":"Flange Bearings", "description":"3/4 2-bolt UCFL207-20", "suppliercode":"R1615", "qty":"2", "unit_price":"8.29", "shelf_pos":"M58.317"},
            {"code":"965-810", "product":"Sprockets", "description":"35T 1-1/4 bore 60P", "suppliercode":"R1899", "qty":"2", "unit_price":"67.9", "shelf_pos":"M33.416"},
            {"code":"101063", "product":"CSEZ-01/05", "description":"Temperature sensor", "suppliercode":"E.1419", "qty":"1", "unit_price":"230", "shelf_pos":"E178.371"},
            {"code":"991-653", "product":"Sprockets", "description":"12T 3/4 bore 60P", "suppliercode":"R1867", "qty":"2", "unit_price":"14.30", "shelf_pos":"M60.569"},
            {"code":"101056", "product":"PKZM4-XM65DE", "description":"Electr.contact module DILM40..M65", "suppliercode":"E.1378", "qty":"2", "unit_price":"200", "shelf_pos":"E173.330"},
            {"code":"101059", "product":"DILM65-XP2", "description":"Parallelling link", "suppliercode":"E.1899", "qty":"1", "unit_price":"340", "shelf_pos":"E157.393"},
            {"code":"144028","product":"EPLHS-M4X8","description":"Fixing screw M4x8","suppliercode":"MA.193-12","qty":"1","unit_price":"50","shelf_pos":"Q81.54"}
        ]
    },
    {"orderid":"923","customerid":"6520","customer":"Etex Building Performance GmbH (AT)","invaddr":"","delivaddr":"St. Peter-Str. 25,Linz Postfach - 4021,AUSTRIA","deliverydate":"6-10-2020","respsalesperson":"Bengt Karlsson","comment":"","totalprice":"1303.01",
        "products": [
            {"code":"101056", "product":"PKZM4-XM65DE", "description":"Electr.contact module DILM40..M65", "suppliercode":"E.1378", "qty":"2", "unit_price":"200", "shelf_pos":"E173.330"},
            {"code":"101059", "product":"DILM65-XP2", "description":"Parallelling link", "suppliercode":"E.1899", "qty":"1", "unit_price":"340", "shelf_pos":"E157.393"},
            {"code":"101064", "product":"TLE", "description":"Staircase lighting switch Eco", "suppliercode":"E.1838", "qty":"2", "unit_price":"230", "shelf_pos":"E191.184"},
            {"code":"1079 9931 02", "product":"DECAL INSTRUCTION", "description":"MODEL:GA37VP_15 , MODEL:GA45VP_15 , MODEL:GA55VP_15 + MOVOL:230V , MODEL:GA55VP_15 + MOVOL:575V + CAPPRE:ULCUL + FREQ:60HZ", "suppliercode":"1245", "qty":"1", "unit_price":"22.43", "shelf_pos":"S43.1234"},
            {"code":"14-612", "product":"Pillow Block Bearings", "description":"1-1/4 UPC206-20", "suppliercode":"R1085", "qty":"2", "unit_price":"12.29", "shelf_pos":"M46.264"},
            {"code":"101053", "product":"PKZM4-XDM65", "description":"Set DOL starter for DILM40..M65", "suppliercode":"E.1163", "qty":"2", "unit_price":"28", "shelf_pos":"E157.326"}
        ]
    },
    {"orderid":"218","customerid":"7140","customer":"Comptoir du B芒timent N.V.","invaddr":"Kuiermansstraat 1,Kapelle-op-den-Bos - 1880,BELGIUM","delivaddr":"Industriepark Noord 1,Sint-Niklaast - 9100,BELGIUM","deliverydate":"10-11-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"1770.62",
        "products": [
            {"code":"17-795", "product":"Paint ", "description":"Flat black", "suppliercode":"R1365", "qty":"3", "unit_price":"47.23", "shelf_pos":"M26.204"},
            {"code":"584-237", "product":"Pulley", "description":"7.75 O.D. 5/8 bore 1 groove", "suppliercode":"R1734", "qty":"1", "unit_price":"22.95", "shelf_pos":"M59.57"},
            {"code":"1625 2159 04", "product":"POWER TRANSFORMER", "description":"", "suppliercode":"1170", "qty":"1", "unit_price":"99.34", "shelf_pos":"S16.312"},
            {"code":"144559", "product":"EMA69C", "description":"DIM cable, 2.4m", "suppliercode":"T.1361 13#3", "qty":"2", "unit_price":"35", "shelf_pos":"QW38.26"},
            {"code":"084369", "product":"TM-2-8221/E", "description":"Mini cam-switch TM; Form E", "suppliercode":"T.1756 12#9", "qty":"2", "unit_price":"654.32", "shelf_pos":"QW13.6"},
            {"code":"144030", "product":"EPHHS-M8X16", "description":"Fixing screw M8x16", "suppliercode":"MA.122-16", "qty":"2", "unit_price":"64", "shelf_pos":"Q80.91"}
        ]
    },
    {"orderid":"915","customerid":"7120","customer":"Euro Panels Overseas N.V.","invaddr":"Bormstraat 24,Tisselt - 2830,BELGIUM","delivaddr":"PassPort Building, Luchthaven Brussel Nationaal,Zaventem - 1930,BELGIUM","deliverydate":"3-10-2020","respsalesperson":"Kelly Chavez","comment":"","totalprice":"815.71",
        "products": [
            {"code":"811-251","product":"Rear wheel","description":"26x12.00-12NHS","suppliercode":"R1791","qty":"1","unit_price":"34.66","shelf_pos":"M15.488"},
            {"code":"54-724","product":"3 point Hitch Lift","description":"Cat. 0 electric lift","suppliercode":"R1475","qty":"1","unit_price":"599.97","shelf_pos":"M23.206"},
            {"code":"811-730","product":"Seat","description":"Deluxe midback steel","suppliercode":"R1960","qty":"1","unit_price":"69.99","shelf_pos":"M49.188"},
            {"code":"765-572","product":"Steering wheel","description":"Replacement, Massey Ferguson keyed hub","suppliercode":"R1982","qty":"1","unit_price":"26.99","shelf_pos":"M21.66"},
            {"code":"998-409","product":"Pillow Block Bearings","description":"1-1/4 UPC206-20","suppliercode":"R1893","qty":"2","unit_price":"12.29","shelf_pos":"M55.250"},
            {"code":"91-349","product":"Flange Bearings","description":"1-1/4 2-bolt UCFL207-20","suppliercode":"R1565","qty":"4","unit_price":"14.88","shelf_pos":"M16.555"}
        ]
    },
    {"orderid":"558","customerid":"6050","customer":"Microtherm N.V.","invaddr":"","delivaddr":"Industriepark Noord 1,Sint-Niklaast - 9100,BELGIUM","deliverydate":"6-11-2020","respsalesperson":"Kimmo Kokkola","comment":"Would need extended payment time until end of December","totalprice":"235.36",
        "products": [
            {"code":"1089 9556 29","product":"FAN WITH FILTER","description":"","suppliercode":"1210","qty":"1","unit_price":"55.32","shelf_pos":"S54.2354"},
            {"code":"1625 2159 04","product":"POWER TRANSFORMER","description":"","suppliercode":"1170","qty":"1","unit_price":"99.34","shelf_pos":"S16.312"},
            {"code":"BPW02.6410.22.00","product":"Rollager","description":"","suppliercode":"2642100","qty":"1","unit_price":"23.22","shelf_pos":"B23.321"},
            {"code":"INA722.0174.10","product":"Nadellager, radial","description":"","suppliercode":"MER007","qty":"2","unit_price":"11.22","shelf_pos":"B23.421"},
            {"code":"550-719","product":"Tubes","description":"5.00-15/4.00-15","suppliercode":"R1691","qty":"2","unit_price":"9.23","shelf_pos":"M42.277"},
            {"code":"566-685","product":"Flange Bearings","description":"3/4 2-bolt UCFL207-20","suppliercode":"R1540","qty":"2","unit_price":"8.29","shelf_pos":"M59.195"}
        ]
    },
    {"orderid":"789","customerid":"6080","customer":"Promat Research and Technology Center N.V.","invaddr":"","delivaddr":"Bormstraat 24,Tisselt - 2830,BELGIUM","deliverydate":"8-10-2020","respsalesperson":"Rudy Gollem","comment":"","totalprice":"193.93",
        "products": [
            {"code":"998-409","product":"Pillow Block Bearings","description":"1-1/4 UPC206-20","suppliercode":"R1893","qty":"2","unit_price":"12.29","shelf_pos":"M55.250"},
            {"code":"774-462","product":"Sprockets","description":"12T 3/4 bore 60P","suppliercode":"R1693","qty":"2","unit_price":"14.30","shelf_pos":"M23.519"},
            {"code":"503-357","product":"Sprockets","description":"35T 1-1/4 bore 60P","suppliercode":"R1604","qty":"2","unit_price":"67.9","shelf_pos":"M24.429"},
            {"code":"553-237","product":"Sprockets","description":"10T 3/4 bore 40P","suppliercode":"R1946","qty":"1","unit_price":"4.95","shelf_pos":"M25.219"}
        ]
    },
    {"orderid":"971","customerid":"4200","customer":"Gypsum S.A. Minera莽茫o Ind煤stria e Com茅rcio","invaddr":"Rua Helena, 140, conjuntos 22,23 e 24,S茫o Paulo - 04.553-050,BRAZIL","delivaddr":"Rua Darcy Pereira 777,Rio de Janeiro - Santa Cruz - 23.565-190,BRAZIL","deliverydate":"4-11-2020","respsalesperson":"Kent 脰jen","comment":"","totalprice":"416.01",
        "products": [
            {"code":"14-612", "product":"Pillow Block Bearings", "description":"1-1/4 UPC206-20", "suppliercode":"R1085", "qty":"2", "unit_price":"12.29", "shelf_pos":"M46.264"},
            {"code":"101053", "product":"PKZM4-XDM65", "description":"Set DOL starter for DILM40..M65", "suppliercode":"E.1163", "qty":"2", "unit_price":"28", "shelf_pos":"E157.326"},
            {"code":"580-437", "product":"Pulley", "description":"3.75 O.D. 1 bore 1 groove", "suppliercode":"R1764", "qty":"1", "unit_price":"43.93", "shelf_pos":"M33.244"},
            {"code":"0147 1963 08", "product":"HEXAGON BOLT", "description":"FREQ:50HZ + MOVOL:500V , MOVOL:200V' + CAPPRE:IEC , (MOVOL:230V , MOVOL:575V) + CAPPRE:ULCUL + FREQ:60HZ", "suppliercode":"1270", "qty":"2", "unit_price":"34.65", "shelf_pos":"S44.2354"},
            {"code":"212-620", "product":"Rectangular tubing", "description":"2x2, 24'; 2x3, 24'", "suppliercode":"R1574", "qty":"1", "unit_price":"202", "shelf_pos":"M37.396"},
            {"code":"084341", "product":"D125-CI44/T", "description":"Ci cover & door, transparent", "suppliercode":"T.1468 17#7", "qty":"1", "unit_price":"20.20", "shelf_pos":"QW20.24"}
        ]
    },
    {"orderid":"657","customerid":"4680","customer":"Centro de Servicios Compartidos SpA","invaddr":"Camino Melipilla N掳 10803,Santiago - ,CHILE","delivaddr":"Mexico Street, number 3, 4th floor, Downtown,Rio de Janeiro - 20031-144,BRAZIL","deliverydate":"1-10-2020","respsalesperson":"Pekka Taalasmaa","comment":"Please note our new invoicing address","totalprice":"1890.57",
        "products": [
            {"code":"17-795", "product":"Paint ", "description":"Flat black", "suppliercode":"R1365", "qty":"3", "unit_price":"47.23", "shelf_pos":"M26.204"},
            {"code":"584-237", "product":"Pulley", "description":"7.75 O.D. 5/8 bore 1 groove", "suppliercode":"R1734", "qty":"1", "unit_price":"22.95", "shelf_pos":"M59.57"},
            {"code":"1625 2159 04", "product":"POWER TRANSFORMER", "description":"", "suppliercode":"1170", "qty":"1", "unit_price":"99.34", "shelf_pos":"S16.312"},
            {"code":"144559", "product":"EMA69C", "description":"DIM cable, 2.4m", "suppliercode":"T.1361 13#3", "qty":"2", "unit_price":"35", "shelf_pos":"QW38.26"},
            {"code":"084369", "product":"TM-2-8221/E", "description":"Mini cam-switch TM; Form E", "suppliercode":"T.1756 12#9", "qty":"2", "unit_price":"654.32", "shelf_pos":"QW13.6"},
            {"code":"144030", "product":"EPHHS-M8X16", "description":"Fixing screw M8x16", "suppliercode":"MA.122-16", "qty":"2", "unit_price":"64", "shelf_pos":"Q80.91"},
            {"code":"19-598", "product":"Peerless Transaxle", "description":"item # 13-1476, 3 forward speed, 1 reverse", "suppliercode":"R1040", "qty":"1", "unit_price":"119.95", "shelf_pos":"M39.156"}
        ]
    },
    {"orderid":"778","customerid":"4620","customer":"Empresas Pizarre帽o S.A.","invaddr":"","delivaddr":"Av. Andr茅s Bello 2777, Piso 22,Santiago - ,CHILE","deliverydate":"12-11-2020","respsalesperson":"Kim Berner","comment":"","totalprice":"1567.75",
        "products": [
            {"code":"010134", "product":"DILEM-01(24V60HZ)", "description":"Contactor,4kW/400V,AC operated", "suppliercode":"E.1852", "qty":"1", "unit_price":"150", "shelf_pos":"E192.137"},
            {"code":"144557", "product":"EMA69A", "description":"DIM cable 1m", "suppliercode":"T.1044 15#8", "qty":"2", "unit_price":"104", "shelf_pos":"QW40.7"},
            {"code":"010110", "product":"DILER-40(24V60HZ)", "description":"Mini contactor relay,4NO/0NC,AC operated", "suppliercode":"E.1953", "qty":"2", "unit_price":"150", "shelf_pos":"E114.392"},
            {"code":"144019", "product":"XVTL-SCH206", "description":"Segregation, vertical and horizontal", "suppliercode":"MA.102-13", "qty":"1", "unit_price":"56", "shelf_pos":"Q78.69"},
            {"code":"375-713", "product":"Throttle control", "description":"", "suppliercode":"R1676", "qty":"1", "unit_price":"36.37", "shelf_pos":"M35.228"},
            {"code":"288-656", "product":"Rectangular Tubing", "description":"2.5 x 2.5", "suppliercode":"R1655", "qty":"1", "unit_price":"58.14", "shelf_pos":"M43.186"},
            {"code":"084357", "product":"SS5-ID1125", "description":"Plinth CI", "suppliercode":"T.1434 19#3", "qty":"3", "unit_price":"33.23", "shelf_pos":"QW12.82"},
            {"code":"970-394", "product":"Steering wheel", "description":"Replacement, Massey Ferguson keyed hub", "suppliercode":"R1925", "qty":"1", "unit_price":"26.99", "shelf_pos":"M34.133"},
            {"code":"131-804", "product":"Threaded Rod", "description":"5/16-18x72, for clutch lever", "suppliercode":"R1418", "qty":"1", "unit_price":"32.59", "shelf_pos":"M35.130"},
            {"code":"462-225", "product":"3 point Hitch Lift", "description":"Cat. 0 electric lift", "suppliercode":"R1810", "qty":"1", "unit_price":"599.97", "shelf_pos":"M54.71"}
        ]
    },
    {"orderid":"449","customerid":"4640","customer":"Inversiones Etex Chile Ltda.","invaddr":"","delivaddr":"Andr茅s Bello N掳 2777,Santiago - xxxx,CHILE","deliverydate":"9-10-2020","respsalesperson":"Matthew Smith","comment":"","totalprice":"188.37",
        "products": [
            {"code":"240-400", "product":"Turnbuckle, pulleys, cable clamps", "description":"For brakes", "suppliercode":"R1778", "qty":"1", "unit_price":"13.53", "shelf_pos":"M10.380"},
            {"code":"155-351", "product":"Rims", "description":"3x15", "suppliercode":"R1283", "qty":"2", "unit_price":"69.95", "shelf_pos":"M22.586"},
            {"code":"127-753", "product":"Fuel Tank", "description":"4 quart plastic", "suppliercode":"R1743", "qty":"1", "unit_price":"34.94", "shelf_pos":"M45.393"}
        ] 
    },
    {"orderid":"655","customerid":"4520","customer":"Sociedad Industrial Pizarre帽o S.A.","invaddr":"","delivaddr":"Camino Melipilla n掳10803,Santiago - xxxx,CHILE","deliverydate":"11-11-2020","respsalesperson":"Bengt Karlsson","comment":"","totalprice":"609.83",
        "products": [
            {"code":"593-294", "product":"Turnbuckles", "description":"", "suppliercode":"R1250", "qty":"1", "unit_price":"35.85", "shelf_pos":"M42.557"},
            {"code":"101057", "product":"DILM65-XRL", "description":"Reversing wiring set", "suppliercode":"E.1800", "qty":"2", "unit_price":"200", "shelf_pos":"E199.118"},
            {"code":"906-614", "product":"Tires", "description":"4.00/15SL Tru-Trac Front Tire", "suppliercode":"R1057", "qty":"2", "unit_price":"86.99", "shelf_pos":"M48.299"}
        ]
    },
    {"orderid":"732","customerid":"4570","customer":"Sociedad Industrial Romeral S.A.","invaddr":"","delivaddr":"Santa Rosa N掳 01998,Santiago - xxxx,CHILE","deliverydate":"2-10-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"1260.37",
        "products": [
            {"code":"101054", "product":"PKZM4-XC55/2", "description":"Top-hat rail adapter plate 55mm", "suppliercode":"E.1333", "qty":"1", "unit_price":"510", "shelf_pos":"E112.77"},
            {"code":"010134", "product":"DILEM-01(24V60HZ)", "description":"Contactor,4kW/400V,AC operated", "suppliercode":"E.1852", "qty":"1", "unit_price":"150", "shelf_pos":"E192.137"},
            {"code":"144557", "product":"EMA69A", "description":"DIM cable 1m", "suppliercode":"T.1044 15#8", "qty":"2", "unit_price":"104", "shelf_pos":"QW40.7"},
            {"code":"010110", "product":"DILER-40(24V60HZ)", "description":"Mini contactor relay,4NO/0NC,AC operated", "suppliercode":"E.1953", "qty":"2", "unit_price":"150", "shelf_pos":"E114.392"},
            {"code":"144019", "product":"XVTL-SCH206", "description":"Segregation, vertical and horizontal", "suppliercode":"MA.102-13", "qty":"1", "unit_price":"56", "shelf_pos":"Q78.69"},
            {"code":"375-713", "product":"Throttle control", "description":"", "suppliercode":"R1676", "qty":"1", "unit_price":"36.37", "shelf_pos":"M35.228"}
        ]
    },
    {"orderid":"529","customerid":"4300","customer":"Etex Colombia S.A.","invaddr":"","delivaddr":"Parque Industrial Juanchito Km 14聽,Manizales - 17001,COLOMBIA","deliverydate":"11-11-2020","respsalesperson":"Kelly Chavez","comment":"","totalprice":"1140.36",
        "products": [
            {"code":"1629 0314 38", "product":"ADAPTER", "description":"CAPPRE:ULCUL + FREQ:60HZ + MOVOL:230V", "suppliercode":"1290", "qty":"2", "unit_price":"32.45", "shelf_pos":"S44.2354"},
            {"code":"101062", "product":"Z-RC/AK-4TE", "description":"RCD cover caps kit", "suppliercode":"E.1038", "qty":"1", "unit_price":"112", "shelf_pos":"E164.399"},
            {"code":"56-730", "product":"Solenoid", "description":"", "suppliercode":"R1972", "qty":"1", "unit_price":"19.99", "shelf_pos":"M15.175"},
            {"code":"101066", "product":"TLK", "description":"Staircase lighting switch Comfort", "suppliercode":"E.1225", "qty":"1", "unit_price":"150", "shelf_pos":"E148.296"},
            {"code":"719-884", "product":"Rectangular Tubing", "description":"3x6, 52", "suppliercode":"R1671", "qty":"1", "unit_price":"156.16", "shelf_pos":"M18.140"},
            {"code":"BPW02.6410.22.00", "product":"Rollager", "description":"", "suppliercode":"2642100", "qty":"1", "unit_price":"23.22", "shelf_pos":"B23.321"},
            {"code":"084356", "product":"WBW100-ID", "description":"Wall fixing bracket Ci distrib.board", "suppliercode":"T.1783 18#8", "qty":"2", "unit_price":"132.34", "shelf_pos":"QW41.9"},
            {"code":"71-624", "product":"Rectangular Tubing", "description":"3 x 3, 60", "suppliercode":"R1269", "qty":"1", "unit_price":"49.41", "shelf_pos":"M48.176"},
            {"code":"144060", "product":"EU5E-SWD-4DX", "description":"Digital module, 4 inputs 3 conductors", "suppliercode":"MA.131-11", "qty":"1", "unit_price":"300", "shelf_pos":"Q91.69"}
        ]
    },
    {"orderid":"404","customerid":"4320","customer":"Gyplac S.A.","invaddr":"","delivaddr":"Km 1 V铆a Mamonal - Gambote,Cartagena - 130013,COLOMBIA","deliverydate":"1-10-2020","respsalesperson":"Kimmo Kokkola","comment":"","totalprice":"683.24",
        "products": [
            {"code":"014432", "product":"ZE-1,6", "description":"Overload relay 1 - 1,6A", "suppliercode":"T.1645 16#0", "qty":"1", "unit_price":"30.64", "shelf_pos":"QW43.48"},
            {"code":"734-882", "product":"Hubs", "description":"1500 lb Spindle Super Lube", "suppliercode":"R1243", "qty":"2", "unit_price":"54.99", "shelf_pos":"M44.422"},
            {"code":"010136", "product":"DILEM-01-G(110VDC)", "description":"Contactor,4kW/400V,DC operated", "suppliercode":"E.1620", "qty":"1", "unit_price":"114", "shelf_pos":"E147.228"},
            {"code":"144061", "product":"EU5E-SWD-X8D", "description":"Digital module, 8 outputs 24V 0,5A", "suppliercode":"MA.140-10", "qty":"1", "unit_price":"300", "shelf_pos":"Q93.73"},
            {"code":"13-831", "product":"Battery Cables ", "description":"", "suppliercode":"R1513", "qty":"2", "unit_price":"36.31", "shelf_pos":"M39.70"},
            {"code":"144209", "product":"CS-68/300-2D", "description":"Control syst. wall enclos., sheet steel", "suppliercode":"T.1196 19#7", "qty":"1", "unit_price":"56", "shelf_pos":"QW42.82"}
        ]
    },
    {"orderid":"166","customerid":"4320","customer":"Gyplac S.A.","invaddr":"","delivaddr":"Parque Industrial Juanchito Km 14 v铆a al Magdalena,Manizales - 17001,COLOMBIA","deliverydate":"4-11-2020","respsalesperson":"Rudy Gollem","comment":"Warranty case, no invoicing!!","totalprice":"540.64",
        "products": [
            {"code":"101060", "product":"DILM65-XR", "description":"Reversing link", "suppliercode":"E.1386", "qty":"1", "unit_price":"1.120", "shelf_pos":"E152.355"},
            {"code":"144064", "product":"EU5E-SWD-4PT", "description":"Analog module, 4 temperature inputs", "suppliercode":"MA.154-14", "qty":"1", "unit_price":"230", "shelf_pos":"Q60.63"},
            {"code":"144063", "product":"EU5E-SWD-2A2A", "description":"Analog module, 2 U/I inputs, 2 outputs", "suppliercode":"MA.188-13", "qty":"1", "unit_price":"230", "shelf_pos":"Q90.95"},
            {"code":"144549", "product":"EML27", "description":"Softstarter, options", "suppliercode":"T.1500 17#9", "qty":"1", "unit_price":"20", "shelf_pos":"QW15.66"},
            {"code":"676-547", "product":"Flange Bearings", "description":"1-1/4 2-bolt UCFL207-20", "suppliercode":"R1098", "qty":"4", "unit_price":"14.88", "shelf_pos":"M59.591"}
        ]
    },
    {"orderid":"314","customerid":"4360","customer":"SSC Colombia","invaddr":"","delivaddr":"Parque Industrial Juanchito Km 14聽,Manizales - 17001,COLOMBIA","deliverydate":"26-10-2020","respsalesperson":"Kent 脰jen","comment":"","totalprice":"330.00",
        "products": [
            {"code":"BPW02.6410.22.00", "product":"Rollager", "description":"", "suppliercode":"2642100", "qty":"1", "unit_price":"23.22", "shelf_pos":"B23.321"},
            {"code":"299-657", "product":"Tie Rod Ends", "description":"3/4\"-16 right-hand male shank, 3/4\" ball ID, 1-3/4\" L thread, for guidance arms", "suppliercode":"R1072", "qty":"4", "unit_price":"12.75", "shelf_pos":"M52.330"},
            {"code":"101053", "product":"PKZM4-XDM65", "description":"Set DOL starter for DILM40..M65", "suppliercode":"E.1163", "qty":"2", "unit_price":"28", "shelf_pos":"E157.326"},
            {"code":"1089 9556 29", "product":"FAN WITH FILTER", "description":"", "suppliercode":"1210", "qty":"1", "unit_price":"55.32", "shelf_pos":"S54.2354"},
            {"code":"288-656", "product":"Rectangular Tubing", "description":"2.5 x 2.5, 72\"", "suppliercode":"R1655", "qty":"1", "unit_price":"58.14", "shelf_pos":"M43.186"},
            {"code":"1629 0314 44", "product":"TRAFO CABLE", "description":"FREQ:50HZ + MOVOL:500V , MOVOL:200V + CAPPRE:IEC , MOVOL:230V , MOVOL:575V + CAPPRE:ULCUL + FREQ:60HZ", "suppliercode":"1250", "qty":"1", "unit_price":"22.32", "shelf_pos":"S43.1234"},
            {"code":"144029", "product":"EPLHS-4,2X16", "description":"Fixing screw 4,2x16", "suppliercode":"MA.100-20", "qty":"1", "unit_price":"64", "shelf_pos":"Q58.81"}
        ]
    },
    {"orderid":"800","customerid":"7500","customer":"Etex Nordic A/S","invaddr":"","delivaddr":"Kometjev 36,Rodekro - 6230,DENMARK","deliverydate":"7-11-2020","respsalesperson":"Pekka Taalasmaa","comment":"","totalprice":"19.99",
        "products": [
            {"code":"56-730", "product":"Solenoid", "description":"", "suppliercode":"R1972", "qty":"1", "unit_price":"19.99", "shelf_pos":"M15.175"}
        ]
    },
    {"orderid":"770","customerid":"9030","customer":"Eternit France S.A.S.U.","invaddr":"","delivaddr":"2 rue Charles Edouard Jeanneret,Poissy - 78300,FRANCE","deliverydate":"28-10-2020","respsalesperson":"Kim Berner","comment":"","totalprice":"314.72",
        "products": [
            {"code":"13-831", "product":"Battery Cables ", "description":"", "suppliercode":"R1513", "qty":"2", "unit_price":"36.31", "shelf_pos":"M39.70"},
            {"code":"965-810", "product":"Sprockets", "description":"35T 1-1/4 bore 60P", "suppliercode":"R1899", "qty":"2", "unit_price":"67.9", "shelf_pos":"M33.416"},
            {"code":"852-537", "product":"Chain", "description":"60 RB, 10' for drive wheel", "suppliercode":"R1554", "qty":"1", "unit_price":"106.3", "shelf_pos":"M11.426"}                    
        ]
    },
    {"orderid":"895","customerid":"9500","customer":"Etex France Building Performance S.A.","invaddr":"","delivaddr":"500 rue Marcel Demonque,Avignon - 84000,FRANCE","deliverydate":"3-11-2020","respsalesperson":"Matthew Smith","comment":"","totalprice":"669.96",
        "products": [
            {"code":"462-225", "product":"3 point Hitch Lift", "description":"Cat. 0 electric lift", "suppliercode":"R1810", "qty":"1", "unit_price":"599.97", "shelf_pos":"M54.71"},
            {"code":"344-854", "product":"Seat", "description":"Deluxe midback steel", "suppliercode":"R1623", "qty":"1", "unit_price":"69.99", "shelf_pos":"M10.528"}
        ]
    },
    {"orderid":"435","customerid":"9570","customer":"Papeteries de B猫gles S.A.S.","invaddr":"","delivaddr":"91 Quai du Pr茅sident Wilson,B猫gles - 33130,FRANCE","deliverydate":"6-10-2020","respsalesperson":"Bengt Karlsson","comment":"","totalprice":"242.78",
        "products": [
            {"code":"299-657", "product":"Tie Rod Ends", "description":"3/4\"-16 right-hand male shank, 3/4\" ball ID, 1-3/4\" L thread, for guidance arms", "suppliercode":"R1072", "qty":"4", "unit_price":"12.75", "shelf_pos":"M52.330"},
            {"code":"101053", "product":"PKZM4-XDM65", "description":"Set DOL starter for DILM40..M65", "suppliercode":"E.1163", "qty":"2", "unit_price":"28", "shelf_pos":"E157.326"},
            {"code":"1089 9556 29", "product":"FAN WITH FILTER", "description":"", "suppliercode":"1210", "qty":"1", "unit_price":"55.32", "shelf_pos":"S54.2354"},
            {"code":"288-656", "product":"Rectangular Tubing", "description":"2.5 x 2.5, 72\"", "suppliercode":"R1655", "qty":"1", "unit_price":"58.14", "shelf_pos":"M43.186"},
            {"code":"1629 0314 44", "product":"TRAFO CABLE", "description":"FREQ:50HZ + MOVOL:500V , MOVOL:200V + CAPPRE:IEC , MOVOL:230V , MOVOL:575V + CAPPRE:ULCUL + FREQ:60HZ", "suppliercode":"1250", "qty":"1", "unit_price":"22.32", "shelf_pos":"S43.1234"}                    
        ]
    },
    {"orderid":"816","customerid":"1700","customer":"Creaton GmbH","invaddr":"","delivaddr":"Dillinger Str. 60,Wertingen - 86637,GERMANY","deliverydate":"11-11-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"332.67",
        "products": [
            {"code":"131-804", "product":"Threaded Rod", "description":"5/16-18x72, for clutch lever", "suppliercode":"R1418", "qty":"1", "unit_price":"32.59", "shelf_pos":"M35.130"},
            {"code":"084350", "product":"K30X10PEN", "description":"Busbar terminal", "suppliercode":"T.1308 20#4", "qty":"1", "unit_price":"32.56", "shelf_pos":"QW22.40"},
            {"code":"676-547", "product":"Flange Bearings", "description":"1-1/4 2-bolt UCFL207-20", "suppliercode":"R1098", "qty":"4", "unit_price":"14.88", "shelf_pos":"M59.591"},
            {"code":"144557", "product":"EMA69A", "description":"DIM cable 1m", "suppliercode":"T.1044 15#8", "qty":"2", "unit_price":"104", "shelf_pos":"QW40.7"}
        ]
    },
    {"orderid":"627","customerid":"1750","customer":"Creaton Produktions GmbH","invaddr":"","delivaddr":"Dillinger Str. 60,Wertingen - 86637,GERMANY","deliverydate":"4-10-2020","respsalesperson":"Kelly Chavez","comment":"","totalprice":"504.95",
        "products": [
            {"code":"339-709", "product":"Sprockets", "description":"10T 3/4 bore 40P", "suppliercode":"R1967", "qty":"1", "unit_price":"4.95", "shelf_pos":"M35.288"},
            {"code":"699-269", "product":"Engine", "description":"Briggs and Stratton 15 hp Model # 28N787", "suppliercode":"R1928", "qty":"1", "unit_price":"500", "shelf_pos":"M23.463"}
        ]
    },
    {"orderid":"283","customerid":"1000","customer":"Etex Germany Exteriors GmbH","invaddr":"Im Breitspiel 20,Heidelberg - 69126,GERMANY","delivaddr":"Scheifenkamp 16,Ratingen - 40878,GERMANY","deliverydate":"12-11-2020","respsalesperson":"Kimmo Kokkola","comment":"","totalprice":"953.10",
        "products": [
            {"code":"603-261", "product":"Tie Rod Ends", "description":"3/8\"-24 right-hand male shank, 3/8\" ball ID, 1-1/4\" L thread, for steering tie rod", "suppliercode":"R1239", "qty":"2", "unit_price":"28.55", "shelf_pos":"M31.546"},
            {"code":"101063", "product":"CSEZ-01/05", "description":"Temperature sensor", "suppliercode":"E.1419", "qty":"1", "unit_price":"230", "shelf_pos":"E178.371"},
            {"code":"144561", "product":"EMA75", "description":"Soft starter S8x1+,control term. block", "suppliercode":"T.1873 14#1", "qty":"1", "unit_price":"56", "shelf_pos":"QW41.49"},
            {"code":"101066", "product":"TLK", "description":"Staircase lighting switch Comfort", "suppliercode":"E.1225", "qty":"1", "unit_price":"150", "shelf_pos":"E148.296"},
            {"code":"101064", "product":"TLE", "description":"Staircase lighting switch Eco", "suppliercode":"E.1838", "qty":"2", "unit_price":"230", "shelf_pos":"E191.184"}
        ]
    },
    {"orderid":"222","customerid":"6180","customer":"Promat Service GmbH","invaddr":"","delivaddr":"Schwesterstrasse 58 c,Wuppertal - 42285,GERMANY","deliverydate":"15-10-2020","respsalesperson":"Rudy Gollem","comment":"","totalprice":"571.10",
        "products": [
            {"code":"101064", "product":"TLE", "description":"Staircase lighting switch Eco", "suppliercode":"E.1838", "qty":"2", "unit_price":"230", "shelf_pos":"E191.184"},
            {"code":"734-882", "product":"Hubs", "description":"1500 lb Spindle Super Lube", "suppliercode":"R1243", "qty":"2", "unit_price":"54.99", "shelf_pos":"M44.422"},
            {"code":"101060", "product":"DILM65-XR", "description":"Reversing link", "suppliercode":"E.1386", "qty":"1", "unit_price":"1.120", "shelf_pos":"E152.355"}
        ]
    },
    {"orderid":"385","customerid":"1500","customer":"Wanit Fulgurit GmbH","invaddr":"","delivaddr":"Eternitstra脽e 1,Leimen - 69181,GERMANY","deliverydate":"10-11-2020","respsalesperson":"Kent 脰jen","comment":"","totalprice":"341.78",
        "products": [
            {"code":"084012", "product":"KST43-150", "description":"Panel enclosure Ci43 with cable glands", "suppliercode":"T.1618 12#8", "qty":"2", "unit_price":"56", "shelf_pos":"QW42.18"},
            {"code":"144209", "product":"CS-68/300-2D", "description":"Control syst. wall enclos., sheet steel", "suppliercode":"T.1196 19#7", "qty":"1", "unit_price":"56", "shelf_pos":"QW42.82"},
            {"code":"144550", "product":"EML34", "description":"LUG COVER KIT", "suppliercode":"T.1873 13#1", "qty":"1", "unit_price":"20.46", "shelf_pos":"QW19.81"},
            {"code":"173-229", "product":"Battery & core", "description":"", "suppliercode":"R1481", "qty":"1", "unit_price":"136.99", "shelf_pos":"M42.292"},
            {"code":"616-326", "product":"Sprockets", "description":"40T 1.25 bore 40P", "suppliercode":"R1444", "qty":"1", "unit_price":"16.33", "shelf_pos":"M27.480"}
        ]
    },
    {"orderid":"966","customerid":"7200","customer":"EASA S.A.","invaddr":"163 rue du Kiem,Strassen - 8030,LUXEMBOURG","delivaddr":"Haven 12,Goor - 7471LV,NETHERLANDS","deliverydate":"12-10-2020","respsalesperson":"Pekka Taalasmaa","comment":"Please be careful with my order, last time two spares were broken","totalprice":"540.14",
        "products": [
            {"code":"101058", "product":"DILM65-XSL", "description":"Star-delta wiring set", "suppliercode":"E.1595", "qty":"1", "unit_price":"340", "shelf_pos":"E135.93"},
            {"code":"010136", "product":"DILEM-01-G(110VDC)", "description":"Contactor,4kW/400V,DC operated", "suppliercode":"E.1620", "qty":"1", "unit_price":"114", "shelf_pos":"E147.228"},
            {"code":"101052", "product":"MSC-R-12-M17(24VDC)", "description":"Reversing starter", "suppliercode":"E.1052", "qty":"2", "unit_price":"20", "shelf_pos":"E113.96"},
            {"code":"166-503", "product":"Fuel shut-off, V-belt, etc.", "description":"Fuel shut-off, 5/8x57 belt (approx. $17), fuel line", "suppliercode":"R1217", "qty":"1", "unit_price":"23.71", "shelf_pos":"M57.300"},
            {"code":"1079 9931 02", "product":"DECAL INSTRUCTION", "description":"MODEL:GA37VP_15 , MODEL:GA45VP_15 , MODEL:GA55VP_15 + MOVOL:230V , MODEL:GA55VP_15 + MOVOL:575V + CAPPRE:ULCUL + FREQ:60HZ", "suppliercode":"1245", "qty":"1", "unit_price":"22.43", "shelf_pos":"S43.1234"}
        ]
    },
    {"orderid":"319","customerid":"7220","customer":"Eternit Investment S.è„¿.r.l.","invaddr":"Vleugelboot 22,Houten - 3991 CL,NETHERLANDS","delivaddr":"Oosterhorn 32,Delfzijl - 9930 AA,NETHERLANDS","deliverydate":"5-11-2020","respsalesperson":"Kim Berner","comment":"","totalprice":"1684.51",
        "products": [
            {"code":"144559", "product":"EMA69C", "description":"DIM cable, 2.4m", "suppliercode":"T.1361 13#3", "qty":"2", "unit_price":"35", "shelf_pos":"QW38.26"},
            {"code":"084341", "product":"D125-CI44/T", "description":"Ci cover & door, transparent", "suppliercode":"T.1468 17#7", "qty":"1", "unit_price":"20.20", "shelf_pos":"QW20.24"},
            {"code":"101056", "product":"PKZM4-XM65DE", "description":"Electr.contact module DILM40..M65", "suppliercode":"E.1378", "qty":"2", "unit_price":"200", "shelf_pos":"E173.330"},
            {"code":"101064", "product":"TLE", "description":"Staircase lighting switch Eco", "suppliercode":"E.1838", "qty":"2", "unit_price":"230", "shelf_pos":"E191.184"},
            {"code":"131-804", "product":"Threaded Rod", "description":"5/16-18x72, for clutch lever", "suppliercode":"R1418", "qty":"1", "unit_price":"32.59", "shelf_pos":"M35.130"},
            {"code":"466-652", "product":"Flange Bearings", "description":"3/4 2-bolt UCFL207-20", "suppliercode":"R1615", "qty":"2", "unit_price":"8.29", "shelf_pos":"M58.317"},
            {"code":"101054", "product":"PKZM4-XC55/2", "description":"Top-hat rail adapter plate 55mm", "suppliercode":"E.1333", "qty":"1", "unit_price":"510", "shelf_pos":"E112.77"},
            {"code":"1625 2159 04", "product":"POWER TRANSFORMER", "description":"", "suppliercode":"1170", "qty":"1", "unit_price":"99.34", "shelf_pos":"S16.312"},
            {"code":"101-373", "product":"Muffler and adapter", "description":"", "suppliercode":"R1428", "qty":"1", "unit_price":"75.8", "shelf_pos":"M39.478"}
        ]
    },
    {"orderid":"355","customerid":"7810","customer":"Merilux S.è„¿.r.L.","invaddr":"","delivaddr":"163 rue du Kiem,Strassen - 8030,LUXEMBOURG","deliverydate":"25-10-2020","respsalesperson":"Matthew Smith","comment":"","totalprice":"119.73",
        "products": [
            {"code":"101-373", "product":"Muffler and adapter", "description":"", "suppliercode":"R1428", "qty":"1", "unit_price":"75.8", "shelf_pos":"M39.478"},
            {"code":"580-437", "product":"Pulley", "description":"3.75 O.D. 1 bore 1 groove", "suppliercode":"R1764", "qty":"1", "unit_price":"43.93", "shelf_pos":"M33.244"}
        ]
    },
    {"orderid":"322","customerid":"7400","customer":"Eternit Holding B.V.","invaddr":"","delivaddr":"Haven 12,Goor - 7471 LV,NETHERLANDS","deliverydate":"5-11-2020","respsalesperson":"Bengt Karlsson","comment":"","totalprice":"449.28",
        "products": [
            {"code":"240-400", "product":"Turnbuckle, pulleys, cable clamps", "description":"For brakes", "suppliercode":"R1778", "qty":"1", "unit_price":"13.53", "shelf_pos":"M10.380"},
            {"code":"19-598", "product":"Peerless Transaxle", "description":"item # 13-1476, 3 forward speed, 1 reverse", "suppliercode":"R1040", "qty":"1", "unit_price":"119.95", "shelf_pos":"M39.156"},
            {"code":"965-810", "product":"Sprockets", "description":"35T 1-1/4 bore 60P", "suppliercode":"R1899", "qty":"2", "unit_price":"67.9", "shelf_pos":"M33.416"},
            {"code":"144346", "product":"EMA71", "description":"Control User Interface with status LED", "suppliercode":"T.1663 16#7", "qty":"1", "unit_price":"50", "shelf_pos":"QW12.1"},
            {"code":"014406", "product":"T3-2-15435/Z", "description":"Cam-switch T3; Form Z", "suppliercode":"MA.143-19", "qty":"2", "unit_price":"65", "shelf_pos":"Q89.78"}
        ]
    },
    {"orderid":"152","customerid":"7270","customer":"Nefibouw B.V.","invaddr":"","delivaddr":"Haven 12,Goor - 7471LV,NETHERLANDS","deliverydate":"24-10-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"288.29",
        "products": [
            {"code":"INA722.0174.10", "product":"Nadellager, radial", "description":"", "suppliercode":"MER007", "qty":"2", "unit_price":"11.22", "shelf_pos":"B23.421"},
            {"code":"593-294", "product":"Turnbuckles", "description":"", "suppliercode":"R1250", "qty":"1", "unit_price":"35.85", "shelf_pos":"M42.557"},
            {"code":"144063", "product":"EU5E-SWD-2A2A", "description":"Analog module, 2 U/I inputs, 2 outputs", "suppliercode":"MA.188-13", "qty":"1", "unit_price":"230", "shelf_pos":"Q90.95"}
        ]
    },
    {"orderid":"62","customerid":"4460","customer":"Etex Peru S.A.C.","invaddr":"","delivaddr":"Jr Repç…¤blica del Ecuador 448,Lima - 1,PERU","deliverydate":"1-11-2020","respsalesperson":"Kelly Chavez","comment":"","totalprice":"892.11",
        "products": [
            {"code":"699-269", "product":"Engine", "description":"Briggs and Stratton 15 hp Model # 28N787", "suppliercode":"R1928", "qty":"1", "unit_price":"500", "shelf_pos":"M23.463"},
            {"code":"981-568", "product":"Rear wheel", "description":"26x12.00-12NHS", "suppliercode":"R1769", "qty":"1", "unit_price":"34.66", "shelf_pos":"M21.495"},
            {"code":"014404", "product":"T3-2-8241/E", "description":"Cam-switch T3; Form E", "suppliercode":"MA.198-17", "qty":"1", "unit_price":"43.65", "shelf_pos":"Q87.69"},
            {"code":"101060", "product":"DILM65-XR", "description":"Reversing link", "suppliercode":"E.1386", "qty":"1", "unit_price":"1.120", "shelf_pos":"E152.355"},
            {"code":"616-326", "product":"Sprockets", "description":"40T 1.25 bore 40P", "suppliercode":"R1444", "qty":"1", "unit_price":"16.33", "shelf_pos":"M27.480"},
            {"code":"101059", "product":"DILM65-XP2", "description":"Parallelling link", "suppliercode":"E.1899", "qty":"1", "unit_price":"340", "shelf_pos":"E157.393"}
        ]
    },
    {"orderid":"105","customerid":"4400","customer":"Fabrica Peruana Eternit S.A.","invaddr":"","delivaddr":"Jr. Repç…¤blica del Ecuador 448,Lima - 1,PERU","deliverydate":"27-10-2020","respsalesperson":"Kimmo Kokkola","comment":"","totalprice":"123.42",
        "products": [
            {"code":"3-439", "product":"Hilling discs", "description":"16\" disc hiller with 16\" shank", "suppliercode":"R1020", "qty":"2", "unit_price":"31.95", "shelf_pos":"M36.370"},
            {"code":"676-547", "product":"Flange Bearings", "description":"1-1/4 2-bolt UCFL207-20", "suppliercode":"R1098", "qty":"4", "unit_price":"14.88", "shelf_pos":"M59.591"}
        ]
    },
    {"orderid":"969","customerid":"5340","customer":"Marley Building Systems","invaddr":"","delivaddr":"2 Setchell Road,Roodekop - 1401,SOUTH AFRICA","deliverydate":"2-11-2020","respsalesperson":"Rudy Gollem","comment":"","totalprice":"906.87",
        "products": [
            {"code":"380-228", "product":"V-Belt", "description":"5/8 x 57", "suppliercode":"R1738", "qty":"1", "unit_price":"44.06", "shelf_pos":"M40.370"},
            {"code":"084350", "product":"K30X10PEN", "description":"Busbar terminal", "suppliercode":"T.1308 20#4", "qty":"1", "unit_price":"32.56", "shelf_pos":"QW22.40"},
            {"code":"010136", "product":"DILEM-01-G(110VDC)", "description":"Contactor,4kW/400V,DC operated", "suppliercode":"E.1620", "qty":"1", "unit_price":"114", "shelf_pos":"E147.228"},
            {"code":"13-831", "product":"Battery Cables ", "description":"", "suppliercode":"R1513", "qty":"2", "unit_price":"36.31", "shelf_pos":"M39.70"},
            {"code":"852-537", "product":"Chain", "description":"60 RB, 10' for drive wheel", "suppliercode":"R1554", "qty":"1", "unit_price":"106.3", "shelf_pos":"M11.426"},
            {"code":"144061", "product":"EU5E-SWD-X8D", "description":"Digital module, 8 outputs 24V 0,5A", "suppliercode":"MA.140-10", "qty":"1", "unit_price":"300", "shelf_pos":"Q93.73"},
            {"code":"010134", "product":"DILEM-01(24V60HZ)", "description":"Contactor,4kW/400V,AC operated", "suppliercode":"E.1852", "qty":"1", "unit_price":"150", "shelf_pos":"E192.137"},
            {"code":"1079 9931 02", "product":"DECAL INSTRUCTION", "description":"MODEL:GA37VP_15 , MODEL:GA45VP_15 , MODEL:GA55VP_15 + MOVOL:230V , MODEL:GA55VP_15 + MOVOL:575V + CAPPRE:ULCUL + FREQ:60HZ", "suppliercode":"1245", "qty":"1", "unit_price":"22.43", "shelf_pos":"S43.1234"},
            {"code":"1629 0314 38", "product":"ADAPTER", "description":"CAPPRE:ULCUL + FREQ:60HZ + MOVOL:230V", "suppliercode":"1290", "qty":"2", "unit_price":"32.45", "shelf_pos":"S44.2354"}
        ]
    },
    {"orderid":"392","customerid":"9100","customer":"Euronit Fachadas y Cubiertas S.L.","invaddr":"","delivaddr":"Ctra de Segovia CL-601, KM 21,Valladolid - 47160,SPAIN","deliverydate":"30-10-2020","respsalesperson":"Kent è„°jen","comment":"","totalprice":"851.33",
        "products": [
            {"code":"970-394", "product":"Steering wheel", "description":"Replacement, Massey Ferguson keyed hub", "suppliercode":"R1925", "qty":"1", "unit_price":"26.99", "shelf_pos":"M34.133"},
            {"code":"56-730", "product":"Solenoid", "description":"", "suppliercode":"R1972", "qty":"1", "unit_price":"19.99", "shelf_pos":"M15.175"},
            {"code":"339-709", "product":"Sprockets", "description":"10T 3/4 bore 40P", "suppliercode":"R1967", "qty":"1", "unit_price":"4.95", "shelf_pos":"M35.288"},
            {"code":"084356", "product":"WBW100-ID", "description":"Wall fixing bracket Ci distrib.board", "suppliercode":"T.1783 18#8", "qty":"2", "unit_price":"132.34", "shelf_pos":"QW41.9"},
            {"code":"135-302", "product":"Tubes", "description":"5.00-15/4.00-15", "suppliercode":"R1950", "qty":"2", "unit_price":"9.23", "shelf_pos":"M53.439"},
            {"code":"144030", "product":"EPHHS-M8X16", "description":"Fixing screw M8x16", "suppliercode":"MA.122-16", "qty":"2", "unit_price":"64", "shelf_pos":"Q80.91"},
            {"code":"81-283", "product":"Threaded Rod", "description":"5/16-18 x 3', for transaxle bolts", "suppliercode":"R1766", "qty":"2", "unit_price":"44.13", "shelf_pos":"M16.336"},
            {"code":"010110", "product":"DILER-40(24V60HZ)", "description":"Mini contactor relay,4NO/0NC,AC operated", "suppliercode":"E.1953", "qty":"2", "unit_price":"150", "shelf_pos":"E114.392"}
        ]
    },
    {"orderid":"12","customerid":"6420","customer":"Promat Ib茅rica S.A.","invaddr":"","delivaddr":"Calle Velasquez 47,Madrid - 28001,SPAIN","deliverydate":"14-11-2020","respsalesperson":"Pekka Taalasmaa","comment":"","totalprice":"157.45",
        "products": [
            {"code":"375-713", "product":"Throttle control", "description":"", "suppliercode":"R1676", "qty":"1", "unit_price":"36.37", "shelf_pos":"M35.228"},
            {"code":"288-656", "product":"Rectangular Tubing", "description":"2.5 x 2.5, 72\"", "suppliercode":"R1655", "qty":"1", "unit_price":"58.14", "shelf_pos":"M43.186"},
            {"code":"144025", "product":"APZB", "description":"Tool locking screw", "suppliercode":"MA.180-10", "qty":"1", "unit_price":"28", "shelf_pos":"Q84.70"},
            {"code":"127-753", "product":"Fuel Tank", "description":"4 quart plastic", "suppliercode":"R1743", "qty":"1", "unit_price":"34.94", "shelf_pos":"M45.393"}
        ]
    },
    {"orderid":"545","customerid":"1100","customer":"Etex Switzerland","invaddr":"","delivaddr":"c/o Treuhand von Fl眉e AG,Zug - 6301,SWITZERLAND","deliverydate":"23-10-2020","respsalesperson":"Kim Berner","comment":"","totalprice":"132.04",
        "products": [
            {"code":"014432", "product":"ZE-1,6", "description":"Overload relay 1 - 1,6A", "suppliercode":"T.1645 16#0", "qty":"1", "unit_price":"30.64", "shelf_pos":"QW43.48"},
            {"code":"663-379", "product":"Guidance wheels", "description":"4.10/3.50 pneumatic, tire and rim", "suppliercode":"R1981", "qty":"2", "unit_price":"36.40", "shelf_pos":"M41.541"},
            {"code":"991-653", "product":"Sprockets", "description":"12T 3/4 bore 60P", "suppliercode":"R1867", "qty":"2", "unit_price":"14.30", "shelf_pos":"M60.569"}
        ]
    },
    {"orderid":"616","customerid":"7290","customer":"Polyfibre S.A.","invaddr":"","delivaddr":"Chemin des Charmettes 7,Lausanne - 1002,SWITZERLAND","deliverydate":"5-11-2020","respsalesperson":"Matthew Smith","comment":"","totalprice":"1042.00",
        "products": [
            {"code":"101053", "product":"PKZM4-XDM65", "description":"Set DOL starter for DILM40..M65", "suppliercode":"E.1163", "qty":"2", "unit_price":"28", "shelf_pos":"E157.326"},
            {"code":"144062", "product":"EU5E-SWD-4AX", "description":"Analog module, 4 U/I inputs", "suppliercode":"MA.125-12", "qty":"2", "unit_price":"240", "shelf_pos":"Q96.74"},
            {"code":"144028", "product":"EPLHS-M4X8", "description":"Fixing screw M4x8", "suppliercode":"MA.184-19", "qty":"1", "unit_price":"50", "shelf_pos":"Q73.98"},
            {"code":"101057", "product":"DILM65-XRL", "description":"Reversing wiring set", "suppliercode":"E.1800", "qty":"2", "unit_price":"200", "shelf_pos":"E199.118"},
            {"code":"144209", "product":"CS-68/300-2D", "description":"Control syst. wall enclos., sheet steel", "suppliercode":"T.1196 19#7", "qty":"1", "unit_price":"56", "shelf_pos":"QW42.82"}
        ]
    },
    {"orderid":"345","customerid":"8200","customer":"Eternit UK Ltd.","invaddr":"Whaddon Road, Meldreth,Royston - SG8 5RL聽,UNITED KINGDOM","delivaddr":"Wellington Road,Burton Upon Trent - DE14 2AP,UNITED KINGDOM","deliverydate":"12-10-2020","respsalesperson":"Bengt Karlsson","comment":"","totalprice":"161.34",
        "products": [
            {"code":"127-753", "product":"Fuel Tank", "description":"4 quart plastic", "suppliercode":"R1743", "qty":"1", "unit_price":"34.94", "shelf_pos":"M45.393"},
            {"code":"603-261", "product":"Tie Rod Ends", "description":"3/8\"-24 right-hand male shank, 3/8\" ball ID, 1-1/4\" L thread, for steering tie rod", "suppliercode":"R1239", "qty":"2", "unit_price":"28.55", "shelf_pos":"M31.546"},
            {"code":"0147 1963 08", "product":"HEXAGON BOLT", "description":"FREQ:50HZ + MOVOL:500V , MOVOL:200V' + CAPPRE:IEC , (MOVOL:230V , MOVOL:575V) + CAPPRE:ULCUL + FREQ:60HZ", "suppliercode":"1270", "qty":"2", "unit_price":"34.65", "shelf_pos":"S44.2354"}
        ]
    },
    {"orderid":"516","customerid":"8100","customer":"Marley Limited","invaddr":"","delivaddr":"1 High Street Mews, Wimbledon Village,london - SW19 7RG,UNITED KINGDOM","deliverydate":"15-11-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"1595.13",
        "products": [
            {"code":"BPW02.6410.22.00", "product":"Rollager", "description":"", "suppliercode":"2642100", "qty":"1", "unit_price":"23.22", "shelf_pos":"B23.321"},
            {"code":"312-305", "product":"Ignition", "description":"", "suppliercode":"R1966", "qty":"1", "unit_price":"13.39", "shelf_pos":"M54.50"},
            {"code":"155-351", "product":"Rims", "description":"3x15", "suppliercode":"R1283", "qty":"2", "unit_price":"69.95", "shelf_pos":"M22.586"},
            {"code":"084369", "product":"TM-2-8221/E", "description":"Mini cam-switch TM; Form E", "suppliercode":"T.1756 12#9", "qty":"2", "unit_price":"654.32", "shelf_pos":"QW13.6"},
            {"code":"734-882", "product":"Hubs", "description":"1500 lb Spindle Super Lube", "suppliercode":"R1243", "qty":"2", "unit_price":"54.99", "shelf_pos":"M44.422"}
        ]
    },
    {"orderid":"69","customerid":"8050","customer":"ML UK Holding Limited","invaddr":"","delivaddr":"C/O Etex (Exteriors) Uk Limited,Burton Upon Trent - DE14 2AP聽,UNITED KINGDOM","deliverydate":"26-10-2020","respsalesperson":"Kelly Chavez","comment":"Thanks again for the fast delivery! ","totalprice":"836.10",
        "products": [
            {"code":"101062", "product":"Z-RC/AK-4TE", "description":"RCD cover caps kit", "suppliercode":"E.1038", "qty":"1", "unit_price":"112", "shelf_pos":"E164.399"},
            {"code":"144560", "product":"EMA69D", "description":"DIM cable, 3.3m", "suppliercode":"T.1955 10#0", "qty":"1", "unit_price":"35", "shelf_pos":"QW35.1"},
            {"code":"173-229", "product":"Battery & core", "description":"", "suppliercode":"R1481", "qty":"1", "unit_price":"136.99", "shelf_pos":"M42.292"},
            {"code":"699-269", "product":"Engine", "description":"Briggs and Stratton 15 hp Model # 28N787", "suppliercode":"R1928", "qty":"1", "unit_price":"500", "shelf_pos":"M23.463"},
            {"code":"981-568", "product":"Rear wheel", "description":"26x12.00-12NHS", "suppliercode":"R1769", "qty":"1", "unit_price":"34.66", "shelf_pos":"M21.495"},
            {"code":"014404", "product":"T3-2-8241/E", "description":"Cam-switch T3; Form E", "suppliercode":"MA.198-17", "qty":"1", "unit_price":"43.65", "shelf_pos":"Q87.69"},
            {"code":"101060", "product":"DILM65-XR", "description":"Reversing link", "suppliercode":"E.1386", "qty":"1", "unit_price":"1.120", "shelf_pos":"E152.355"},
            {"code":"616-326", "product":"Sprockets", "description":"40T 1.25 bore 40P", "suppliercode":"R1444", "qty":"1", "unit_price":"16.33", "shelf_pos":"M27.480"}
        ]
    },
    {"orderid":"358","customerid":"6160","customer":"Promat Glasgow Ltd.","invaddr":"","delivaddr":"B1 Heywood Distribution Park聽聽聽,Heywood - OL10 2TS,UNITED KINGDOM","deliverydate":"6-11-2020","respsalesperson":"Kimmo Kokkola","comment":"","totalprice":"155.01",
        "products": [
            {"code":"084357", "product":"SS5-ID1125", "description":"Plinth CI", "suppliercode":"T.1434 19#3", "qty":"3", "unit_price":"33.23", "shelf_pos":"QW12.82"},
            {"code":"1089 9556 29", "product":"FAN WITH FILTER", "description":"", "suppliercode":"1210", "qty":"1", "unit_price":"55.32", "shelf_pos":"S54.2354"}
        ]
    },
    {"orderid":"141","customerid":"6140","customer":"Promat UK Ltd.","invaddr":"","delivaddr":"B1 Heywood Distribution Park聽聽聽,Heywood - OL10 2TS,UNITED KINGDOM","deliverydate":"29-10-2020","respsalesperson":"Rudy Gollem","comment":"","totalprice":"436.75",
        "products": [
            {"code":"71-624", "product":"Rectangular Tubing", "description":"3 x 3, 60\"", "suppliercode":"R1269", "qty":"1", "unit_price":"49.41", "shelf_pos":"M48.176"},
            {"code":"662-720", "product":"Seat swivel", "description":"6\" to 7\"", "suppliercode":"R1561", "qty":"1", "unit_price":"36.34", "shelf_pos":"M21.335"},
            {"code":"144060", "product":"EU5E-SWD-4DX", "description":"Digital module, 4 inputs 3 conductors", "suppliercode":"MA.131-11", "qty":"1", "unit_price":"300", "shelf_pos":"Q91.69"},
            {"code":"299-657", "product":"Tie Rod Ends", "description":"3/4\"-16 right-hand male shank, 3/4\" ball ID, 1-3/4\" L thread, for guidance arms", "suppliercode":"R1072", "qty":"4", "unit_price":"12.75", "shelf_pos":"M52.330"}
        ]
    },
    {"orderid":"915","customerid":"1210","customer":"Wallius Hitsauskoneet Oy","invaddr":"","delivaddr":"Muurlantie 510, 25130 MUURLA","deliverydate":"7-11-2020","respsalesperson":"Kent è„°jen","comment":"","totalprice":"753.03",
        "products": [
            {"code":"144063", "product":"EU5E-SWD-2A2A", "description":"Analog module, 2 U/I inputs, 2 outputs", "suppliercode":"MA.188-13", "qty":"1", "unit_price":"230", "shelf_pos":"Q90.95"},
            {"code":"81-283", "product":"Threaded Rod", "description":"5/16-18 x 3', for transaxle bolts", "suppliercode":"R1766", "qty":"2", "unit_price":"44.13", "shelf_pos":"M16.336"},
            {"code":"970-394", "product":"Steering wheel", "description":"Replacement, Massey Ferguson keyed hub", "suppliercode":"R1925", "qty":"1", "unit_price":"26.99", "shelf_pos":"M34.133"},
            {"code":"144030", "product":"EPHHS-M8X16", "description":"Fixing screw M8x16", "suppliercode":"MA.122-16", "qty":"2", "unit_price":"64", "shelf_pos":"Q80.91"},
            {"code":"56-730", "product":"Solenoid", "description":"", "suppliercode":"R1972", "qty":"1", "unit_price":"19.99", "shelf_pos":"M15.175"},
            {"code":"101-373", "product":"Muffler and adapter", "description":"", "suppliercode":"R1428", "qty":"1", "unit_price":"75.8", "shelf_pos":"M39.478"},
            {"code":"344-854", "product":"Seat", "description":"Deluxe midback steel", "suppliercode":"R1623", "qty":"1", "unit_price":"69.99", "shelf_pos":"M10.528"},
            {"code":"010136", "product":"DILEM-01-G(110VDC)", "description":"Contactor,4kW/400V,DC operated", "suppliercode":"E.1620", "qty":"1", "unit_price":"114", "shelf_pos":"E147.228"}
        ]
    },
    {"orderid":"811","customerid":"2420","customer":"Viimatech Digital Oy","invaddr":"Harjutie 26B, 02730 Espoo","delivaddr":"Harjutie 26B, 02730 Espoo","deliverydate":"1-10-2020","respsalesperson":"Pekka Taalasmaa","comment":"","totalprice":"423.71",
        "products": [
            {"code":"101-373", "product":"Muffler and adapter", "description":"", "suppliercode":"R1428", "qty":"1", "unit_price":"75.8", "shelf_pos":"M39.478"},
            {"code":"344-854", "product":"Seat", "description":"Deluxe midback steel", "suppliercode":"R1623", "qty":"1", "unit_price":"69.99", "shelf_pos":"M10.528"},
            {"code":"010136", "product":"DILEM-01-G(110VDC)", "description":"Contactor,4kW/400V,DC operated", "suppliercode":"E.1620", "qty":"1", "unit_price":"114", "shelf_pos":"E147.228"},
            {"code":"1625 2159 04", "product":"POWER TRANSFORMER", "description":"", "suppliercode":"1170", "qty":"1", "unit_price":"99.34", "shelf_pos":"S16.312"},
            {"code":"144558", "product":"EMA69B", "description":"DIM cable, 1.5m", "suppliercode":"T.1038 11#2", "qty":"1", "unit_price":"48", "shelf_pos":"QW43.18"},
            {"code":"466-652", "product":"Flange Bearings", "description":"3/4 2-bolt UCFL207-20", "suppliercode":"R1615", "qty":"2", "unit_price":"8.29", "shelf_pos":"M58.317"}
        ]
    },
    {"orderid":"43","customerid":"3840","customer":"Platom Oy","invaddr":"15023811@scan.netvisor.fi","delivaddr":"J盲盲k盲rinkatu 33, 50130 Mikkeli ","deliverydate":"8-11-2020","respsalesperson":"Kim Berner","comment":"","totalprice":"187.13",
        "products": [
            {"code":"3-439", "product":"Hilling discs", "description":"16\" disc hiller with 16\" shank", "suppliercode":"R1020", "qty":"2", "unit_price":"31.95", "shelf_pos":"M36.370"},
            {"code":"166-503", "product":"Fuel shut-off, V-belt, etc.", "description":"Fuel shut-off, 5/8x57 belt (approx. $17), fuel line", "suppliercode":"R1217", "qty":"1", "unit_price":"23.71", "shelf_pos":"M57.300"},
            {"code":"676-547", "product":"Flange Bearings", "description":"1-1/4 2-bolt UCFL207-20", "suppliercode":"R1098", "qty":"4", "unit_price":"14.88", "shelf_pos":"M59.591"},
            {"code":"101052", "product":"MSC-R-12-M17(24VDC)", "description":"Reversing starter", "suppliercode":"E.1052", "qty":"2", "unit_price":"20", "shelf_pos":"E113.96"}
        ]
    },
    {"orderid":"175","customerid":"8620","customer":"Powder Technic Ltd","invaddr":"","delivaddr":"Alasuutarintie 22, 48400 KOTKA ","deliverydate":"30-10-2020","respsalesperson":"Matthew Smith","comment":"","totalprice":"232.64",
        "products": [
            {"code":"014432", "product":"ZE-1,6", "description":"Overload relay 1 - 1,6A", "suppliercode":"T.1645 16#0", "qty":"1", "unit_price":"30.64", "shelf_pos":"QW43.48"},
            {"code":"212-620", "product":"Rectangular tubing", "description":"2x2, 24'; 2x3, 24'", "suppliercode":"R1574", "qty":"1", "unit_price":"202", "shelf_pos":"M37.396"}
        ]
    },
    {"orderid":"119","customerid":"1213","customer":"Prosys OPC Ltd","invaddr":"","delivaddr":"Tekniikantie 14, 02150 Espoo ","deliverydate":"4-11-2020","respsalesperson":"Bengt Karlsson","comment":"","totalprice":"879.29",
        "products": [
            {"code":"1089 9556 29", "product":"FAN WITH FILTER", "description":"", "suppliercode":"1210", "qty":"1", "unit_price":"55.32", "shelf_pos":"S54.2354"},
            {"code":"084012", "product":"KST43-150", "description":"Panel enclosure Ci43 with cable glands", "suppliercode":"T.1618 12#8", "qty":"2", "unit_price":"56", "shelf_pos":"QW42.18"},
            {"code":"462-225", "product":"3 point Hitch Lift", "description":"Cat. 0 electric lift", "suppliercode":"R1810", "qty":"1", "unit_price":"599.97", "shelf_pos":"M54.71"},
            {"code":"101062", "product":"Z-RC/AK-4TE", "description":"RCD cover caps kit", "suppliercode":"E.1038", "qty":"1", "unit_price":"112", "shelf_pos":"E164.399"}
        ]
    },
    {"orderid":"563","customerid":"8421","customer":"Japrotek Oy Ab","invaddr":"PL 12, 68601 Pietarsaari ","delivaddr":"Pohjantie (Nordanv盲gen) 9, 68601 Pietarsaari","deliverydate":"13-11-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"767.63",
        "products": [
            {"code":"084356", "product":"WBW100-ID", "description":"Wall fixing bracket Ci distrib.board", "suppliercode":"T.1783 18#8", "qty":"2", "unit_price":"132.34", "shelf_pos":"QW41.9"},
            {"code":"144062", "product":"EU5E-SWD-4AX", "description":"Analog module, 4 U/I inputs", "suppliercode":"MA.125-12", "qty":"2", "unit_price":"240", "shelf_pos":"Q96.74"},
            {"code":"584-237", "product":"Pulley", "description":"7.75 O.D. 5/8 bore 1 groove", "suppliercode":"R1734", "qty":"1", "unit_price":"22.95", "shelf_pos":"M59.57"}
        ]
    },
    {"orderid":"352","customerid":"3423","customer":"ionSign","invaddr":"","delivaddr":"Paananvahe 4, FI-26100 Rauma ","deliverydate":"21-10-2020","respsalesperson":"Kelly Chavez","comment":"","totalprice":"393.25",
        "products": [
            {"code":"965-810", "product":"Sprockets", "description":"35T 1-1/4 bore 60P", "suppliercode":"R1899", "qty":"2", "unit_price":"67.9", "shelf_pos":"M33.416"},
            {"code":"312-305", "product":"Ignition", "description":"", "suppliercode":"R1966", "qty":"1", "unit_price":"13.39", "shelf_pos":"M54.50"},
            {"code":"010134", "product":"DILEM-01(24V60HZ)", "description":"Contactor,4kW/400V,AC operated", "suppliercode":"E.1852", "qty":"1", "unit_price":"150", "shelf_pos":"E192.137"},
            {"code":"144346", "product":"EMA71", "description":"Control User Interface with status LED", "suppliercode":"T.1663 16#7", "qty":"1", "unit_price":"50", "shelf_pos":"QW12.1"},
            {"code":"380-228", "product":"V-Belt", "description":"5/8 x 57", "suppliercode":"R1738", "qty":"1", "unit_price":"44.06", "shelf_pos":"M40.370"}
        ]
    },
    {"orderid":"940","customerid":"5423","customer":"CoreIoT Technologies Ltd.","invaddr":"","delivaddr":"Visiokatu 4, 33720 Tampere ","deliverydate":"13-11-2020","respsalesperson":"Kimmo Kokkola","comment":"","totalprice":"638.79",
        "products": [
            {"code":"144019", "product":"XVTL-SCH206", "description":"Segregation, vertical and horizontal", "suppliercode":"MA.102-13", "qty":"1", "unit_price":"56", "shelf_pos":"Q78.69"},
            {"code":"014406", "product":"T3-2-15435/Z", "description":"Cam-switch T3; Form Z", "suppliercode":"MA.143-19", "qty":"2", "unit_price":"65", "shelf_pos":"Q89.78"},
            {"code":"719-884", "product":"Rectangular Tubing", "description":"3x6, 52\"", "suppliercode":"R1671", "qty":"1", "unit_price":"156.16", "shelf_pos":"M18.140"},
            {"code":"BPW02.6410.22.00", "product":"Rollager", "description":"", "suppliercode":"2642100", "qty":"1", "unit_price":"23.22", "shelf_pos":"B23.321"},
            {"code":"144550", "product":"EML34", "description":"LUG COVER KIT", "suppliercode":"T.1873 13#1", "qty":"1", "unit_price":"20.46", "shelf_pos":"QW19.81"},
            {"code":"339-709", "product":"Sprockets", "description":"10T 3/4 bore 40P", "suppliercode":"R1967", "qty":"1", "unit_price":"4.95", "shelf_pos":"M35.288"},
            {"code":"144556", "product":"EMA68", "description":"Keypad cover", "suppliercode":"T.1053 11#9", "qty":"1", "unit_price":"192", "shelf_pos":"QW35.47"},
            {"code":"144561", "product":"EMA75", "description":"Soft starter S8x1+,control term. block", "suppliercode":"T.1873 14#1", "qty":"1", "unit_price":"56", "shelf_pos":"QW41.49"}
        ]
    },
    {"orderid":"106","customerid":"4320","customer":"Gyplac S.A.","invaddr":"","delivaddr":"Parque Industrial Juanchito Km 14 v铆a al Magdalena,Manizales - 17001,COLOMBIA","deliverydate":"27-10-2020","respsalesperson":"Matthew Smith","comment":"","totalprice":"145.06",
        "products": [
            {"code":"INA722.0174.10", "product":"Nadellager, radial", "description":"", "suppliercode":"MER007", "qty":"2", "unit_price":"11.22", "shelf_pos":"B23.421"},
            {"code":"13-831", "product":"Battery Cables ", "description":"", "suppliercode":"R1513", "qty":"2", "unit_price":"36.31", "shelf_pos":"M39.70"},
            {"code":"144028", "product":"EPLHS-M4X8", "description":"Fixing screw M4x8", "suppliercode":"MA.184-19", "qty":"1", "unit_price":"50", "shelf_pos":"Q73.98"}
        ]
    },
    {"orderid":"439","customerid":"4360","customer":"SSC Colombia","invaddr":"","delivaddr":"Parque Industrial Juanchito Km 14聽,Manizales - 17001,COLOMBIA","deliverydate":"13-11-2020","respsalesperson":"Bengt Karlsson","comment":"","totalprice":"820.79",
        "products": [
            {"code":"17-795", "product":"Paint ", "description":"Flat black", "suppliercode":"R1365", "qty":"3", "unit_price":"47.23", "shelf_pos":"M26.204"},
            {"code":"71-624", "product":"Rectangular Tubing", "description":"3 x 3, 60\"", "suppliercode":"R1269", "qty":"1", "unit_price":"49.41", "shelf_pos":"M48.176"},
            {"code":"144060", "product":"EU5E-SWD-4DX", "description":"Digital module, 4 inputs 3 conductors", "suppliercode":"MA.131-11", "qty":"1", "unit_price":"300", "shelf_pos":"Q91.69"},
            {"code":"084357", "product":"SS5-ID1125", "description":"Plinth CI", "suppliercode":"T.1434 19#3", "qty":"3", "unit_price":"33.23", "shelf_pos":"QW12.82"},
            {"code":"101063", "product":"CSEZ-01/05", "description":"Temperature sensor", "suppliercode":"E.1419", "qty":"1", "unit_price":"230", "shelf_pos":"E178.371"}
        ]
    },
    {"orderid":"357","customerid":"7500","customer":"Etex Nordic A/S","invaddr":"","delivaddr":"Kometjev 36,Rodekro - 6230,DENMARK","deliverydate":"28-10-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"501.89",
        "products": [
            {"code":"173-229", "product":"Battery & core", "description":"", "suppliercode":"R1481", "qty":"1", "unit_price":"136.99", "shelf_pos":"M42.292"},
            {"code":"144061", "product":"EU5E-SWD-X8D", "description":"Digital module, 8 outputs 24V 0,5A", "suppliercode":"MA.140-10", "qty":"1", "unit_price":"300", "shelf_pos":"Q93.73"},
            {"code":"1629 0314 38", "product":"ADAPTER", "description":"CAPPRE:ULCUL + FREQ:60HZ + MOVOL:230V", "suppliercode":"1290", "qty":"2", "unit_price":"32.45", "shelf_pos":"S44.2354"}
        ]
    },
    {"orderid":"967","customerid":"9030","customer":"Eternit France S.A.S.U.","invaddr":"","delivaddr":"2 rue Charles Edouard Jeanneret,Poissy - 78300,FRANCE","deliverydate":"10-11-2020","respsalesperson":"Kelly Chavez","comment":"","totalprice":"501.89",
        "products": [
            {"code":"173-229", "product":"Battery & core", "description":"", "suppliercode":"R1481", "qty":"1", "unit_price":"136.99", "shelf_pos":"M42.292"},
            {"code":"144061", "product":"EU5E-SWD-X8D", "description":"Digital module, 8 outputs 24V 0,5A", "suppliercode":"MA.140-10", "qty":"1", "unit_price":"300", "shelf_pos":"Q93.73"},
            {"code":"1629 0314 38", "product":"ADAPTER", "description":"CAPPRE:ULCUL + FREQ:60HZ + MOVOL:230V", "suppliercode":"1290", "qty":"2", "unit_price":"32.45", "shelf_pos":"S44.2354"}
        ]
    },
    {"orderid":"610","customerid":"9500","customer":"Etex France Building Performance S.A.","invaddr":"","delivaddr":"500 rue Marcel Demonque,Avignon - 84000,FRANCE","deliverydate":"3-10-2020","respsalesperson":"Kimmo Kokkola","comment":"","totalprice":"1599.22",
        "products": [
            {"code":"580-437", "product":"Pulley", "description":"3.75 O.D. 1 bore 1 groove", "suppliercode":"R1764", "qty":"1", "unit_price":"43.93", "shelf_pos":"M33.244"},
            {"code":"084369", "product":"TM-2-8221/E", "description":"Mini cam-switch TM; Form E", "suppliercode":"T.1756 12#9", "qty":"2", "unit_price":"654.32", "shelf_pos":"QW13.6"},
            {"code":"616-326", "product":"Sprockets", "description":"40T 1.25 bore 40P", "suppliercode":"R1444", "qty":"1", "unit_price":"16.33", "shelf_pos":"M27.480"},
            {"code":"144557", "product":"EMA69A", "description":"DIM cable 1m", "suppliercode":"T.1044 15#8", "qty":"2", "unit_price":"104", "shelf_pos":"QW40.7"},
            {"code":"1629 0314 44", "product":"TRAFO CABLE", "description":"FREQ:50HZ + MOVOL:500V , MOVOL:200V + CAPPRE:IEC , MOVOL:230V , MOVOL:575V + CAPPRE:ULCUL + FREQ:60HZ", "suppliercode":"1250", "qty":"1", "unit_price":"22.32", "shelf_pos":"S43.1234"}
        ]
    },
    {"orderid":"103","customerid":"9570","customer":"Papeteries de B猫gles S.A.S.","invaddr":"","delivaddr":"91 Quai du Pr茅sident Wilson,B猫gles - 33130,FRANCE","deliverydate":"13-11-2020","respsalesperson":"Matthew Smith","comment":"Expecting fast delivery, thanks! ","totalprice":"138.58",
        "products": [
            {"code":"734-882", "product":"Hubs", "description":"1500 lb Spindle Super Lube", "suppliercode":"R1243", "qty":"2", "unit_price":"54.99", "shelf_pos":"M44.422"},
            {"code":"991-653", "product":"Sprockets", "description":"12T 3/4 bore 60P", "suppliercode":"R1867", "qty":"2", "unit_price":"14.30", "shelf_pos":"M60.569"}
        ]
    },
    {"orderid":"807","customerid":"1700","customer":"Creaton GmbH","invaddr":"","delivaddr":"Dillinger Str. 60,Wertingen - 86637,GERMANY","deliverydate":"17-10-2020","respsalesperson":"Bengt Karlsson","comment":"","totalprice":"510.00",
        "products": [
            {"code":"101054", "product":"PKZM4-XC55/2", "description":"Top-hat rail adapter plate 55mm", "suppliercode":"E.1333", "qty":"1", "unit_price":"510", "shelf_pos":"E112.77"}
        ]
    },
    {"orderid":"478","customerid":"1100","customer":"Etex Switzerland","invaddr":"","delivaddr":"c/o Treuhand von Fl眉e AG,Zug - 6301,SWITZERLAND","deliverydate":"12-11-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"1176.01",
        "products": [
            {"code":"1629 0314 38", "product":"ADAPTER", "description":"CAPPRE:ULCUL + FREQ:60HZ + MOVOL:230V", "suppliercode":"1290", "qty":"2", "unit_price":"32.45", "shelf_pos":"S44.2354"},
            {"code":"344-854", "product":"Seat", "description":"Deluxe midback steel", "suppliercode":"R1623", "qty":"1", "unit_price":"69.99", "shelf_pos":"M10.528"},
            {"code":"101056", "product":"PKZM4-XM65DE", "description":"Electr.contact module DILM40..M65", "suppliercode":"E.1378", "qty":"2", "unit_price":"200", "shelf_pos":"E173.330"},
            {"code":"101058", "product":"DILM65-XSL", "description":"Star-delta wiring set", "suppliercode":"E.1595", "qty":"1", "unit_price":"340", "shelf_pos":"E135.93"},
            {"code":"101060", "product":"DILM65-XR", "description":"Reversing link", "suppliercode":"E.1386", "qty":"1", "unit_price":"1.120", "shelf_pos":"E152.355"},
            {"code":"010110", "product":"DILER-40(24V60HZ)", "description":"Mini contactor relay,4NO/0NC,AC operated", "suppliercode":"E.1953", "qty":"2", "unit_price":"150", "shelf_pos":"E114.392"}
        ]
    },
    {"orderid":"186","customerid":"7290","customer":"Polyfibre S.A.","invaddr":"","delivaddr":"Chemin des Charmettes 7,Lausanne - 1002,SWITZERLAND","deliverydate":"25-10-2020","respsalesperson":"Matthew Smith","comment":"","totalprice":"907.63",
        "products": [
            {"code":"144063", "product":"EU5E-SWD-2A2A", "description":"Analog module, 2 U/I inputs, 2 outputs", "suppliercode":"MA.188-13", "qty":"1", "unit_price":"230", "shelf_pos":"Q90.95"},
            {"code":"734-882", "product":"Hubs", "description":"1500 lb Spindle Super Lube", "suppliercode":"R1243", "qty":"2", "unit_price":"54.99", "shelf_pos":"M44.422"},
            {"code":"155-351", "product":"Rims", "description":"3x15", "suppliercode":"R1283", "qty":"2", "unit_price":"69.95", "shelf_pos":"M22.586"},
            {"code":"144209", "product":"CS-68/300-2D", "description":"Control syst. wall enclos., sheet steel", "suppliercode":"T.1196 19#7", "qty":"1", "unit_price":"56", "shelf_pos":"QW42.82"},
            {"code":"288-656", "product":"Rectangular Tubing", "description":"2.5 x 2.5, 72\"", "suppliercode":"R1655", "qty":"1", "unit_price":"58.14", "shelf_pos":"M43.186"},
            {"code":"173-229", "product":"Battery & core", "description":"", "suppliercode":"R1481", "qty":"1", "unit_price":"136.99", "shelf_pos":"M42.292"},
            {"code":"13-831", "product":"Battery Cables ", "description":"", "suppliercode":"R1513", "qty":"2", "unit_price":"36.31", "shelf_pos":"M39.70"},
            {"code":"144558", "product":"EMA69B", "description":"DIM cable, 1.5m", "suppliercode":"T.1038 11#2", "qty":"1", "unit_price":"48", "shelf_pos":"QW43.18"},
            {"code":"144019", "product":"XVTL-SCH206", "description":"Segregation, vertical and horizontal", "suppliercode":"MA.102-13", "qty":"1", "unit_price":"56", "shelf_pos":"Q78.69"}
        ]
    },
    {"orderid":"17","customerid":"8200","customer":"Eternit UK Ltd.","invaddr":"Whaddon Road, Meldreth,Royston - SG8 5RL聽,UNITED KINGDOM","delivaddr":"Wellington Road,Burton Upon Trent - DE14 2AP,UNITED KINGDOM","deliverydate":"7-11-2020","respsalesperson":"Bengt Karlsson","comment":"","totalprice":"22.32",
        "products": [
            {"code":"1629 0314 44", "product":"TRAFO CABLE", "description":"FREQ:50HZ + MOVOL:500V , MOVOL:200V + CAPPRE:IEC , MOVOL:230V , MOVOL:575V + CAPPRE:ULCUL + FREQ:60HZ", "suppliercode":"1250", "qty":"1", "unit_price":"22.32", "shelf_pos":"S43.1234"}
        ]
    },
    {"orderid":"988","customerid":"1100","customer":"Etex Switzerland","invaddr":"","delivaddr":"c/o Treuhand von Fl眉e AG,Zug - 6301,SWITZERLAND","deliverydate":"27-10-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"155.22",
        "products": [
            {"code":"970-394", "product":"Steering wheel", "description":"Replacement, Massey Ferguson keyed hub", "suppliercode":"R1925", "qty":"1", "unit_price":"26.99", "shelf_pos":"M34.133"},
            {"code":"593-294", "product":"Turnbuckles", "description":"", "suppliercode":"R1250", "qty":"1", "unit_price":"35.85", "shelf_pos":"M42.557"},
            {"code":"101-373", "product":"Muffler and adapter", "description":"", "suppliercode":"R1428", "qty":"1", "unit_price":"75.8", "shelf_pos":"M39.478"},
            {"code":"466-652", "product":"Flange Bearings", "description":"3/4 2-bolt UCFL207-20", "suppliercode":"R1615", "qty":"2", "unit_price":"8.29", "shelf_pos":"M58.317"}
        ]
    },
    {"orderid":"772","customerid":"7290","customer":"Polyfibre S.A.","invaddr":"","delivaddr":"Chemin des Charmettes 7,Lausanne - 1002,SWITZERLAND","deliverydate":"2-11-2020","respsalesperson":"Kelly Chavez","comment":"","totalprice":"649.34",
        "products": [
            {"code":"1625 2159 04", "product":"POWER TRANSFORMER", "description":"", "suppliercode":"1170", "qty":"1", "unit_price":"99.34", "shelf_pos":"S16.312"},
            {"code":"144549", "product":"EML27", "description":"Softstarter, options", "suppliercode":"T.1500 17#9", "qty":"1", "unit_price":"20", "shelf_pos":"QW15.66"},
            {"code":"144061", "product":"EU5E-SWD-X8D", "description":"Digital module, 8 outputs 24V 0,5A", "suppliercode":"MA.140-10", "qty":"1", "unit_price":"300", "shelf_pos":"Q93.73"},
            {"code":"144028", "product":"EPLHS-M4X8", "description":"Fixing screw M4x8", "suppliercode":"MA.184-19", "qty":"1", "unit_price":"50", "shelf_pos":"Q73.98"},
            {"code":"084329", "product":"T0-2-1/IVS-RT", "description":"Cam-switch T0; Form IVS-RT", "suppliercode":"T.1660 11#5", "qty":"1", "unit_price":"140", "shelf_pos":"QW41.32"},
            {"code":"101052", "product":"MSC-R-12-M17(24VDC)", "description":"Reversing starter", "suppliercode":"E.1052", "qty":"2", "unit_price":"20", "shelf_pos":"E113.96"}
        ]
    },
    {"orderid":"413","customerid":"8200","customer":"Eternit UK Ltd.","invaddr":"Whaddon Road, Meldreth,Royston - SG8 5RL聽,UNITED KINGDOM","delivaddr":"Wellington Road,Burton Upon Trent - DE14 2AP,UNITED KINGDOM","deliverydate":"23-10-2020","respsalesperson":"Kimmo Kokkola","comment":"","totalprice":"1114.17",
        "products": [
            {"code":"19-598", "product":"Peerless Transaxle", "description":"item # 13-1476, 3 forward speed, 1 reverse", "suppliercode":"R1040", "qty":"1", "unit_price":"119.95", "shelf_pos":"M39.156"},
            {"code":"101059", "product":"DILM65-XP2", "description":"Parallelling link", "suppliercode":"E.1899", "qty":"1", "unit_price":"340", "shelf_pos":"E157.393"},
            {"code":"101053", "product":"PKZM4-XDM65", "description":"Set DOL starter for DILM40..M65", "suppliercode":"E.1163", "qty":"2", "unit_price":"28", "shelf_pos":"E157.326"},
            {"code":"0147 1963 08", "product":"HEXAGON BOLT", "description":"FREQ:50HZ + MOVOL:500V , MOVOL:200V' + CAPPRE:IEC , (MOVOL:230V , MOVOL:575V) + CAPPRE:ULCUL + FREQ:60HZ", "suppliercode":"1270", "qty":"2", "unit_price":"34.65", "shelf_pos":"S44.2354"},
            {"code":"212-620", "product":"Rectangular tubing", "description":"2x2, 24'; 2x3, 24'", "suppliercode":"R1574", "qty":"1", "unit_price":"202", "shelf_pos":"M37.396"},
            {"code":"240-400", "product":"Turnbuckle, pulleys, cable clamps", "description":"For brakes", "suppliercode":"R1778", "qty":"1", "unit_price":"13.53", "shelf_pos":"M10.380"},
            {"code":"144060", "product":"EU5E-SWD-4DX", "description":"Digital module, 4 inputs 3 conductors", "suppliercode":"MA.131-11", "qty":"1", "unit_price":"300", "shelf_pos":"Q91.69"},
            {"code":"312-305", "product":"Ignition", "description":"", "suppliercode":"R1966", "qty":"1", "unit_price":"13.39", "shelf_pos":"M54.50"}
        ]
    },
    {"orderid":"223","customerid":"4360","customer":"SSC Colombia","invaddr":"","delivaddr":"Parque Industrial Juanchito Km 14聽,Manizales - 17001,COLOMBIA","deliverydate":"4-11-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"728.48",
        "products": [
            {"code":"299-657", "product":"Tie Rod Ends", "description":"3/4\"-16 right-hand male shank, 3/4\" ball ID, 1-3/4\" L thread, for guidance arms", "suppliercode":"R1072", "qty":"4", "unit_price":"12.75", "shelf_pos":"M52.330"},
            {"code":"101057", "product":"DILM65-XRL", "description":"Reversing wiring set", "suppliercode":"E.1800", "qty":"2", "unit_price":"200", "shelf_pos":"E199.118"},
            {"code":"14-612", "product":"Pillow Block Bearings", "description":"1-1/4 UPC206-20", "suppliercode":"R1085", "qty":"2", "unit_price":"12.29", "shelf_pos":"M46.264"},
            {"code":"81-283", "product":"Threaded Rod", "description":"5/16-18 x 3', for transaxle bolts", "suppliercode":"R1766", "qty":"2", "unit_price":"44.13", "shelf_pos":"M16.336"},
            {"code":"584-237", "product":"Pulley", "description":"7.75 O.D. 5/8 bore 1 groove", "suppliercode":"R1734", "qty":"1", "unit_price":"22.95", "shelf_pos":"M59.57"},
            {"code":"17-795", "product":"Paint ", "description":"Flat black", "suppliercode":"R1365", "qty":"3", "unit_price":"47.23", "shelf_pos":"M26.204"}
        ]
    },
    {"orderid":"26","customerid":"7500","customer":"Etex Nordic A/S","invaddr":"","delivaddr":"Kometjev 36,Rodekro - 6230,DENMARK","deliverydate":"26-10-2020","respsalesperson":"Kelly Chavez","comment":"","totalprice":"729.49",
        "products": [
            {"code":"852-537", "product":"Chain", "description":"60 RB, 10' for drive wheel", "suppliercode":"R1554", "qty":"1", "unit_price":"106.3", "shelf_pos":"M11.426"},
            {"code":"462-225", "product":"3 point Hitch Lift", "description":"Cat. 0 electric lift", "suppliercode":"R1810", "qty":"1", "unit_price":"599.97", "shelf_pos":"M54.71"},
            {"code":"BPW02.6410.22.00", "product":"Rollager", "description":"", "suppliercode":"2642100", "qty":"1", "unit_price":"23.22", "shelf_pos":"B23.321"}
        ]
    },
    {"orderid":"778","customerid":"9030","customer":"Eternit France S.A.S.U.","invaddr":"","delivaddr":"2 rue Charles Edouard Jeanneret,Poissy - 78300,FRANCE","deliverydate":"5-11-2020","respsalesperson":"Kimmo Kokkola","comment":"Wish you nice end of the year! ","totalprice":"360.00",
        "products": [
            {"code":"014406", "product":"T3-2-15435/Z", "description":"Cam-switch T3; Form Z", "suppliercode":"MA.143-19", "qty":"2", "unit_price":"65", "shelf_pos":"Q89.78"},
            {"code":"101063", "product":"CSEZ-01/05", "description":"Temperature sensor", "suppliercode":"E.1419", "qty":"1", "unit_price":"230", "shelf_pos":"E178.371"}
        ]
    },
    {"orderid":"799","customerid":"9500","customer":"Etex France Building Performance S.A.","invaddr":"","delivaddr":"500 rue Marcel Demonque,Avignon - 84000,FRANCE","deliverydate":"27-10-2020","respsalesperson":"Matthew Smith","comment":"","totalprice":"1658.10",
        "products": [
            {"code":"084369", "product":"TM-2-8221/E", "description":"Mini cam-switch TM; Form E", "suppliercode":"T.1756 12#9", "qty":"2", "unit_price":"654.32", "shelf_pos":"QW13.6"},
            {"code":"144064", "product":"EU5E-SWD-4PT", "description":"Analog module, 4 temperature inputs", "suppliercode":"MA.154-14", "qty":"1", "unit_price":"230", "shelf_pos":"Q60.63"},
            {"code":"144071", "product":"XNNHKS-M12X66", "description":"Hook-Head Bolt SL M12x66", "suppliercode":"MA.192-17", "qty":"1", "unit_price":"64", "shelf_pos":"Q65.75"},
            {"code":"144560", "product":"EMA69D", "description":"DIM cable, 3.3m", "suppliercode":"T.1955 10#0", "qty":"1", "unit_price":"35", "shelf_pos":"QW35.1"},
            {"code":"144550", "product":"EML34", "description":"LUG COVER KIT", "suppliercode":"T.1873 13#1", "qty":"1", "unit_price":"20.46", "shelf_pos":"QW19.81"}
        ]
    },
    {"orderid":"344","customerid":"9570","customer":"Papeteries de B猫gles S.A.S.","invaddr":"","delivaddr":"91 Quai du Pr茅sident Wilson,B猫gles - 33130,FRANCE","deliverydate":"3-11-2020","respsalesperson":"Bengt Karlsson","comment":"","totalprice":"709.70",
        "products": [
            {"code":"965-810", "product":"Sprockets", "description":"35T 1-1/4 bore 60P", "suppliercode":"R1899", "qty":"2", "unit_price":"67.9", "shelf_pos":"M33.416"},
            {"code":"101054", "product":"PKZM4-XC55/2", "description":"Top-hat rail adapter plate 55mm", "suppliercode":"E.1333", "qty":"1", "unit_price":"510", "shelf_pos":"E112.77"},
            {"code":"3-439", "product":"Hilling discs", "description":"16\" disc hiller with 16\" shank", "suppliercode":"R1020", "qty":"2", "unit_price":"31.95", "shelf_pos":"M36.370"}
        ]
    },
    {"orderid":"774","customerid":"4200","customer":"Gypsum S.A. Minera莽茫o Ind煤stria e Com茅rcio","invaddr":"Rua Helena, 140, conjuntos 22,23 e 24,S茫o Paulo - 04.553-050,BRAZIL","delivaddr":"Rua Darcy Pereira 777,Rio de Janeiro - Santa Cruz - 23.565-190,BRAZIL","deliverydate":"4-10-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"334.99",
        "products": [
            {"code":"101062", "product":"Z-RC/AK-4TE", "description":"RCD cover caps kit", "suppliercode":"E.1038", "qty":"1", "unit_price":"112", "shelf_pos":"E164.399"},
            {"code":"616-326", "product":"Sprockets", "description":"40T 1.25 bore 40P", "suppliercode":"R1444", "qty":"1", "unit_price":"16.33", "shelf_pos":"M27.480"},
            {"code":"144029", "product":"EPLHS-4,2X16", "description":"Fixing screw 4,2x16", "suppliercode":"MA.100-20", "qty":"1", "unit_price":"64", "shelf_pos":"Q58.81"},
            {"code":"339-709", "product":"Sprockets", "description":"10T 3/4 bore 40P", "suppliercode":"R1967", "qty":"1", "unit_price":"4.95", "shelf_pos":"M35.288"},
            {"code":"166-503", "product":"Fuel shut-off, V-belt, etc.", "description":"Fuel shut-off, 5/8x57 belt (approx. $17), fuel line", "suppliercode":"R1217", "qty":"1", "unit_price":"23.71", "shelf_pos":"M57.300"},
            {"code":"010136", "product":"DILEM-01-G(110VDC)", "description":"Contactor,4kW/400V,DC operated", "suppliercode":"E.1620", "qty":"1", "unit_price":"114", "shelf_pos":"E147.228"}
        ]
    },
    {"orderid":"353","customerid":"4680","customer":"Centro de Servicios Compartidos SpA","invaddr":"Camino Melipilla N掳 10803,Santiago - ,CHILE","delivaddr":"Mexico Street, number 3, 4th floor, Downtown,Rio de Janeiro - 20031-144,BRAZIL","deliverydate":"10-11-2020","respsalesperson":"Kelly Chavez","comment":"","totalprice":"256.56",
        "products": [
            {"code":"563-421", "product":"Chain half links", "description":"60 O/L", "suppliercode":"R1774", "qty":"2", "unit_price":"14.00", "shelf_pos":"M12.252"},
            {"code":"144561", "product":"EMA75", "description":"Soft starter S8x1+,control term. block", "suppliercode":"T.1873 14#1", "qty":"1", "unit_price":"56", "shelf_pos":"QW41.49"},
            {"code":"084350", "product":"K30X10PEN", "description":"Busbar terminal", "suppliercode":"T.1308 20#4", "qty":"1", "unit_price":"32.56", "shelf_pos":"QW22.40"},
            {"code":"144025", "product":"APZB", "description":"Tool locking screw", "suppliercode":"MA.180-10", "qty":"1", "unit_price":"28", "shelf_pos":"Q84.70"},
            {"code":"084012", "product":"KST43-150", "description":"Panel enclosure Ci43 with cable glands", "suppliercode":"T.1618 12#8", "qty":"2", "unit_price":"56", "shelf_pos":"QW42.18"}
        ]
    },
    {"orderid":"525","customerid":"4620","customer":"Empresas Pizarre帽o S.A.","invaddr":"","delivaddr":"Av. Andr茅s Bello 2777, Piso 22,Santiago - ,CHILE","deliverydate":"27-10-2020","respsalesperson":"Kimmo Kokkola","comment":"","totalprice":"392.09",
        "products": [
            {"code":"719-884", "product":"Rectangular Tubing", "description":"3x6, 52\"", "suppliercode":"R1671", "qty":"1", "unit_price":"156.16", "shelf_pos":"M18.140"},
            {"code":"144556", "product":"EMA68", "description":"Keypad cover", "suppliercode":"T.1053 11#9", "qty":"1", "unit_price":"192", "shelf_pos":"QW35.47"},
            {"code":"580-437", "product":"Pulley", "description":"3.75 O.D. 1 bore 1 groove", "suppliercode":"R1764", "qty":"1", "unit_price":"43.93", "shelf_pos":"M33.244"}
        ]
    },
    {"orderid":"157","customerid":"4640","customer":"Inversiones Etex Chile Ltda.","invaddr":"","delivaddr":"Andr茅s Bello N掳 2777,Santiago - xxxx,CHILE","deliverydate":"15-11-2020","respsalesperson":"Shanya Shiraz","comment":"","totalprice":"476.16",
        "products": [
            {"code":"084357", "product":"SS5-ID1125", "description":"Plinth CI", "suppliercode":"T.1434 19#3", "qty":"3", "unit_price":"33.23", "shelf_pos":"QW12.82"},
            {"code":"014432", "product":"ZE-1,6", "description":"Overload relay 1 - 1,6A", "suppliercode":"T.1645 16#0", "qty":"1", "unit_price":"30.64", "shelf_pos":"QW43.48"},
            {"code":"442-480", "product":"Idler Pulley", "description":"31225100 Phoenix", "suppliercode":"R1735", "qty":"1", "unit_price":"43.37", "shelf_pos":"M38.543"},
            {"code":"144557", "product":"EMA69A", "description":"DIM cable 1m", "suppliercode":"T.1044 15#8", "qty":"2", "unit_price":"104", "shelf_pos":"QW40.7"},
            {"code":"127-753", "product":"Fuel Tank", "description":"4 quart plastic", "suppliercode":"R1743", "qty":"1", "unit_price":"34.94", "shelf_pos":"M45.393"},
            {"code":"676-547", "product":"Flange Bearings", "description":"1-1/4 2-bolt UCFL207-20", "suppliercode":"R1098", "qty":"4", "unit_price":"14.88", "shelf_pos":"M59.591"}
        ]
    },
    {"orderid":"379","customerid":"1213","customer":"Prosys OPC Ltd","invaddr":"","delivaddr":"Tekniikantie 14, 02150 Espoo ","deliverydate":"29-10-2020","respsalesperson":"Kelly Chavez","comment":"","totalprice":"58.78",
        "products": [
            {"code":"1649 8003 59", "product":"POWER CABLE", "description":"CAPPRE:IEC + FREQ:50HZ + MOVOL:500V , CAPPRE:ULCUL + FREQ:60HZ + MOVOL:575V", "suppliercode":"T234-234", "qty":"1", "unit_price":"3.43", "shelf_pos":"S43.43"},
            {"code":"INA722.0174.10", "product":"Nadellager, radial", "description":"", "suppliercode":"MER007", "qty":"2", "unit_price":"11.22", "shelf_pos":"B23.421"},
            {"code":"662-720", "product":"Seat swivel", "description":"6\" to 7\"", "suppliercode":"R1561", "qty":"1", "unit_price":"36.34", "shelf_pos":"M21.335"}
        ]
    },
    {"orderid":"820","customerid":"8421","customer":"Japrotek Oy Ab","invaddr":"PL 12, 68601 Pietarsaari ","delivaddr":"Pohjantie (Nordanv盲gen) 9, 68601 Pietarsaari","deliverydate":"14-11-2020","respsalesperson":"Kimmo Kokkola","comment":"","totalprice":"218.04",
        "products": [
            {"code":"380-228", "product":"V-Belt", "description":"5/8 x 57", "suppliercode":"R1738", "qty":"1", "unit_price":"44.06", "shelf_pos":"M40.370"},
            {"code":"014404", "product":"T3-2-8241/E", "description":"Cam-switch T3; Form E", "suppliercode":"MA.198-17", "qty":"1", "unit_price":"43.65", "shelf_pos":"Q87.69"},
            {"code":"906-614", "product":"Tires", "description":"4.00/15SL Tru-Trac Front Tire", "suppliercode":"R1057", "qty":"2", "unit_price":"86.99", "shelf_pos":"M48.299"}
        ]
    }   
]
var tablehead1 = [
    "Order ID", 
    "Customer ID", 
    "Customer", 
    "Invoicing Address", 
    "Delivery Address", 
    "Delivery Date", 
    "Respons Salesperson", 
    "Comment", 
    "Total Price"
]
var tablehead2 = [
    "Code", 
    "Procuct", 
    "Description", 
    "Supplier Code", 
    "Quantity",
    "Unit Price",
    "Shelf Pos",
    "Picked",
    "Comment"
]

var tp, vl, basicdata, prodata, bdArry;
function ordersearch(){
    $(document).ready(function(){
        $("table tr:nth-child(even)").css("background-color", "#dddddd");
    });

    tp = document.getElementById("searchtype").value;
    vl = document.getElementById("searchvalue").value;
    xmlhttp.onreadystatechange = function() {
        if (this.readyState == 4 && this.status == 200) {
            myobj = JSON.parse(this.responseText);
            for(x in myobj){
                if(myobj[x][tp] == vl){
                    basicdata = myobj[x];
                    prodata = myobj[x].products;
                }
            }
        }
    }
    xmlhttp.open("GET", "project.json", true);
    xmlhttp.send();
    /**var x = "";
    for(x in myobj){
        if(myobj[x][tp] == vl){
            basicdata = myobj[x];
            prodata = myobj[x].products;
            break;
        }
    }**/

    bdArry = [
        basicdata.orderid,
        basicdata.customerid,
        basicdata.customer,
        basicdata.invaddr,
        basicdata.delivaddr,
        basicdata.deliverydate,
        basicdata.respsalesperson,
        basicdata.comment,
        basicdata.totalprice
    ]

    console.log(basicdata)
    console.log(bdArry)
    var txt1, txt2, j, k, submit_button, print_button = "";

    txt1 = "<table  style='width:100%; border: 2px solid black'><tr><th colspan='2' style='text-align: left; font-size: 150%'>Basic information</th></tr>";
    for(j = 0; j < 9; j++){
        txt1 += "<tr><th style='text-align: left'>" + tablehead1[j] + "</th>" + 
            "<td>" + bdArry[j] +  "</td></tr>";
    }
    txt1 += "<tr><th style='text-align: left'>Order Status</th><td>Under processing</td></table>";

    txt2 = "<table style='width:100%; border: 2px solid black'><tr><th colspan='9' style='text-align: left; font-size: 150%'>Products list</th></tr><tr>";
    for(k = 0; k < 9; k++){
        txt2 += "<th style='text-align: left'>" + tablehead2[k] +"</th>";
    }
    txt2 += "</tr>";
    for(var x in prodata){
        txt2 += 
        "<tr><td>" + prodata[x].code + "</td>" + 
        "<td>" + prodata[x].product + "</td>" + 
        "<td>" + prodata[x].description + "</td>" + 
        "<td>" + prodata[x].suppliercode + "</td>" + 
        "<td>" + prodata[x].qty + "</td>" + 
        "<td>" + prodata[x].unit_price + "</td>" + 
        "<td>" + prodata[x].shelf_pos + "</td>" + 
        "<td style='text-align: center'><form><input type='checkbox' class='pick'></form></td><td style='text-align: center'><form><input type='text' class='comment' style='height:40px'></form></td></tr>"
    }
    txt2 += "</table>";

    console.log(prodata);
    document.getElementById("basicinfo").innerHTML = txt1;
    document.getElementById("proinfo").innerHTML = txt2;
    submit_button = "<input type='button' style='font-size: 150%' value='Submit' onclick='listsubmit();'/>";
    print_button = "<input type='button' style='font-size: 150%' value='Print Table' onclick='listprint();'/>";
    document.getElementById("submit_button").innerHTML = submit_button;
    document.getElementById("print_button").innerHTML = print_button;
}

function listsubmit(){
    $(document).ready(function(){
        $("table tr:nth-child(even)").css("background-color", "#dddddd");
    });
    var basicdata1, prodata1;
    var tp1 = document.getElementById("searchtype").value;
    var vl1 = document.getElementById("searchvalue").value;
    var x = "";
    for(x in myobj){
        if(myobj[x][tp1] == vl1){
            basicdata1 = myobj[x];
            prodata1 = myobj[x].products;
            break;
        }
    }

    var bdArry1 = [
        basicdata.orderid,
        basicdata.customerid,
        basicdata.customer,
        basicdata.invaddr,
        basicdata.delivaddr,
        basicdata.deliverydate,
        basicdata.respsalesperson,
        basicdata.comment,
        basicdata.totalprice
    ];

    
    console.log(basicdata1)
    console.log(bdArry1)
    var txt3, l = "";

    txt3 = "<table style='width:100%; border: 2px solid black'><tr><th colspan='2' style='text-align: left; font-size: 150%'>Basic information</th></tr>";
    for(l = 0; l < 9; l++){
        txt3 += "<tr><th style='text-align: left'>" + tablehead1[l] + "</th>" + 
            "<td>" + bdArry1[l] +  "</td></tr>";
    }
    txt3 += "<tr><th style='text-align: left'>Order Status</th><td>Ready</td></table>";
    document.getElementById("basicinfo").innerHTML = txt3;
} 

function listprint(){
    bdhtml=window.document.body.innerHTML;      
    sprnstr="<!--startprint-->";      
    eprnstr="<!--endprint-->";      
    prnhtml=bdhtml.substr(bdhtml.indexOf(sprnstr)+17);      
    prnhtml=prnhtml.substring(0,prnhtml.indexOf(eprnstr));      
    window.document.body.innerHTML=prnhtml;   
    window.print();  
}
Copied

<script defer data-domain="html.cafe" src="https://milkymouse.com/js/script.js"></script>