14.1 sp287_dispatch_statuses
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
Lookup table of possible delivery status for dispatch messages (used in sp100 and sp207). Current contents of this table are:
| 0 | pending dispatch |
| 1 | dispatched OK |
| 2 | failed dispatch |
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| dispatch_status | number(2) |  | |
| description | varchar2(20) | | |
| field_id | varchar2(100) | |
Keys
primary key (dispatch_status)
foreign key (field_id) references 14.1 sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| dispatch_status | Primary key: unique identifier of the status . |
| description | Depreciated - Short description of the status. |
| field_id | Key to language translations for description. |