ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.enterprise/C DocType
C_DocType
- Name:C_DocType
- Classname:DocumentType
This table contains the following columns:
Name | Nullable | Data Type | Description
|
IsActive | No | CHAR (1) | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions. |
C_Doctypeaggrinvoice_ID | Yes | VARCHAR (32) | The Document Type for Aggregated Invoice indicates the document type that will be used when an aggregated invoice is generated from this sales document.This field will display only when the base document type is Sales Order. |
C_Doctypesimpinvoice_ID | Yes | VARCHAR (32) | The Document Type for Simplified Invoice indicates the document type that will be used when a simplified invoice is generated from this sales document.
This field will display only when the base document type is Sales Order. |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
DocumentNote | Yes | NVARCHAR (2000) | The Document Note is used for recording any additional information regarding this product. |
CreatedBy | No | VARCHAR (32) | The Created By field indicates the user who created this record. |
Created | No | TIMESTAMP (7) | The Created field indicates the date that this record was created. |
IsDefault | No | CHAR (1) | The Default Checkbox indicates if this record will be used as a default value. |
Description | Yes | NVARCHAR (255) | A description is limited to 255 characters. |
C_Doctype_Reversed_ID | Yes | VARCHAR (32) | |
DocBaseType | No | VARCHAR (60) | The Document Base Type identifies the base or starting point for a document. Multiple document types may share a single document base type. |
DocNoSequence_ID | Yes | VARCHAR (32) | The Document Sequence indicates the sequencing rule to use for this document type. |
C_DocType_ID | No | VARCHAR (32) | The Document Type determines document sequence and processing rules |
C_DocTypeInvoice_ID | Yes | VARCHAR (32) | The Document Type for Invoice indicates the document type that will be used when an invoice is generated from this sales document. This field will display only when the base document type is Sales Order. |
C_Doctypeorder_ID | Yes | VARCHAR (32) | |
C_DocTypeShipment_ID | Yes | VARCHAR (32) | The Document Type for Shipments indicates the document type that will be used when a shipment is generated from this sales document. This field will display only when the base document type is Sales Order. |
IsExpense | No | CHAR (1) | Invoices in the Create AP Invoices process will be created preferably with a document type with this flag activated. This way invoices related to expenses will not appear in the Invoice Register Book. |
Orgfiltered | No | CHAR (1) | Filters by organization. This is used to calculate the document number by document type. |
GL_Category_ID | No | VARCHAR (32) | The General Ledger Category is an optional, user defined method of grouping journal lines. |
Name | No | NVARCHAR (60) | A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length. |
DocumentCopies | No | DECIMAL (10,0) | The Document Copies indicates the number of copies of each document that will be generated. |
AD_Org_ID | No | VARCHAR (32) | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
PrintName | No | NVARCHAR (60) | The Label to be printed indicates the name that will be printed on a document or correspondence. The max length is 2000 characters. |
IsReturn | No | CHAR (1) | Return checkbox indicates if the document is of reversal type. Documents with this flag enables implies to use negative quantities. |
Isreversal | No | CHAR (1) | Credit Memo checkbox only applies to Invoice document types.
Invoices marked as Credit Memo will behave as Credit Memos, which implies that: - "Total gross amount" must always be positive. - "Payment Plan" will be negative. - Accounting will be opposite than Invoice accounting. |
DocSubTypeSO | Yes | VARCHAR (60) | The SO Sub Type indicates the type of sales order this document refers to. This field only appears when the Document Base Type is Sales Order. The selection made here will determine which documents will be generated when an order is processed and which documents must be generated manually or in batches. The following outlines this process. SO Sub Type of Standard Order will generate just the Order document when the order is processed. The Delivery Note, Invoice and Receipt must be generated via other processes. SO Sub Type of Warehouse Order will generate the Order and Delivery Note. The Invoice and Receipt must be generated via other processes. SO Sub Type of Credit Order will generate the Order, Delivery Note and Invoice. The Reciept must be generated via other processes. SO Sub Type of POS (Point of Sale) will generate all document |
IsSOTrx | No | CHAR (1) | The Sales Transaction checkbox indicates if this item is a Sales Transaction. |
IsDocNoControlled | No | CHAR (1) | The Document Number Controlled checkbox indicates if this document type will have a sequence number. |
AD_Table_ID | Yes | VARCHAR (32) | The Table indicates the table in which a field or fields reside. |
Updated | No | TIMESTAMP (7) | The Updated field indicates the date that this record was updated. |
UpdatedBy | No | VARCHAR (32) | The Updated By field indicates the user who updated this record. |
Columns
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
C_Doctypeaggrinvoice_ID
- Physical column name: C_Doctypeaggrinvoice_ID
- Property Name: doctypeaggrinvoice
- Reference: Table
Foreign key column to C_DocType table, (column: C_DocType_ID)
It has a validation "Document Type for Invoice", with the following code
C_DocType.DocBaseType IN ('ARI', 'API', 'ARI_RM') AND C_DocType.IsSOTrx='@IsSOTrx@' AND (AD_ISORGINCLUDED(@AD_Org_ID@,C_DocType.AD_Org_ID, @#AD_Client_ID@) <> '-1' OR COALESCE(@AD_Org_ID@,'-1')='-1')
C_Doctypesimpinvoice_ID
- Physical column name: C_Doctypesimpinvoice_ID
- Property Name: doctypesimpinvoice
- Reference: Table
Foreign key column to C_DocType table, (column: C_DocType_ID)
It has a validation "Document Type for Invoice", with the following code
C_DocType.DocBaseType IN ('ARI', 'API', 'ARI_RM') AND C_DocType.IsSOTrx='@IsSOTrx@' AND (AD_ISORGINCLUDED(@AD_Org_ID@,C_DocType.AD_Org_ID, @#AD_Client_ID@) <> '-1' OR COALESCE(@AD_Org_ID@,'-1')='-1')
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
It has a validation "AD_Client Security validation", with the following code
AD_Client.AD_Client_ID in (@#User_Client@)
Comments
- Physical column name: DocumentNote
- Property Name: comments
- Reference: Text
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Default
- Physical column name: IsDefault
- Property Name: default
- Reference: YesNo
- Default value: N
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Document Cancelled
- Physical column name: C_Doctype_Reversed_ID
- Property Name: documentCancelled
- Reference: Table
Foreign key column to C_DocType table, (column: C_DocType_ID)
It has a validation "DocType For Document Cancelled", with the following code
C_DocType.isreversal || C_DocType.docbasetype = (select isreversal || docbasetype from c_doctype where c_doctype_id = @C_DocType_ID@)
Document Category
- Physical column name: DocBaseType
- Property Name: documentCategory
- Reference: List
List values: C_DocType DocBaseType
The allowed values for this list are:
- GLJ (GL Journal)
- GLD (GL Document)
- API (AP Invoice)
- APP (AP Payment)
- ARI (AR Invoice)
- ARR (AR Receipt)
- SOO (Sales Order)
- ARF (AR Pro Forma Invoice)
- MMS (Material Delivery)
- MMR (Material Receipt)
- MMM (Material Movement)
- POO (Purchase Order)
- POR (Purchase Requisition)
- MMI (Material Physical Inventory)
- APC (AP Credit Memo)
- ARC (AR Credit Memo)
- CMB (Bank Statement)
- CMC (Cash Journal)
- CMA (Payment Allocation)
- MMP (Material Production)
- MXI (Match Invoice)
- MXP (Match PO)
- PJI (Project Issue)
- STT (Settlement): Settlement of debt-payments
- STM (Settlement manual)
- AMZ (Amortization)
- DPM (Debt Payment Management)
- BSF (Bank Statement File)
- PPR (Payment proposal)
- MIC (Material Internal Consumption)
- CAD (Cost Adjustment)
- LDC (Landed Cost)
- FAT (Financial Account Transaction)
- ARRP (AR Receivable Proposal)
- REC (Reconciliation): Reconciliation
- ARI_RM (AR Return Material Invoice)
- DDB (Doubtful Debt): Doubtful Debt
- --- (** New **)
- LCC (Landed Cost Cost)
- APPP (AP Payment Proposal)
- IAU (Inventory Amount Update)
- WRE (Work Requirement): Work Requirement
Document Sequence
- Physical column name: DocNoSequence_ID
- Property Name: documentSequence
- Reference: Table
Foreign key column to AD_Sequence table, (column: AD_Sequence_ID)
Document Type
- Physical column name: C_DocType_ID
- Property Name: id
- Reference: ID
Document Type for Invoice
- Physical column name: C_DocTypeInvoice_ID
- Property Name: documentTypeForInvoice
- Reference: Table
Foreign key column to C_DocType table, (column: C_DocType_ID)
It has a validation "Document Type for Invoice", with the following code
C_DocType.DocBaseType IN ('ARI', 'API', 'ARI_RM') AND C_DocType.IsSOTrx='@IsSOTrx@' AND (AD_ISORGINCLUDED(@AD_Org_ID@,C_DocType.AD_Org_ID, @#AD_Client_ID@) <> '-1' OR COALESCE(@AD_Org_ID@,'-1')='-1')
Document Type for Order
- Physical column name: C_Doctypeorder_ID
- Property Name: documentTypeForOrder
- Reference: Table
Foreign key column to C_DocType table, (column: C_DocType_ID)
Document Type for Shipment
- Physical column name: C_DocTypeShipment_ID
- Property Name: documentTypeForShipment
- Reference: Table
Foreign key column to C_DocType table, (column: C_DocType_ID)
It has a validation "C_DocType Material Shipments/Receipts", with the following code
C_DocType.DocBaseType IN ('MMR', 'MMS') AND C_DocType.IsSOTrx='@IsSOTrx@' AND AD_ISORGINCLUDED(@AD_Org_ID@,C_DocType.AD_Org_ID, @#AD_Client_ID@) <> '-1'
AND (COALESCE(@isReturnMaterial@, 'N') = C_DocType.IsReturn OR COALESCE(@isDocumentTypeWindow@, 'N') = 'Y')
Expense
- Physical column name: IsExpense
- Property Name: expense
- Reference: YesNo
- Default value: N
Filter by Organization
- Physical column name: Orgfiltered
- Property Name: filterByOrganization
- Reference: YesNo
- Default value: N
G/L Category
- Physical column name: GL_Category_ID
- Property Name: gLCategory
- Reference: TableDir
Foreign key column to GL_Category table, (column: GL_Category_ID)
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Number of Copies
- Physical column name: DocumentCopies
- Property Name: numberOfCopies
- Reference: Integer
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Print Text
- Physical column name: PrintName
- Property Name: printText
- Reference: String
Return
- Physical column name: IsReturn
- Property Name: return
- Reference: YesNo
- Default value: N
Reversal
- Physical column name: Isreversal
- Property Name: reversal
- Reference: YesNo
- Default value: N
SO Sub Type
- Physical column name: DocSubTypeSO
- Property Name: sOSubType
- Reference: List
List values: C_DocType SubTypeSO
The allowed values for this list are:
- RM (Return Material **): ** not fully implemented **
- PR (Prepay Order)
- WI (On Credit Order)
- WR (POS Order)
- WP (Warehouse Order)
- SO (Standard Order)
- ON (Proposal)
- OB (Quotation)
Sales Transaction
- Physical column name: IsSOTrx
- Property Name: salesTransaction
- Reference: YesNo
- Default value: Y
Sequenced Document
- Physical column name: IsDocNoControlled
- Property Name: sequencedDocument
- Reference: YesNo
- Default value: Y
Table
- Physical column name: AD_Table_ID
- Property Name: table
- Reference: TableDir
Foreign key column to AD_Table table, (column: AD_Table_ID)
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Other Info
Check Constraints
These are the check constraints for this table:
- C_DOCTYPE_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- C_DOCTYPE_ISDOCNOCONTROLLE_CHK: ISDOCNOCONTROLLED IN ('Y', 'N')
- C_DOCTYPE_ISRETURN_CHK: ISRETURN IN ('Y', 'N')
- C_DOCTYPE_ISREVERSAL_CHECK: ISREVERSAL IN ('Y', 'N')
- C_DOCTYPE_ISSOTRX_CHECK: ISSOTRX IN ('Y', 'N')
- C_DOCTYPE_ORGFILTERED_CHECK: ORGFILTERED IN ('Y', 'N')