Table idempiere9.adempiere.ad_printformatitem
Item/Column in the Print format

 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_printformatitem_id numeric 10
ad_printformatitem_trl.ad_printformatitem_id adprintformatitem_trl C
ad_printgraph.data1_printformatitem_id adprintformatitem_graphdata1 R
ad_printgraph.data2_printformatitem_id adprintformatitem_graphdata2 R
ad_printgraph.data3_printformatitem_id adprintformatitem_graphdata3 R
ad_printgraph.data4_printformatitem_id adprintformatitem_graphdata4 R
ad_printgraph.data_printformatitem_id adprintformatitem_graphdata R
ad_printgraph.description_printformatitem_id adprintformatitem_graphdescr R
Item/Column in the Print format
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_printformat_id numeric 10
ad_printformat.ad_printformat_id adprintformat_printformatitem C
Data Print Format
name varchar 60 Alphanumeric identifier of the entity
printname varchar 2000  √  null The label text to be printed on a document or correspondence.
isprinted bpchar 1 'Y'::bpchar Indicates if this document / line is printed
printareatype bpchar 1 Print Area
seqno numeric 10 Method of ordering records; lowest number comes first
printformattype bpchar 1 Print Format Type
ad_column_id numeric 10  √  null
ad_column.ad_column_id adcolumn_adprintformatitem R
Column in the table
ad_printformatchild_id numeric 10  √  null
ad_printformat.ad_printformat_id adprintformat_printformatchild N
Print format that is included here.
isrelativeposition bpchar 1 'Y'::bpchar The item is relative positioned (not absolute)
isnextline bpchar 1 'Y'::bpchar Print item on next line
xspace numeric 10 Relative X (horizontal) space in 1/72 of an inch
yspace numeric 10 Relative Y (vertical) space in 1/72 of an inch
xposition numeric 10 Absolute X (horizontal) position in 1/72 of an inch
yposition numeric 10 Absolute Y (vertical) position in 1/72 of an inch
maxwidth numeric 10 Maximum Width in 1/72 if an inch - 0 = no restriction
isheightoneline bpchar 1 'Y'::bpchar If selected, only one line is printed
maxheight numeric 10 Maximum Height in 1/72 if an inch - 0 = no restriction
fieldalignmenttype bpchar 1 Field Text Alignment
linealignmenttype bpchar 1 Line Alignment
ad_printcolor_id numeric 10  √  null
ad_printcolor.ad_printcolor_id adprintcolor_adprintformatitem R
Color used for printing and display
ad_printfont_id numeric 10  √  null
ad_printfont.ad_printfont_id adprintfont_adprintformatitem R
Maintain Print Font
isorderby bpchar 1 'N'::bpchar Include in sort order
sortno numeric 10 Determines in what order the records are displayed
isgroupby bpchar 1 'N'::bpchar After a group change, totals, etc. are printed
ispagebreak bpchar 1 'N'::bpchar Start with new page
issummarized bpchar 1 'N'::bpchar Calculate the Sum of numeric content or length
imageisattached bpchar 1 'N'::bpchar The image to be printed is attached to the record
imageurl varchar 120  √  null URL of image
isaveraged bpchar 1 'N'::bpchar Calculate Average of numeric content or length
iscounted bpchar 1 'N'::bpchar Count number of not empty elements
issetnlposition bpchar 1 'N'::bpchar Set New Line Position
issuppressnull bpchar 1 'N'::bpchar Suppress columns or elements with NULL value
belowcolumn numeric 10  √  null Print this column below the column index entered
ad_printgraph_id numeric 10  √  null
ad_printgraph.ad_printgraph_id adprintgraph_printformatitem R
Graph included in Reports
isfixedwidth bpchar 1 'N'::bpchar Column has a fixed width
isnextpage bpchar 1 'N'::bpchar The column is printed on the next page
printnamesuffix varchar 60  √  null The label text to be printed on a document or correspondence after the field
ismincalc bpchar 1 'N'::bpchar Calculate the minimum amount
ismaxcalc bpchar 1 'N'::bpchar Calculate the maximum amount
isrunningtotal bpchar 1 'N'::bpchar Create a running total (sum)
runningtotallines numeric 10  √  null Create Running Total Lines (page break) every x lines
isvariancecalc bpchar 1 'N'::bpchar Calculate Variance
isdeviationcalc bpchar 1 'N'::bpchar Calculate Standard Deviation
isfilledrectangle bpchar 1 'N'::bpchar Fill the shape with the color selected
linewidth numeric 10  √  null Width of the lines
arcdiameter numeric 10  √  null Arc Diameter for rounded Rectangles
shapetype bpchar 1  √  null Type of the shape to be painted
iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
isimagefield bpchar 1 'N'::bpchar The image is retrieved from the data column
barcodetype bpchar 3  √  null Type of barcode
formatpattern varchar 60  √  null The pattern used to format a number or date.
issuppressrepeats bpchar 1 'N'::bpchar Suppress repeated elements in column.
ad_printformatitem_uu varchar 36  √  NULL::character varying AD_PrintFormatItem_UU
isdesc bpchar 1 'N'::bpchar Sort your data using a SQL Desc Order By statement
isprintbarcodetext bpchar 1 'Y'::bpchar Print barcode text at the bottom of barcode
displaylogic varchar 2000  √  NULL::character varying If the Field is displayed, the result determines if the field is actually displayed
script varchar 2000  √  NULL::character varying Dynamic Java Language Script to calculate result
isprintinstanceattributes bpchar 1 'N'::bpchar Print each attributes as report column instead of printing the description of attribute set instance

Table contained 2,675 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_printformatitem_id Primary key Asc ad_printformatitem_pkey
ad_printformat_id Performance Asc ad_printformatitem_format
ad_printformatitem_uu Must be unique Asc ad_printformatitem_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.