Table of Contents | ||||
---|---|---|---|---|
|
Capability
This Import allows the User to INSERT or UPDATE existing Approval Criteria for Requests created through (2024.1) CustomerCenter.
Matches On
You can match on existing records by either
...
All Criteria fields have a "duplicate" field prefixed with "New" to denote the new value that will be applied on the completion of the update.
Fields
Approval Criteria RECID
Datatype is is Number
Default: blank
Equipment Catalog
Datatype is is Hierarchical String
Note: Service Catalog and Equipment Catalog cannot both have values.
Service Catalog
Datatype is is Hierarchical String
Note: Service Catalog and Equipment Catalog cannot both have values.
Owner Contact's Customer Number
Datatype is String
Note: Owner Contacts and Owner Department cannot both have values.
Owner Contact's First Name
Datatype is String
MUST be be used with Owner Contact's Last Name.
Note: Owner Contacts and Owner Department cannot both have values.
Owner Contact's Last Name
Datatype is String
MUST be be used with Owner Contact's Customer Number.
Note: Owner Contacts and Owner Department cannot both have values.
Owner Department Hierarchy
Datatype is is Hierarchical String
The full Department Hierarchy Path Code value should be provided.
The Import does not accept the Department Hierarchy Name.
Note: Owner Contacts and Owner Department cannot both have values.
GLA
Datatype is is Hierarchical String
Minimum Amount
Datatype is Numberis Number
Maximum Amount
Datatype is Numberis Number
Approver Contact's Customer Number
Datatype is String
Approver Contact's First Name
Datatype is String
MUST be be used with Approver Contact's Last Name
Approver Contact's Last Name
Datatype is String
MUST be be used with Approver Contact's First Name.
New Equipment Catalog
Datatype is is Hierarchical String
Note: New Service Catalog and New Equipment Catalog cannot both have values
New Service Catalog
Datatype is is Hierarchical String
Note: New Service Catalog and New Equipment Catalog cannot both have values
New
Owner New Owner Contact's Customer Number
Datatype is String
Note: Owner Contacts and Owner Department cannot both have values.
New Owner Contact's First Name
Datatype is String
MUST be be used with New Owner Contact's Last Name.
Note: Owner Contacts and Owner Department cannot both have values.
New Owner Contact's Last Name
Datatype is String
MUST be be used with New Owner Contact's First Name
Note: Owner Contacts and Owner Department cannot both have values.
New
Owner
Department Owner Department Hierarchy
Datatype is is Hierarchical String
The full Department Hierarchy Path Code value should be provided.
Note: Owner Contacts and Owner Department cannot both have values.
New GLA
Datatype is is Hierarchical String
New Minimum Amount
Datatype is Numberis Number.
New
Maximum New Maximum Amount
Datatype is Numberis Number.
Flags
FLAG_CLEAR_APPROVERS
Datatype is Boolean
Default: False
Will remove all approvers for criteria.
Note: If this is set to true when updating, the approver is required
FLAG_UPDATE_BLANKS
Datatype is Boolean
Default: False
This flag is only relevant when updating a record. When set to true, any fields that were mapped either with Column Mappings or Conditional Logic and have a blank value will be cleared on the record. If the flag is false or a field has not been mapped the value on the record will be retained.
Note:it will only update blank mapped fields
Errors
Fields that convert to recids can throw
No records found
Multiple records found
Record must be active
Catalog fields cannot be a category
Amount fields must be numeric
Amount fields cannot be negative
Minimum Amount cannot be greater than Maximum Amount
At least one Approver required for
Inserts
Updates when Clear Approvers is true
Inserts require at least one criteria field.
Update would result in all blank criteria fields.