Skip to main content

 

 

Coupa Success Portal

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 Rules Columns

Column Name Description Req'd Unique Type Allowable Values
Name* Name of Account Validation Rule TRUE TRUE string(100) any
Error Message* Error Message to display if rule is triggered TRUE FALSE string(255) any
Description Description of the rule FALSE FALSE string(255) any
Active If this rule is currently active or not FALSE FALSE boolean Yes/No, True/False, Y/N, T/F
Chart of Accounts Name Leave blank to trigger for ALL chart of accounts. Otherwise Chart of Account Name must exist. FALSE FALSE string(50) Blank or must exist in Coupa
Segment 1 Condition Segment 1 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 1 Min Segment 1 Min if Condition i s Range FALSE FALSE string(255) any
Segment 1 Max Segment 1 Max if condition is Range FALSE FALSE string(255) any
Segment 2 Condition Segment 2 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 2 Min Segment 2 Min if condition is Range FALSE FALSE string(255) any
Segment 2 Max Segment 2 Max if condition is Range FALSE FALSE string(255) any
Segment 3 Condition Segment 3 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 3 Min Segment 3 Min if condition is Range FALSE FALSE string(255) any
Segment 3 Max Segment 3 Max if condition is Range FALSE FALSE string(255) any
Segment 4 Condition Segment 4 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 4 Min Segment 4 Min if condition is Range FALSE FALSE string(255) any
Segment 4 Max Segment 4 Max if condition is Range FALSE FALSE string(255) any
Segment 5 Condition Segment 5 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 5 Min Segment 5 Min if condition is Range FALSE FALSE string(255) any
Segment 5 Max Segment 5 Max if condition is Range FALSE FALSE string(255) any
Segment 6 Condition Segment 6 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 6 Min Segment 6 Min if condition is Range FALSE FALSE string(255) any
Segment 6 Max Segment 6 Max if condition is Range FALSE FALSE string(255) any
Segment 7 Condition Segment 7 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 7 Min Segment 7 Min if condition is Range FALSE FALSE string(255) any
Segment 7 Max Segment 7 Max if condition is Range FALSE FALSE string(255) any
Segment 8 Condition Segment 8 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 8 Min Segment 8 Min if condition is Range FALSE FALSE string(255) any
Segment 8 Max Segment 8 Max if condition is Range FALSE FALSE string(255) any
Segment 9 Condition Segment 9 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 9 Min Segment 9 Min if condition is Range FALSE FALSE string(255) any
Segment 9 Max Segment 9 Max if condition is Range FALSE FALSE string(255) any
Segment 10 Condition Segment 10 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 10 Min Segment 10 Min if condition is Range FALSE FALSE string(255) any
Segment 10 Max Segment 10 Max if condition is Range FALSE FALSE string(255) any
Segment 11 Condition Segment 11 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 11 Min Segment 11 Min if condition is Range FALSE FALSE string(255) any
Segment 11 Max Segment 11 Max if condition is Range FALSE FALSE string(255) any
Segment 12 Condition Segment 12 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 12 Min Segment 12 Min if condition is Range FALSE FALSE string(255) any
Segment 12 Max Segment 12 Max if condition is Range FALSE FALSE string(255) any
Segment 13 Condition Segment 13 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 13 Min Segment 13 Min if condition is Range FALSE FALSE string(255) any
Segment 13 Max Segment 13 Max if condition is Range FALSE FALSE string(255) any
Segment 14 Condition Segment 14 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 14 Min Segment 14 Min if condition is Range FALSE FALSE string(255) any
Segment 14 Max Segment 14 Max if condition is Range FALSE FALSE string(255) any
Segment 15 Condition Segment 15 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 15 Min Segment 15 Min if condition is Range FALSE FALSE string(255) any
Segment 15 Max Segment 15 Max if condition is Range FALSE FALSE string(255) any
Segment 16 Condition Segment 16 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 16 Min Segment 16 Min if condition is Range FALSE FALSE string(255) any
Segment 16 Max Segment 16 Max if condition is Range FALSE FALSE string(255) any
Segment 17 Condition Segment 17 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 17 Min Segment 17 Min if condition is Range FALSE FALSE string(255) any
Segment 17 Max Segment 17 Max if condition is Range FALSE FALSE string(255) any
Segment 18 Condition Segment 18 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 18 Min Segment 18 Min if condition is Range FALSE FALSE string(255) any
Segment 18 Max Segment 18 Max if condition is Range FALSE FALSE string(255) any
Segment 19 Condition Segment 19 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 19 Min Segment 19 Min if condition is Range FALSE FALSE string(255) any
Segment 19 Max Segment 19 Max if condition is Range FALSE FALSE string(255) any
Segment 20 Condition Segment 20 Condition (Range, Blank Value, Any Values) FALSE FALSE string(255) Range, Blank Value, All Values
Segment 20 Min Segment 20 Min if condition is Range FALSE FALSE string(255) any
Segment 20 Max Segment 20 Max if condition is Range FALSE FALSE string(255) any
  • Was this article helpful?