<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > SysNotificationUser Table |
Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
SysNotificationUser Table
Collapse All Expand All
iVend Database Database : SysNotificationUser Table |
Description
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.
Properties
Creation Date |
1/12/2016 5:57 PM |
File Group |
PRIMARY |
Text File Group |
PRIMARY |
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 |
NotificationKey |
Reference key for the Notification. See CfgNotification. |
VarWChar |
50 |
|
|
|
|
|
NotificationContentKey |
Reference key for the Notification. See SysNotification. |
VarWChar |
50 |
|
|
|
|
UserKey |
Reference key for the Security User. See SecSecurityUser. |
VarWChar |
50 |
|
|
|
|
IsUnRead |
Value is True if the Alert has been read by the user else False |
Boolean |
1 |
|
|
|
|
IsEmail |
Value is true if the Email Notification has been generated for the user else false |
Boolean |
1 |
|
|
|
|
IsInApp |
Value is true if the App Notification has been generated for the user else false |
Boolean |
1 |
|
|
|
|
IsSms |
Value is True if the SMS Notification has been generated for the user else false |
Boolean |
1 |
|
|
|
|
FromStoreKey |
Reference for the Store. See RtlStore. |
VarWChar |
50 |
|
|
|
|
ToStoreKey |
Reference key for the Store Key. See rtlStore. |
VarWChar |
50 |
|
|
|
|
AlertNotificationType |
Valid values are Query = 0 PurchaseOrder = 1, StockTransferRequest = 2, StockTransferShipment = 3, SalesDelivery = 4, OrderFulfillment = 5, LayAwayFulfillment = 6, PriceListChange = 7, CouponCreation = 8, BonusBuyCreation = 9, GoodsReceiptPOCreation = 10, GoodsIssueCreation = 11, GoodsReturnCreation = 12, GoodsReceiptCreation = 13, GiftCertificateCreation=14, ProductCreation=15 |
Integer |
4 |
|
|
|
|
Created |
Date of creation of this record |
DBTimeStamp |
4 |
|
|
|
|
CreatedBy |
Reference of user who has created this record. See also Security User |
VarWChar |
50 |
|
|
|
|
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 |
|
|
|
|
SMSBody |
Stores SMS body. |
LongVarWChar |
16 |
|
|
|
|
EMailBody |
Stores email body. |
LongVarWChar |
16 |
|
|
Indexes
Index |
Description |
Primary |
Unique |
|
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[SysNotificationUser]( [NotificationKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [NotificationContentKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [UserKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [IsUnRead] [bit] NOT NULL, [IsEmail] [bit] NOT NULL, [IsInApp] [bit] NOT NULL, [IsSms] [bit] NOT NULL, [FromStoreKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ToStoreKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [AlertNotificationType] [int] NOT NULL, [Created] [datetime] NOT NULL, [CreatedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Modified] [datetime] NOT NULL, [ModifiedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SMSBody] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EMailBody] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_SysNotificationUser] PRIMARY KEY CLUSTERED ( [NotificationKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
See Also
© 2019 All Rights Reserved.
Send comments on this topic.