Table idempiere9.adempiere.ad_printform Form

Generated by Quality Systems & Solutions

Related columns Constraints Comments Legend

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_printform_id numeric 10 Form ad_client_id numeric 10  √  null ad_client.ad_client_id adclient_adprintform R 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 invoice_printformat_id numeric 10  √  null ad_printformat.ad_printformat_id adprintformat_forminvoice R Print Format for printing Invoices order_printformat_id numeric 10  √  null ad_printformat.ad_printformat_id adprintformat_formorder R Print Format for Orders, Quotes, Offers remittance_printformat_id numeric 10  √  null ad_printformat.ad_printformat_id adprintformat_formremittance R Print Format for separate Remittances shipment_printformat_id numeric 10  √  null ad_printformat.ad_printformat_id adprintformat_formshipment R Print Format for Shipments, Receipts, Pick Lists invoice_mailtext_id numeric 10  √  null r_mailtext.r_mailtext_id rmailtext_invoiceadprintform R Email text used for sending invoices order_mailtext_id numeric 10  √  null r_mailtext.r_mailtext_id rmailtext_orderadprintform R Email text used for sending order acknowledgements or quotations remittance_mailtext_id numeric 10  √  null r_mailtext.r_mailtext_id rmailtext_remitadprintform R Email text used for sending payment remittances shipment_mailtext_id numeric 10  √  null r_mailtext.r_mailtext_id rmailtext_shipadprintform R Email text used for sending delivery notes project_mailtext_id numeric 10  √  null r_mailtext.r_mailtext_id rmailtext_projectadprintform R Standard text for Project EMails project_printformat_id numeric 10  √  null ad_printformat.ad_printformat_id adprintformat_formproject R Standard Project Print Format manuf_order_mailtext_id numeric 10  √  null r_mailtext.r_mailtext_id manufordermailtext_adprintform R Email text used for sending Manufacturing Order manuf_order_printformat_id numeric 10  √  null ad_printformat.ad_printformat_id manuforderprintformat_adprintf R Print Format for printing Manufacturing Order distrib_order_mailtext_id numeric 10  √  null r_mailtext.r_mailtext_id distribordermailtext_adprintfo R Email text used for sending Distribution Order distrib_order_printformat_id numeric 10  √  null ad_printformat.ad_printformat_id distriborderprintformat_adprin R Print Format for printing Distribution Order ad_printform_uu varchar 36  √  NULL::character varying AD_PrintForm_UU Table contained 2 rows at 2021-12-25 14:43 +0100

SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.