sp240_ext_data_display_defns
This table defines the set of actual display rules applied to individual external data types by the GUI when formatting external data input fields.
Â
Table Definition
Field | Type | Default | Nullable |
---|---|---|---|
external_data_type | number(9)Â | Â | Â |
display_property | number (2)Â | Â | Â |
display_value | varchar2(30)Â | Â | Â |
Keys
Primary key (external_data_type, display _property)Â
Foreign key (external_data_type) references sp231_ext_data_types(external_data_type)Â
Foreign key (validation_property) references sp239_ext_data_display(display_property)
Column Descriptions
Field | Description |
---|---|
external_data_type | Identifier of the data type   |
display_property | Identifier of the display type |
display_value | The value used with the display property to determine the appearance of the input field. For example, with a diplay_property referencing the display_rule 'field size' and a display rule defined here as '10' a 10 character or digit input field would be displayed. |