Key Concepts

This Wiki is read-only for reference purposes to avoid broken links.

⇐ Table of Contents{{#if: | | [[{{{2}}}]] }}{{#if: | | [[{{{3}}}]] }}{{#if: | | [[{{{4}}}]] }}{{#if: | | [[{{{5}}}]] }} | Key Concepts{{#if: | | [[{{{next}}}]] }} ⇒

This section is a summary of key concepts you will need to understand as you read the rest of this manual.

Database Tables and Common Fields

In ADempiere, most database tables contain a set of common fields that are used by most windows or by the underlying rules and software. These are:

• AD_Ord_ID
• AD_Client_ID
• Created
• CreatedBy
• IsActive
• Name
• Description
• Comment/Help
• Updated
• UpdatedBy
• Value/Search Key

There is one other field of the form <table name>_ID that contains the ID key of the records in the table.