Table idempiere11.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
c_bankstatement.c_doctype_id cdoctype_cbankstatement 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_invoice.c_doctype_id cdoctype_cinvoice R
c_invoice.c_doctypetarget_id cdoctypetarget_cinvoice 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
Document type or rules
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
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 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 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 Price List

Table contained 52 rows at 2024-01-03 13:46 +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

Close relationships  within of separation: