iVend Database Database : GetNextSiteNumberForCurrentSite Stored Procedure

Creation Date

12/3/2015 10:29 AM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@NextnoId

In

Id for which the accounting id has to be generated

VarChar

50

@Result

Out

Next Number generated by the procedure

VarWChar

50

@RETURN_VALUE

Return Value

Integer

4

Database Object

Object Type

Description

Dep Level

CfgSiteInformation

Table

Stores the site information. Enterprise always has the site id as 1. System Table Warning : Should not be modified directly

1

GetNextSiteNumber

Stored Procedure

1

/**

BEGIN TRANSACTION

DECLARE @lNewKey nvarchar(50)

EXEC GetNextSiteNumberForCurrentSite 'Table.AuditLogFilter', @lNewKey OUTPUT

SELECT @lNewKey

ROLLBACK TRANSACTION

***/

CREATE PROCEDURE [dbo].[GetNextSiteNumberForCurrentSite]

(

  @NextnoId VARCHAR(50),

  @Result   nvarchar(50) OUTPUT

)

AS

BEGIN

SET NOCOUNT ON

DECLARE @lNewKey nvarchar(50) ,

          @lSiteId INT ,

          @lPOSSiteId INT;

  SELECT @lSiteId = SiteId ,

          @lPOSSiteId = ISNULL(POSSiteId, 0)

  FROM    CfgSiteInformation;

SELECT @lNewKey = 0;

  EXEC GetNextSiteNumber @lSiteId, @NextnoId, @lNewKey OUTPUT, 0, @lPOSSiteId;

SET @Result = @lNewKey

END