dbo Schema

Navigation: »No topics above this level«

iVend 6.6 Database Help

dbo Schema

Collapse All Expand All

Tables

Table	Description
ArrAccountsReceivable	Defines the on Credit details of all Customers
ArrAccountsReceivableLog	Stores the account receivable log
CfgAddon	Stores the AddOn Data for the replication
CfgAddonSetting	Stores the settings required for the iVend Add On
CfgAddress	Defines the address details for each Address.
CfgAlertNotification	Stores the Master Information for the Alerts setup
CfgAlertNotificationUser	Stores the Users assigned for the Alerts Setup
CfgAlertSchedule	Stores the Alert Schedule when the Alert is setup for Query
CfgAttributeValidValues	Defines the Valid Values of an Sales/Item level attribute.
CfgAuditLog	Stores system logs.
CfgAuditLogFilter	System Table. Defines for which columns the logs will be captured.
CfgAuditLogMaster	System Table. Stores the list of tables for which the system logs are generated.
CfgBank	Stores the bank information of the various banks defained in the system.
CfgBarCodeMask	Store the barcode mask.
CfgBarCodeMaskDetail	Detail tables for storing the barcode mask information.
CfgBranchSetup	Provides the details for the branch setup
CfgCloudServiceStatus	Defines the Cloud service status
CfgComment	Defines the details of all the comments that have been stored for various objects like Customer, Vendor etc.
CfgContact	Defines the contact details that are saved against any address
CfgCountry	The country details are specified which can be selected further at the addresses entry of the customer/ vendor or which are related to the business in some way.
CfgCounty	Table used for the county information
CfgCultureInformation
CfgCustomerDisplayFeedback	Stores the feedback form information for customer display
CfgCustomerDisplayFeedbackResult	Stores the feedback of customer
CfgCustomerDisplayIdleScreen	Stores the idle screen information for customer display
CfgCustomerDisplayIdleScreenImage	Stores image information to show on customer display screen during idle time
CfgCustomerDisplayLayout	Stores the layouts of customer display
CfgCustomerDisplayQuestions	Stores the feedback questions for customer display
CfgCustomerDisplayQuestionsOptions	Stores the options for feedback question of customer display
CfgCustomerDisplayTransactionLayout	Stores transaction layout information.
CfgCustomerDisplayTransactionLayoutDetail	Stores transaction layout information details.
CfgCustomSeries	Stores the custom numbering details for a Store/Enterprise.
CfgCustomTransactionInfoGrid	Stores the master values for the Transaction information grid
CfgCustomTransactionInfoGridDetail	Stores the detailed values for the Transaction information grid
CfgCustomTransactionInfoGridStore	Stores the master values for the Transaction information grid for Store
CfgDashboard	Stores the Dashboard information
CfgDatabaseVersion	Table used for maintaing the database version of application
CfgDiscountGroupSetup	Stores the Discount Group setup for the iVend
CfgDisplayProfile	Stores the definition for the Display profile to be used in application
CfgDocumentNumberSeries	Used to store the Document Number series for the applicatiom
CfgEmailSMSTemplate	Stores the Email and SMS templates for Loyalty and Scheduler services
CfgEmailTemplate	Stores the value for defining the Email templates
CfgEnterprise	Stores the basic configuration entries for the system . These settings are mandatory for the system to work properly.
CfgEULAInformation	System table. Do not modify
CfgHardwareDevice	Stores the hardware DLL information registered in the system.
CfgLanguageTranslation	Stores the translated description
CfgLanguageTranslationDetail	Stores the details related to translated description CfgLanguageTranslation table
CfgLayoutSettings	System Table. Saves the screen information releated to Display Profile.
CfgLineAttribute	Stores the sales attributes (Added information that can be attached to each transaction at POS) created in the system. Maximum of 10 attributes are allowed to be created.
CfgLoyaltyConfig	Stores the configuration information for the loyalty
CfgMobilePOSTableList
CfgObjectDependency	System table. Do not modify
CfgOfflineUpdateInformation
CfgPassbookSettings	used to store the master data for the iVend Passes
CfgPatch	Stores patches information.
CfgPatchReplicationInfo	Stores updated patch information on database.
CfgPaymentProcessorSetup	We can specify the payment processor required by the merchant and can setup the assembly info and other details like card type: visa/ master etc.
CfgPOSButtonGrid	Stores the grid configuration for the Buttons
CfgPOSButtonInfo	Stores the information attached to the button
CfgPOSButtonStyle	Stores the button styles
CfgPOSLayout	Stores the header level details for the POS Layout
CfgPOSLayoutDetail	Stores the control level layout information attached to the POS layout
CfgPOSOperationType	Stores the various operations which can be mapped to the buttons
CfgPOSOperationTypeParam	Parameter information for the various operations
CfgPOSTabImage	Stores TabbedControlGroup's Tab Caption Image Information
CfgPropertyCaptionSetup	Stores the values for the custom captions set by user
CfgPurgeHistory	Stores the historical data for the Purged data
CfgPurgeMaster	Stores the values for the currently scheduled Purge on database
CfgQuery	Stores the Query generated in iVend for custom data purposes
CfgReasonCode	Stores the various reason codes created in the system.
CfgReferralSetup	Defines the Loyalty Refferal Setup in the system.
CfgRegisteredApplication	Stores the third party Registered applications in the iVend.
CfgRegisteredApplicationEvents	Stores the enabled Module list of registered application in ivend. For these module event would be generate.
CfgReport	Used to store the data related to the iVend Reports
CfgSaleAttribute	Stores the sales attributes (Added information that can be attached to each transaction at POS) created in the system. Maximum of 10 attributes are allowed to be created.
CfgSearchGrid	Stores information about various Search View's used in the system
CfgSearchGridColumn	Defines a list of all the columns together with their screen names on the basis of which the resultset is shown
CfgSearchGridSearchFieldSequence	Store the sequence of the fields displayed to the user on which the user can search
CfgSecurityPolicy	System table. Do not modify
CfgSettings
CfgShippingType	Defines the various types through which the products can be shipped to the respective destinations.
CfgSignature	Stores the Signature data for the iVend transactions
CfgSiteInformation	Stores the site information. Enterprise always has the site id as 1. System Table Warning : Should not be modified directly
CfgSkin	Stores the Skin information for the application - such as theme
CfgStage	Defines the Stages for the Multilevel authorization
CfgStageApprover	Defines the assigned approvers and originator for the stage and stage authorization template
CfgStageAuthorizationTemplate	Defines the Templates for the Stage Authorization
CfgStageDocumentAuthorization	Defines the condition setup for the templates define for the stage
CfgStageTemplateList	Defines the list of stages for the defined stage templates
CfgState	The state details are specified which can be selected further at the addresses entry of the customer/ vendor or which are related to the business in some way.
CfgSystemConfiguration	Stores the system configuration information. System Table. Do not modify
CfgTableDependency	Stores the Depenedent tables name for the object
CfgTenantInformation
CfgThermalLabel	Table used for the thermal label configuration
CfgTransactionLayout	Stores layout information of POS transaction screen
CfgUpgradeInformation
CfgUpgradeProgressInformation
CfgUserDefinedField	Stores the User defined Field values
CfgUserDefinedFieldDetail	Stores the Details of the User Defined field values
CfgUserDefinedFieldValidValue	Stores the User defined field values
CfgUserDefinedTable	Stores the Users defined tables
CfgValidationRule	Stores custom validation rules that need to be implemented in the system. System Table
CfgVersion
CfgVersionHistory
CfgZipCode	Store the list of all valid zip codes which the system can accept if the Zip code validation is turned on.
ConTrxARPayment	Stores the Consolidated Transaction AR Payment values
ConTrxTransaction	Stores the Consolidated Transaction detail values
ConTrxTransactionGiftCertificate
ConTrxTransactionMapping
ConTrxTransactionPayment	Stores the consolidated values for the Transaction payments
ConTrxTransactionSaleItem	Stores the consolidated values for the Transaction Sale Item
ConTrxTransactionSalesPerson	Stores the consolidated transaction information for the Sales person
ConTrxTransactionSurcharge	Stores the consolidated information for the Transaction Surcharges
CusCreditCard	Stores the customer card information
CusCustomer	Defines the customer details that interact with the enterprise.
CusCustomerAddress	Defines the address details for each customer
CusCustomerBranch	Stores the customer branch information
CusCustomerCatalog	Header table to store Customer catalog details defined for a customer
CusCustomerCatalogDetail	Detail table to store Customer catalog details defined for a customer. Stores the customer catalog number against the products
CusCustomerComment	Defines the comments if any that are saved for any customer
CusCustomerContact	Stores the value for the customer Contact
CusCustomerDiscountGroup	Defined the various Discount groups under which the Customers can be categorised. Used in Navision Integration only
CusCustomerGroup	Defines the groups in which the customers can be catagorised.
CusCustomerPriceGroup	Defined the various Price groups under which the Customers can be categorised. Used in Navision Integration only
CusCustomerPrinting	Stores the printing information for a customer
FulFulfillmentPlan	Defines the plan through which the sold quantities can be fulfilled later to the customer.
FulFulfillmentPlanSurcharge	Defines the list of surcharge details that are attached with each fulfillment plan.
HisHistoricalSales	Stores the historic value for the sales of product
InvAlternateProduct	Defines a list of alternate products associated with a parent product that can be sold at the POS in case the parent product is unavailable etc.
InvAssemblyComponent	Defines the Assembly set up at the console together with the parent as well as the associated products.
InvAttributeDetail	Stores the details of attrbutes defined for a matrix product
InvAttributeMaster	Stores the attrbutes information for a matrix product
InvBatch	Batch details gets affected when doing any transaction with item which has been batch tracked.
InvBatchLocation	Describes the batch information with Location, Warehouse, Product and Expiry date
InvBatchLocationLog	Stores each record processed for the batch with location deifned.
InvBatchLog	Stores the Delta updates made to any batch in the system. This table gets affected when doing any inventory related transaction for a batch item.
InvDynamicAssemblyComponent	Stores dynamic assembly components.
InvForecast
InvForecastPlanning	Stores the data based on which the inventory forecast needs to plan
InvForecastPlanningDetails	Stores the detailed data for the forecast planning
InvForeCastTemp	Stores the temporary data for the forecasting
InvGoodReceipt	Stores the Goods receipt done in the system.
InvGoodReceiptBatch	This is affected in case the goods receipt is done for a batch product.
InvGoodReceiptDetail	Defines the details associated with each goods receipt
InvGoodReceiptSerial	This is affected in case the goods receipt is done for a serial tracked product.
InvGoodsReturn	Stores the data related to Inventory Goods Return
InvGoodsReturnBatch	Stores the data related to inventory goods return for batch
InvGoodsReturnDetail	Stores the details of inventory goods return
InvGoodsReturnSerial	Stores the data related to serial inventory goods return
InvHistoricalSales	Stores the Historic sales records
InvImportForecast	Specifies the Forecast details used while importing
InvInventoryCount	Stores the master data for the Inventory counting
InvInventoryCountBatch	Stores the batch details for the inventory count document.
InvInventoryCountDetail	Stores the details counting data for the inventory
InvInventoryCountSerial	Stores the serial details for the inventory count document.
InvInventoryCycleSetup	Used to stores the Inventory Cycle setup data
InvInventoryItem	Stores inventory details for each Product for each Warehouse
InvInventoryItemLog	Stores any Delta changes to the Inventory. Stores the quantity changes along with the reference of the document due to which the inventory got updated.
InvInventoryLocation	Stores the location information for the Inventory available at different locations
InvInventoryLocationLog	Stores the logs or Audit information of location for the Inventory available at different locations
InvInventoryRevaluation	Specifies the Inventory revaluation information
InvInventoryRevaluationDetail	Specifies the details for the Inventroy revaluation
InvInventorySnapshot
InvInventoryTransaction	This gets affected when the inventory of a particular item is consumed at the store itself for any reason.
InvInventoryTransactionBatch	This gets affected in case the product on the goods issue note is batch tracked.
InvInventoryTransactionDetail	Defines the details of the product on the goods issue note
InvInventoryTransactionSerial	This gets affected in case the product on the goods issue note is serial tracked.
InvItemMatrixCodeSetting	Defines the item matrix product code setup values for a defined product
InvItemMatrixGlobalSetting	Defines the item matrix product code setup values for all products
InvItemPrinting	Stores the printing information for an item
InvKitComponent	Defines the Kit set up at the console together with the parent as well as the associated products.
InvLocation	Save the location infomation.
InvLocationStockTransfer	Stores the Inter location document information.
InvLocationStockTransferBatch	Stores the information releated to batches for inter location transfers.
InvLocationStockTransferDetail	Stores the InterStore location document line information.
InvLocationStockTransferSerial	Stores the information releated to serials for inter location transfers.
InvManufacturer	Stores the manufacturer information
InvMerchandiseHierarchy	Header table for saving the merchandise Hierarch details.
InvMerchandiseHierarchyDetail	Detail table for saving the merchandise Hierarch tree details.
InvMRPSettings	Used to stores the MRP settings
InvPackage	Stores the Package details for the inventory
InvPackageDetail	Stores the Package details data
InvPackageGroup	used to create the Groups for the Inventory package
InvPickingBatch
InvPickingDetail
InvPickingMaster
InvPickingSerial
InvPlanningScenario	Defines the planning scenario of a product for forecasting
InvPlanningScenarioDetails	Defines the detailed information for the Inventory planning
InvProduct	Stores the product related details.
InvProductAttribute	Defines the attribute information assigned to a product
InvProductBreakDown	Defines the product and quantity used for the product build break
InvProductBuildBreak	Stores the information when the product is Build or Broken into its components
InvProductBuildBreakBatch	Stores the information when the product is Build or Broken into its components from a batch
InvProductBuildBreakDetail	Defines the product details which is being built or break.
InvProductCategory	Defines the categories under which the products can be put for logical classification.
InvProductCategoryProduct	Defines the list of products that have been put under each category.
InvProductClass	Defines the class for a product
InvProductCost	Store the historical cost of the product.
InvProductCostAudit	Stores the effective date and Cost for a product
InvProductCostUpdateLog	Stores the log information for the Product cost
InvProductDefaultSettings	Stores the Default product settings as template for new products
InvProductGrossMargin	Stores the master data for the product gross margin
InvProductGrossMarginDetail	Defines the details related to the gross margin defined on the products such as Percentage, UOM ..
InvProductGroup	Defined the various groups under which the products can be categorised.
InvProductImages	Defines any images that have been put against the product
InvProductMarginCalculation	Defines the information regerding the Margins setup for the products
InvProductMerchandiseHierarchy	Stores the values related to a defined Merchandise hirarchy for a product
InvProductMerchandiseHierarchyLog	Used to log the transactions releated to the merchandise Hierarchy
InvProductPriceManager	Stores the information of Product price manager created in the system.
InvProductPriceManagerDetail	Stores the details of Product price manager.
InvProductSalesPerson	Stores the values for sales person for a product
InvProductSurcharge	Stores the surcharge information applied for a product
InvSerial	Serial details gets affected when doing any transaction with the item which has been serial tracked.
InvSerialLog	Stores the Delta updates made to any serial in the system. This table gets affected when doing any inventory related transaction for a serial item.
InvStockTransfer	Stores stock transfer details
InvStockTransferBatch	This gets affected in case the stock transfer is done for a batch product
InvStockTransferDetail	Detail table which stores the stock transfer detail information.
InvStockTransferRequest	Defines the information for the generation of the Stock Transfer request
InvStockTransferRequestDetail	Stores the detailed information for a generated Stock Transfer request
InvStockTransferSerial	This gets affected in case the stock transfer is done for a serially tracked product
InvTempMatrixProductAttribute	Specifies the Temp product attribute for the products
InvTempMatrixProductList
InvTempSelectedAttributeList	Specifies the selected Temp attribute list for products
InvTransactionSurcharge	Stores the surcharge information that has been applied to the Inventory related transactions like Pruchase Order etc.
InvUOM	Master table for the Inv UOM
InvUOMGroup	Stores the value for the UOM group
InvUOMGroupDetail	Stores the details for the UOM group
InvUOMLengthWidth	Stores the Inv UOM length and width details
InvUOMPackage	Stores the Inv UOM package details
InvUOMProduct	Stores the Inv UOM product details
InvUOMWeight	Stores the Inv UOM product weight details
InvUPCTranslation	Specified multiple UPC Codes or Bar codes for a product.
InvUpsellProduct	Defines a list of upsell products associated with each parent product that can be sold along with the parent product at the POS.
InvWarehouse	Defines a list of all warehouses defined in the system.
LbrBreakSession	Defines the list of break in, break out sessions performed by the user logged in at the POS
LbrEmployeePosition	Defines a list of employee positions defined in the system.
LbrJobCode	Defines a list of all Job Codes defined in the system.
LbrLaborSession	Stores information regarding a particular session. New Session starts when the employee Clocks In and ends when the employee Clocks out.
LbrLaborTransaction	Defines the working time of a user at MC.
LbrTeam	Defines a list of teams created in the system
LbrUser	Defines a list of all employees/ labor users created in the system
LbrUserJobCode	Defines a list of job codes assigned to various users.
LoyAdjustmentJournal	Stores the Header detail of Loyalty Adjustment Journal in the system.
LoyAdjustmentJournalDetails	Stores the details of Loyalty Adjustment Journal in the system.
LoyCardTransfer	Stores the Header detail of Loyalty Card Transfer in the system.
LoyCardTransferDetails	Stores the details of Loyalty Loyalty Card Transfer in the system.
LoyCumulativeAwardDetail	Store the details of Carry forward award details in case Cumulative Plans.
LoyCumulativePointsAwardDetail	Store the points details of Carry forward award details in case Cumulative Plans.
LoyExceptionRule	Stores the Loyalty Exception Rules detals attach to plan in the system.
LoyLoyaltyCardInformation	Store the Details of Loyalty Customer in the system.
LoyLoyaltyTransactionImportHistory	Stores the historical information for the loyalty transaction imported in the system
LoyMailData	Store the mail & sms data sent on mail & sms.
LoyMailSentHistory	Store the history of loyalty mail sent to loyalty customer.
LoyMailTemplate	Not IN USE
LoyMailTokens	Define the Mail & SMS tokens for Loyalty Email & SMS Templates.
LoyMembershipGroup	Stores the Header detail of Loyalty Membership Group in the system.
LoyNotification	Stores the details of Loyalty Email & SMS notofaication in the system.
LoyPlan	Stores the Header detail of Loyalty Plan in the system.
LoyPlanApplicability	Day & Time Details Of Loyalty Plan.
LoyPlanApplicabilityDetails	Hold the Stores information on which plan is applicable.
LoyPlanDetails	Stores the details of Loyalty Plan in the system.
LoyPlanExceptionRules	Stores the Exception rules of Loyalty Plan in the system.
LoyPlanSpecialDays	Stores the Special Days of Loyalty Plan in the system.
LoyPoints	Stores the Header detail of Loyalty Points awarded in the system.
LoyPointsDetail	Stores the details of Loyalty Points awarded in the system.
LoyPointsExpiry	Stores the details of Loyalty Points Exipry Of Loyalty Configuration.
LoyPointsSummary	Stores the Summary of Loyalty Points awarded in the system.
LoyPrePrintedCard	Stores the Header detail of Loyalty PrePrinted Cards in the system.
LoyPrePrintedCardDetails	Stores the details of Loyalty PrePrinted Cards in the system.
LoySlab	Stores Loyalty Slab configured in the system.
LoySMSSentHistory	Store the history of loyalty SMS sent to loyalty customer.
LoySMSTemplate	Not IN USE
LoySpecialDays	Hold the user define special days for loyalty customers
MsgSMSReply	Hold the details for the SMS
PmtCollection	Specifies the payment collection information
PmtCollectionDetail	Specifies the detailed payment collection information
PmtCreditCardSurcharge	Used to store the credit card surcharge setup
PmtCurrency	Define a list of all currecies defined in the system.
PmtCurrencyDenomination	Defines a list of denominations for each of the currencies.
PmtExchangeRate	Stores the Exchange Rate values for the currencies defined in application
PmtGiftCertificate	Used to store the values for the Gift Certificate issued
PmtGiftCertificateLog	Stores the log for every Gift certificate used
PmtLayawayPlan	Defines the plan through which the items can be put on layaways to the customers.
PmtLayawayPlanProduct	Defines a list of default products associated with every layaway plan.
PmtLayawayPlanSurcharge	Defines the list of surcharges associated with each layaway plan.
PmtPaymentType	Defines a list of payment types specified in the system. These payment types are used to take payment against a transaction at POS.
PmtPaymentTypeAttribute	Defines a list of attrbutes that have been attached to a Custom tender type
PmtPaymentTypeDiscount	Stores the Discount details defined for a payment type
PmtPaymentTypeStore	Stores the payment types associated with a store
PmtPaymentTypeSurcharge	Stores the Surcharge details defined for a payment type
PrcDiscountGroup	Stores the Discount group related details. Used in Navision Integration only
PrcPriceList	Defines the price lists which are integrated through ERP system.
PrcPriceMatrix	Defines the list of products that are associated with each price list. It is also integrated through ERP.
PrcPriceMatrixAuditLog	stores the log/history related to price matrix.
PrcProductDiscountGroup	Stores the Product discount group related details. Used in Navision Integration only
PrcPurchasePrice	Stores the Purchase price related details. Used in Navision Integration only
PrcSalesPrice	Stores the Sales price related details. Used in Navision Integration only
PrcSpecialPriceDiscountGroup	Defines a list of all products which fall under a common discount group on the basis of belonging to a common Customer group, Product group or Manufacturer.
PrcSpecialPriceDiscountGroupDate	Defines a list of all products which fall under a common discount group on the basis of belonging to a common Customer group, Product group or Manufacturer by Date range
PrcSpecialPriceDiscountGroupQuantity	Stores the discount information based on quantity defined for a product
PrcSpecialPriceListDate	Defines discounts applicable to products for specified date range.
PrcSpecialPriceListMaster	Defines special prices applicable for customer and product combinations.
PrcSpecialPriceListQuantity	Defines the volume discount applicable on products. Here we specify the quantity of product on the purchase of which a certain discount would be applied.
PrcSurcharge	Defines a list of surcharges that have been defined in the system. Surcharges can be applicable both at the Sale and Purchase side
PrcUOMPriceMatrix	Defines the values for the UOM price matrix
PrnLabelPrintField	Store the fields to be used in label printing
PrnLabelPrinting
ProCoupon	Stores the issued coupon details for iVend
ProCouponCondition	Stores the conditions for a Coupon to apply
ProCouponIssueInformation	Specifies the issued coupon information
ProCustomerPromotion	Stores the promotion information for every customer when doing promotional transaction.This data would be used later to validate how many times a promotion is applied to the customer.
ProCustomerSpecialDays	Stores setting of promotion applicability as per Customers special days (i.e. Birthday and Anniversary)
ProPromotionApplicabilityDetails	Stores the details for a promotion applicability
ProPromotionApplicabilityMaster	Stores the values for a promotion applicablity on special days or time
ProPromotionBonusBuysMaster	Stores the master data for the Promotion defined
ProPromotionBuySide	Stores the Buy side data for a promotion
ProPromotionExcludedItem	Stores the values for the excluded items from a promotion
ProPromotionGetSide	Stores the Get Side data for a promotion defined
ProPromotionProductDetail	Not in use
PurPurchaseOrder	Stores information related to Purchase order transactions done from Console or done from ERP on behalf of this store.
PurPurchaseOrderDetail	Stores the line details of the purchase order.
PurVendor	Defines the vendor details of an enterprise from which the products are purchased.
PurVendorAddress	Defines the address of each vendor.
PurVendorBranch	Store the branch for the vendore
PurVendorCatalog	Not in use
PurVendorCatalogDetail	Not in use
PurVendorComment	Stores the Vendor comment infoormation
PurVendorGroup	Defines the groups in which the Vendors can be catagorised.
PurVendorProduct	Stores the Product details of a Vendor
PurVendorWarehouseItem	Stores Vendor details for each Subsidiary
RepEventNotification	Stores the Replication even notofication information
RepIncomingIntegrationLog
RepIntegrationLog	Stores the Integration records for the SAP
RepLoyaltyIntegrationLog	Table used maintian the log for loyalty records
RepObjectMapDB	System table. Do not modify
RepReplicationDestinationError	Stores the error information while replicating the data between stores
RepReplicationMasterEventLog	Stores the events for the replication of data
RepReplicationMobileDump	Stores the data for the mobile pos replication
RepReplicationMobileInitialization
RepReplicationOutgoingNotification
RepReplicationProcessingStatus	Stores the current status for the replication records while processing
RepReplicationReceivedEvents
RepReplicationReceivedPayload
RepReplicationSendDump	stores the information that has to be sent using replication service between store and HO.
RepReplicationSendStatus	Stores the replication data status sent between stores
RepReplicationSendStatusMobile	Table used to track the replication record status
RepReplicationStatus	Stores the current status for the replication data
RepReplicationTransaction	Stores the Transaction details for them the data needs to be replicated
RepReplicationTransactionDetail
RepReplicationTransactionDetailArchive
RepReplicationTransactionMobile	Stores the Transaction details for them the data needs to be replicated from mobile
RepServiceState	Not in use
RptZReport	Not in use
RptZReportDetail
RtlDepartment	The details of the departments of the company are specified here.
RtlDocumentNumberSeries	Table used to define the document number series for the different type of documents
RtlDocumentPrintProfile	Header table that contains the settings for printing various documents that are generated when business transactions are done from iVend Management console
RtlDocumentPrintProfileDetail	Details table for Document Print Profile that contains the detailed information for Document Print Profile.
RtlDocumentPrintProfileUser	Detail table for Doucment Print Profile that contains details of users to which the document print profile being generated would be applied.
RtlEvent	Contains all events that have been defined in the system. These events can be attached to transaction at POS.
RtlEventStore	Stores the value for the events defined for a store
RtlExpense	Stores the various expense captured at the Store and POS
RtlFiscalMask	Stores the mask values defined for a transaction type and Custmor group
RtlHandheldDevices	Stores the registered Handheld devices information
RtlHardwareProfile	Details about the Hardware profile which is attached to the POS. Contains details about various hardware devices that have been registered in the system.
RtlManagementConsole	Stores the registered management console information
RtlPoleDisplayMessage	Stores various Pole display messages that have been defined in the system. These messages when used in POS display messages as defined here.
RtlPOS	Contains details about all POS defined in the system.
RtlPOSDocumentNumberSeries	Stores the Document Number series details for a POS
RtlPrintFormat	Stores the format for types of printing that is done in POS. E.g Transaction Receipt, X-Tape Report.
RtlPrintProfile	Header table that contains details about printing formats that is attached to POS. Format attached to the type of printout is stored in detail table.
RtlPrintProfileDetail	Contains the details for the print profile created. Contains format information about the different types of the printouts.
RtlRetailMessages	String messages applicable to Users, Products, System, POS, Jobcodes etc. are created here and can specify the exact reference of the same. These messages are shown at POS.
RtlRetailProfile	Contains different profiles defined in the system. Profiles contains information which is defines the behaviour of the POS and Console.
RtlStore	Contains the details of Stores defined in the system.
RtlStoreGroup	Stores the values for a store group
RtlStorePriceList	Stores the price list that will be effective for the store on current date
RtlSubsidiary	Defines all the Subsidiaries defined in the application
SBOBatchUpdates
SBOInventoryUpdates
SBOSerialUpdates
SchSchedule	Stores the schedule details
SchSchedulerLog	Stores the log for the every schedule
SecCustomSecurityFeatureSubFunction
SecCustomSecuritySubFunction	Store the custom security access rights depending on the store ownership type. System Table Warning : Should not be modified directly
SecSecurityFunction	Defines a list of all the main modules on which the security needs to be applied. Eg.. Administration, Business partner etc.
SecSecurityGroup	System table. Do not modify
SecSecurityGroupSecurityFunction	System table. Do not modify
SecSecurityGroupSecuritySubFunction	System table. Do not modify
SecSecurityRole	The details of the security role and associated rights over the security functions (different objects )e.g.GoodReceipt are specified here .In different roles we can give different rights to the predefined security functions. e.g. for an employee the role can be just to read all the security functions and for manager the role must have full rights to all the security functions.
SecSecurityRoleSecurityFunction	This table defines the security rights on the main modules granted to a specific security role.
SecSecurityRoleSecuritySubFunction	This table defines the security rights on the sub modules granted to a specific security role.
SecSecuritySubFunction	Defines a list of all the sub modules under the main module on which the security needs to be applied.
SecSecurityUser	We can make any employee of the system as a security user and specify details like login id and password and electronic id etc in this table , who may be doing POS transactions. It is mandatory to make an employee a security user before he/she can do POS transactions.
SecSecurityUserSession	System table. Do not modify
SecSecurityUserStoreMapping	Stores the Store security user mapping information
SubSubsidiaryItem	Stores Subsidiary information for each master, which can have multiple Subsidiaries assigned
SysAnalyticsEventLog
SysApplicationUpdate	Not in use
SysNextNumber	System table
SysNotification	Stores the information generated by the Scheduler for the Alerts
SysNotificationUser	Stores the information for the alerts sent to the Users. ie status of the alerts like if the alerts have been sent or read by the user etc.
SysOutGoingNotification	Header taqble that contains the information regarding out going system notifications
SysPassNotification	stores the information if ivend pass has been issued for perticular record.
SysRequestLogger	Logs the Payload of API call for using in debugging
SysSystemInformation	System table. Do not modify
TaxTaxCode	TaxCode is defined at the SBO and it's replicated from SBO to iVend. We can only view the TaxCodes at MC and associate them with the different objects, like Product, Customer, Enterprise, etc.
TaxTaxCodeByZipCode	Specifies the tax information based on Zip Code
TaxTaxCodeCondition	Stores the data for the Tax code condition
TaxTaxCodeDetail	Specifies the Tax code detail information
TaxTaxEvent	Stores the Tax Event description
TaxTaxEventDetail	Stores the data for a defined Tax event
TaxTaxPeriodDefinition	Defines the period from which the particular tax rate would be applicable.
TilCashDrawerLog	Stores the activity for the cash drawer
TilCount	Defines the amount details like the opening amount, system amount etc. associated with the till
TilCountDenomination	Defines the details for each denominations defined in the system against a particular currency
TilCountDetail	Defines the amount details aasociated with the till for each payment type.
TilCountInventory	Speifies the till inventory with serial no
TilCountPaymentDetail	Stores the payment count details for the till
TilInventory	Specifies the inventory count based on warehouse
TilSession	Defines all the till sessions from the time a till is assigned to a POS till the time it is finalized.
TilSessionDetail	Defines all the till sessions from the time a till is assigned to a POS till the time it is finalized against each tender type.
TilSessionTransaction	Defines the list of all the transactions that occur through the particular till along with the store , POS n user details.
TilSessionUser	Stores the various till user session details.
TilTill	Till is defined at the MC and attached with the cash drawer at POS. At a time only one till can be associated with the POS. It is the virtual entity in which we defined some settings (like setting the mode in which the till works) that will be applicable at the POS (for which the till is attached).
TilTillDetail	Defines the details for the each till set up.
TilTillMaster	Stores the master till information
TilTillMasterFloatAmountDetail	Stores the details of allowed float amount for the till
TilVariance	Defines the variations if any between the system amount and the counted amount of the till.
TilVarianceDetail	Defines the variations if any between the system amount and the counted amount of the till against each tender type.
TrxARPayment	Defines the details of the on account payments or any other settlements being done by the customer and the amount.
TrxDeliveryPackage	Stores the Delivery package information
TrxDeliveryPackageBatch	Batch details for the delivery package is stores
TrxDeliveryPackageDetail	Captures the delivery details of the package that is to be delivered from iVend Mobile POS.
TrxDeliveryPackageSerial	Serial no for the delivery package items are stored
TrxScannedDataDetail
TrxScannedDataHeader
TrxTransaction	The main table which defined the primary details concerned with every type of transaction.
TrxTransactionAttribute	Defines a list of sale tranaction attributes (any additional information) captured at the time of a transaction.
TrxTransactionAudit	Stores audit information like Reason code and comments for any unsual activity carried on the POS against a transaction like Price override, Discount override. Whether reason code or comment is required depends on the settings made in the applicable Retail profile.
TrxTransactionCoupon	Stores the value for the Coupon in a transaction
TrxTransactionDeliveryInformation	Stores the values for the delivery information for a transaction
TrxTransactionDynamicAssemblyItem	Stores sale/refund/delivery if Dynamic assmebly items attached to a transaction
TrxTransactionElectronicInvoice	Stores the data for the Electonic Invoice - for chile localization
TrxTransactionFulfillment	Defines a list of all those transactions which have a fulfillment plan attached to it.
TrxTransactionFulfillmentDeliveryDetail	Stores the delivery details of all the transactions that have a fulfillment plan attached to them.
TrxTransactionFulfillmentDetail	Defines the details of all the transactions which have a fulfillment plan attached to them.
TrxTransactionGiftCertificate	Stores the values for the Gift certificate for the transaction
TrxTransactionInstallmentDetail	Defines the installments details of all those transactions which have a layaway plan attached to it.
TrxTransactionItemAttribute	Defines a list of sale tranaction attributes (any additional information) captured at the time of a transaction.
TrxTransactionLayaway	Store layway type of transactions.
TrxTransactionLineItemAttribute	Stores the Line attribute details for the transaction
TrxTransactionLostSaleItem	Stores the values for the Lost Sale item
TrxTransactionLoyalty	Stores the loyalty details for a transaction
TrxTransactionOrder	Stores information about various order booked in the system.
TrxTransactionPayment	Stores all the payment details for each transaction.
TrxTransactionPaymentAttribute	Stores all the payment attribute details for each transaction.
TrxTransactionPrintCount	Stores the history of Transaction Printing
TrxTransactionPrinting	Stores the Transaction printing details for a transaction
TrxTransactionPromotionDetail	Stores the promotion applied details on the transaction
TrxTransactionQuotation	Stores information about various order booked in the system.
TrxTransactionReceipt	Stores the Transaction receipt information
TrxTransactionSaleAttribute	Stores the Sale attribute details for the transaction
TrxTransactionSaleItem	Stores sale/refund/delivery items attached to a transaction
TrxTransactionSalesPerson	Defines a list of all the users to whom a certain commission has been given as a part of a transaction.
TrxTransactionSignature	Stores the Transaction Signature data
TrxTransactionStageApprovalLog	Stores the Approval log for the transactions.
TrxTransactionStatus	Defines the transaction status with respect to various amounts that are affected by it.
TrxTransactionSurcharge	Provides a reference of all the surcharges & other details attached with any transaction.
UpgradeInformation
XMLReportHierarchy	stores the hierarchy information of the data objects of the reports in the system.

Views

View	Description
Loyalty_ActiveBillValue
Loyalty_ActiveTransactionCount
Loyalty_GenderInfo
vw_AddressDetails
vw_CusCustomer
vw_GrossProfit
vw_InventoryCost
vw_InventoryMovement
vw_InvInventoryItem
vw_InvProduct
vw_InvProductInventoryInfo
vw_ProductCost
vw_ProductMerchandiseHierarchy
vw_PurVendor
vw_RtlPrintFormat
vw_SalesReportData
vw_TrxTransaction
vwAnalytics_GiftCertificates
vwAnalytics_InventorySnapshot
vwAnalytics_MerchandiseInventoryCount
vwAnalytics_MerchandisePromotionSales
vwAnalytics_MerchandiseSales
vwAnalytics_NetSales
vwAnalytics_OpenPO_Snapshot
vwAnalytics_OpenStockTransferReceipt
vwAnalytics_OpenStockTransferRequest
vwAnalytics_POS
vwAnalytics_PromotionSales
vwAnalytics_Sales
vwAnalytics_SalesPerson
vwAnalytics_SalesTransaction
vwAnalytics_UpSellSales

Stored Procedures

Stored Procedure	Description
AssignTill	Assigns a Till to the selected POS
BarCodeResolution
BatchLocationQuantityUpdates	Used in replication to update the Batch quantities
BatchQuantityUpdates
BreakBuildKit
CancelStockTransfer
ClearOfflinePOSData
CreateRollupJob
CreateTillCount
CustomeLabelReport
DataNotification
DeleteSuspendedTransactionDetails
EnableRollup
ExecuteInventoryItemLogUpdate
Forecast
ForeCast_UpdateMerchandiseHierarchy
GenerateLabelData	Generates label data depending on the parameter specified
GenerateLabelData_Custom
GenerateSKU
GetBatchTrackedProductDetails
GetBOMQuantity
GetChildInventoryItemList
GETDATABASELIST
GetDeliveryPackages
GetFulfilmentTransactions
GetInventoryItemForStockCount
GetMobilePOSDeliveryTransactions
GetMobileReplicationData
GetNextAccountingId	Generates a unique Accounting Id for the Next Number Id
GetNextAutoGeneratedCode	Generates the next code depending on the Source Type
GetNextDocumentNumber	Generates the next Transaction Number depending on the Parameters provided
GetNextDocumentNumberForPOS	Generates the next Transaction Number depending on the Parameters provided
GetNextSiteNumber
GetNextSiteNumberForCurrentSite
GetPriceListForPriceManager
GetPriceListProductsForGrossMargin
GetReceiptNodeList
GetSecurityRoleSecurityFunction
GetSecurityRoleSecuritySubFunction
GetSerialTrackedProductDetails
GetSpecialOrderHistory
GetTransactionData
GetTransactionLinkDocument
GetUOMPriceMatrix
GetUserRights	Gets the valid rights for the user
GetValidPromotionsForProduct
GiftCertificateUpdate
GoodsIssueReport
GoodsReceiptPOReport
GoodsReceiptReport
InsertGenerator
Integration_ARPayment
Integration_Consolidated_Transaction
Integration_Consolidated_TransactionPayment
Integration_Consolidated_TransactionSurcharge
Integration_DisplayNegativeInventory
Integration_GoodsIssue
Integration_GoodsIssue_SerialBatch
Integration_GoodsReceipt
Integration_GoodsReceiptSerialBatch
Integration_GoodsReceiptSerialBatchShortReceived
Integration_GoodsReceiptSurcharge
Integration_GoodsReturn
Integration_GoodsReturnSerialBatch
Integration_GoodsReturnSurcharge
Integration_InventoryItem
Integration_InventoryItemPrice
Integration_PurchaseOrder
Integration_PurchaseOrderSurcharge
Integration_StockTransfer
Integration_StockTransferSerialBatch
Integration_Transaction
Integration_TransactionAttribute
Integration_TransactionLineAttribute
Integration_TransactionPayment
Integration_TransactionSurcharge
InventoryCount_Save
InventoryItemQuantityUpdates
InventoryItemSerialStatusUpdates
InventoryLocationQuantityUpdates	Updates the inventory location quantity depending on the delata update
InventoryValuation
InvGetAllSelectedAttributeItems
InvGetAllSelectedAttributeItemsList
InvGetMatrixItems	Applies Buy Some Get Some promotion on the transaction
InvGetSelectedAttributeProduct
InvWarehouseInventoryLocation
LogAuditInformation
Loy_GetLayawayPlanKey
Loy_GetMonthlyPointSummary
Loy_GetPointsSummaryForPortalIntegration
Loy_GetTransactionHeader
Loy_GetTransactionLineItem
Loy_GetTransactionLineItemByDate
Loy_GetTransactionPayment
Loy_GetTransactionPromotionDetail
LoyUpdatePointSummary
MRP
MRP_CalculateInOut
MRP_GenerateDemandForKit
PurchaseOrderReport
RecalculateSlabForLoyaltyCustomer
RemoveTill	Removes a Till from the selected POS
ReplicationGetMobileSites
ReplicationMobileMonitor
ReplicationMonitor
ReplicationRecordsToSend
ReplicationUpdateSentStatus
RepUpdateCustomerBalance	Updates the customer balances in iVend Unplugged
RPT_ABCAnalysis
Rpt_BestWorstSellingItem
RPT_DailyClosingBalance
rpt_Delivery
RPT_ExchangeRate
rpt_LayAway
rpt_StockTransfer
RPT_StoreAnalysis
RptSalesTransactionByItemAndItemGroup
SalesAnalysisbySalesPersons
StockTransferReport
TrxCompleteTransactionUpdates
TrxConsolidateTransaction
TrxConsolidateTransactionForCreditCustomers
TrxGenerateLayawayInstallments	Generates Layaway installments for the Layaway transaction
TrxGenerateLayawayInstallmentsForSaleLevel	Generates Layaway installments for the Layaway transaction
TrxGetLaybyInstallmentPlan	Computes the Layaway details like Duration, Starting Date etc for the layaway depending on the Layaway Plan
TrxHandleARPayments	Handles updates related to On Account payments
TrxInventoryUpdateBatchNumber
TrxInventoryUpdateCheckNegativeInventory
TrxInventoryUpdateLaybyCancellationItem
TrxInventoryUpdateLaybyItem
TrxInventoryUpdateOrder	Handles updates related to Order item
TrxInventoryUpdatePaymentDiscount	Handles updates related to sale item
TrxInventoryUpdateQuotation	Handles updates related to Quotation item
TrxInventoryUpdateSaleDelivery	Handles updates related to delivery of a Sale item
TrxInventoryUpdateSaleItem	Handles updates related to sale item
TrxInventoryUpdateSerialNumber
TrxInventoryUpdatesSaleRefund	Handles updates related to On Account payments
TrxUpdateCustomerBalance
UpdateDeliveryInformationFromSAPBusinessOne
UpdateInventoryCost	Used in replication to update the cost of an item if the costing method is set to enterprise
UpdateTillAfterPaymentInsert	Handles updates to Till once payment against a particular payment type has been taken
UpdateTillAmounts	Handles updates to Till once payment against a transaction has been taken
UseDrawer	Creates a valid Till User session depending on the Cash drawer selected by the user
usp_RethrowError	Rethrow an error to the calling function/application
uspGetItemPrice
uspGetItemPriceForNAV
uspGetItemSpecialPrice	Determines the price of the Product for the customer specified and other parameters
uspGetPurchasePriceForNAV
uspGetSQLSchemaInfo
uspTapeReport
uspValidateCustomerTaxNumber_Ecuador
ValidateUserTable
XTapeReport	Generates the XTape report for a particular till
ZTapeReport

User Defined Functions

User Defined Function	Description
Daily_ProductCost
DailySaleSummary
fn_Loy_GetRedemablePointsAndAmount
fn_Loy_SlabWiseRedeamlePointAndAmount
fnSplitValues
FunSplit
GetCompanyDateTime
GetExchangeRate
GetFullAddress
GetNextnumber
Integration_funcTransaction
Rpt_ActiveLoyalty
Rpt_ItemWithoutSale
rptClosingBalanceQuantity
rptOpeningBalance
rptOpeningBalance_dailyClosingBal
rptOpeningBalance_Location
rptOpeningBalance_Stock
rptSalesData
rptSalesTransactionData
rptSalesTransactionDataWithSalesPerson
SalesDetail
SecondLastItem
SplitString
ToProperCase
usp_InvInventoryItem_Condition
ValidateNoficationEvent

Related Objects

iVend Database Database

Send comments on this topic.