Action Indicator for Transaction

Description

Indicator for Insert, Update, or Delete data manipulation action. This is the action AQS will perform with the data in the remainder of the record.

Valid values:

  • I for Insert

  • U for Update

  • D for Delete

Insert will add the data to the database. Update will update all provided fields with new values for the matching key fields. (Key fields will vary by transaction). Delete will remove data from the database for the matching key fields.

Business Rules

Must be I, U, or D.

You cannot insert a record if a record with the same key information already exists in the database.

You cannot update or delete a record if no record with the same key information already exists in the database.