Table idempiere11.adempiere.ad_printformat
Data 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_printformat_id numeric 10
c_bpartner.invoice_printformat_id adprintformatinv_cbpartner R
c_dunninglevel.dunning_printformat_id adprintformat_cdunninglevel R
Data Print Format
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
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
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
istablebased bpchar 1 'Y'::bpchar Table based List Reporting
isform bpchar 1 'N'::bpchar If Selected, a Form is printed, if not selected a columnar List report
ad_table_id numeric 10 Database Table information
ad_printpaper_id numeric 10 Printer paper definition
ad_printcolor_id numeric 10 Color used for printing and display
ad_printfont_id numeric 10 Maintain Print Font
isstandardheaderfooter bpchar 1 'Y'::bpchar The standard Header and Footer is used
headermargin numeric 10 Margin of the Header in 1/72 of an inch
footermargin numeric 10 Margin of the Footer in 1/72 of an inch
createcopy bpchar 1  √  null Create Copy
ad_reportview_id numeric 10  √  null View used to generate this report
ad_printtableformat_id numeric 10  √  null Table Format in Reports
printername varchar 40  √  null Name of the Printer
isdefault bpchar 1 'N'::bpchar Default value
jasperprocess_id numeric 10  √  null The Jasper Process used by the print engine if any process defined
classname varchar 240  √  null Java Classname
args varchar 510  √  null Args
ad_printformat_uu varchar 36  √  NULL::character varying AD_PrintFormat_UU
ad_window_id numeric 10  √  NULL::numeric Data entry or display window
isbreakpageperrecord bpchar 1 'Y'::bpchar Page Break after each record
ad_printheaderfooter_id numeric 10  √  NULL::numeric Print Header/Footer
filenamepattern varchar 255  √  null File Name Pattern

Table contained 92 rows at 2024-01-03 13:48 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_printformat_id Primary key Asc ad_printformat_pkey
ad_client_id + ad_table_id + name Must be unique Asc/Asc/Asc ad_printformat_name
ad_table_id Performance Asc ad_printformat_table
ad_printformat_uu Must be unique Asc ad_printformat_uu_idx

Close relationships  within of separation: