SELECT pickOrderNo, waveOrder, pickOrderState, id, transNo, customerId, customerName, custAddress, desk, bulkBox, bulkBag, sumBoxCnt, tranLocationId, volume, weight, orderBulkPickState, orderBatchPickState, orderDate, pickedBy, pickedTime, waveStart, waveEnd, priority, seedsPickNo, invoicedBy, invoiceNo, docNo, invoicedByName, checkedByName, salesperson, checkedBy, goodsId, goodsName, goodsPickState, batch, count, bulkCount, batch1Count, batch2Count, boxcnt, productDate, validDate, manufacturer, spec, regeditCode, unit, type, barCode, goodsType, goodsTypeName, bulkPickState, batchPickState, bigCount, skuId, skuCode, ownerName, description, price, phone1, phone2, approvedBy, sumPrice, orderDesc, lineName, invoicePrintCnt FROM dbo.v_stockOutRequestPick