ManPageW PrintFormat
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)
|
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
- 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 |