Approval Chain Import

Overview

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

Keys & Validations

Approval Chain Name and Approval Chain Type are the keys to update an existing approval chain. Both these keys are needed in order to perform an update. You cannot update the type of an existing approval chain.

You cannot create Orders and Requisitions approval chains with the same name. Loading an approval name for orders with the same name of an existing one for requisitions through the bulk loader will cause the Approval Chain Type to change from "requisition" to "order" (it's also true vice versa).

Currently supported conditions and operations:

  • Accounts (equals, contains)

  • Commodity (equals, contains, not contains)

  • Item (equals, contains, not contains)

  • Requester (equals, contains, not contains)

Approval chains created through the loader follow the same validations as those created through the UI.

Note: Priority cannot be 50 because 50 is the management hierarchy. This means that a chain that's less than 50 fires before management hierarchy while a chain that's greater than 50 fires after management hierarchy.

Approval Chain

Field Name Required Field Unique? Field Type Field Description Possible Values
Approval Chain Name No No Unique Approval Chain Name
Status No No Active or Inactive
Approval Chain Type No No Some possible values: requisition requisition-submission-blocking requisition-approval-blocking requisition-hierarchy expense invoice invoice-submission-blocking invoice-submission-warning invoice-approval-blocking invoice-hierarchy contract-hierarchy contract contract-submission-blocking contract-submission-warning easy-form-user contract-round
Priority No No Order in which to evaluate approval chain. Number from 1 to 49 and 51 to 99
Skip Approvers No No Skip Approvers prior to self if on approval chain
Skip Management Hierarchy No No Skip Management Hierarchy if this chain matches
Skip Further Approvers No No Skip Further Approvers if this chain matches
Auto Approve Self No No Auto Approve Self if added to approval chain
Dedupe OBO User and Auto Approve No No Override On Behalf Of user, keep the approval chain approver and auto approve the approval
Always Evaluate No No Always Evaluate
Parallel No No Parallel approvals supported
Total Comparator No No The total comparator
Minimum Total Amount No No Minimum allowed approval total
Maximum Total Amount No No Maximum allowed approval total
Total Currency No No Currency Code for total currency
Minimum Approval Limit No No Minimum Approval Limit
Maximum Approval Limit Amount No No Maximum Approval Limit Amount
Maximum Approval Limit Currency No No Maximum Approval Limit Currency
Maximum Approval Limit No No Maximum Approval Limit
Operator No No The conditions operator
Condition 1 No No Condition 1 - Colon : seperated list of val:field:condition
Condition 2 No No Condition 2
Condition 3 No No Condition 3
Condition 4 No No Condition 4
Condition 5 No No Condition 5
Condition 6 No No Condition 6
Condition 7 No No Condition 7
Condition 8 No No Condition 8
Condition 9 No No Condition 9
Condition 10 No No Condition 10
Description No No Set custom notification text for the condition(s) you have set above. If you leave this field blank, the system will use the name of the configuration you set as the default text.
Approver 1 No No Approver 1 - Colon : seperated value consisting of user_login;amount;currency_code
Approver 2 No No Approver 2
Approver 3 No No Approver 3
Approver 4 No No Approver 4
Approver 5 No No Approver 5
Approver 6 No No Approver 6
Approver 7 No No Approver 7
Approver 8 No No Approver 8
Approver 9 No No Approver 9
Approver 10 No No Approver 10
Watcher 1 No No Watcher 1 - User Login to add as watcher
Watcher 2 No No Watcher 2
Watcher 3 No No Watcher 3
Watcher 4 No No Watcher 4
Watcher 5 No No Watcher 5
Approver Params No No semi-colon ; seperated list of parameters. Each parameter begins with an identifier than any needed values seperated by a colon : Example identifiers are first_approver, middle_approvers and last_approver. sample values for these are skip, watcher, or approver. Other examples are escalation:User:<UserLogin>, escalation:ApprovalGroup:<GroupName> where the bracketed values should be replaced by the actual Login or Name.
Validation Message No No Approval Chain Message / Description
Signatory 1 No No Signatory 1 - User Login to as signatory
Signatory 2 No No Signatory 2
Signatory 3 No No Signatory 3
Signatory 4 No No Signatory 4
Signatory 5 No No Signatory 5
Applies to Supplier No No Applies to Supplier

Approval Group

Field Name Required Field Unique? Field Type Field Description Possible Values
Name Yes Yes string(255) Name
Id No No integer Unique identifier Coupa assigns when a new record is created. It can’t be modified, but can be used to update the record.
Active No No boolean Whether this Project or Group is currently Active.
Owner No No Owner group receives notifications on Approval Group errors. Field is called Parent Group in the UI.
Users By Login No No A semi-colon seperated list of Logins for all users of this project or group.
Users By Employee Number No No A semi-colon seperated list of Employee Numbers for all users of this project or group.
Description No No Description