top of page
Search
  • ABS

iVend Replication - Re-trigger the missing to Store DB


Select 'exec DataNotification @pSourceType=38, @pSourceKey=''' + CONVERT(VARCHAR(100),InventoryItemKey) + ''',@pBatchKey=''' + CONVERT(VARCHAR(100),NewID()) + ''', @pOperationType=0,@pUserKey=1'

from invinventoryitem WITH (NOLOCK)

join InvProduct on InvProduct.ProductKey=invinventoryitem.ProductKey

where InvProduct.Id='TEST002'



1 view0 comments

Recent Posts

See All

ivend-SAP Integration Monitor from SBO to ivend Query

Select IntegrationKey,Cast(SourceType AS Varchar(20)) As SourceType,SourceKey, OperationType, isNull(LogDatetime, getdate()) As LogDatetime, Case isNull(Status, 0) When 0 Then 'Not Processed' Else 'Fa

Post: Blog2_Post
bottom of page