iVend Database Database > Tables

Navigation: iVend Database Database > Tables >

iVend 6.6 Database Help

RtlStore Table

Collapse All Expand All

iVend Database Database : RtlStore Table

Description

Contains the details of Stores defined in the system.

Properties

Creation Date	4/13/2015 12:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	2
Data Space Used	8.00 KB
Index Space Used	40.00 KB

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
StoreKey	Value is the system generated Primary Key of the table.	VarWChar	50
Id	Value is the id of the store.	VarWChar	20
Description	Value is the description of the store.	VarWChar	100
AddressKey	Value is the key of the address defined for the store. See also Address	VarWChar	50
RetailProfileKey	Value is retail profile selected for the store (Default can be overriden at POS level).See also Retail Profile	VarWChar	50
CashCustomerKey	Value is the key of the customer card which has been marked as the cash customer or one time customer. See also Customer	VarWChar	50
CustomerTemplateKey	For future use.	VarWChar	50
PurchaseTaxCodeKey	Value is the key of tax code which will be applicable for the store specific purchase transactions (Default and may be Overriden). See also TaxCode	VarWChar	50
SalesTaxCodeKey	Value is the key of tax code which will be applicable for the store specific sale transactions (Default and may be Overriden). See also TaxCode	VarWChar	50
WarehouseKey	Value is the warehouse key which is store specific (selling warehouse for the store). See also Warehouse	VarWChar	50
Email	Value is the email of the store.	VarWChar	50
BankAccount	Value is the bank account number of the store.	VarWChar	50
Bank	Value is the bank details of the store like bank name .	VarWChar	50
SiteId	Value is the site id of the store.	Integer	4
PriceListKey	Value is the Pricelist Key used at the store for commodities. See also PriceList	VarWChar	50
LayawayPlanKey	Value is the key of the layaway plan applicable on the layaway transactions on that store (Default and may be Overriden).See also Layaways	VarWChar	50
FulfillmentPlanKey	Value is the key of the fulfillment plan applicable for the fulfillments attached to the transactions at store (Default and may be Overriden). See also Fulfillments	VarWChar	50
BusinessDate	Contains the business day of the store. Value will be automatically updated when end of day will be carried on.	DBTimeStamp	4
CreatedBy	Reference of user who has created this record. See also Security User	VarWChar	50
Created	Date of creation of this record	DBTimeStamp	4
Modified	Date of last modification of this record	DBTimeStamp	4
ModifiedBy	Reference of user who has modified this record. See also Security User	VarWChar	50
IsDeleted	Value is True if the record has been deleted from the system. Record is always Soft Deleted	Boolean	1
SalesPersonKey	Reference key of the Sales person. See also Employee	VarWChar	50
ReassignAllTillsAtEOD	Flag to check whether all the master tills are to be reassigned when the store manager runs End Of Day.	Boolean	1
HardwareProfileKey	Sepcifies the Hardware Profile that is attached to the Management Console. Based on the Profile, the scanner will be used for Goods Receipt and GRPO.	VarWChar	50		((0))
RestartTransactionIdAtEOD	Obselete	Boolean	1		((0))
PricingStoreGroupKey	Specifies the Store Group under which this store falls for the selection of the price list	VarWChar	50		((0))
IsLoyaltyEnabled	Specifies if the loyalty system is configured for this instance of iVend	Boolean	1		((0))
LoyaltyServiceEndPoint	If loyalty service is enabled then this setting would specify the path of the loyalty service	VarWChar	1000
LayawayFulfillmentPlanKey	Value is the key of the fulfillment plan applicable for the fulfillments of layaway items attached to the transactions at store (Default and may be Overriden). See also Fulfillments	VarWChar	50		((0))
StoreType	Signifies the type of the store. Valid values are: Retail Store = 0 Web Store = 1	Integer	4		((0))
EStoreUserId	Stores the User Id for connecting the E- Store	VarWChar	50
EStorePassword	Stores the Password for connecting the E- Store	VarWChar	100
EStoreURL	Stores the URL of the E-Store	VarWChar	255
TaxationStoreGroupKey	Stores the Key that specifies the Store group based on their Taxation and can be used to setup different Tax Condition.	VarWChar	50		((0))
DeviceId	Stores the Device ID for the Mobile Store.	VarWChar	255
IsEStorePasswordHashed	Value is true if password is hashed (encrypted)	Boolean	1
LoyaltySiteId	Stores the Value for the Loyalty Site ID to which this store is connected	Integer	4
CostPriceListKey	Value is the Start Time of the Message.	VarWChar	50		((0))
BaseCurrencyKey		VarWChar	50
IsOnPremise	Value is True if the Store is on Premise	Boolean	1
IsAddOnUpdated	Value is True if the AddOn has been updated	Boolean	1		((0))
ApiServerEnableSSL	Value is the true if the API server supports SSL	Boolean	1
ApiServerAdvanceSetting	Value is true is the API server value would be a complete link rather a IP address only	Boolean	1
ApiServerAddress	Stores the Api server IP address	VarWChar	100
IsOfflinePOSEnabled	Value is True if the POS is ready to go for Offline mode.	Boolean	1		((0))
RetailPriceListKey	Reference key for the Price List. See Price List.	VarWChar	50
CustomerPriceGroupKey	Reference Key for the Price Group.	VarWChar	50
SubsidiaryKey	Reference key of the Subsidiary. See also Subsidiary	VarWChar	50		((0))
UseStoreSchedulerService	Value is True if the Store Scheduler Serivce has to be used for the Alert Notifications. Otherwise Enterprise scheduler service will be used.	Boolean	1
TaxNumber		VarWChar	50
DoAutomaticEndofDay		Boolean	1		((0))
AutomaticEndofDayTime		DBTimeStamp	4

Indexes

Index	Description	Primary	Unique
IX_RtlStore_1
IX_RtlStoreSiteID
PK_StoStore

Objects that depend on RtlStore

Database Object	Object Type	Description	Dep Level
AssignTill	Stored Procedure	Assigns a Till to the selected POS	1
BarCodeResolution	Stored Procedure		1
CreateTillCount	Stored Procedure		1
CustomeLabelReport	Stored Procedure		2
DailySaleSummary	User Defined Function		1
DataNotification	Stored Procedure		1
DeleteSuspendedTransactionDetails	Stored Procedure		1
GenerateLabelData	Stored Procedure	Generates label data depending on the parameter specified	1
GetDeliveryPackages	Stored Procedure		1
GetFulfilmentTransactions	Stored Procedure		1
GetMobilePOSDeliveryTransactions	Stored Procedure		1
GetMobileReplicationData	Stored Procedure		1
GetNextAutoGeneratedCode	Stored Procedure	Generates the next code depending on the Source Type	1
GetTransactionLinkDocument	Stored Procedure		1
GetUserRights	Stored Procedure	Gets the valid rights for the user	1
GetValidPromotionsForProduct	Stored Procedure		1
GoodsIssueReport	Stored Procedure		1
GoodsReceiptPOReport	Stored Procedure		1
GoodsReceiptReport	Stored Procedure		1
Integration_ARPayment	Stored Procedure		1
Integration_Consolidated_Transaction	Stored Procedure		1
Integration_Consolidated_TransactionPayment	Stored Procedure		1
Integration_StockTransfer	Stored Procedure		1
Integration_TransactionPayment	Stored Procedure		1
InventoryCount_Save	Stored Procedure		1
InventoryItemQuantityUpdates	Stored Procedure		1
LogAuditInformation	Stored Procedure		1
Loyalty_ActiveBillValue	View		1
Loyalty_ActiveTransactionCount	View		1
MRP	Stored Procedure		1
PurchaseOrderReport	Stored Procedure		1
RemoveTill	Stored Procedure	Removes a Till from the selected POS	1
ReplicationGetMobileSites	Stored Procedure		1
ReplicationRecordsToSend	Stored Procedure		1
Rpt_ActiveLoyalty	User Defined Function		1
Rpt_ItemWithoutSale	User Defined Function		1
rpt_LayAway	Stored Procedure		1
rpt_StockTransfer	Stored Procedure		1
RPT_StoreAnalysis	Stored Procedure		1
rptSalesData	User Defined Function		1
rptSalesTransactionData	User Defined Function		1
rptSalesTransactionDataWithSalesPerson	User Defined Function		1
SalesAnalysisbySalesPersons	Stored Procedure		2
SalesDetail	User Defined Function		1
StockTransferReport	Stored Procedure		1
Trg_ReplicationTransactionMobile	Trigger		1
TrxCompleteTransactionUpdates	Stored Procedure		2
TrxConsolidateTransaction	Stored Procedure		1
TrxConsolidateTransactionForCreditCustomers	Stored Procedure		1
TrxInventoryUpdateCheckNegativeInventory	Stored Procedure		1
TrxInventoryUpdateLaybyCancellationItem	Stored Procedure		1
TrxInventoryUpdateLaybyItem	Stored Procedure		1
TrxInventoryUpdateOrder	Stored Procedure	Handles updates related to Order item	1
TrxInventoryUpdateSaleDelivery	Stored Procedure	Handles updates related to delivery of a Sale item	1
TrxInventoryUpdateSerialNumber	Stored Procedure		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
usp_InvInventoryItem_Condition	User Defined Function		1
uspGetItemPrice	Stored Procedure		1
uspGetItemPriceForNAV	Stored Procedure		1
uspTapeReport	Stored Procedure		1
vw_GrossProfit	View		1
vw_SalesReportData	View		1
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
XTapeReport	Stored Procedure	Generates the XTape report for a particular till	1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RtlStore](

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

[Id] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Description] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

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

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

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

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

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

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

[Email] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[BankAccount] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Bank] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SiteId] [int] NOT NULL,

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

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

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

[BusinessDate] [datetime] NOT NULL,

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

[Created] [datetime] NOT NULL,

[Modified] [datetime] NOT NULL,

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

[IsDeleted] [bit] NOT NULL,

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

[ReassignAllTillsAtEOD] [bit] NOT NULL,

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

[RestartTransactionIdAtEOD] [bit] NOT NULL,

[PricingStoreGroupKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsLoyaltyEnabled] [bit] NOT NULL,

[LoyaltyServiceEndPoint] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

[StoreType] [int] NOT NULL,

[EStoreUserId] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[EStorePassword] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[EStoreURL] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[TaxationStoreGroupKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[DeviceId] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsEStorePasswordHashed] [bit] NULL,

[LoyaltySiteId] [int] NULL,

[CostPriceListKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[BaseCurrencyKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsOnPremise] [bit] NULL,

[IsAddOnUpdated] [bit] NULL,

[ApiServerEnableSSL] [bit] NULL,

[ApiServerAdvanceSetting] [bit] NULL,

[ApiServerAddress] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsOfflinePOSEnabled] [bit] NULL,

[RetailPriceListKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CustomerPriceGroupKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SubsidiaryKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[UseStoreSchedulerService] [bit] NULL,

[TaxNumber] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[DoAutomaticEndofDay] [bit] NULL,

[AutomaticEndofDayTime] [datetime] NULL,

CONSTRAINT [PK_StoStore] PRIMARY KEY CLUSTERED

(

[StoreKey] 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].[RtlStore] ADD CONSTRAINT [DF__RtlStore__Hardwa__192BAC54] DEFAULT ((0)) FOR [HardwareProfileKey]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF_RtlStore_RestartTransactionIdAtEOD] DEFAULT ((0)) FOR [RestartTransactionIdAtEOD]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF_RtlStore_PricingStoreGroupKey] DEFAULT ((0)) FOR [PricingStoreGroupKey]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF_RtlStore_IsLoyaltyEnabled] DEFAULT ((0)) FOR [IsLoyaltyEnabled]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF_RtlStore_LayawayFulfillmentPlanKey] DEFAULT ((0)) FOR [LayawayFulfillmentPlanKey]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF_RtlStore_StoreType] DEFAULT ((0)) FOR [StoreType]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF_RtlStore_PricingStoreGroupKey1] DEFAULT ((0)) FOR [TaxationStoreGroupKey]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF_RtlStore_CostPriceListKey] DEFAULT ((0)) FOR [CostPriceListKey]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF_RtlStore_IsAddOnUpdated] DEFAULT ((0)) FOR [IsAddOnUpdated]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF_RtlStore_IsOfflinePOSEnabled] DEFAULT ((0)) FOR [IsOfflinePOSEnabled]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF__RtlStore__Subsid__3D1EF407] DEFAULT ((0)) FOR [SubsidiaryKey]

ALTER TABLE [dbo].[RtlStore] ADD CONSTRAINT [DF_RtlStore_DoAutomaticEndofDay] DEFAULT ((0)) FOR [DoAutomaticEndofDay]

Related Objects

iVend Database Database

Send comments on this topic.