Account Validation Rules Import
The accounts validation rules integration loader uses only a single set of header columns.
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.
| 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 |