View source | Discuss this page | Page history | Printable version   

ERP/2.50/Developers Guide/Database Model/org.openbravo.model.common.enterprise/C DocType

Contents

C_DocType

The Document Definition Tab defines the processing parameters and controls for the document.

This table contains the following columns:

Name Nullable Data Type Description
C_DocType_ID NVARCHAR2(32)A value defining what sequence and process setup are used to handle this document.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
Name NNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
PrintName NNVARCHAR2(60)The displayed text of an element.
Description YNVARCHAR2(255)A space to write additional related information.
DocBaseType NVARCHAR2(60)A classification of document types that are shown and processed in the same window.
IsSOTrx NCHAR(1)An indication that a transfer of goods and money between business partners is occurring.
DocSubTypeSO YVARCHAR2(60)Sales Order Sub Type
C_DocTypeShipment_ID YVARCHAR2(32)Document type used for shipments generated from this sales document
C_DocTypeInvoice_ID YVARCHAR2(32)Document type used for invoices generated from this sales document
IsDocNoControlled NCHAR(1)The document has a document sequence
DocNoSequence_ID YVARCHAR2(32)Document sequence determines the numbering of documents
GL_Category_ID NVARCHAR2(32)A classification used to group lines in the general ledger.
DocumentNote YNVARCHAR2(2000)A space to write additional related information.
IsDefault NCHAR(1)A value that is shown whenever a record is created.
DocumentCopies NNUMBER(10, 0)The number of copies of each document that will be printed.
AD_Table_ID YVARCHAR2(32)A dictionary table used for this tab that points to the database table.
Orgfiltered NCHAR(1)Filters by organization. This is used to calculate the document number by document type.
C_Doctype_Reversed_ID YVARCHAR2(32)null
IsExpense NCHAR(1)A flag indicating whether this document type is for expenses or not.
Isreversal NCHAR(1)This is a reversing transaction

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

Document Type

The Document Type determines document sequence and processing rules

top

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)


Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Active

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Name

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.

top

Print Text

The Label to be printed indicates the name that will be printed on a document or correspondence. The max length is 2000 characters.

top

Description

A description is limited to 255 characters.

top

Document Category

The Document Base Type identifies the base or starting point for a document. Multiple document types may share a single document base type.

List values: C_DocType DocBaseType

The allowed values for this list are:

top

Sales Transaction

The Sales Transaction checkbox indicates if this item is a Sales Transaction.

top

SO Sub Type

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

List values: C_DocType SubTypeSO

The allowed values for this list are:

top

Document Type for Shipment

Foreign key column to C_DocType table, (column: C_DocType_ID)


Reference Table C_DocType With the following where clause:

 
C_DocType.AD_Client_ID=@#AD_Client_ID@


Validation Rule C_DocType Material Shipments/Receipts: Document Type Material Shipments and 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'

top

Document Type for Invoice

Foreign key column to C_DocType table, (column: C_DocType_ID)


Reference Table C_DocType With the following where clause:

 
C_DocType.AD_Client_ID=@#AD_Client_ID@


Validation Rule C_DocType AR/AP Invoices and Credit Memos: Document Type AR/AP Invoice and Credit Memos. With the following code:

 
C_DocType.DocBaseType IN ('ARI', 'API','ARC','APC') 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')

top

Sequenced Document

The Document Number Controlled checkbox indicates if this document type will have a sequence number.

top

Document Sequence

Foreign key column to AD_Sequence table, (column: AD_Sequence_ID)


Reference Table AD_Sequence for Documents With the following where clause:

 
AD_Sequence.IsTableID='N'


top

G/L Category

Foreign key column to GL_Category table, (column: GL_Category_ID)

top

Comments

The Document Note is used for recording any additional information regarding this product.

top

Default

The Default Checkbox indicates if this record will be used as a default value.

top

Number of Copies

The Document Copies indicates the number of copies of each document that will be generated.

top

Table

Foreign key column to AD_Table table, (column: AD_Table_ID)

top

Filter by Organization

Filters by organization. This is used to calculate the document number by document type.

top

Document Cancelled

Foreign key column to C_DocType table, (column: C_DocType_ID)


Reference Table C_DocType With the following where clause:

 
C_DocType.AD_Client_ID=@#AD_Client_ID@


Validation Rule DocType Not A Credit Memo: DocType that is not a Credit Memo. With the following code:

 
C_DocType.DocBaseType NOT IN ('APC','ARC')

top

Expense

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.

top

Reversal

The Reversal check box indicates if this is a reversal of a prior transaction.

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.common.enterprise/C_DocType"

This page has been accessed 8,114 times. This page was last modified on 2 July 2011, at 20:44. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.