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
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 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
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 Column in the table
ad_fieldgroup_id numeric 10  √  null 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 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 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 Required to specify, if data type is Table or List
ad_val_rule_id numeric 10  √  null 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 Label CSS Style
ad_fieldstyle_id numeric 10  √  NULL::numeric 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 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:57 +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

Close relationships  within of separation: