Table erp.COMPIERE.AD_PRINTFORMAT

Generated by SchemaSpy

Implied relationships Related columns Constraint names Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships Dashed lines show implied relationships < n > number of related tables Please support this project

Column Type Size Nulls Auto Default Children Parents AD_PRINTFORMAT_ID number 10 AD_PRINTFORM INVOICE_PRINTFORMAT_ID ADPRINTFORMAT_FORMINVOICE AD_PRINTFORM ORDER_PRINTFORMAT_ID ADPRINTFORMAT_FORMORDER AD_PRINTFORM PROJECT_PRINTFORMAT_ID ADPRINTFORMAT_FORMPROJECT AD_PRINTFORM REMITTANCE_PRINTFORMAT_ID ADPRINTFORMAT_FORMREMITTANCE AD_PRINTFORM SHIPMENT_PRINTFORMAT_ID ADPRINTFORMAT_FORMSHIPMENT AD_PRINTFORMATITEM AD_PRINTFORMATCHILD_ID ADPRINTFORMAT_PRINTFORMATCHILD AD_PRINTFORMATITEM AD_PRINTFORMAT_ID ADPRINTFORMAT_PRINTFORMATITEM AD_PRINTGRAPH AD_PRINTFORMAT_ID ADPRINTFORMAT_ADPRINTGRAPH AD_PROCESS AD_PRINTFORMAT_ID ADPRINTFORMAT_ADPROCESS C_BANKACCOUNTDOC CHECK_PRINTFORMAT_ID ADPRINTFORMAT_CBANKACCOUNTDOC C_BPARTNER INVOICE_PRINTFORMAT_ID ADPRINTFORMATINV_CBPARTNER C_DOCTYPE AD_PRINTFORMAT_ID ADPRINTFORMAT_CDOCTYPE C_DUNNINGLEVEL DUNNING_PRINTFORMAT_ID ADPRINTFORMAT_CDUNNINGLEVEL C_RFQ_TOPIC AD_PRINTFORMAT_ID ADPRINTFORMAT_ARFQTOPIC PA_REPORT AD_PRINTFORMAT_ID ADPRINTFORMAT_PAREPORT RV_PRINTFORMATDETAIL AD_PRINTFORMAT_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID Implied Constraint AD_ORG_ID number 10 AD_ORGINFO AD_ORG_ID Implied Constraint ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null ISTABLEBASED char 1 'Y' ISFORM char 1 'N' AD_TABLE_ID number 10 AD_TABLE AD_TABLE_ID ADTABLE_ADPRINTFORMAT AD_PRINTPAPER_ID number 10 AD_PRINTPAPER AD_PRINTPAPER_ID ADPRINTPAPER_ADPRINTFORMAT AD_PRINTCOLOR_ID number 10 AD_PRINTCOLOR AD_PRINTCOLOR_ID ADPRINTCOLOR_ADPRINTFORMAT AD_PRINTFONT_ID number 10 AD_PRINTFONT AD_PRINTFONT_ID AD_PRINTFONT_ADPRINTFORMAT ISSTANDARDHEADERFOOTER char 1 'Y' HEADERMARGIN number 10 FOOTERMARGIN number 10 CREATECOPY char 1  √  null AD_REPORTVIEW_ID number 10  √  null AD_REPORTVIEW AD_REPORTVIEW_ID ADPRINTVIEW_ADPRINTFORMAT AD_PRINTTABLEFORMAT_ID number 10  √  null AD_PRINTTABLEFORMAT AD_PRINTTABLEFORMAT_ID ADPRINTFORMATTABLE_FORMAT PRINTERNAME nvarchar2 80  √  null ISDEFAULT char 1 'N' Table contained 39 rows at Wed Mar 15 18:14 SAST 2006

SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.