Module outbox event queue: event type, source entity, JSON payload, processing status, and retries
Data model
Fields
| Field | Type | Description |
|---|---|---|
| entity_id* | UNIQUEIDENTIFIER | Event source record ID |
| entity_name* | VARCHAR (100) | Event Source Entity |
| event_type* | VARCHAR (100) | Integration Event Type |
| integration_event_id* | UNIQUEIDENTIFIER | Unique identifier of the integration event |
| is_active* | BIT | Logical Deletion: 1 = Active Record, 0 = Retired |
| last_error | NVARCHAR (MAX) | Last processing error |
| last_sync_date | DATETIME2 | Date of last event processing |
| payload_json* | NVARCHAR (MAX) | Event Content (JSON) |
| processing_status* | VARCHAR (30) | Event Processing Status (Pending, Processed, Failed) |
| retry_count* | INT | Number of processing retries |
Primary Key
| PK_APMO_INTEGRATION_EVENT |
|---|
| integration_event_id |