ManPageW PrintFormat

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Print Format

Description : Maintain Print Format

Help : The print format determines how data is rendered for print.



Tab: Print Format

Description : Maintain Print Format

Help : The print format determines how data is rendered for print.

Table Name  : AD_PrintFormat

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Default Default value The Default Checkbox indicates if this record will be used as a default value. IsDefault

CHAR(1)

YesNo

Table Database Table information The Database Table provides the information of the table definition AD_Table_ID

NUMBER(10)

TableDir

Report View View used to generate this report The Report View indicates the view used to generate this report. AD_ReportView_ID

NUMBER(10)

TableDir

Form If Selected, a Form is printed, if not selected a columnar List report A form has individual elements with layout information (example: invoice, check)


A columnar list report has individual columns (example: list of invoices)

IsForm

CHAR(1)

YesNo

Table Based Table based List Reporting Table based columnar list reporting is invoked from the Window Report button IsTableBased

CHAR(1)

YesNo

Print Paper Printer paper definition Printer Paper Size, Orientation and Margins AD_PrintPaper_ID

NUMBER(10)

TableDir

Standard Header/Footer The standard Header and Footer is used If the standard header is not used, it must be explicitly defined. IsStandardHeaderFooter

CHAR(1)

YesNo

Print Table Format Table Format in Reports Print Table Format determines Fonts, Colors of the printed Table AD_PrintTableFormat_ID

NUMBER(10)

TableDir

Printer Name Name of the Printer Internal (Opereating System) Name of the Printer; Please mote that the printer name may be different on different clients. Enter a printer name, which applies to ALL clients (e.g. printer on a server).

If none is entered, the default printer is used. You specify your default printer when you log in. You can also change the default printer in Preferences.

PrinterName

NVARCHAR2(40)

String

Header Margin Margin of the Header in 1/72 of an inch Distance from the top of the printable page to the start of the main content in 1/72 of an inch (point) HeaderMargin

NUMBER(10)

Integer

Footer Margin Margin of the Footer in 1/72 of an inch Distance from the bottom of the main content to the end of the printable page in 1/72 of an inch (point) FooterMargin

NUMBER(10)

Integer

Print Font Maintain Print Font Font used for printing AD_PrintFont_ID

NUMBER(10)

TableDir

Print Color Color used for printing and display Colors used for printing and display AD_PrintColor_ID

NUMBER(10)

TableDir

Jasper Process The Jasper Process used by the printengine if any process defined JasperProcess_ID

NUMBER(10)

Table

ClassName ClassName

VARCHAR2

String

Copy/Create Copy existing OR create Print Format from Table Select either a table to create a print format [creates initial rough layout]

OR a print format to copy into the current print format [copies layout].

CreateCopy

CHAR(1)

Button

Args Args

VARCHAR2

String


Tab: Display Order

Description : Display Order of the Print Format Items

Help :

Table Name  : AD_PrintFormatItem

Fields

Name Description Help Technical Data

Tab: Sort Order

Description : Sort Order of the Print Format Items

Help :

Table Name  : AD_PrintFormatItem

Fields

Name Description Help Technical Data

Tab: Format Item

Description : Print Format Item

Help : Item in the print format maintaining layout information. The following additional variables are available when printing: <p>@*Page@ - the current page number
@*PageCount@ - the total number of pages
@*MultiPageInfo@ - "Page x of y" - only printed if more than one page
@*CopyInfo@ - if it is a copy of the document "Duplicate" is printed
@*ReportName@ - name of the report
@*Header@ - Full Header with user/client/org name and connection
@*CurrentDate@ - the print date
@*CurrentDateTime@ - the print time

The layoit logic for forms is:

- if not printed: ignore
- set New Line Position
- new page
- new line, if something was printed since last new line
- format item
- print it (if not null/empty selected)
(i.e. supress null does not prevent new line)

Table Name  : AD_PrintFormatItem

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Print Format Data Print Format The print format determines how data is rendered for print. AD_PrintFormat_ID

NUMBER(10)

TableDir

Sequence Method of ordering records; lowest number comes first The Sequence indicates the order of records SeqNo

NUMBER(10)

Integer

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Print Text The label text to be printed on a document or correspondence. The Label to be printed indicates the name that will be printed on a document or correspondence. The max length is 2000 characters. PrintName

NVARCHAR2(2000)

String

Print Label Suffix The label text to be printed on a document or correspondence after the field The Label to be printed indicates the name that will be printed on a document or correspondence after the field. The max length is 60 characters. PrintNameSuffix

NVARCHAR2(60)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Centrally maintained Information maintained in System Element table The Centrally Maintained checkbox indicates if the Name, Description and Help maintained in 'System Element' table or 'Window' table. IsCentrallyMaintained

CHAR(1)

YesNo

Suppress Null Suppress columns or elements with NULL value If a Form entry is NULL and if selected, the field (including label) is not printed.

If all elements in a table column are NULL and if selected, the column is not printed.

IsSuppressNull

CHAR(1)

YesNo

Format Type Print Format Type The print format type determines what will be printed. PrintFormatType

CHAR(1)

List

Column Column in the table Link to the database column of the table AD_Column_ID

NUMBER(10)

TableDir

Line Width Width of the lines LineWidth

NUMBER(10)

Integer

Included Print Format Print format that is included here. Included Print formats allow to e.g. Lines to Header records. The Column provides the parent link. AD_PrintFormatChild_ID

NUMBER(10)

Table

Image Field The image is retrieved from the data column The Image URL is retrieved from the data column IsImageField

CHAR(1)

YesNo

Image attached The image to be printed is attached to the record The image to be printed is stored in the database as attachment to this record. The image can be a gif, jpeg or png. ImageIsAttached

CHAR(1)

YesNo

Image URL URL of image URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png. ImageURL

NVARCHAR2(120)

Unknown (40)

Area Print Area Print area of this item PrintAreaType

CHAR(1)

List

Barcode Type Type of barcode BarcodeType

CHAR(3)

List

Relative Position The item is relative positioned (not absolute) The relative positioning of the item is determined by X-Z space and next line IsRelativePosition

CHAR(1)

YesNo

Set NL Position Set New Line Position When enabled, the current x (horizontal) Position before printing the item is saved. The next New Line will use the saved x (horizontal) Position, enabling to print data in columns.

The setting is not restricted to an area (header, content, footer), allowing to align information also with Header and Footer with the Content.

IsSetNLPosition

CHAR(1)

YesNo

X Position Absolute X (horizontal) position in 1/72 of an inch Absolute X (horizontal) position in 1/72 of an inch XPosition

NUMBER(10)

Integer

Y Position Absolute Y (vertical) position in 1/72 of an inch Absolute Y (vertical) position in 1/72 of an inch YPosition

NUMBER(10)

Integer

Next Line Print item on next line If not selected, the item is printed on the same line IsNextLine

CHAR(1)

YesNo

Next Page The column is printed on the next page Before printing this column, there will be a page break. IsNextPage

CHAR(1)

YesNo

Below Column Print this column below the column index entered This column is printed in a second line below the content of the first line identified. Please be aware, that this is depends on the actual sequence. Enter a 1 to add the info below the first column. BelowColumn

NUMBER(10)

Integer

Line Alignment Line Alignment For relative positioning, the line alignment LineAlignmentType

CHAR(1)

List

Field Alignment Field Text Alignment Alignment of field text. The default is determined by the data/display type: Numbers are right aligned, other data is left aligned FieldAlignmentType

CHAR(1)

List

X Space Relative X (horizontal) space in 1/72 of an inch Relative X (horizontal) space in 1/72 of an inch in relation to the end of the previous item. XSpace

NUMBER(10)

Integer

Y Space Relative Y (vertical) space in 1/72 of an inch Relative Y (vertical) space in 1/72 of an inch in relation to the end of the previous item. YSpace

NUMBER(10)

Integer

Max Width Maximum Width in 1/72 if an inch - 0 = no restriction Maximum width of the element in 1/72 of an inch (point). If zero (0), there is no width restriction. MaxWidth

NUMBER(10)

Integer

Fixed Width Column has a fixed width The Column has a fixed width, independent from the content IsFixedWidth

CHAR(1)

YesNo

Shape Type Type of the shape to be painted ShapeType

CHAR(1)

List

Max Height Maximum Height in 1/72 if an inch - 0 = no restriction Maximum height of the element in 1/72 of an inch (point). If zero (0), there is no height restriction. MaxHeight

NUMBER(10)

Integer

One Line Only If selected, only one line is printed If the column has a width restriction, the text is broken into multiple lines. If One Line is selected, only the first line is printed. IsHeightOneLine

CHAR(1)

YesNo

Fill Shape Fill the shape with the color selected IsFilledRectangle

CHAR(1)

YesNo

Print Color Color used for printing and display Colors used for printing and display AD_PrintColor_ID

NUMBER(10)

TableDir

Print Font Maintain Print Font Font used for printing AD_PrintFont_ID

NUMBER(10)

TableDir

Arc Diameter Arc Diameter for rounded Rectangles Width of the horizontal/vertical diameter of the arc at the four corners ArcDiameter

NUMBER(10)

Integer

Order by Include in sort order The records are ordered by the value of this column. If a column is used for grouping, it needs to be included in the sort order as well. IsOrderBy

CHAR(1)

YesNo

Record Sort No Determines in what order the records are displayed The Record Sort No indicates the ascending sort sequence of the records. If the number is negative, the records are sorted descending.

Example: A tab with C_DocType_ID (1), DocumentNo (-2) will be sorted ascending by document type and descending by document number (SQL: ORDER BY C_DocType, DocumentNo DESC)

SortNo

NUMBER(10)

Integer

Group by After a group change, totals, etc. are printed Grouping allows to print sub-totals. If a group changes, the totals are printed. Group by columns need to be included in the sort order. IsGroupBy

CHAR(1)

YesNo

Page break Start with new page Before printing this item, create a new page IsPageBreak

CHAR(1)

YesNo

Calculate Sum (?) Calculate the Sum of numeric content or length Calculate the Sum (?) of the data if the field is numeric, otherwise total sum length of the field. IsSummarized

CHAR(1)

YesNo

Running Total Create a running total (sum) A running total creates a sum at the end of a page and on the top of the next page for all colums, which have a Sum function. You should define running total only once per format. IsRunningTotal

CHAR(1)

YesNo

Calculate Count (?) Count number of not empty elements Calculate the total number (?) of not empty (NULL) elements (maximum is the number of lines). IsCounted

CHAR(1)

YesNo

Running Total Lines Create Running Total Lines (page break) every x lines When you want to print running totals, enter the number of lines per page after you want to create a running total line and page break. You should define running total only once per format. RunningTotalLines

NUMBER(10)

Integer

Calculate Minimum (?) Calculate the minimum amount Calculate the Minimum (?) of the data if the field is numeric, otherwise minimum length of the field. IsMinCalc

CHAR(1)

YesNo

Calculate Maximim (?) Calculate the maximim amount Calculate the Maximum (?) of the data if the field is numeric, otherwise maximum length of the field. IsMaxCalc

CHAR(1)

YesNo

Calculate Mean (?) Calculate Average of numeric content or length Calculate the Mean (?) of the data if the field is numeric, otherwise calculate the average length of the field. IsAveraged

CHAR(1)

YesNo

Calculate Variance (?¿) Calculate Variance The Variance (?¿) is the a measure of dispersion - used in combination with the Mean (?) IsVarianceCalc

CHAR(1)

YesNo

Calculate Deviation (?) Calculate Standard Deviation The Standard Deviation (?) is the a measure of dispersion - used in combination with the Mean (?) IsDeviationCalc

CHAR(1)

YesNo


Tab: Item Translation

Description : Print Format Translation

Help :

Table Name  : AD_PrintFormatItem_Trl

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Print Format Item Item/Column in the Print format Item/Column in the print format maintaining layout information AD_PrintFormatItem_ID

NUMBER(10)

TableDir

Language Language for this entity The Language identifies the language to use for display and formatting AD_Language

VARCHAR2

Table

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Translated This column is translated The Translated checkbox indicates if this column is translated. IsTranslated

CHAR(1)

YesNo

Print Text The label text to be printed on a document or correspondence. The Label to be printed indicates the name that will be printed on a document or correspondence. The max length is 2000 characters. PrintName

NVARCHAR2(2000)

String

Print Label Suffix The label text to be printed on a document or correspondence after the field The Label to be printed indicates the name that will be printed on a document or correspondence after the field. The max length is 60 characters. PrintNameSuffix

NVARCHAR2(60)

String

Contributions

Personal tools