View erp.COMPIERE.AD_FIELD_V

 Generated by
SchemaSpy
Implied relationships Related columns Constraint names Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents
AD_WINDOW_ID number 10
AD_WINDOW AD_WINDOW_ID Implied Constraint
AD_TAB_ID number 10
AD_TAB AD_TAB_ID Implied Constraint
AD_FIELD_ID number 10
AD_FIELD AD_FIELD_ID Implied Constraint
AD_TABLE_ID number 10
AD_TABLE AD_TABLE_ID Implied Constraint
AD_COLUMN_ID number 10  √  null
AD_COLUMN AD_COLUMN_ID Implied Constraint
NAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
HELP nvarchar2 4000  √  null
ISDISPLAYED char 1
DISPLAYLOGIC nvarchar2 4000  √  null
DISPLAYLENGTH number 10  √  null
SEQNO number 10  √  null
SORTNO number 10  √  null
ISSAMELINE char 1
ISHEADING char 1
ISFIELDONLY char 1
ISREADONLY char 1
ISENCRYPTEDFIELD char 1
OBSCURETYPE char 3  √  null
COLUMNNAME varchar2 40  √  null
COLUMNSQL nvarchar2 510  √  null
FIELDLENGTH number 10  √  null
VFORMAT nvarchar2 120  √  null
DEFAULTVALUE nvarchar2 4000  √  null
ISKEY char 1  √  null
ISPARENT char 1  √  null
ISMANDATORY char 1  √  null
ISIDENTIFIER char 1  √  null
ISTRANSLATED char 1  √  null
AD_REFERENCE_VALUE_ID number 10  √  null
CALLOUT nvarchar2 510  √  null
AD_REFERENCE_ID number 10  √  null
AD_REF_TABLE AD_REFERENCE_ID Implied Constraint
AD_VAL_RULE_ID number 10  √  null
AD_VAL_RULE AD_VAL_RULE_ID Implied Constraint
AD_PROCESS_ID number 10  √  null
AD_PROCESS AD_PROCESS_ID Implied Constraint
ISALWAYSUPDATEABLE char 1  √  null
READONLYLOGIC nvarchar2 4000  √  null
ISUPDATEABLE char 1  √  null
ISENCRYPTEDCOLUMN char 1  √  null
ISSELECTIONCOLUMN char 1  √  null
TABLENAME varchar2 40
VALUEMIN nvarchar2 40  √  null
VALUEMAX nvarchar2 40  √  null
FIELDGROUP nvarchar2 120  √  null
VALIDATIONCODE nvarchar2 4000  √  null
View SQL:
SELECT t.AD_Window_ID, f.AD_Tab_ID, f.AD_Field_ID, tbl.AD_Table_ID, f.AD_Column_ID, 
f.Name, f.Description, f.Help, f.IsDisplayed, f.DisplayLogic, f.DisplayLength, 
f.SeqNo, f.SortNo, f.IsSameLine, f.IsHeading, f.IsFieldOnly, f.IsReadOnly, 
f.IsEncrypted AS IsEncryptedField, f.ObscureType,
c.ColumnName, c.ColumnSQL, c.FieldLength, c.VFormat, c.DefaultValue, c.IsKey, c.IsParent, 
c.IsMandatory, c.IsIdentifier, c.IsTranslated, c.AD_Reference_Value_ID, 
c.Callout, c.AD_Reference_ID, c.AD_Val_Rule_ID, c.AD_Process_ID, c.IsAlwaysUpdateable,
c.ReadOnlyLogic, c.IsUpdateable, c.IsEncrypted AS IsEncryptedColumn, c.IsSelectionColumn,
tbl.TableName, c.ValueMin, c.ValueMax, 
fg.Name AS FieldGroup, vr.Code AS ValidationCode
FROM AD_Field f 
  INNER JOIN AD_Tab t ON (f.AD_Tab_ID = t.AD_Tab_ID)
  LEFT OUTER JOIN AD_FieldGroup fg ON (f.AD_FieldGroup_ID = fg.AD_FieldGroup_ID) 
  LEFT OUTER JOIN AD_Column c ON (f.AD_Column_ID = c.AD_Column_ID)
INNER JOIN AD_Table tbl ON (c.AD_Table_ID = tbl.AD_Table_ID)
INNER JOIN AD_Reference r ON (c.AD_Reference_ID = r.AD_Reference_ID)
LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID)
WHERE f.IsActive = 'Y' 
  AND c.IsActive = 'Y'


SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.