14.1 sp241_ext_data_list_text
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table defines the set of values used either to label a Boolean true/false pair or a set of values to populate a drop down selection list for a given external data type.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| external_data_type | number(9) |  | |
| list_item | varchar2(50) | | |
| list_display_order | number(3) | |
Keys
Primary key (external_data_type, list_item)
Foreign key (external_data_type) references sp231_ext_data_types (external_data_type)
Column Descriptions
| Field | Description |
|---|---|
| external_data_type | Identifier of the data type list_item The text displayed on screen and stored as the value of the data type (for the selection list type) |
| list_display_order | The order in which items appear in the the list. NB for Boolean types 0 denotes the 'false' and 1 denotes 'true' value |