iVend Database Database : SysOutGoingNotification Table

Creation Date

12/5/2016 12:18 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

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

OutGoingNotificationKey

System generated Primary Key of the tab

VarWChar

50

IsEmailNotification

Flag indicates whether Email notification needs to be sent or not

Boolean

1

((0))

IsSMSNotification

Flag indicates whether SMS notification needs to be sent or not

Boolean

1

((0))

IsApplicationNotification

Flag indicates whether Application notification needs to be sent or not

Boolean

1

((0))

MobileNumbers

Stores the Mobile numbers for sending SMS, separated by comma(,)

VarWChar

4000

SMSText

Stores the text to send as SMS

VarWChar

500

ToEmailIds

Stores the eMail address(es) for email, separated by comma() or semi-colon(;)

VarWChar

4000

CCEmailIds

Stores the CC address(es) for email, separated by comma(,) or semi-colon(;)

VarWChar

4000

BCCEmailIds

Stores the BCC address(es) for email, separated by comma(,) or semi-colon(;)

VarWChar

4000

EmailSubject

Stores the subject text for email

VarWChar

200

EmailBody

Stores the email body Text

LongVarWChar

16

ReportKey

Refers to the Report Key that will be sent with Email/Notification

VarWChar

50

ParamaterValues

Refers to the Report Parameter values in XML format

VarWChar

4000

UserKey

Refers to the target user uey for sending Application Notification

VarWChar

50

ApplicationNotificationText

Stores the text to show in Application Notification

LongVarWChar

16

IsEmailProcessed

Values indicates whether email has been sent or not

Boolean

1

((0))

IsSMSProcessed

Values indicates whether sms notificationl has been sent or not

Boolean

1

((0))

IsApplicationProcessed

Values indicates whether application notificationl has been sent or not

Boolean

1

((0))

IsEmailSendingError

Stored value will be true if there is any error occurred while sending Email otherwise value will be false

Boolean

1

((0))

IsSMSSendingError

Stored value will be true if there is any error occurred while sending SMS notification otherwise value will be false

Boolean

1

((0))

IsApplicationSendingError

Stored value will be true if there is any error occurred while sending application notification, otherwise value will be false

Boolean

1

((0))

CreatedBy

Refers to the user who has created this record. See also Security User

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

ModifiedBy

Reference of user who has modified this record. See also Security User

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

Index

Description

Primary

Unique

PK_SysOutGoingNotification

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[SysOutGoingNotification](

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

[IsEmailNotification] [bit] NULL,

[IsSMSNotification] [bit] NULL,

[IsApplicationNotification] [bit] NULL,

[MobileNumbers] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SMSText] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ToEmailIds] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CCEmailIds] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[BCCEmailIds] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[EmailSubject] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[EmailBody] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

[ParamaterValues] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

[ApplicationNotificationText] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsEmailProcessed] [bit] NOT NULL,

[IsSMSProcessed] [bit] NOT NULL,

[IsApplicationProcessed] [bit] NOT NULL,

[IsEmailSendingError] [bit] NOT NULL,

[IsSMSSendingError] [bit] NOT NULL,

[IsApplicationSendingError] [bit] NOT NULL,

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

[Created] [datetime] NOT NULL,

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

[Modified] [datetime] NOT NULL,

CONSTRAINT [PK_SysOutGoingNotification] PRIMARY KEY CLUSTERED

(

[OutGoingNotificationKey] 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].[SysOutGoingNotification] ADD CONSTRAINT [DF__SysOutGoi__IsEma__2A8120DF] DEFAULT ((0)) FOR [IsEmailNotification]

ALTER TABLE [dbo].[SysOutGoingNotification] ADD CONSTRAINT [DF__SysOutGoi__IsSMS__2B754518] DEFAULT ((0)) FOR [IsSMSNotification]

ALTER TABLE [dbo].[SysOutGoingNotification] ADD CONSTRAINT [DF__SysOutGoi__IsApp__2C696951] DEFAULT ((0)) FOR [IsApplicationNotification]

ALTER TABLE [dbo].[SysOutGoingNotification] ADD CONSTRAINT [DF__SysOutGoi__IsEma__2D5D8D8A] DEFAULT ((0)) FOR [IsEmailProcessed]

ALTER TABLE [dbo].[SysOutGoingNotification] ADD CONSTRAINT [DF__SysOutGoi__IsSMS__2E51B1C3] DEFAULT ((0)) FOR [IsSMSProcessed]

ALTER TABLE [dbo].[SysOutGoingNotification] ADD CONSTRAINT [DF__SysOutGoi__IsApp__2F45D5FC] DEFAULT ((0)) FOR [IsApplicationProcessed]

ALTER TABLE [dbo].[SysOutGoingNotification] ADD CONSTRAINT [DF__SysOutGoi__IsEma__3039FA35] DEFAULT ((0)) FOR [IsEmailSendingError]

ALTER TABLE [dbo].[SysOutGoingNotification] ADD CONSTRAINT [DF__SysOutGoi__IsSMS__312E1E6E] DEFAULT ((0)) FOR [IsSMSSendingError]

ALTER TABLE [dbo].[SysOutGoingNotification] ADD CONSTRAINT [DF__SysOutGoi__IsApp__322242A7] DEFAULT ((0)) FOR [IsApplicationSendingError]