Account Validation Rules Import

Overview

The Approval chains Import process reads files from ./Incoming/AccountValidationRules/ in the SFTP. These files will be moved to the archive folder located at ./Archive/Incoming/AccountValidationRules/ before being processed in Alpha-Numeric order.

Account Validation Rule

Field NameRequired FieldUnique?Field TypeField DescriptionPossible Values
NameYesYesstring(100)Name of Account Validation Rule
Error MessageYesNostring(255)Error Message to display if rule is triggered
DescriptionNoNostring(255)Description of the rule
ActiveNoNobooleanIf this rule is currently active or not
Chart of Accounts NameNoNoLeave blank to trigger for ALL chart of accounts. Otherwise Chart of Account Name must exist.
Segment 1 ConditionNoNostring(255)Segment 1 Condition (Range, Blank Value, Any Values)
Segment 1 MinNoNostring(255)Segment 1 Min if Condition i s Range
Segment 1 MaxNoNostring(255)Segment 1 Max if condition is Range
Segment 2 ConditionNoNostring(255)Segment 2 Condition (Range, Blank Value, Any Values)
Segment 2 MinNoNostring(255)Segment 2 Min if condition is Range
Segment 2 MaxNoNostring(255)Segment 2 Max if condition is Range
Segment 3 ConditionNoNostring(255)Segment 3 Condition (Range, Blank Value, Any Values)
Segment 3 MinNoNostring(255)Segment 3 Min if condition is Range
Segment 3 MaxNoNostring(255)Segment 3 Max if condition is Range
Segment 4 ConditionNoNostring(255)Segment 4 Condition (Range, Blank Value, Any Values)
Segment 4 MinNoNostring(255)Segment 4 Min if condition is Range
Segment 4 MaxNoNostring(255)Segment 4 Max if condition is Range
Segment 5 ConditionNoNostring(255)Segment 5 Condition (Range, Blank Value, Any Values)
Segment 5 MinNoNostring(255)Segment 5 Min if condition is Range
Segment 5 MaxNoNostring(255)Segment 5 Max if condition is Range
Segment 6 ConditionNoNostring(255)Segment 6 Condition (Range, Blank Value, Any Values)
Segment 6 MinNoNostring(255)Segment 6 Min if condition is Range
Segment 6 MaxNoNostring(255)Segment 6 Max if condition is Range
Segment 7 ConditionNoNostring(255)Segment 7 Condition (Range, Blank Value, Any Values)
Segment 7 MinNoNostring(255)Segment 7 Min if condition is Range
Segment 7 MaxNoNostring(255)Segment 7 Max if condition is Range
Segment 8 ConditionNoNostring(255)Segment 8 Condition (Range, Blank Value, Any Values)
Segment 8 MinNoNostring(255)Segment 8 Min if condition is Range
Segment 8 MaxNoNostring(255)Segment 8 Max if condition is Range
Segment 9 ConditionNoNostring(255)Segment 9 Condition (Range, Blank Value, Any Values)
Segment 9 MinNoNostring(255)Segment 9 Min if condition is Range
Segment 9 MaxNoNostring(255)Segment 9 Max if condition is Range
Segment 10 ConditionNoNostring(255)Segment 10 Condition (Range, Blank Value, Any Values)
Segment 10 MinNoNostring(255)Segment 10 Min if condition is Range
Segment 10 MaxNoNostring(255)Segment 10 Max if condition is Range
Segment 11 ConditionNoNostring(255)Segment 11 Condition (Range, Blank Value, Any Values)
Segment 11 MinNoNostring(255)Segment 11 Min if condition is Range
Segment 11 MaxNoNostring(255)Segment 11 Max if condition is Range
Segment 12 ConditionNoNostring(255)Segment 12 Condition (Range, Blank Value, Any Values)
Segment 12 MinNoNostring(255)Segment 12 Min if condition is Range
Segment 12 MaxNoNostring(255)Segment 12 Max if condition is Range
Segment 13 ConditionNoNostring(255)Segment 13 Condition (Range, Blank Value, Any Values)
Segment 13 MinNoNostring(255)Segment 13 Min if condition is Range
Segment 13 MaxNoNostring(255)Segment 13 Max if condition is Range
Segment 14 ConditionNoNostring(255)Segment 14 Condition (Range, Blank Value, Any Values)
Segment 14 MinNoNostring(255)Segment 14 Min if condition is Range
Segment 14 MaxNoNostring(255)Segment 14 Max if condition is Range
Segment 15 ConditionNoNostring(255)Segment 15 Condition (Range, Blank Value, Any Values)
Segment 15 MinNoNostring(255)Segment 15 Min if condition is Range
Segment 15 MaxNoNostring(255)Segment 15 Max if condition is Range
Segment 16 ConditionNoNostring(255)Segment 16 Condition (Range, Blank Value, Any Values)
Segment 16 MinNoNostring(255)Segment 16 Min if condition is Range
Segment 16 MaxNoNostring(255)Segment 16 Max if condition is Range
Segment 17 ConditionNoNostring(255)Segment 17 Condition (Range, Blank Value, Any Values)
Segment 17 MinNoNostring(255)Segment 17 Min if condition is Range
Segment 17 MaxNoNostring(255)Segment 17 Max if condition is Range
Segment 18 ConditionNoNostring(255)Segment 18 Condition (Range, Blank Value, Any Values)
Segment 18 MinNoNostring(255)Segment 18 Min if condition is Range
Segment 18 MaxNoNostring(255)Segment 18 Max if condition is Range
Segment 19 ConditionNoNostring(255)Segment 19 Condition (Range, Blank Value, Any Values)
Segment 19 MinNoNostring(255)Segment 19 Min if condition is Range
Segment 19 MaxNoNostring(255)Segment 19 Max if condition is Range
Segment 20 ConditionNoNostring(255)Segment 20 Condition (Range, Blank Value, Any Values)
Segment 20 MinNoNostring(255)Segment 20 Min if condition is Range
Segment 20 MaxNoNostring(255)Segment 20 Max if condition is Range