iVend Database Database : GetCompanyDateTime User Defined Function

Creation Date

4/13/2015 12:00 PM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@RETURN_VALUE

Return Value

DBTimeStamp

4

Database Object

Object Type

Description

Dep Level

AssignTill

Stored Procedure

Assigns a Till to the selected POS

1

BatchLocationQuantityUpdates

Stored Procedure

Used in replication to update the Batch quantities

1

BatchQuantityUpdates

Stored Procedure

1

BreakBuildKit

Stored Procedure

1

CancelStockTransfer

Stored Procedure

1

CustomeLabelReport

Stored Procedure

2

DataNotification

Stored Procedure

2

ExecuteInventoryItemLogUpdate

Stored Procedure

2

GenerateLabelData

Stored Procedure

Generates label data depending on the parameter specified

1

GetInventoryItemForStockCount

Stored Procedure

1

GetMobileReplicationData

Stored Procedure

1

GetNextDocumentNumberForPOS

Stored Procedure

Generates the next Transaction Number depending on the Parameters provided

1

GetValidPromotionsForProduct

Stored Procedure

1

InventoryItemQuantityUpdates

Stored Procedure

1

InventoryItemSerialStatusUpdates

Stored Procedure

1

InvWarehouseInventoryLocation

Stored Procedure

1

LogAuditInformation

Stored Procedure

1

Loy_GetMonthlyPointSummary

Stored Procedure

1

RemoveTill

Stored Procedure

Removes a Till from the selected POS

1

TrgSBOBatchUpdate

Trigger

Handles updates made to Batch table from ERP system (Business One in this case)

2

TrgSBOInventoryUpdate

Trigger

Handles updates made to item inventory in the ERP system (Business One in this case)

1

TrxCompleteTransactionUpdates

Stored Procedure

2

TrxInventoryUpdateBatchNumber

Stored Procedure

1

TrxInventoryUpdateLaybyCancellationItem

Stored Procedure

1

TrxInventoryUpdateLaybyItem

Stored Procedure

1

TrxInventoryUpdateOrder

Stored Procedure

Handles updates related to Order item

1

TrxInventoryUpdatePaymentDiscount

Stored Procedure

Handles updates related to sale item

1

TrxInventoryUpdateQuotation

Stored Procedure

Handles updates related to Quotation item

1

TrxInventoryUpdateSaleDelivery

Stored Procedure

Handles updates related to delivery of a Sale item

1

TrxInventoryUpdateSaleItem

Stored Procedure

Handles updates related to sale item

1

TrxInventoryUpdatesSaleRefund

Stored Procedure

Handles updates related to On Account payments

1

TrxUpdateCustomerBalance

Stored Procedure

1

UpdateTillAmounts

Stored Procedure

Handles updates to Till once payment against a transaction has been taken

1

UseDrawer

Stored Procedure

Creates a valid Till User session depending on the Cash drawer selected by the user

1

uspGetItemPrice

Stored Procedure

1

uspGetItemSpecialPrice

Stored Procedure

Determines the price of the Product for the customer specified and other parameters

1

vw_ProductCost

View

1

ZTapeReport

Stored Procedure

1

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.

1

CfgSiteInformation

Table

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

1

CREATE FUNCTION [dbo].[GetCompanyDateTime]()

RETURNS DATETIME

AS

BEGIN

DECLARE @returnDate DATETIME

DECLARE @TimeZoneOffSetInMinutes DECIMAL(20,5)

IF EXISTS(SELECT * FROM CfgSiteInformation WHERE ISNULL(SiteId,0) > 1)

BEGIN

RETURN GetDate()

END

SET @TimeZoneOffSetInMinutes = 0

SELECT @TimeZoneOffSetInMinutes = CompanyTimeZoneOffSetInMinutes FROM dbo.CfgEnterprise

IF(ISNULL(@TimeZoneOffSetInMinutes, 0) = 0)

SET @returnDate = getdate();

ELSE

SELECT @returnDate = DATEADD(minute,@TimeZoneOffSetInMinutes,GetUTCDate())

RETURN @returnDate;

END