View idempiere9.adempiere.rv_printformatdetail
PrintFormat Detail

 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_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
ad_printformat_id numeric 10  √  null Data Print Format
name varchar 60  √  null Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
istablebased bpchar 1  √  null Table based List Reporting
isform bpchar 1  √  null If Selected, a Form is printed, if not selected a columnar List report
ad_table_id numeric 10  √  null Database Table information
ad_reportview_id numeric 10  √  null View used to generate this report
ad_printpaper_id numeric 10  √  null Printer paper definition
default_ad_printcolor_id numeric 10  √  null Default Print Color
default_ad_printfont_id numeric 10  √  null Default Print Font
isstandardheaderfooter bpchar 1  √  null The standard Header and Footer is used
ad_printtableformat_id numeric 10  √  null Table Format in Reports
headermargin numeric 10  √  null Margin of the Header in 1/72 of an inch
footermargin numeric 10  √  null Margin of the Footer in 1/72 of an inch
printername varchar 40  √  null Name of the Printer
isdefault bpchar 1  √  null Default value
ad_printformatitem_id numeric 10  √  null Item/Column in the Print format
itemname varchar 60  √  null Print Item Name
printname varchar 2000  √  null The label text to be printed on a document or correspondence.
printnamesuffix varchar 60  √  null The label text to be printed on a document or correspondence after the field
isprinted bpchar 1  √  null Indicates if this document / line is printed
printareatype bpchar 1  √  null Print Area
seqno numeric 10  √  null Method of ordering records; lowest number comes first
printformattype bpchar 1  √  null Print Format Type
ad_column_id numeric 10  √  null Column in the table
ad_printformatchild_id numeric 10  √  null Print format that is included here.
imageisattached bpchar 1  √  null The image to be printed is attached to the record
imageurl varchar 120  √  null URL of image
isrelativeposition bpchar 1  √  null The item is relative positioned (not absolute)
isnextline bpchar 1  √  null Print item on next line
xspace numeric 10  √  null Relative X (horizontal) space in 1/72 of an inch
yspace numeric 10  √  null Relative Y (vertical) space in 1/72 of an inch
xposition numeric 10  √  null Absolute X (horizontal) position in 1/72 of an inch
yposition numeric 10  √  null Absolute Y (vertical) position in 1/72 of an inch
maxwidth numeric 10  √  null Maximum Width in 1/72 if an inch - 0 = no restriction
isheightoneline bpchar 1  √  null If selected, only one line is printed
maxheight numeric 10  √  null Maximum Height in 1/72 if an inch - 0 = no restriction
isfixedwidth bpchar 1  √  null Column has a fixed width
issetnlposition bpchar 1  √  null Set New Line Position
issuppressnull bpchar 1  √  null Suppress columns or elements with NULL value
belowcolumn numeric 10  √  null Print this column below the column index entered
fieldalignmenttype bpchar 1  √  null Field Text Alignment
linealignmenttype bpchar 1  √  null Line Alignment
ad_printcolor_id numeric 10  √  null Color used for printing and display
ad_printfont_id numeric 10  √  null Maintain Print Font
isorderby bpchar 1  √  null Include in sort order
sortno numeric 10  √  null Determines in what order the records are displayed
isgroupby bpchar 1  √  null After a group change, totals, etc. are printed
ispagebreak bpchar 1  √  null Start with new page
isnextpage bpchar 1  √  null The column is printed on the next page
issummarized bpchar 1  √  null Calculate the Sum of numeric content or length
isaveraged bpchar 1  √  null Calculate Average of numeric content or length
iscounted bpchar 1  √  null Count number of not empty elements
ismincalc bpchar 1  √  null Calculate the minimum amount
ismaxcalc bpchar 1  √  null Calculate the maximum amount
isvariancecalc bpchar 1  √  null Calculate Variance
isdeviationcalc bpchar 1  √  null Calculate Standard Deviation
isrunningtotal bpchar 1  √  null Create a running total (sum)
runningtotallines numeric 10  √  null Create Running Total Lines (page break) every x lines
ad_printgraph_id numeric 10  √  null Graph included in Reports

Analyzed at 2021-12-25 14:43 +0100