Table idempiere9.adempiere.c_doctype
Document type or rules

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
c_doctype_id numeric 10
a_asset_addition.c_doctype_id cdoctype_aassetaddition R
a_asset_disposed.c_doctype_id cdoctype_aassetdisposed R
a_asset_reval_entry.c_doctype_id cdoctype_aassetrevalentry R
a_depreciation_entry.c_doctype_id cdoctype_adepreciationentry R
ad_document_action_access.c_doctype_id cdoctype_addocumentactionacces R
ad_replicationdocument.c_doctype_id cdoctype_adreplicationdocument R
c_allocationhdr.c_doctype_id cdoctype_callocationhdr R
c_chargetype_doctype.c_doctype_id cdoctype_cchargetypedoctype R
c_depositbatch.c_doctype_id cdoctype_cdepositbatch R
c_doctype.c_doctypedifference_id cdoctypedifference_cdoctype R
c_doctype.c_doctypeinvoice_id cdoctype_invoice R
c_doctype.c_doctypeproforma_id cdoctype_proforma R
c_doctype.c_doctypeshipment_id cdoctype_shipment R
c_doctype_trl.c_doctype_id cdoctype_cdoctypetrl C
c_doctypecounter.c_doctype_id cdoctype_cdoctypecounter R
c_doctypecounter.counter_c_doctype_id cdoctypecount_cdoctypecount R
c_invoice.c_doctype_id cdoctype_cinvoice R
c_invoice.c_doctypetarget_id cdoctypetarget_cinvoice R
c_invoicebatchline.c_doctype_id cdoctype_cinvoicebatchline R
c_order.c_doctype_id c_doctype_corder R
c_order.c_doctypetarget_id cdoctypetarget_corder R
c_payment.c_doctype_id cdoctype_cpayment R
c_pos.c_doctype_id cdoctype_cpos R
dd_order.c_doctype_id cdoctype_ddorder R
gl_distribution.c_doctype_id cdoctype_gldistribution R
gl_journal.c_doctype_id cdoctype_gljournal R
gl_journalbatch.c_doctype_id cdoctype_gljournalbatch R
gl_journalgenerator.c_doctype_id cdoctype_qssjournalgenerator R
hr_process.c_doctype_id cdoctype_hrprocess R
hr_process.c_doctypetarget_id cdoctypetarget_hrprocess R
i_fajournal.c_doctype_id cdoctype_ifajournal R
i_gljournal.c_doctype_id cdoctype_igljournal N
i_inventory.c_doctype_id cdoctype_iinventory R
i_invoice.c_doctype_id cdoctype_iinvoice N
i_movement.c_doctype_id cdoctype_imovement R
i_order.c_doctype_id cdoctype_iorder N
i_payment.c_doctype_id cdoctype_ipayment N
k_index.c_doctype_id cdoctype_kindex C
k_indexstop.c_doctype_id cdoctype_kindexstop R
m_inout.c_doctype_id cdoctype_minout R
m_inventory.c_doctype_id cdoctype_minventory R
m_movement.c_doctype_id cdoctype_mmovement R
m_requisition.c_doctype_id cdoctype_mrequisition R
m_rma.c_doctype_id cdoctype_mrma R
m_storagereservationlog.c_doctype_id cdoctype_mstoragereservationlo R
pp_cost_collector.c_doctype_id cdoctype_ppcostcollector R
pp_cost_collector.c_doctypetarget_id cdoctypetarget_ppcostcollector R
pp_order.c_doctype_id cdoctype_pporder R
pp_order.c_doctypetarget_id cdoctypetarget_pporder R
t_invoicegl.c_doctypereval_id cdoctype_tinvoicegl C
t_replenish.c_doctype_id cdoctype_treplenish C
Document type or rules
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
printname varchar 60 The label text to be printed on a document or correspondence.
description varchar 255  √  null Optional short description of the record
docbasetype bpchar 3 Logical type of document
issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
docsubtypeso bpchar 2  √  null Sales Order Sub Type
hasproforma bpchar 1  √  'N'::bpchar Indicates if Pro Forma Invoices can be generated from this document
c_doctypeproforma_id numeric 10  √  null
c_doctype.c_doctype_id cdoctype_proforma R
Document type used for pro forma invoices generated from this sales document
c_doctypeshipment_id numeric 10  √  null
c_doctype.c_doctype_id cdoctype_shipment R
Document type used for shipments generated from this sales document
c_doctypeinvoice_id numeric 10  √  null
c_doctype.c_doctype_id cdoctype_invoice R
Document type used for invoices generated from this sales document
isdocnocontrolled bpchar 1 'N'::bpchar The document has a document sequence
docnosequence_id numeric 10  √  null
ad_sequence.ad_sequence_id ad_sequence_doctypedoc R
Document sequence determines the numbering of documents
gl_category_id numeric 10
gl_category.gl_category_id glcategory_cdoctype R
General Ledger Category
hascharges bpchar 1 'N'::bpchar Charges can be added to the document
documentnote varchar 2000  √  null Additional information for a Document
isdefault bpchar 1 'N'::bpchar Default value
documentcopies numeric 10 Number of copies to be printed
ad_printformat_id numeric 10  √  null
ad_printformat.ad_printformat_id adprintformat_cdoctype R
Data Print Format
isdefaultcounterdoc bpchar 1 'N'::bpchar The document type is the default counter document type
isshipconfirm bpchar 1 'N'::bpchar Require Ship or Receipt Confirmation before processing
ispickqaconfirm bpchar 1 'N'::bpchar Require Pick or QA Confirmation before processing
isintransit bpchar 1 'N'::bpchar Movement is in transit
issplitwhendifference bpchar 1 'N'::bpchar Split document when there is a difference
c_doctypedifference_id numeric 10  √  null
c_doctype.c_doctype_id cdoctypedifference_cdoctype R
Document type for generating in dispute Shipments
iscreatecounter bpchar 1 'Y'::bpchar Create Counter Document
isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
isoverwriteseqoncomplete bpchar 1  √  'N'::bpchar Overwrite Sequence on Complete
definitesequence_id numeric 10  √  null
ad_sequence.ad_sequence_id definitesequence_cdoctype R
Definite Sequence
isoverwritedateoncomplete bpchar 1  √  'N'::bpchar Overwrite Date on Complete
ispreparesplitdocument bpchar 1 'Y'::bpchar Prepare generated split shipment/receipt document
c_doctype_uu varchar 36  √  NULL::character varying C_DocType_UU
ischargeorproductmandatory bpchar 1  √  'N'::bpchar Mandatory Charge or Product
docsubtypeinv varchar 2  √  NULL::character varying Inventory Sub Type
isnopricelistcheck bpchar 1  √  'N'::bpchar Allow Product Without Pricelist

Table contained 52 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_doctype_id Primary key Asc c_doctype_pkey
ad_client_id + name Must be unique Asc/Asc c_doctype_name
c_doctype_uu Must be unique Asc c_doctype_uu_idx


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.