parameters | ||
|
sessionID | ||
|
link | ||
|
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_data | importer | farm_cust | farm | cust | location | ship_date | description | boxes | pack | order_no | item_product | product_code | product_ref | instructions | sp_pack | PO | cust_desc | price | box_type | reference | box_code | fob_point | box_type_cust | po_rec_date | carrier_Code | carrier_name | standingOrderNumber | item_final_cust_code | reservation_code | business_location | exporter_name_po | unit_type | delivery_date | wave | route | po_class | julian | exporter_product | lot_number | ||
1 | 23049517 | DELA | 1312 | 1312 | SW | 12-06-2023 | Rose Rd Freedom 40cm | 6 | 125 | 28863 | 28863 | SW000727921 | 0.250 | Q | 1 | Cs125 | Q | 12-12-2023 | Ecuador | Roses | FLC | FLORA CONCEPT EXCELLENCE | ST | 12-12-2023 | Perishable | Perishable | 346 | 0 | |||||||||||||
2 | 23049519 | DELA | 1312 | 1312 | SW | 12-06-2023 | Rose Rd Freedom 50cm cs100 | 20 | 100 | 49909 | 49909 | SW000727921 | 0.350 | Q | 2 | Cs100 | Q | 12-12-2023 | Excellence | Roses | FBC | FLORA CONCEPT EXCELLENCE | ST | 12-12-2023 | Perishable | Perishable | 346 | 0 | |||||||||||||
3 | 23049520 | DELA | 1312 | 1312 | SW | 12-06-2023 | Rose Rd Freedom 60cm cs100 | 20 | 100 | 49911 | 49911 | SW000727921 | 0.450 | Q | 3 | Cs100 | Q | 12-12-2023 | Excellence | Roses | FBC | FLORA CONCEPT EXCELLENCE | ST | 12-12-2023 | Perishable | Perishable | 346 | 0 | |||||||||||||
4 | 23049884 | DELA | 1312 | 1312 | SW | 12-06-2023 | Rose Rd Freedom 40cm cs125 | 10 | 125 | 49594 | 49594 | SW000727921 | 0.250 | Q | 4 | Cs125 | Q | 12-12-2023 | Ecuador | Roses | FBC | FLORA CONCEPT EXCELLENCE | ST | 12-12-2023 | Perishable | Perishable | 346 | 0 |