2026-08-17 18:18:23







2026-08-17 18:20:20







2026-08-17 21:50:24







2026-08-18 06:10:12

update schedule set Sch='H', Ship='C' where OrderNum IN ('65301','555786','65300') or SalesOrder IN ('65301','555786','65300')

{"id":"shp_NF34MbDbEN7A","shid":125843649,"status":"ordered","origin_address":{"id":"badr_EwQ7a9tzNzTW","name":"Custom Products Corp.","company":"Custom Products Corp.","street1":"1120 Flowood Drive","street2":"","city":"Flowood","state":"MS","zip":"39232","country":"US","phone_number":"6019325854","email":"clayton@cpcsigns.com","is_residential":false,"is_warehouse":false,"address_type":"commercial","code":null},"destination_address":{"id":"badr_zfBnB42651GK","name":"Marlin Glass","company":"Southern Lighting and Traffic","street1":"1225 Old Alpharetta Rd","street2":"Ste 270","city":"Alpharetta","state":"GA","zip":"30005","country":"US","phone_number":"7702059007","email":"jpoole@southernltg.com","is_residential":false,"is_warehouse":false,"address_type":"commercial","code":null},"ultimate_consignee_address":null,"carrier":"RandL","carrier_code":"randl","carrier_scac":"RLCA","carrier_type_code":"ltl","is_external":false,"external_carrier_scac":null,"is_customer_tariff":true,"is_international":false,"service_name":"Standard Freight Service","service_level":null,"insurance_type":"no_insurance","total_price":186.12,"tracking_number":"344717388","tracking_page_url":"https://metvso.tms.myshiphawk.com/tracking/metvso?id=shp_NF34MbDbEN7A","carrier_tracking_page_url":"https://www.rlcarriers.com/freight/shipping/shipment-tracing?pro=344717388&docType=PRO&source=web","last_mile_tracking_number":null,"documents":[{"id":"doc_se4KkgNKqVHa","customer_uploaded":false,"broker_uploaded":false,"type":"Packing Slip","template_level":null,"extension":"PDF","code":"packing_slip","url":"https://shiphawk-assets-rackspace-production.s3.amazonaws.com/uploads/packing_slip_8bb47791c75ae289e727f8588add0c33.pdf20260818-4016998-cshzyz.pdf?X-Amz-Expires=604800&X-Amz-Date=20260818T111010Z&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAWUN5GNS7DEXBKO4S%2F20260818%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-SignedHeaders=host&X-Amz-Signature=ac2940a21dccf59ab0fa48044d8c83de26af9e7180feedc5ce51e1fafe2a60f7","meta_data":{},"created_at":"2026-08-18T11:10:05.104+00:00","shipment_id":"shp_NF34MbDbEN7A"},{"id":"doc_5dnYW7B2vFb4","customer_uploaded":false,"broker_uploaded":false,"type":"Ucc Labels Combined","template_level":"pallet","extension":"ZPL","code":"ucc_labels_combined","url":"https://shiphawk-assets-rackspace-production.s3.amazonaws.com/uploads/ucc_labels_combined_20260818-4016998-5gg8kq.zpl?X-Amz-Expires=604800&X-Amz-Date=20260818T111010Z&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAWUN5GNS7DEXBKO4S%2F20260818%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-SignedHeaders=host&X-Amz-Signature=6192eee41749f65b27fe7dc5e9c22e85129b3c1384f987322b82828abc59eb10","meta_data":{},"created_at":"2026-08-18T11:10:01.446+00:00","shipment_id":"shp_NF34MbDbEN7A"},{"id":"doc_jJg2H9f4X71D","customer_uploaded":false,"broker_uploaded":false,"type":"Ucc Labels Combined","template_level":"pallet","extension":"PDF","code":"ucc_labels_combined","url":"https://shiphawk-assets-rackspace-production.s3.amazonaws.com/uploads/shp_NF34MbDbEN7A_PalletLabelwoSSCCwithPRObarcode_pallet_label20260818-4016998-1iwsh.pdf?X-Amz-Expires=604800&X-Amz-Date=20260818T111010Z&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAWUN5GNS7DEXBKO4S%2F20260818%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-SignedHeaders=host&X-Amz-Signature=7ee91fb40812a1f74baf40f37554b6f05a5e0e272bf030215cddce01913f0ed7","meta_data":{},"created_at":"2026-08-18T11:10:01.596+00:00","shipment_id":"shp_NF34MbDbEN7A"},{"id":"doc_CsPnytxVzD1R","customer_uploaded":false,"broker_uploaded":false,"type":"BOL","template_level":null,"extension":"PDF","code":"bol","url":"https://shiphawk-assets-rackspace-production.s3.amazonaws.com/uploads/bol_ZO89WLAGHH.pdf?X-Amz-Expires=604800&X-Amz-Date=20260818T111010Z&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAWUN5GNS7DEXBKO4S%2F20260818%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-SignedHeaders=host&X-Amz-Signature=8b9f136a6fe78a71c5d8088b80260f78f628687235e86584fee04360ffdd0a65","meta_data":{},"created_at":"2026-08-18T11:09:59.972+00:00","shipment_id":"shp_NF34MbDbEN7A"},{"id":"doc_mf4y88DDm2tn","customer_uploaded":false,"broker_uploaded":false,"type":"Address Label","template_level":null,"extension":"PDF","code":"address_label","url":"https://shiphawk-assets-rackspace-production.s3.amazonaws.com/uploads/address_labels_f7589aabf2a36feec8c37c187ad25bc3.pdf?X-Amz-Expires=604800&X-Amz-Date=20260818T111010Z&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAWUN5GNS7DEXBKO4S%2F20260818%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-SignedHeaders=host&X-Amz-Signature=5290cb401ef80bf1b0e28ee59dd6b7eaedd4ec24f5cf2d451b6ea55da7cc0829","meta_data":{},"created_at":"2026-08-18T11:10:00.573+00:00","shipment_id":"shp_NF34MbDbEN7A"}],"price_details":{"shipping":132.12,"packing":0.0,"insurance":0.0,"pickup":0.0,"delivery":0.0,"accessorials":54.0},"account_cost_details":{"account_total_cost":186.12,"account_total_price":236.37,"account_shipping_cost":132.12,"account_packing_cost":0.0,"account_pickup_cost":0.0,"account_delivery_cost":0.0,"account_insurance_cost":0.0,"account_accessorial_cost":54.0},"dispatch":{"id":"disp_CYgHhceyEHv9","pickup_date":"2026-08-18T15:00:00+00:00","pickup_start_time":"2026-08-18T15:00:00+00:00","pickup_end_time":"2026-08-18T17:00:00+00:00","dispatch_instructions":"Pickup instruction: Pickup Instructions. Delivery instruction: FORKLIFT-N APPT-N LIFTGATE-Y.","sent_at":"2026-08-18T11:09:58+00:00","sent_type":"api","confirmed_at":"2026-08-18T11:09:58+00:00","confirmation_number":"111155996","bol_number":"36300398","status":"confirmed","shipment_id":125843649,"error_message":null},"packages":[{"id":"pkg_qxvQfhBPmRvf","tracking_number":"344717388","tracking_url":"https://www.rlcarriers.com/freight/shipping/shipment-tracing?pro=344717388&docType=PRO&source=web","return_tracking_number":null,"freight_class":"65","nmfc":"013120-00","packing_type":"pallet","package_type":"pallet","handling_unit_type":"pallet","quantity":1,"package_quantity":8,"length":52.0,"width":42.0,"height":20.0,"dimension_uom":"in","weight":880.558,"weight_uom":"lb","dry_ice_weight":null,"value":6878.6,"volume":25.28,"commodity_description":"Aluminum Sign Components; Aluminum Sign Components; Aluminum Sign Components; Aluminum Sign Components; Aluminum Sign Components; Aluminum Sign Components; Aluminum Sign Components; Aluminum Sign Components","label_document_id":null,"dangerous":false,"carrier_container":null,"carrier_container_mapped":null,"preset_container":null,"material_container_kind":"pallet","materials_weight":38.0,"number_of_units":null,"license_plate_number":null,"sscc_serial_references":[],"total_packing_cost":1.17,"accessorials":[],"hazmat_data_list":[],"package_items":[{"sequence_number":null,"product_sku":"RHSSHB516","product_name":"STAINLESS STEEL BRACKET HARDWARE 5/16\" X 18 X 3/4\" BOLT AND WASHER","quantity":40,"value":0.54,"weight":0.025,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_W7bC1Db8CWmE","line_item_sku_component_id":"lisc_XDNQ5yNkTnMm"},{"sequence_number":null,"product_sku":"VS3636W1123AG","product_name":"36X36 PEDESTRIAN TRAFFIC (SYM) BK/FYG DG3/AL~","quantity":50,"value":87.54,"weight":11.205,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_edqVDgEdKz7v","line_item_sku_component_id":"lisc_QrdP9RK0xXBa"},{"sequence_number":null,"product_sku":"S2448S5125FH3A","product_name":"24X48 SCHOOL SPEED LIMIT25 WHEN FLASHING BK/FYG/WH DG3/HIP/AL","quantity":20,"value":85.95,"weight":10.9104,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_th7qgmf7yWGE","line_item_sku_component_id":"lisc_mSkegWtdtrFb"},{"sequence_number":null,"product_sku":"RHSLAFM","product_name":"SNAP LOCK HOSE CLAMP ASSEMBLY 31\"L/POST UP TO 10\"OD (100/CASE)[F]","quantity":100,"value":3.76,"weight":0.3,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_ZeV6W8BmrgWs","line_item_sku_component_id":"lisc_xQSRv19cVvAk"},{"sequence_number":null,"product_sku":"RHSLAFM","product_name":"SNAP LOCK HOSE CLAMP ASSEMBLY 31\"L/POST UP TO 10\"OD (100/CASE)[F]","quantity":40,"value":3.76,"weight":0.3,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_ZeV6W8BmrgWs","line_item_sku_component_id":"lisc_xQSRv19cVvAk"},{"sequence_number":null,"product_sku":"RHSSBMINUS4","product_name":"STAINLESS STEEL BRACKET MINUS 4 FOR POLES 4\"OD OR LESS (BOLT NOT INCLUDED)","quantity":100,"value":1.29,"weight":0.11,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_Xs4skMGtH13T","line_item_sku_component_id":"lisc_SVKbW7JgmpRn"},{"sequence_number":null,"product_sku":"RHSSBMINUS4","product_name":"STAINLESS STEEL BRACKET MINUS 4 FOR POLES 4\"OD OR LESS (BOLT NOT INCLUDED)","quantity":40,"value":1.29,"weight":0.11,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_Xs4skMGtH13T","line_item_sku_component_id":"lisc_SVKbW7JgmpRn"},{"sequence_number":null,"product_sku":"RHSSHB516","product_name":"STAINLESS STEEL BRACKET HARDWARE 5/16\" X 18 X 3/4\" BOLT AND WASHER","quantity":100,"value":0.54,"weight":0.025,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_W7bC1Db8CWmE","line_item_sku_component_id":"lisc_XDNQ5yNkTnMm"}],"handling_unit_packages":[{"id":"pkg_kH5z6Ehc2DMN","system_package_id":"pkg_shrb8QSjgVPG","weight":2.7,"weight_uom":"lb","length":null,"width":null,"height":null,"dimension_uom":"in","dry_ice_weight":null,"value":21.6,"package_type":"box","freight_class":"60","tracking_number":null,"return_tracking_number":null,"nmfc":"013120-00","number_of_units":1,"commodity_description":"Aluminum Sign Components","sscc_serial_references":[],"total_packing_cost":0.0,"line_number":1,"license_plate_number":null,"hazmat_data_list":[],"package_items":[{"sequence_number":null,"product_sku":"RHSSHB516","product_name":"STAINLESS STEEL BRACKET HARDWARE 5/16\" X 18 X 3/4\" BOLT AND WASHER","quantity":40,"value":0.54,"weight":0.025,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_W7bC1Db8CWmE","line_item_sku_component_id":"lisc_XDNQ5yNkTnMm"}],"materials":[],"labors":[],"sscc_serial_references_details":[]},{"id":"pkg_xtyf1ZzAhCdP","system_package_id":"pkg_PRP24kJe5RJm","weight":560.25,"weight_uom":"lb","length":null,"width":null,"height":null,"dimension_uom":"in","dry_ice_weight":null,"value":4377.0,"package_type":"box","freight_class":"60","tracking_number":null,"return_tracking_number":null,"nmfc":"013120-00","number_of_units":50,"commodity_description":"Aluminum Sign Components","sscc_serial_references":[],"total_packing_cost":0.0,"line_number":2,"license_plate_number":null,"hazmat_data_list":[],"package_items":[{"sequence_number":null,"product_sku":"VS3636W1123AG","product_name":"36X36 PEDESTRIAN TRAFFIC (SYM) BK/FYG DG3/AL~","quantity":50,"value":87.54,"weight":11.205,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_edqVDgEdKz7v","line_item_sku_component_id":"lisc_QrdP9RK0xXBa"}],"materials":[],"labors":[],"sscc_serial_references_details":[]},{"id":"pkg_wwYNM0ke8rTF","system_package_id":"pkg_TA9FJv9rakJJ","weight":218.208,"weight_uom":"lb","length":null,"width":null,"height":null,"dimension_uom":"in","dry_ice_weight":null,"value":1719.0,"package_type":"box","freight_class":"60","tracking_number":null,"return_tracking_number":null,"nmfc":"013120-00","number_of_units":20,"commodity_description":"Aluminum Sign Components","sscc_serial_references":[],"total_packing_cost":0.0,"line_number":3,"license_plate_number":null,"hazmat_data_list":[],"package_items":[{"sequence_number":null,"product_sku":"S2448S5125FH3A","product_name":"24X48 SCHOOL SPEED LIMIT25 WHEN FLASHING BK/FYG/WH DG3/HIP/AL","quantity":20,"value":85.95,"weight":10.9104,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_th7qgmf7yWGE","line_item_sku_component_id":"lisc_mSkegWtdtrFb"}],"materials":[],"labors":[],"sscc_serial_references_details":[]},{"id":"pkg_t3HtJg02ZPQJ","system_package_id":"pkg_MPmme2S4Zfhd","weight":30.0,"weight_uom":"lb","length":null,"width":null,"height":null,"dimension_uom":"in","dry_ice_weight":null,"value":376.0,"package_type":"box","freight_class":"60","tracking_number":null,"return_tracking_number":null,"nmfc":"013120-00","number_of_units":2,"commodity_description":"Aluminum Sign Components","sscc_serial_references":[],"total_packing_cost":0.0,"line_number":4,"license_plate_number":null,"hazmat_data_list":[],"package_items":[{"sequence_number":null,"product_sku":"RHSLAFM","product_name":"SNAP LOCK HOSE CLAMP ASSEMBLY 31\"L/POST UP TO 10\"OD (100/CASE)[F]","quantity":100,"value":3.76,"weight":0.3,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_ZeV6W8BmrgWs","line_item_sku_component_id":"lisc_xQSRv19cVvAk"}],"materials":[],"labors":[],"sscc_serial_references_details":[]},{"id":"pkg_ExW6QzEanyBR","system_package_id":"pkg_XEdEz9eSqRHr","weight":12.0,"weight_uom":"lb","length":null,"width":null,"height":null,"dimension_uom":"in","dry_ice_weight":null,"value":150.4,"package_type":"box","freight_class":"60","tracking_number":null,"return_tracking_number":null,"nmfc":"013120-00","number_of_units":1,"commodity_description":"Aluminum Sign Components","sscc_serial_references":[],"total_packing_cost":0.0,"line_number":5,"license_plate_number":null,"hazmat_data_list":[],"package_items":[{"sequence_number":null,"product_sku":"RHSLAFM","product_name":"SNAP LOCK HOSE CLAMP ASSEMBLY 31\"L/POST UP TO 10\"OD (100/CASE)[F]","quantity":40,"value":3.76,"weight":0.3,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_ZeV6W8BmrgWs","line_item_sku_component_id":"lisc_xQSRv19cVvAk"}],"materials":[],"labors":[],"sscc_serial_references_details":[]},{"id":"pkg_HdACbVRNsH32","system_package_id":"pkg_XWBRNdBqmeee","weight":12.0,"weight_uom":"lb","length":null,"width":null,"height":null,"dimension_uom":"in","dry_ice_weight":null,"value":129.0,"package_type":"box","freight_class":"60","tracking_number":null,"return_tracking_number":null,"nmfc":"013120-00","number_of_units":2,"commodity_description":"Aluminum Sign Components","sscc_serial_references":[],"total_packing_cost":0.0,"line_number":6,"license_plate_number":null,"hazmat_data_list":[],"package_items":[{"sequence_number":null,"product_sku":"RHSSBMINUS4","product_name":"STAINLESS STEEL BRACKET MINUS 4 FOR POLES 4\"OD OR LESS (BOLT NOT INCLUDED)","quantity":100,"value":1.29,"weight":0.11,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_Xs4skMGtH13T","line_item_sku_component_id":"lisc_SVKbW7JgmpRn"}],"materials":[],"labors":[],"sscc_serial_references_details":[]},{"id":"pkg_Za4h7QCKFJyb","system_package_id":"pkg_GqcHpSYSMZWT","weight":4.9,"weight_uom":"lb","length":null,"width":null,"height":null,"dimension_uom":"in","dry_ice_weight":null,"value":51.6,"package_type":"box","freight_class":"60","tracking_number":null,"return_tracking_number":null,"nmfc":"013120-00","number_of_units":1,"commodity_description":"Aluminum Sign Components","sscc_serial_references":[],"total_packing_cost":0.0,"line_number":7,"license_plate_number":null,"hazmat_data_list":[],"package_items":[{"sequence_number":null,"product_sku":"RHSSBMINUS4","product_name":"STAINLESS STEEL BRACKET MINUS 4 FOR POLES 4\"OD OR LESS (BOLT NOT INCLUDED)","quantity":40,"value":1.29,"weight":0.11,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_Xs4skMGtH13T","line_item_sku_component_id":"lisc_SVKbW7JgmpRn"}],"materials":[],"labors":[],"sscc_serial_references_details":[]},{"id":"pkg_cRbNz6TgSW0Q","system_package_id":"pkg_t7h5rjSC9WcP","weight":2.5,"weight_uom":"lb","length":null,"width":null,"height":null,"dimension_uom":"in","dry_ice_weight":null,"value":54.0,"package_type":"box","freight_class":"60","tracking_number":null,"return_tracking_number":null,"nmfc":"013120-00","number_of_units":1,"commodity_description":"Aluminum Sign Components","sscc_serial_references":[],"total_packing_cost":0.0,"line_number":8,"license_plate_number":null,"hazmat_data_list":[],"package_items":[{"sequence_number":null,"product_sku":"RHSSHB516","product_name":"STAINLESS STEEL BRACKET HARDWARE 5/16\" X 18 X 3/4\" BOLT AND WASHER","quantity":100,"value":0.54,"weight":0.025,"weight_uom":"lb","inventory_identification":null,"inventory_identifier_code":null,"inventory_identifier_id":null,"order_line_item_id":"ordi_W7bC1Db8CWmE","line_item_sku_component_id":"lisc_XDNQ5yNkTnMm"}],"materials":[],"labors":[],"sscc_serial_references_details":[]}],"materials":[{"name":"STOCKPALLET1 50x050","unit_cost":0,"ext_cost":0,"weight":38.0,"quantity":1,"uom":"Each","is_cut_down":false,"telescoped_box_count":1,"original_dimensions":[50.0,50.0,6.0],"type_of_packing":"pallet"}],"labors":[{"name":"STOCKPALLET1 50x050 Labor","unit_cost":70,"ext_cost":1.17,"quantity":1}],"sscc_serial_references_details":[]}],"shipment_line_items":[{"order_line_item_id":"ordi_edqVDgEdKz7v","quantity":50,"name":"36X36 PEDESTRIAN TRAFFIC (SYM) BK/FYG DG3/AL~","description":"","sku":"VS3636W1123AG","upc":null,"value":87.54,"weight":11.205,"weight_uom":"lb","hs_code":null,"country_of_origin":"US","child_sku":null,"child_sku_quantity":null,"line_number":1,"source_system_line_number":null,"source_system_id":"1","origin_order_number":null,"line_item_skus":[{"id":"lis_Y43GjAJPEvjx","name":"36X36 PEDESTRIAN TRAFFIC (SYM) BK/FYG DG3/AL~","sku":"VS3636W1123AG","quantity":50,"quantity_aggregated":50,"child_sku":null,"child_sku_quantity":null,"value":87.54,"currency":"USD","length":36.0,"width":36.0,"height":0.101,"dimension_uom":"in","weight":11.205,"weight_uom":"lb","item_type":"unpacked","unpacked_item_type_id":null,"handling_unit_type":null,"hs_code":null,"eccn":null,"freight_class":null,"package_type":"box","package_quantity":null,"upc":null,"country_of_origin":"US","description":"","commodity_description":null,"bin_number":null,"mpn":null,"gtin":null,"asin":null,"inventory_identification":null,"inventory_identifier_codes":[],"line_item_sku_components":[],"order_line_item_sku_id":"lis_NyVmJGzmEBF1"}],"order_line_item":{"origin_order_number":null,"origin_order_source_system_id":"1635149:1641664","source_system_id":"1"}},{"order_line_item_id":"ordi_th7qgmf7yWGE","quantity":20,"name":"24X48 SCHOOL SPEED LIMIT25 WHEN FLASHING BK/FYG/WH DG3/HIP/AL","description":null,"sku":"S2448S5125FH3A","upc":null,"value":85.95,"weight":10.91,"weight_uom":"lb","hs_code":null,"country_of_origin":"US","child_sku":null,"child_sku_quantity":null,"line_number":2,"source_system_line_number":null,"source_system_id":"2","origin_order_number":null,"line_item_skus":[{"id":"lis_QE1gM0R7DjVB","name":"24X48 SCHOOL SPEED LIMIT25 WHEN FLASHING BK/FYG/WH DG3/HIP/AL","sku":"S2448S5125FH3A","quantity":20,"quantity_aggregated":20,"child_sku":null,"child_sku_quantity":null,"value":85.95,"currency":"USD","length":48.1,"width":24.0,"height":0.122,"dimension_uom":"in","weight":10.91,"weight_uom":"lb","item_type":"unpacked","unpacked_item_type_id":null,"handling_unit_type":null,"hs_code":null,"eccn":null,"freight_class":null,"package_type":"box","package_quantity":null,"upc":null,"country_of_origin":"US","description":null,"commodity_description":null,"bin_number":null,"mpn":null,"gtin":null,"asin":null,"inventory_identification":null,"inventory_identifier_codes":[],"line_item_sku_components":[],"order_line_item_sku_id":"lis_FF2Qbb9DeXN8"}],"order_line_item":{"origin_order_number":null,"origin_order_source_system_id":"1635149:1641664","source_system_id":"2"}},{"order_line_item_id":"ordi_ZeV6W8BmrgWs","quantity":140,"name":"SNAP LOCK HOSE CLAMP ASSEMBLY 31\"L/POST UP TO 10\"OD (100/CASE)[F]","description":null,"sku":"RHSLAFM","upc":null,"value":3.76,"weight":0.3,"weight_uom":"lb","hs_code":null,"country_of_origin":"US","child_sku":null,"child_sku_quantity":null,"line_number":4,"source_system_line_number":null,"source_system_id":"4","origin_order_number":null,"line_item_skus":[{"id":"lis_K63tDj9jNrrg","name":"SNAP LOCK HOSE CLAMP ASSEMBLY 31\"L/POST UP TO 10\"OD (100/CASE)[F]","sku":"RHSLAFM","quantity":140,"quantity_aggregated":140,"child_sku":null,"child_sku_quantity":null,"value":3.76,"currency":"USD","length":5.0,"width":5.0,"height":0.8,"dimension_uom":"in","weight":0.3,"weight_uom":"lb","item_type":"unpacked","unpacked_item_type_id":null,"handling_unit_type":null,"hs_code":null,"eccn":null,"freight_class":null,"package_type":"box","package_quantity":null,"upc":null,"country_of_origin":"US","description":null,"commodity_description":null,"bin_number":null,"mpn":null,"gtin":null,"asin":null,"inventory_identification":null,"inventory_identifier_codes":[],"line_item_sku_components":[],"order_line_item_sku_id":"lis_NH8kAK7tBxpC"}],"order_line_item":{"origin_order_number":null,"origin_order_source_system_id":"1635149:1641664","source_system_id":"4"}},{"order_line_item_id":"ordi_Xs4skMGtH13T","quantity":140,"name":"STAINLESS STEEL BRACKET MINUS 4 FOR POLES 4\"OD OR LESS (BOLT NOT INCLUDED)","description":null,"sku":"RHSSBMINUS4","upc":null,"value":1.29,"weight":0.11,"weight_uom":"lb","hs_code":null,"country_of_origin":"US","child_sku":null,"child_sku_quantity":null,"line_number":5,"source_system_line_number":null,"source_system_id":"5","origin_order_number":null,"line_item_skus":[{"id":"lis_V5ZgTf1yKqSB","name":"STAINLESS STEEL BRACKET MINUS 4 FOR POLES 4\"OD OR LESS (BOLT NOT INCLUDED)","sku":"RHSSBMINUS4","quantity":140,"quantity_aggregated":140,"child_sku":null,"child_sku_quantity":null,"value":1.29,"currency":"USD","length":1.95,"width":1.5,"height":1.35,"dimension_uom":"in","weight":0.11,"weight_uom":"lb","item_type":"unpacked","unpacked_item_type_id":null,"handling_unit_type":null,"hs_code":null,"eccn":null,"freight_class":null,"package_type":"box","package_quantity":null,"upc":null,"country_of_origin":"US","description":null,"commodity_description":null,"bin_number":null,"mpn":null,"gtin":null,"asin":null,"inventory_identification":null,"inventory_identifier_codes":[],"line_item_sku_components":[],"order_line_item_sku_id":"lis_FavXm2xdKgHP"}],"order_line_item":{"origin_order_number":null,"origin_order_source_system_id":"1635149:1641664","source_system_id":"5"}},{"order_line_item_id":"ordi_W7bC1Db8CWmE","quantity":140,"name":"STAINLESS STEEL BRACKET HARDWARE 5/16\" X 18 X 3/4\" BOLT AND WASHER","description":null,"sku":"RHSSHB516","upc":null,"value":0.54,"weight":0.025,"weight_uom":"lb","hs_code":null,"country_of_origin":"US","child_sku":null,"child_sku_quantity":null,"line_number":6,"source_system_line_number":null,"source_system_id":"6","origin_order_number":null,"line_item_skus":[{"id":"lis_Rpb2JnjHt5ha","name":"STAINLESS STEEL BRACKET HARDWARE 5/16\" X 18 X 3/4\" BOLT AND WASHER","sku":"RHSSHB516","quantity":140,"quantity_aggregated":140,"child_sku":null,"child_sku_quantity":null,"value":0.54,"currency":"USD","length":0.85,"width":0.6,"height":0.7,"dimension_uom":"in","weight":0.025,"weight_uom":"lb","item_type":"unpacked","unpacked_item_type_id":null,"handling_unit_type":null,"hs_code":null,"eccn":null,"freight_class":null,"package_type":"box","package_quantity":null,"upc":null,"country_of_origin":"US","description":null,"commodity_description":null,"bin_number":null,"mpn":null,"gtin":null,"asin":null,"inventory_identification":null,"inventory_identifier_codes":[],"line_item_sku_components":[],"order_line_item_sku_id":"lis_jyyFFAqqwSe2"}],"order_line_item":{"origin_order_number":null,"origin_order_source_system_id":"1635149:1641664","source_system_id":"6"}}],"reference_numbers":[{"id":"shpr_8SeTQsdg3863","code":"other_id","value":"F","name":"UPS Signature"},{"id":"shpr_Js6fpvwSdw6J","code":"other_id","value":"T","name":"Liftgate Delivery"},{"id":"shpr_215thWapERzS","code":"other_id","value":"0.00","name":"Handling Cost"},{"id":"shpr_QsfpvnGzDDmf","code":"other_id","value":"F","name":"Blind Dropship"},{"id":"shpr_hTta5FmEgCTn","code":"other_id","value":"26-25180","name":"PO"},{"id":"shpr_0GNxxXA42r7X","code":"other_id","value":"SO555786","name":"Sales Order"},{"id":"shpr_1Sn2smbyceQH","code":"other_id","value":"T","name":"PalletCam Image Uploaded"},{"id":"shpr_qcVNQ9cZH5Sr","code":"other_id","value":"843 lbs.","name":"Total Pallet Weight"},{"id":"shpr_NBa4hK4tS7eA","code":"other_id","value":"SLSYS Southern Lighting & Traffic Systems","name":"Customer"},{"id":"shpr_2cQyvQwk625t","code":"other_id","value":"Standard Freight Service","name":"Shipping Service Rated"},{"id":"shpr_NHSvsvkPaDy4","code":"other_id","value":"Origin - Freight Quoted","name":"F.O.B."},{"id":"shpr_Sq7dPWFq7ww3","code":"other_id","value":"SO555786","name":"Order Number"}],"origin_instructions":"Pickup Instructions","destination_instructions":"FORKLIFT-N APPT-N LIFTGATE-Y","print_package_labels_enabled":true,"exceptions":[],"est_delivery_date":"2026-08-21T00:00:00.000+00:00","service_days":null,"order_id":"ord_G5TnfxjNDNsm","order_number":"IF57376","combined_order_numbers":["IF57376"],"combined_source_system_ids":["1641664"],"order_line_items_quantity":[{"id":"ordi_edqVDgEdKz7v","quantity":50,"sku":"VS3636W1123AG"},{"id":"ordi_th7qgmf7yWGE","quantity":20,"sku":"S2448S5125FH3A"},{"id":"ordi_ZeV6W8BmrgWs","quantity":140,"sku":"RHSLAFM"},{"id":"ordi_Xs4skMGtH13T","quantity":140,"sku":"RHSSBMINUS4"},{"id":"ordi_W7bC1Db8CWmE","quantity":140,"sku":"RHSSHB516"}],"label_url":null,"label_format":null,"label_document_id":null,"label_pdf_url":null,"label_pdf_document_id":null,"label_zpl_url":null,"label_zpl_document_id":null,"end_of_day_manifest_date":null,"created_at":"2026-08-18T11:09:57.557+00:00","created_by":{"type":"user","name":"antwan@cpcsigns.com"},"updated_at":"2026-08-18T11:09:58.750+00:00","actual_pickup_time":null,"shipment_billing":{"shortcut_account_number":null,"account_number":null,"name":"","company":"","phone_number":"","street1":"","street2":"","city":"","state":"","country":"US","zip":"","bill_to":"sender","carrier_code":"randl","service_code":"STD","service_name":"Standard Freight Service","billing_country_zip_mismatch":null},"duties_taxes_billing":{"shortcut_account_number":null,"account_number":"","name":"","company":"","phone_number":"","street1":"","street2":"","city":"","state":"","country":"US","zip":"","bill_to":"recipient","carrier_code":null,"service_code":null,"service_name":null,"billing_country_zip_mismatch":null},"packing_slip_template":{"size":null,"advanced_size":"letter_landscape"},"can_attach_bol":true,"cannot_attach_bol_reason":null,"can_attach_master_bol":false,"cannot_attach_master_bol_reason":null,"accessorials":[{"accessorial_type":"liftgate_delivery","price":54.0}],"is_generate_commercial_invoice":false,"can_dispatch":true,"ship_date":"2026-08-18T11:09:57.499+00:00","pro_number":"344717388","recipient_name":"Marlin Glass","proposed_shipment_id":"pshp_xqVjgTXSMEWF","insurance_category_id":null,"currency":"USD","email_docs":{"recipient_email":"jpoole@southernltg.com","email_content":"Hi Marlin Glass,\n\nYour shipping documents are attached to this email.\n\nThis shipment is in regards to reference numbers:\n0.00\n26-25180\n843 lbs.\nF\nF\nOrigin - Freight Quoted\nSLSYS Southern Lighting & Traffic Systems\nSO555786\nSO555786\nStandard Freight Service\nT\nT\n\nIf you have any questions or concerns, please contact CPC Signs.\n"},"customs_data_list":[],"eei":{"compliance":null,"compliance_code":null},"carrier_account":{"id":"ca_ScZz9wG1nyTX","name":"Default RandL [WH: 1120]","provider_code":"randl","provider_name":"RandL","default":true,"integration_id":null,"warehouse_id":null,"packing_types":[],"insurance_categories":[]},"warehouse":{"id":"whs_YZDTzDZHVYQC","code":"1120","default_for_international":false,"enabled_for_external_domestic_rating":true,"enabled_for_external_international_rating":true,"domestic_priority":1,"international_priority":1,"currency":null,"dimension_uom":"in","weight_uom":"lb","created_at":"2023-03-03T19:07:43+00:00"},"workstation":null,"external_shipping_price_markup":{"type":"percent","value":27.0,"rule_id":"spol_EG4akZsvjhr8"},"external_shipping_price_markups":[{"type":"percent","value":27.0,"rule_id":"spol_EG4akZsvjhr8"}],"local_cancellation_only":false,"warnings":null,"license_plate_number":null,"all_license_plate_numbers":[],"cover_genius_id":null,"cover_genius_security_token":null,"cover_genius_status":null,"freight_request_quote_id":null,"designated_weight_uom":"lb","designated_dimension_uom":"in","parent_ids":[],"inventory_identifiers":[],"single_bin_number":"(None)","consolidation_key":null,"event":"shipment.create_from_order"}



2026-08-18 06:43:17