<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > RtlRetailMessages Table |
Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
RtlRetailMessages Table
Collapse All Expand All
iVend Database Database : RtlRetailMessages Table |
Description
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.
Properties
Creation Date |
4/13/2015 12:00 PM |
File Group |
PRIMARY |
Text File Group |
|
System Object |
|
Published for Replication |
|
Rows |
0 |
Data Space Used |
0.00 KB |
Index Space Used |
0.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
MessageKey |
Value is the system generated Primary Key of the table. |
VarWChar |
50 |
|
|
|
|
|
Id |
Value is the Id of the message. |
VarWChar |
20 |
|
|
|
|
Description |
Value is any description of the message. |
VarWChar |
100 |
|
|
|
|
Message |
Value is the message to be displayed for the source. |
VarWChar |
500 |
|
|
|
|
Type |
Value is the type of source for which the message has to be displayed. Valid values are: User = 0 JobCode = 1 System = 2 POS = 3 Product = 4 ProductGroup = 5 SaleComplete = 6 Customer = 7 CustomerGroup = 8 |
Integer |
4 |
|
|
|
|
SourceKey |
Value is the specific source key for which exactly the message has to be displayed. Value depends on the source type |
VarWChar |
50 |
|
|
|
|
Created |
Date of creation of this record |
DBTimeStamp |
4 |
|
|
|
|
Modified |
Date of last modification of this record |
DBTimeStamp |
4 |
|
|
|
|
CreatedBy |
Reference of user who has created this record. See also Security User |
VarWChar |
50 |
|
|
|
|
ModifiedBy |
Reference of user who has modified this record. See also Security User |
VarWChar |
50 |
|
|
|
|
StartDate |
Value is the Start date of the Message. |
DBTimeStamp |
4 |
|
|
|
|
EndDate |
Value is the end date of the Message. |
DBTimeStamp |
4 |
|
|
|
|
StartTime |
Value is the Start Time of the Message. |
DBTimeStamp |
4 |
|
|
|
|
EndTime |
Value is the end Time of the Message. |
DBTimeStamp |
4 |
|
|
Indexes
Index |
Description |
Primary |
Unique |
|
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[RtlRetailMessages]( [MessageKey] [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, [Message] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Type] [int] NOT NULL, [SourceKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Created] [datetime] NOT NULL, [Modified] [datetime] NOT NULL, [CreatedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ModifiedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [StartDate] [datetime] NULL, [EndDate] [datetime] NULL, [StartTime] [datetime] NULL, [EndTime] [datetime] NULL, CONSTRAINT [PK_CfgMessages] PRIMARY KEY CLUSTERED ( [MessageKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] |
See Also
© 2019 All Rights Reserved.
Send comments on this topic.