fnTransactions_GetTopNUnprocessedCustomTransactionForClient

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@ClientID	int	IN
@TransactionTypeGuid	uniqueidentifier	IN
@N	int	IN

Definition

Copy

CREATE function [dbo].[fnTransactions_GetTopNUnprocessedCustomTransactionForClient]
          (@ClientID int,
           @TransactionTypeGuid as uniqueidentifier,
           @N as int)
          returns table as
      return (
          select top (@N)
          ctran.TransactionTypeGuid,
          ctran.CustomTransactionID,
          ctran.DateLastChanged,
          ctran.AddedByUserID,
          ctran.Data,
          dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(ctran.addedbyuserid) BackofficeID

          from dbo.CustomTransactions ctran

          where 
              ctran.ClientsID=@ClientID
              and ctran.dateProcessed is null
              and (ctran.TransactionTypeGuid=@TransactionTypeGuid or (ctran.TransactionTypeGuid = 'B66DBB34-D0A1-4155-8E2E-89A328BCCD33' and @TransactionTypeGuid = '1A74D83C-818E-11DC-BD66-F4AD56D89593'))
          order by ctran.CustomTransactionID
      )