View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

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

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.enterprise


Contents

C_DocType

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



top


C_Doctypeaggrinvoice_ID


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')

top


C_Doctypesimpinvoice_ID


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')

top


Client


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@)

top


Comments



top


Created By


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

top


Creation Date



top


Default



top


Description



top


Document Cancelled


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@)

top


Document Category



List values: C_DocType DocBaseType

The allowed values for this list are:

top


Document Sequence


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

top


Document Type



top


Document Type for Invoice


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')

top


Document Type for Order


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

top


Document Type for Shipment


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')

top


Expense



top


Filter by Organization



top


G/L Category


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

top


Name


top


Number of Copies



top


Organization


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

top


Print Text



top


Return



top


Reversal



top


SO Sub Type



List values: C_DocType SubTypeSO

The allowed values for this list are:

top


Sales Transaction



top


Sequenced Document



top


Table


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

top


Updated



top


Updated By


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

top


Other Info

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.common.enterprise

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

This page has been accessed 6,191 times. This page was last modified on 14 March 2023, at 04:11. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.