Integration Queue

This form provides visibility of inbound data transactions to be reviewed and posted. This form is intended to assist an integrator with integration analysis.

The grid on the form leverages the integration_queue database table. As records are inserted into the table, a customer stored procedure is called to handle the record and attempt to post it. When the record posts successfully it is marked as posted, otherwise the record is flagged with an error message.

This form can be used to re-post any record that was originally flagged with an error.

Note: The integration_queue table can be extended to house custom columns as deemed necessary by the integrator and these new columns can be referenced in the custom stored procedure.