Validation rules

If any of these rules are violated, the transaction is rejected:

• Transaction must contain primary key field.
• Transaction must contain valid approver external key. If an approver is missing or invalid, a default approver is assigned. A default approver is defined as an application parameter.
• Transaction must contain a valid cost center external key.
• Transaction must contain a valid active status.
• Transaction must contain a valid country external key.
• Transaction must contain valid currency external keys.
• If present, transaction must contain a valid set of books external key.
• If a credit card external key is provided, the Standard Import Process checks for the existence of this credit card entry. If the credit card does not exist, a new credit card record is created and assigned to this user. To create a new credit card, these must exist:
  • Credit card number
  • Valid credit card processor external key
  • Valid payment type external key

If the credit card exists but is not assigned to the current user, the credit card is not re-assigned to this user. The Standard Import Process logs a warning. If the credit card exists and is assigned to this user, no action is taken.

• User login name must be unique system-wide.
• Transaction must contain valid out_of_office flag.