Action Indicator for Transaction¶
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.
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.
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.