View erp.COMPIERE.RV_PRINTFORMATDETAIL

 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_CLIENT_ID number 10
AD_CLIENTINFO AD_CLIENT_ID Implied Constraint
AD_ORG_ID number 10
AD_ORGINFO AD_ORG_ID Implied Constraint
ISACTIVE char 1
CREATED date 7
CREATEDBY number 10
UPDATED date 7
UPDATEDBY number 10
AD_PRINTFORMAT_ID number 10
AD_PRINTFORMAT AD_PRINTFORMAT_ID Implied Constraint
NAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
ISTABLEBASED char 1
ISFORM char 1
AD_TABLE_ID number 10
AD_TABLE AD_TABLE_ID Implied Constraint
AD_REPORTVIEW_ID number 10  √  null
AD_REPORTVIEW AD_REPORTVIEW_ID Implied Constraint
AD_PRINTPAPER_ID number 10
AD_PRINTPAPER AD_PRINTPAPER_ID Implied Constraint
DEFAULT_AD_PRINTCOLOR_ID number 10
DEFAULT_AD_PRINTFONT_ID number 10
ISSTANDARDHEADERFOOTER char 1
AD_PRINTTABLEFORMAT_ID number 10  √  null
AD_PRINTTABLEFORMAT AD_PRINTTABLEFORMAT_ID Implied Constraint
HEADERMARGIN number 10
FOOTERMARGIN number 10
PRINTERNAME nvarchar2 80  √  null
ISDEFAULT char 1
AD_PRINTFORMATITEM_ID number 10
AD_PRINTFORMATITEM AD_PRINTFORMATITEM_ID Implied Constraint
ITEMNAME nvarchar2 120
PRINTNAME nvarchar2 4000  √  null
PRINTNAMESUFFIX nvarchar2 120  √  null
ISPRINTED char 1
PRINTAREATYPE char 1
SEQNO number 10
PRINTFORMATTYPE char 1
AD_COLUMN_ID number 10  √  null
AD_COLUMN AD_COLUMN_ID Implied Constraint
AD_PRINTFORMATCHILD_ID number 10  √  null
IMAGEISATTACHED char 1
IMAGEURL nvarchar2 240  √  null
ISRELATIVEPOSITION char 1
ISNEXTLINE char 1
XSPACE number 10
YSPACE number 10
XPOSITION number 10
YPOSITION number 10
MAXWIDTH number 10
ISHEIGHTONELINE char 1
MAXHEIGHT number 10
ISFIXEDWIDTH char 1
ISSETNLPOSITION char 1
ISSUPPRESSNULL char 1
BELOWCOLUMN number 10  √  null
FIELDALIGNMENTTYPE char 1
LINEALIGNMENTTYPE char 1
AD_PRINTCOLOR_ID number 10  √  null
AD_PRINTCOLOR AD_PRINTCOLOR_ID Implied Constraint
AD_PRINTFONT_ID number 10  √  null
AD_PRINTFONT AD_PRINTFONT_ID Implied Constraint
ISORDERBY char 1
SORTNO number 10
ISGROUPBY char 1
ISPAGEBREAK char 1
ISNEXTPAGE char 1
ISSUMMARIZED char 1
ISAVERAGED char 1
ISCOUNTED char 1
ISMINCALC char 1
ISMAXCALC char 1
ISVARIANCECALC char 1
ISDEVIATIONCALC char 1
ISRUNNINGTOTAL char 1
RUNNINGTOTALLINES number 10  √  null
AD_PRINTGRAPH_ID number 10  √  null
AD_PRINTGRAPH AD_PRINTGRAPH_ID Implied Constraint
View SQL:
SELECT f.AD_Client_ID, f.AD_Org_ID, i.IsActive, i.Created,i.CreatedBy,i.Updated,i.UpdatedBy,
    f.AD_PrintFormat_ID,
    f.Name, f.Description,
    f.IsTableBased,f.IsForm,f.AD_Table_ID,f.AD_ReportView_ID,
    f.AD_PrintPaper_ID, 
    f.AD_PrintColor_ID AS Default_AD_PrintColor_ID,
    f.AD_PrintFont_ID AS Default_AD_PrintFont_ID,
    f.IsStandardHeaderFooter,
    f.AD_PrintTableFormat_ID,
    f.HeaderMargin,f.FooterMargin,
    f.PrinterName,f.IsDefault,
    i.AD_PrintFormatItem_ID,
    i.Name AS ItemName, i.PrintName, i.PrintNameSuffix, i.IsPrinted, i.PrintAreaType, i.SeqNo,
    i.PrintFormatType, i.AD_Column_ID, i.AD_PrintFormatChild_ID, i.ImageIsAttached,i.ImageURL,
    i.IsRelativePosition, i.IsNextLine, XSpace,YSpace, XPosition,YPosition,
    i.MaxWidth, IsHeightOneLine, MaxHeight, i.IsFixedWidth,
    i.IsSetNLPosition,i.IsSuppressNull, i.BelowColumn,
    i.FieldAlignmentType,i.LineAlignmentType,
    i.AD_PrintColor_ID,i.AD_PrintFont_ID,
    i.IsOrderBy,i.SortNo, i.IsGroupBy,i.IsPageBreak,i.IsNextPage,
    i.IsSummarized,i.IsAveraged,i.IsCounted,i.IsMinCalc,i.IsMaxCalc,
    i.IsVarianceCalc,i.IsDeviationCalc,
    i.IsRunningTotal,i.RunningTotalLines,
    i.AD_PrintGraph_ID
FROM AD_PrintFormat f
  INNER JOIN AD_PrintFormatItem i ON (f.AD_PrintFormat_ID=i.AD_PrintFormat_ID)


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.