select * from so s where code = 'HI.OL.2407.01312';

select * from order_sales os where order_code = 'HI.OL.2407.01312';

select * from order_sales_address osa where order_sales_id = 8219;

select * from order_sales_detail osd where order_sales_address_id = 8227;

select * from so_detail_sn sds where so_id = 10531;

select * from model_sn ms where serial_number = '111007900201111110000483';

select * from unit_sn_history_wms ushw where unit_id = 75429;