SELECT id, pickOrderNo, waveOrder, recordId, count, boxcnt, locationId, state, pickCount, description, operater, dr, createtime, lastmodified, batch, productDate, validDate, goodsName, manufacturer, spec, unit, bigCount, BarCode, goodsTypeName, type, bulkMax, bulkMax1, batchMax1, batchMax2, customerName, batchPickState, regeditCode, customerId, goodsId, orderType, orderDate, tranLocationId FROM dbo.v_stockOutBatchPickDetail