<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > SysNotification Table |
Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
SysNotification Table
Collapse All Expand All
iVend Database Database : SysNotification Table |
Description
Stores the information generated by the Scheduler for the Alerts
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 |
NotificationContentKey |
Primary Key for the table. |
VarWChar |
50 |
|
|
|
|
|
AlertNotificationKey |
Reference Key for the AlertNotification. See Alert notification |
VarWChar |
50 |
|
|
|
|
DocumentKey |
Reference Key for the Document. See Document |
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 |
|
|
|
|
Status |
Valid values are New = 0 Completed = 1 Error = 2 |
Integer |
4 |
|
|
|
|
EmailBody |
Value is the Email body, that is being sent with the email notification. |
LongVarWChar |
16 |
|
|
|
|
NotificationContent |
Value is the Notification Content Generated for the event. |
LongVarBinary |
16 |
|
|
|
|
ErrorText |
Value is the error text generated while processing the Notification. |
LongVarWChar |
16 |
|
|
|
|
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 |
|
|
|
|
FromStoreKey |
Reference for the Store. See RtlStore. |
VarWChar |
50 |
|
|
|
|
ToStoreKey |
Reference for the Store. See RtlStore. |
VarWChar |
50 |
|
|
|
|
SiteId |
Primary Key holds the Site Id of the Sending Site. |
Integer |
4 |
|
|
|
|
SMSBody |
Stores SMS body. |
LongVarWChar |
16 |
(NULL) |
|
Indexes
Index |
Description |
Primary |
Unique |
|
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[SysNotification]( [NotificationContentKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [AlertNotificationKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [DocumentKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [AlertNotificationType] [int] NOT NULL, [Status] [int] NOT NULL, [EmailBody] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [NotificationContent] [varbinary](max) NULL, [ErrorText] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS 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, [FromStoreKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ToStoreKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SiteId] [int] NULL, [SMSBody] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_SysNotification] PRIMARY KEY CLUSTERED ( [NotificationContentKey] 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] ALTER TABLE [dbo].[SysNotification] ADD CONSTRAINT [DF__SysNotifi__SMSBo__0F982079] DEFAULT (NULL) FOR [SMSBody] |
See Also
© 2019 All Rights Reserved.
Send comments on this topic.