Document toolboxDocument toolbox

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_typenumber(9)  (error) 
display_propertynumber (2)  (error) 
display_valuevarchar2(30)  (error) 

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

FieldDescription
external_data_typeIdentifier of the data type   
display_propertyIdentifier 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.