iVend Database Database : CfgValidationRule Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

76

Data Space Used

16.00 KB

Index Space Used

48.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ValidationRuleKey

Primary Key

VarWChar

50

Id

Refers to the Id

VarWChar

200

Description

Refers to the description

VarWChar

200

ObjectId

Object on which custom validation rules are to be applied

VarWChar

100

PropertyName

Property name on which the rule has to be applied

VarWChar

100

RuleType

Refers to the type of rule.

Valid values are:

NotNull = 1

StringRequired = 2

StringMaxLength = 3

StringMinLength = 4

StringLengthRange = 5

MinValue = 8 MaxValue = 9

Range = 10

RegExMatch = 11

Integer

4

ErrorMessageId

Refers to the Id of the error message displayed

VarWChar

100

MinLength

Refers to the min string length

SmallInt

2

MaxLength

Refers to the max string length

SmallInt

2

MinValue

Refers to the min value

Numeric

9 (20,5)

MaxValue

Refers to the max value

Numeric

9 (20,5)

MinDate

Refers to the min date from which the rule would be applicable

DBTimeStamp

4

MaxDate

Refers to the max date till which the rule would be applicable

DBTimeStamp

4

RegExPattern

If the ruletype is of type RegExMatch, then the field stores the Regular Expression Pattern which would be used to validate the user input

VarWChar

100

UIRegExPattern

If the ruletype is of type RegExMatch, then the field stores the Regular Expression Pattern which would be used to validate the user input in UI

VarWChar

100

IsSystemRule

Speicifies whether this is a System Rule or the end user has created this rule. System rules are not allowed to be edited by the end user

Boolean

1

IsDeleted

Value is True if the record has been deleted from the system. Record is always Soft Deleted

Boolean

1

Created

Date of creation of this record

DBTimeStamp

4

([dbo].[GetCompanyDateTime]())

CreatedBy

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

VarWChar

50

((1))

Modified

Date of last modification of this record

DBTimeStamp

4

([dbo].[GetCompanyDateTime]())

ModifiedBy

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

VarWChar

50

((1))

PropertyCaption

Value is True if the Property Caption to display

VarWChar

100

ERPType

Valid values are :

None = -1,

iVendUnplugged = 0,

SAPBusinessOne = 1,

OthersWithAPI = 2,

SAPBusinessOneStartPack = 3,

NAV = 4

Integer

4

((0))

IsUIRule

If the validation is for UI.

Boolean

1

((0))

Index

Description

Primary

Unique

IX_CfgValidationRule

IX_CfgValidationRule_1

PK_CfgValidations

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgValidationRule](

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

[Id] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

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

[ObjectId] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[PropertyName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[RuleType] [int] NOT NULL,

[ErrorMessageId] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[MinLength] [smallint] NOT NULL,

[MaxLength] [smallint] NOT NULL,

[MinValue] [decimal](20, 5) NOT NULL,

[MaxValue] [decimal](20, 5) NOT NULL,

[MinDate] [datetime] NULL,

[MaxDate] [datetime] NULL,

[RegExPattern] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[UIRegExPattern] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsSystemRule] [bit] NOT NULL,

[IsDeleted] [bit] 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,

[PropertyCaption] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ERPType] [int] NULL,

[IsUIRule] [bit] NULL,

CONSTRAINT [PK_CfgValidations] PRIMARY KEY CLUSTERED

(

[ValidationRuleKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

ALTER TABLE [dbo].[CfgValidationRule] ADD CONSTRAINT [DF_CfgValidationRule_Created] DEFAULT ([dbo].[GetCompanyDateTime]()) FOR [Created]

ALTER TABLE [dbo].[CfgValidationRule] ADD CONSTRAINT [DF_CfgValidationRule_CreatedBy] DEFAULT ((1)) FOR [CreatedBy]

ALTER TABLE [dbo].[CfgValidationRule] ADD CONSTRAINT [DF_CfgValidationRule_Modified] DEFAULT ([dbo].[GetCompanyDateTime]()) FOR [Modified]

ALTER TABLE [dbo].[CfgValidationRule] ADD CONSTRAINT [DF_CfgValidationRule_ModifiedBy] DEFAULT ((1)) FOR [ModifiedBy]

ALTER TABLE [dbo].[CfgValidationRule] ADD CONSTRAINT [DF_CfgValidationRule_ERPType] DEFAULT ((0)) FOR [ERPType]

ALTER TABLE [dbo].[CfgValidationRule] ADD CONSTRAINT [DF_CfgValidationRule_IsUIRule] DEFAULT ((0)) FOR [IsUIRule]