iVend Database Database : CustomeLabelReport Stored Procedure

Creation Date

4/13/2015 12:00 PM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@pMachineName

In

VarWChar

100

@RETURN_VALUE

Return Value

Integer

4

Database Object

Object Type

Description

Dep Level

CfgEnterprise

Table

Stores the basic configuration entries for the system . These settings are mandatory for the system to work properly.

3

CfgSiteInformation

Table

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

3

GenerateLabelData

Stored Procedure

Generates label data depending on the parameter specified

1

GenerateLabelData_Custom

Stored Procedure

2

GetCompanyDateTime

User Defined Function

2

InvInventoryItem

Table

Stores inventory details for each Product for each Warehouse

2

InvProduct

Table

Stores the product related details.

2

PrnLabelPrintField

Table

Store the fields to be used in label printing

2

PrnLabelPrinting

Table

2

RtlStore

Table

Contains the details of Stores defined in the system.

2

CREATE PROCEDURE [dbo].[CustomeLabelReport]

(

@pMachineName NVarChar(100)   /*Stored Procedure edit by Jyotsna As per discuss with Santosh to execute the irt report in Item label printing*/

-- @pStoreKey BIGINT

)

AS

BEGIN

SET NOCOUNT ON

DECLARE @lStoreKey NVARCHAR(50),

  @lEffectiveDate DateTime,

  @lMachineName NVarChar(100)

--Select @lEffectiveDate = BusinessDate

--From RtlStore

--Where StoreKey = @pStoreKey

--SET @lMachineName = HOST_NAME()

Exec GenerateLabelData @pMachineName, 'False'

END