ManPageW DocumentType

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Document Type

Description : Maintain Document Types

Help : The Document Type Window defines any document to be used in the system. Each document type provides the basis for processing of each document and controls the printed name and document sequence used.



Tab: Document Type

Description : Define a Document Type

Help : The Document Definition Tab defines the processing parameters and controls for the document. Note that shipments for automatic documents like POS/Warehouse Orders cannot have confirmations!

Table Name  : C_DocType

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

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

NVARCHAR2(60)

String

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

NVARCHAR2(2000)

Text

Active The record is active in the system 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 reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

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

CHAR(1)

YesNo

GL Category General Ledger Category The General Ledger Category is an optional, user defined method of grouping journal lines. GL_Category_ID

NUMBER(10)

TableDir

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

CHAR(1)

YesNo

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

CHAR(3)

List

SO Sub Type Sales Order 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

DocSubTypeSO

CHAR(2)

List

Pro forma Invoice Indicates if Pro Forma Invoices can be generated from this document The Pro Forma Invoice checkbox indicates if pro forma invoices can be generated from this sales document. A pro forma invoice indicates the amount that will be due should an order be shipped. HasProforma

CHAR(1)

YesNo

Document Type for ProForma Document type used for pro forma invoices generated from this sales document he 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 and the Pro Forma Invoice checkbox is selected C_DocTypeProforma_ID

NUMBER(10)

Table

Document Type for Invoice Document type used for invoices generated from this sales document 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_DocTypeInvoice_ID

NUMBER(10)

Table

Document Type for Shipment Document type used for shipments generated from this sales document he 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. C_DocTypeShipment_ID

NUMBER(10)

Table

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

CHAR(1)

YesNo

Document Sequence Document sequence determines the numbering of documents The Document Sequence indicates the sequencing rule to use for this document type. DocNoSequence_ID

NUMBER(10)

Table

Overwrite Sequence on Complete IsOverwriteSeqOnComplete

CHAR(1)

YesNo

Definite Sequence DefiniteSequence_ID

NUMBER(10)

Table

Overwrite Date on Complete IsOverwriteDateOnComplete

CHAR(1)

YesNo

Pick/QA Confirmation Require Pick or QA Confirmation before processing The processing of the Shipment (Receipt) requires Pick (QA) Confirmation. Note that shipments for automatic documents like POS/Warehouse Orders cannot have confirmations! IsPickQAConfirm

CHAR(1)

YesNo

Ship/Receipt Confirmation Require Ship or Receipt Confirmation before processing The processing of the Shipment (Receipt) requires Ship (Receipt) Confirmation. Note that shipments for automatic documents like POS/Warehouse Orders cannot have confirmations! IsShipConfirm

CHAR(1)

YesNo

Split when Difference Split document when there is a difference If the confirmation contains differences, the original document is split allowing the original document (shipment) to be processed and updating Inventory - and the newly created document for handling the dispute at a later time. Until the confirmation is processed, the inventory is not updated. IsSplitWhenDifference

CHAR(1)

YesNo

Difference Document Document type for generating in dispute Shipments If the confirmation contains differences, the original document is split allowing the original document (shipment) to be processed and updating Inventory - and the newly created document for handling the dispute at a later time. Until the confirmation is processed, the inventory is not updated. C_DocTypeDifference_ID

NUMBER(10)

Table

In Transit Movement is in transit Material Movement is in transit - shipped, but not received.

The transaction is completed, if confirmed.

IsInTransit

CHAR(1)

YesNo

Create Counter Document Create Counter Document If selected, create specified counter document. If not selected, no counter document is created for the document type. IsCreateCounter

CHAR(1)

YesNo

Default Counter Document The document type is the default counter document type When using explicit documents for inter-org transaction (after linking a Business Partner to an Organization), you can determine what document type the counter document is based on the document type of the original transaction. Example: when generating a Sales Order, use this Sales Order document type.

This default can be overwritten by defining explicit counter document relationships.

IsDefaultCounterDoc

CHAR(1)

YesNo

Print Format Data Print Format The print format determines how data is rendered for print. AD_PrintFormat_ID

NUMBER(10)

TableDir

Document Copies Number of copies to be printed The Document Copies indicates the number of copies of each document that will be generated. DocumentCopies

NUMBER(10)

Integer


Tab: Translation

Description : Translation

Help : The Translation Tab defines a Document Type in an alternate language.

Table Name  : C_DocType_Trl

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Document Type Document type or rules The Document Type determines document sequence and processing rules C_DocType_ID

NUMBER(10)

TableDir

Language Language for this entity The Language identifies the language to use for display and formatting AD_Language

VARCHAR2

Table

Active The record is active in the system 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 reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Translated This column is translated The Translated checkbox indicates if this column is translated. IsTranslated

CHAR(1)

YesNo

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

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

NVARCHAR2(60)

String

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

NVARCHAR2(2000)

Text

Contributions

Personal tools