Table erp.COMPIERE.C_DOCTYPE

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 C_DOCTYPE_ID number 10 C_DOCTYPE C_DOCTYPEINVOICE_ID CDOCTYPE_INVOICE C_DOCTYPE C_DOCTYPEPROFORMA_ID CDOCTYPE_PROFORMA C_DOCTYPE C_DOCTYPESHIPMENT_ID CDOCTYPE_SHIPMENT C_DOCTYPECOUNTER COUNTER_C_DOCTYPE_ID CDOCTYPECOUNT_CDOCTYPECOUNT C_DOCTYPECOUNTER C_DOCTYPE_ID CDOCTYPE_CDOCTYPECOUNTER C_DOCTYPE_TRL C_DOCTYPE_ID CDOCTYPE_CDOCTYPETRL C_INVOICE C_DOCTYPETARGET_ID CDOCTYPETARGET_CINVOICE C_INVOICE C_DOCTYPE_ID CDOCTYPE_CINVOICE C_INVOICEBATCHLINE C_DOCTYPE_ID CDOCTYPE_CINVOICEBATCHLINE C_INVOICE_HEADER_V C_DOCTYPE_ID Implied Constraint C_INVOICE_HEADER_VT C_DOCTYPE_ID Implied Constraint C_INVOICE_V C_DOCTYPE_ID Implied Constraint C_ORDER C_DOCTYPETARGET_ID CDOCTYPETARGET_CORDER C_ORDER C_DOCTYPE_ID C_DOCTYPE_CORDER C_ORDER_HEADER_V C_DOCTYPE_ID Implied Constraint C_ORDER_HEADER_VT C_DOCTYPE_ID Implied Constraint C_PAYMENT C_DOCTYPE_ID CDOCTYPE_CPAYMENT C_PAYMENT_V C_DOCTYPE_ID Implied Constraint C_POS C_DOCTYPE_ID Implied Constraint GL_DISTRIBUTION C_DOCTYPE_ID CDOCTYPE_GLDISTRIBUTION GL_JOURNAL C_DOCTYPE_ID CDOCTYPE_GLJOURNAL GL_JOURNALBATCH C_DOCTYPE_ID CDOCTYPE_GLJOURNALBATCH I_GLJOURNAL C_DOCTYPE_ID CDOCTYPE_IGLJOURNAL I_INVOICE C_DOCTYPE_ID CDOCTYPE_IINVOICE I_ORDER C_DOCTYPE_ID CDOCTYPE_IORDER I_PAYMENT C_DOCTYPE_ID CDOCTYPE_IPAYMENT M_INOUT C_DOCTYPE_ID CDOCTYPE_MINOUT M_INOUTCONFIRM_V C_DOCTYPE_ID Implied Constraint M_INOUTCONFIRM_VT C_DOCTYPE_ID Implied Constraint M_INOUT_CANDIDATE_V C_DOCTYPE_ID Implied Constraint M_INOUT_HEADER_V C_DOCTYPE_ID Implied Constraint M_INOUT_HEADER_VT C_DOCTYPE_ID Implied Constraint M_INVENTORY C_DOCTYPE_ID Implied Constraint M_MOVEMENT C_DOCTYPE_ID Implied Constraint M_REQUISITION C_DOCTYPE_ID Implied Constraint M_RMA C_DOCTYPE_ID Implied Constraint T_INVOICEGL C_DOCTYPEREVAL_ID CDOCTYPE_TINVOICEGL T_INVOICEGL_V C_DOCTYPE_ID Implied Constraint T_INVOICEGL_VT C_DOCTYPE_ID Implied Constraint T_REPLENISH C_DOCTYPE_ID CDOCTYPE_TREPLENISH 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 PRINTNAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null DOCBASETYPE char 3 ISSOTRX char 1 'Y' DOCSUBTYPESO char 2  √  null HASPROFORMA char 1  √  'N' C_DOCTYPEPROFORMA_ID number 10  √  null C_DOCTYPE C_DOCTYPE_ID CDOCTYPE_PROFORMA C_DOCTYPESHIPMENT_ID number 10  √  null C_DOCTYPE C_DOCTYPE_ID CDOCTYPE_SHIPMENT C_DOCTYPEINVOICE_ID number 10  √  null C_DOCTYPE C_DOCTYPE_ID CDOCTYPE_INVOICE ISDOCNOCONTROLLED char 1 'N' DOCNOSEQUENCE_ID number 10  √  null AD_SEQUENCE AD_SEQUENCE_ID AD_SEQUENCE_DOCTYPEDOC GL_CATEGORY_ID number 10 GL_CATEGORY GL_CATEGORY_ID GLCATEGORY_CDOCTYPE HASCHARGES char 1 'N' DOCUMENTNOTE nvarchar2 4000  √  null ISDEFAULT char 1 'N' DOCUMENTCOPIES number 10 AD_PRINTFORMAT_ID number 10  √  null AD_PRINTFORMAT AD_PRINTFORMAT_ID ADPRINTFORMAT_CDOCTYPE ISDEFAULTCOUNTERDOC char 1 'N' ISSHIPCONFIRM char 1 'N' ISPICKQACONFIRM char 1 'N' ISINTRANSIT char 1 'N' ISSPLITWHENDIFFERENCE char 1 'N' C_DOCTYPEDIFFERENCE_ID number 10  √  null ISCREATECOUNTER char 1 'Y' Table contained 36 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.