深圳智汇创想科技有限公司

1.其他入库

2.其他出库

相关语句：

select top 100 * from RB_Inventory_InOutBallance with (nolock) where CustomerID=1 and Remark = '根据云仓入库报告自动生成,原入库单类型为：产品库存处理单'

select top 100 * from RB_Inventory_InOutBallance with (nolock) where CustomerID=1 and Remark = '根据云仓出库报告自动生成，原出库单类型为：产品库存处理单'


select top 1000 * from RB_OutboundReceivingDetailList WITH(NOLOCK) where CustomerID=1 and OrderSearchKey=6 
order by Id desc

select top 1000 * from RB_ShippingReceivingDetailList WITH(NOLOCK) where CustomerID=1 and OrderSearchKey=6 
order by Id desc


select top 1000 * from RB_ShippingReceivingDetailList WITH(NOLOCK) where CustomerID=1 and Id=9143
select top 1000 * from RB_OutboundReceivingDetailList WITH(NOLOCK) where CustomerID=1 and Id=23453

--update RB_Inventory_InOutBallance set CustomerID=-1 where ID IN (2655,2542)
--update RB_ShippingReceivingDetailList set CreationTime='2023-06-21 19:37:08.217',Status=1,WareHouseID=4393,ProductSku='2SS903380-BK' where CustomerID=1 and Id=9143
--update RB_OutboundReceivingDetailList set CreationTime='2023-06-21 19:37:08.217',Status=1,WareHouseID=4424,ProductSku='59P31K15X5LY4C',Reason=0 where CustomerID=1 and Id=23453

SELECT  
alias.Id,
alias.CustomerID,
alias.WareHouseID,
alias.WareHouseName,
alias.OperationTypeId,
alias.OrderSearchKey,
alias.OutOrderCode,                                 
alias.StorageModeId,
alias.ProductSku,
alias.Quantity,
alias.ItemCode,
alias.CreationTime,
alias.Status,
alias.Reason,
alias.ShipmentiID,
b.warehousename LocalWareHouseName,
alias.ReferenceOrderCode,
alias.Remark
FROM    RB_OutboundReceivingDetailList alias WITH ( NOLOCK ) 
inner join rb_warehouse b with(nolock) on alias.WareHouseID=b.id                                                                  
WHERE   alias.CustomerID = 1
AND alias.CreationTime >= '2023-06-01'
AND alias.CreationTime <'2023-07-01'
AND alias.OrderSearchKey in (7,6,4,3,5) And alias.Status in (2,1)

SELECT  CustomerID ,
WareHouseID ,
SKU ,
OrderSourceSKU
FROM    RB_WareHouse_Product WITH ( NOLOCK )
WHERE   CustomerID = 1
--AND WareHouseID IN ( SELECT CONVERT(INT, item)
--FROM   CharSplitForIn('4344', ',') )
--AND OrderSourceSKU IN ( SELECT  CONVERT(NVARCHAR, item)
--FROM    CharSplitForIn('6351354', ',') )
AND ISNULL(SKU,'')!=''

代码提交记录：