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
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
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_storagereservationlog.c_doctype_id cdoctype_mstoragereservationlo R
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 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 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:52 +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: