iVend Database Database > CfgValidationRule Table : IX_CfgValidationRule_1 Index

File Group

PRIMARY

Space Used

16.00 KB

Fill Factor

0

Do not Recompute Statistics

Full Text Key

Clustered Index

Primary Key Index

Unique Index

Pad Index

Column

Description

Sort Order

ObjectId

Object on which custom validation rules are to be applied

Ascending

PropertyName

Property name on which the rule has to be applied

Ascending

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

Ascending

ERPType

Valid values are :

None = -1,

iVendUnplugged = 0,

SAPBusinessOne = 1,

OthersWithAPI = 2,

SAPBusinessOneStartPack = 3,

NAV = 4

Ascending

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

Ascending

IsDeleted

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

Ascending

Average key length

45.21

Density

0.20

Rows in the Table

76

Rows Sampled

76

Distribution Steps

18

Updated

Oct 8 2018 5:57PM