sp241_ext_data_list_text

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