parameters
string<![CDATA[<parameters><initialDate>2023-12-06</initialDate><finalDate>2023-12-06</finalDate><importerCode>DELA</importerCode><exporterCode></exporterCode></parameters>]]>
sessionID
stringID-6061227263890505733
link
stringhttps://www.knfreshcolombia.com/exportaciones/services/PurchaseOrdersWS?method=getPurchaseOrders
Query
Template: /legacyviews/scratchpad/DW/getPurchaseOrders.cfm:148
Execution Time: 0.732 ms
Record Count: 4
Cached: No
Lazy: No
SQL:
select *
from cQuery
where PO = 'SW000727921'
id_dataimporterfarm_custfarmcustlocationship_datedescriptionboxespackorder_noitem_productproduct_codeproduct_refinstructionssp_packPOcust_descpricebox_typereferencebox_codefob_pointbox_type_custpo_rec_datecarrier_Codecarrier_namestandingOrderNumberitem_final_cust_codereservation_codebusiness_locationexporter_name_pounit_typedelivery_datewaveroutepo_classjulianexporter_productlot_number
123049517DELA13121312SW12-06-2023Rose Rd Freedom 40cm61252886328863SW0007279210.250Q1Cs125Q12-12-2023EcuadorRosesFLCFLORA CONCEPT EXCELLENCEST12-12-2023PerishablePerishable3460
223049519DELA13121312SW12-06-2023Rose Rd Freedom 50cm cs100201004990949909SW0007279210.350Q2Cs100Q12-12-2023ExcellenceRosesFBCFLORA CONCEPT EXCELLENCEST12-12-2023PerishablePerishable3460
323049520DELA13121312SW12-06-2023Rose Rd Freedom 60cm cs100201004991149911SW0007279210.450Q3Cs100Q12-12-2023ExcellenceRosesFBCFLORA CONCEPT EXCELLENCEST12-12-2023PerishablePerishable3460
423049884DELA13121312SW12-06-2023Rose Rd Freedom 40cm cs125101254959449594SW0007279210.250Q4Cs125Q12-12-2023EcuadorRosesFBCFLORA CONCEPT EXCELLENCEST12-12-2023PerishablePerishable3460