Table idempiere9.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
ad_printform.distrib_order_printformat_id distriborderprintformat_adprin R
ad_printform.invoice_printformat_id adprintformat_forminvoice R
ad_printform.manuf_order_printformat_id manuforderprintformat_adprintf R
ad_printform.order_printformat_id adprintformat_formorder R
ad_printform.project_printformat_id adprintformat_formproject R
ad_printform.remittance_printformat_id adprintformat_formremittance R
ad_printform.shipment_printformat_id adprintformat_formshipment R
ad_printformatitem.ad_printformat_id adprintformat_printformatitem C
ad_printformatitem.ad_printformatchild_id adprintformat_printformatchild N
ad_printgraph.ad_printformat_id adprintformat_adprintgraph R
ad_process.ad_printformat_id adprintformat_adprocess R
c_bankaccountdoc.check_printformat_id adprintformat_cbankaccountdoc R
c_bpartner.invoice_printformat_id adprintformatinv_cbpartner R
c_doctype.ad_printformat_id adprintformat_cdoctype R
c_dunninglevel.dunning_printformat_id adprintformat_cdunninglevel R
Data 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
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
ad_table.ad_table_id adtable_adprintformat R
Database Table information
ad_printpaper_id numeric 10
ad_printpaper.ad_printpaper_id adprintpaper_adprintformat R
Printer paper definition
ad_printcolor_id numeric 10
ad_printcolor.ad_printcolor_id adprintcolor_adprintformat R
Color used for printing and display
ad_printfont_id numeric 10
ad_printfont.ad_printfont_id ad_printfont_adprintformat R
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
ad_reportview.ad_reportview_id adprintview_adprintformat R
View used to generate this report
ad_printtableformat_id numeric 10  √  null
ad_printtableformat.ad_printtableformat_id adprintformattable_format R
Table Format in Reports
printername varchar 40  √  null Name of the Printer
isdefault bpchar 1 'N'::bpchar Default value
jasperprocess_id numeric 10  √  null
ad_process.ad_process_id jasperprocess_adprintformat R
The Jasper Process used by the printengine 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
ad_printheaderfooter.ad_printheaderfooter_id adprintheaderfooter_adprintfor R
Print Header/Footer

Table contained 89 rows at 2021-12-25 14:53 +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: