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.