SELECT id, locationCode, orderNo, goodsId, batch, locationId, count, direction, validDate, productDate, description, operater, lastmodified, createtime, dr, bigCount, unit, spec, manufacturer, goodsName, box, type, regeditCode FROM dbo.v_reportStockRecord