iVend Database Database : CfgSiteInformation Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

1

Data Space Used

8.00 KB

Index Space Used

8.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

SiteName

Refers to the description ( Enterprise, Store)

VarWChar

50

SiteId

Refers to the site id

Integer

4

ParticipateInUserExperience

Value is True if the User would like to share the system details

Boolean

1

((0))

IsUnplugged

Value is True is the Store is in Unplugged Mode

Boolean

1

IsHosted

Value is True if the Store is Hosted

Boolean

1

POSSiteId

Value is the POS site id

Integer

4

Index

Description

Primary

Unique

PK_SysSiteId

Database Object

Object Type

Description

Dep Level

AssignTill

Stored Procedure

Assigns a Till to the selected POS

1

BarCodeResolution

Stored Procedure

1

BatchLocationQuantityUpdates

Stored Procedure

Used in replication to update the Batch quantities

2

BatchQuantityUpdates

Stored Procedure

2

BreakBuildKit

Stored Procedure

2

CancelStockTransfer

Stored Procedure

1

ClearOfflinePOSData

Stored Procedure

1

CreateRollupJob

Stored Procedure

1

CustomeLabelReport

Stored Procedure

3

DataNotification

Stored Procedure

1

DeleteSuspendedTransactionDetails

Stored Procedure

1

ExecuteInventoryItemLogUpdate

Stored Procedure

3

GenerateLabelData

Stored Procedure

Generates label data depending on the parameter specified

2

GetCompanyDateTime

User Defined Function

1

GetInventoryItemForStockCount

Stored Procedure

2

GetMobileReplicationData

Stored Procedure

2

GetNextAutoGeneratedCode

Stored Procedure

Generates the next code depending on the Source Type

1

GetNextDocumentNumberForPOS

Stored Procedure

Generates the next Transaction Number depending on the Parameters provided

1

GetNextSiteNumberForCurrentSite

Stored Procedure

1

GetValidPromotionsForProduct

Stored Procedure

2

Integration_InventoryItem

Stored Procedure

1

Integration_InventoryItemPrice

Stored Procedure

1

InventoryItemQuantityUpdates

Stored Procedure

1

InventoryItemSerialStatusUpdates

Stored Procedure

2

InvWarehouseInventoryLocation

Stored Procedure

1

LogAuditInformation

Stored Procedure

1

Loy_GetMonthlyPointSummary

Stored Procedure

2

RecalculateSlabForLoyaltyCustomer

Stored Procedure

1

RemoveTill

Stored Procedure

Removes a Till from the selected POS

1

ReplicationGetMobileSites

Stored Procedure

1

ReplicationRecordsToSend

Stored Procedure

1

rpt_StockTransfer

Stored Procedure

1

Trg_ReplicationTransactionMobile

Trigger

1

Trg_RepNotification

Trigger

1

TrgSBOBatchUpdate

Trigger

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

1

TrgSBOInventoryUpdate

Trigger

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

1

TrgSBOSerialUpdate

Trigger

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

1

TrxCompleteTransactionUpdates

Stored Procedure

1

TrxConsolidateTransaction

Stored Procedure

1

TrxConsolidateTransactionForCreditCustomers

Stored Procedure

1

TrxGenerateLayawayInstallments

Stored Procedure

Generates Layaway installments for the Layaway transaction

1

TrxGenerateLayawayInstallmentsForSaleLevel

Stored Procedure

Generates Layaway installments for the Layaway transaction

1

TrxInventoryUpdateBatchNumber

Stored Procedure

1

TrxInventoryUpdateLaybyCancellationItem

Stored Procedure

2

TrxInventoryUpdateLaybyItem

Stored Procedure

2

TrxInventoryUpdateOrder

Stored Procedure

Handles updates related to Order item

2

TrxInventoryUpdatePaymentDiscount

Stored Procedure

Handles updates related to sale item

2

TrxInventoryUpdateQuotation

Stored Procedure

Handles updates related to Quotation item

2

TrxInventoryUpdateSaleDelivery

Stored Procedure

Handles updates related to delivery of a Sale item

2

TrxInventoryUpdateSaleItem

Stored Procedure

Handles updates related to sale item

2

TrxInventoryUpdateSerialNumber

Stored Procedure

1

TrxInventoryUpdatesSaleRefund

Stored Procedure

Handles updates related to On Account payments

2

TrxUpdateCustomerBalance

Stored Procedure

1

UpdateTillAfterPaymentInsert

Stored Procedure

Handles updates to Till once payment against a particular payment type has been taken

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

usp_InvInventoryItem_Condition

User Defined Function

1

uspGetItemPrice

Stored Procedure

2

uspGetItemSpecialPrice

Stored Procedure

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

2

vw_ProductCost

View

2

vwAnalytics_GiftCertificates

View

1

vwAnalytics_InventorySnapshot

View

1

vwAnalytics_MerchandiseInventoryCount

View

1

vwAnalytics_MerchandisePromotionSales

View

1

vwAnalytics_MerchandiseSales

View

1

vwAnalytics_NetSales

View

1

vwAnalytics_OpenPO_Snapshot

View

1

vwAnalytics_OpenStockTransferReceipt

View

1

vwAnalytics_OpenStockTransferRequest

View

1

vwAnalytics_POS

View

1

vwAnalytics_PromotionSales

View

1

vwAnalytics_Sales

View

1

vwAnalytics_SalesPerson

View

1

vwAnalytics_SalesTransaction

View

1

vwAnalytics_UpSellSales

View

1

ZTapeReport

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgSiteInformation](

[SiteName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SiteId] [int] NOT NULL,

[ParticipateInUserExperience] [bit] NULL,

[IsUnplugged] [bit] NULL,

[IsHosted] [bit] NULL,

[POSSiteId] [int] NULL,

CONSTRAINT [PK_SysSiteId] PRIMARY KEY CLUSTERED

(

[SiteName] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

ALTER TABLE [dbo].[CfgSiteInformation] ADD CONSTRAINT [DF_CfgSiteInformation_ParticipateInUserExperience] DEFAULT ((0)) FOR [ParticipateInUserExperience]