Table idempiere9.adempiere.ad_userdef_field
User defined Field

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_userdef_field_id numeric 10 User defined Field
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
ad_userdef_tab_id numeric 10
ad_userdef_tab.ad_userdef_tab_id aduserdeftab_aduserdeffield R
User defined Tab
ad_field_id numeric 10
ad_field.ad_field_id adfield_aduserdeffield R
Field on a database table
name varchar 60  √  null Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
isdisplayed bpchar 1  √  null Determines, if this field is displayed
isreadonly bpchar 1  √  null Field is read only
issameline bpchar 1  √  null Displayed on same line as previous field
isupdateable bpchar 1  √  null Determines, if the field can be updated
displaylength numeric 10 0 Length of the display in characters
displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
sortno numeric 10 0 Determines in what order the records are displayed
seqno numeric 10 (0)::numeric Method of ordering records; lowest number comes first
ad_userdef_field_uu varchar 36  √  NULL::character varying AD_UserDef_Field_UU
isalwaysupdateable bpchar 1  √  NULL::bpchar The column is always updateable, even if the record is not active or processed
mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
readonlylogic varchar 2000  √  NULL::character varying Logic to determine if field is read only (applies only when field is read-write)
ad_reference_value_id numeric 10  √  NULL::numeric
ad_reference.ad_reference_id adreferencevalue_aduserdeffiel R
Required to specify, if data type is Table or List
ismandatory bpchar 1  √  NULL::bpchar Data entry is required in this column
xposition numeric 10  √  NULL::numeric Absolute X (horizontal) position in 1/72 of an inch
numlines numeric 10  √  NULL::numeric Number of lines for a field
columnspan numeric 10  √  NULL::numeric Number of column for a box of field
istoolbarbutton bpchar 1  √  null Show the button on the toolbar, the window, or both
ad_reference_id numeric 10  √  NULL::numeric
ad_reference.ad_reference_id adreference_aduserdeffield R
System Reference and Validation
ad_val_rule_id numeric 10  √  NULL::numeric
ad_val_rule.ad_val_rule_id advalrule_aduserdeffield R
Dynamic Validation Rule
vformat varchar 255  √  NULL::character varying Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_labelstyle_id numeric 10  √  NULL::numeric
ad_style.ad_style_id adlabelstyle_aduserdeffield R
Label CSS Style
ad_fieldstyle_id numeric 10  √  NULL::numeric
ad_style.ad_style_id adfieldstyle_aduserdeffield R
Field CSS Style
pa_dashboardcontent_id numeric 10  √  NULL::numeric
pa_dashboardcontent.pa_dashboardcontent_id padashboardcontent_aduserdeffi R
Dashboard Content
placeholder varchar 255  √  NULL::character varying Placeholder
isautocomplete bpchar 1  √  NULL::bpchar Automatic completion for textfields
ad_val_rule_lookup_id numeric 10  √  NULL::numeric
ad_val_rule.ad_val_rule_id advalrulelookup_aduserdeffield R
Override Dynamic Validation Rule for Lookup Window
ad_fieldgroup_id numeric 10  √  NULL::numeric
ad_fieldgroup.ad_fieldgroup_id adfieldgroup_aduserdeffield R
Logical grouping of fields
seqnogrid numeric 10 '0'::numeric Grid Sequence No
isdisplayedgrid bpchar 1  √  NULL::bpchar Show in Grid

Table contained 0 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_userdef_field_id Primary key Asc ad_userdef_field_pkey
ad_userdef_tab_id + ad_field_id Must be unique Asc/Asc ad_userdef_field_unique
ad_userdef_field_uu Must be unique Asc ad_userdef_field_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.