ManPageW Test

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



Window: Test

Description : Test Screen

Help :



Tab: Test

Description :

Help :

Table Name  : Test

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

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

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

Integer T_Integer

NUMBER(10)

Integer

Number T_Number

NUMBER

Number

Currency The Currency for this record Indicates the Currency to be used when processing or reporting on this record C_Currency_ID

NUMBER(10)

TableDir

Amount T_Amount

NUMBER

Amount

UOM Unit of Measure The UOM defines a unique non monetary Unit of Measure C_UOM_ID

NUMBER(10)

TableDir

Qty T_Qty

NUMBER

Quantity

Date T_Date

DATE

Date

DateTime T_DateTime

DATE

DateTime

Address Location or Address The Location / Address field defines the location of an entity. C_Location_ID

NUMBER(10)

Location

Account_Acct Account_Acct

NUMBER(10)

Account

Payment Payment identifier The Payment is a unique identifier of this payment. C_Payment_ID

NUMBER(10)

Search

Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID

NUMBER(10)

Locator

Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID

NUMBER(10)

Search

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

BinaryData Binary Data The Binary field stores binary data. BinaryData

BLOB

Image

Character Data Long Character Field CharacterData

CLOB

TextLong

Processed The document has been processed The Processed checkbox indicates that a document has been processed. Processed

CHAR(1)

YesNo

Process Now Processing

CHAR(1)

Button

Contributions

Personal tools