异动盘点：一般在每天下班前，由系统导出当天有货物进出的库位，交由仓管去指定库位盘点货物，盘点数据与系统数据对比确认是否有差异。

select * from v_Invtake  where loc in  --v_Invtake视图 查询库存信息

(

/*********************当天收货*********************/

 SELECT distinct LOC FROM RECEIPTDETAIL

    WHERE RECEIPTDETAIL.STATUS>='06'

    AND LOC<>''

    AND CONVERT(DATETIME,RECEIPTDETAIL.LOTTABLE04,120)='2012-9-20'

 UNION  All

/*********************当天物转*********************/

    SELECT distinct TOLOC  from InvTransferDetail

    left join   InvTransfer on  InvTransfer.whseid=InvTransferDetail.whseid and InvTransfer.transferkey=InvTransferDetail.transferkey

    WHERE  InvTransfer.status='1' and  InvTransfer.type='1'

    AND CONVERT(datetime, CONVERT(varchar(10), InvTransferDetail.adddate, 120),120)='2012-9-20'

UNION ALL

/*********************当天出货*********************/

    SELECT  distinct FROMLOC FROM PICKDETAIL

    WHERE  STATUS='05'

    AND  CONVERT(datetime, CONVERT(varchar(10), PICKDETAIL.EDITDATE, 120),120)='2012-9-20'

UNION ALL

/*********************当天移库*********************/

    SELECT distinct TOLOC FROM InvMoveDetail

    JOIN InvMove ON InvMove.WHSEID=InvMoveDetail.WHSEID AND InvMoveDetail.MOVEKEY=InvMove.MOVEKEY

    WHERE InvMove.STATUS='1'

    AND CONVERT(datetime, CONVERT(varchar(10), C_DATE, 120),120)='2012-9-20'

)