Table idempiere9.adempiere.ad_field
Field on a database table

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_field_id numeric 10
ad_field_trl.ad_field_id ad_fieldtrl C
ad_fieldsuggestion.ad_field_id adfield_adfieldsuggestion R
ad_userdef_field.ad_field_id adfield_aduserdeffield R
asp_clientexception.ad_field_id adfield_aspclientexception R
asp_field.ad_field_id adfield_aspfield R
Field on a database table
ad_client_id numeric 10
ad_client.ad_client_id fieldclient R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id fieldorg R
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
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
ad_tab_id numeric 10
ad_tab.ad_tab_id ad_tab_field C
Tab within a Window
ad_column_id numeric 10  √  null
ad_column.ad_column_id ad_column_field R
Column in the table
ad_fieldgroup_id numeric 10  √  null
ad_fieldgroup.ad_fieldgroup_id adfieldgroup_adfield R
Logical grouping of fields
isdisplayed bpchar 1 'Y'::bpchar Determines, if this field is displayed
displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
displaylength numeric 10  √  null Length of the display in characters
isreadonly bpchar 1 'N'::bpchar Field is read only
seqno numeric 10  √  null Method of ordering records; lowest number comes first
sortno numeric 10  √  null Determines in what order the records are displayed
issameline bpchar 1 'N'::bpchar Displayed on same line as previous field
isheading bpchar 1 'N'::bpchar Field without Column - Only label is displayed
isfieldonly bpchar 1 'N'::bpchar Label is not displayed
isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adfield R
Dictionary Entity Type; Determines ownership and synchronization
obscuretype bpchar 3  √  null Type of obscuring the data (limiting the display)
ad_reference_id numeric 10  √  null
ad_reference.ad_reference_id adreference_adfield R
System Reference and Validation
ismandatory bpchar 1  √  null Data entry is required in this column
included_tab_id numeric 10  √  null
ad_tab.ad_tab_id includedtab_adfield R
Included Tab in this Tab (Master Detail)
defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_reference_value_id numeric 10  √  null
ad_reference.ad_reference_id adreferencevalue_adfield R
Required to specify, if data type is Table or List
ad_val_rule_id numeric 10  √  null
ad_val_rule.ad_val_rule_id advalrule_adfield R
Dynamic Validation Rule
infofactoryclass varchar 255  √  null Fully qualified class name that implements the InfoFactory interface
ad_field_uu varchar 36  √  NULL::character varying AD_Field_UU
isallowcopy bpchar 1  √  NULL::bpchar Determine if a column must be copied when pushing the button to copy record
seqnogrid numeric 10  √  NULL::numeric Grid Sequence No
isdisplayedgrid bpchar 1  √  'Y'::bpchar Show in Grid
xposition numeric 10  √  (1)::numeric Absolute X (horizontal) position in 1/72 of an inch
numlines numeric 10  √  (1)::numeric Number of lines for a field
columnspan numeric 10  √  (1)::numeric Number of column for a box of field
isquickentry bpchar 1 'N'::bpchar Quick Entry
isupdateable bpchar 1  √  NULL::bpchar Determines, if the field can be updated
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)
istoolbarbutton bpchar 1  √  null Show the button on the toolbar, the window, or both
isadvancedfield bpchar 1  √  'N'::bpchar Advanced Field
isdefaultfocus bpchar 1 'N'::bpchar Default Focus
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_adfield R
Label CSS Style
ad_fieldstyle_id numeric 10  √  NULL::numeric
ad_style.ad_style_id adfieldstyle_adfield R
Field CSS Style
placeholder varchar 255  √  NULL::character varying Placeholder
isquickform bpchar 1 'N'::bpchar Display in Quick Form
isselectioncolumn bpchar 1  √  NULL::bpchar Is this column used for finding rows in windows
ad_val_rule_lookup_id numeric 10  √  NULL::numeric
ad_val_rule.ad_val_rule_id advalrulelookup_adfield R
Override Dynamic Validation Rule for Lookup Window
columnsql varchar 4000  √  null Virtual Column (r/o)

Table contained 20,329 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_field_id Primary key Asc ad_field_pkey
ad_tab_id + ad_column_id Must be unique Asc/Asc ad_field_column
ad_field_uu Must be unique Asc ad_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.