Browse by Database Table
This index maps the most important ADempiere database tables to the engineering documentation where they are explained.
Use this page whenever a development task starts from a database table.
The objective is to quickly identify:
- The responsibility of the table.
- Which engineering objects are related.
- Which business modules depend on it.
- Where the implementation is documented.
- Whether the knowledge has already been certified.
Engineering Workflow
- Identify the database table involved.
- Review the related engineering objects.
- Open the referenced documentation.
- Follow the appropriate Playbook.
- Implement the change.
- Validate the deployment.
Master Data
| Database Table |
Area |
Purpose |
Related Objects |
Used By |
Documentation |
Status |
C_BPartner |
Master Data |
Business Partner master information. |
MBPartner • MBPartnerLocation |
Sales • Purchasing • Projects • API • BlackNet |
Business Partners API (KB-301 planned) |
✅ Certified |
M_Product |
Master Data |
Product master information. |
MProduct |
Sales • Purchasing • Inventory • CFDI |
CFDI Architecture (KB-302 planned) |
✅ Certified |
M_PriceList |
Pricing |
Price List definition. |
MPriceList |
Sales • Purchasing |
Functional Documentation (planned) |
📋 Planned |
M_PriceList_Version |
Pricing |
Versioned product pricing. |
MPriceListVersion |
Sales • Purchasing |
Functional Documentation (planned) |
📋 Planned |
C_Tax |
Accounting |
Tax configuration. |
MTax |
Sales • Purchasing • CFDI |
📖 Account Resolution Engine |
✅ Certified |
Sales
| Database Table |
Area |
Purpose |
Related Objects |
Used By |
Documentation |
Status |
C_Order |
Sales |
Sales and Purchase Orders. |
MOrder • Doc_Order |
Sales Cycle |
📖 Document Posting Patterns |
📋 Planned |
C_OrderLine |
Sales |
Order detail lines. |
MOrderLine |
Sales Cycle |
📖 Document Posting Patterns |
📋 Planned |
C_Invoice |
Sales |
Customer and Vendor invoices. |
MInvoice • Doc_Invoice • Fact_Acct |
Posting • CFDI • Payments |
📖 Document Posting Patterns • CFDI Architecture (KB-302 planned) |
✅ Certified |
C_InvoiceLine |
Sales |
Invoice detail lines. |
MInvoiceLine • FactLine |
Posting |
📖 Fact & FactLine |
✅ Certified |
Inventory
| Database Table |
Area |
Purpose |
Related Objects |
Used By |
Documentation |
Status |
M_InOut |
Inventory |
Material Receipts and Shipments. |
MInOut • Doc_InOut |
Inventory • Purchasing • Sales |
📖 Runtime Architecture |
📋 Planned |
M_InOutLine |
Inventory |
Shipment and Receipt lines. |
MInOutLine |
Inventory |
📖 Runtime Architecture |
📋 Planned |
Accounting
| Database Table |
Area |
Purpose |
Related Objects |
Used By |
Documentation |
Status |
Fact_Acct |
Accounting Engine |
Stores all accounting entries. |
Fact • FactLine |
Posting Engine |
📖 Fact & FactLine |
✅ Certified |
C_AcctSchema |
Accounting Engine |
Accounting Schema configuration. |
MAcctSchema |
Posting Engine |
📖 MAcctSchema |
✅ Certified |
C_ValidCombination |
Accounting Engine |
Valid accounting combinations. |
MAccount |
Posting Engine |
📖 Accounting Dimensions |
✅ Certified |
C_ElementValue |
Accounting Engine |
Chart of Accounts. |
MElementValue |
Posting Engine |
📖 Accounting Metadata Layer |
✅ Certified |
Projects
| Database Table |
Area |
Purpose |
Related Objects |
Used By |
Documentation |
Status |
C_Project |
Projects |
Project master information. |
MProject |
Projects API • BlackNet |
Projects API (KB-301 planned) |
✅ Certified |
C_ProjectPhase |
Projects |
Project phases. |
MProjectPhase |
Projects |
Functional Documentation (planned) |
📋 Planned |
C_ProjectTask |
Projects |
Project tasks. |
MProjectTask |
Projects |
Functional Documentation (planned) |
📋 Planned |
Application Dictionary
| Database Table |
Area |
Purpose |
Related Objects |
Used By |
Documentation |
Status |
AD_Table |
Dictionary |
Application Dictionary tables. |
MTable |
Model Generation |
Application Dictionary (KB-217 planned) |
📋 Planned |
AD_Column |
Dictionary |
Application Dictionary columns. |
MColumn |
Model Generation |
Application Dictionary (KB-217 planned) |
📋 Planned |
AD_Field |
Dictionary |
Window fields. |
GridField |
UI |
Application Dictionary (KB-217 planned) |
📋 Planned |
AD_Window |
Dictionary |
Windows. |
MWindow |
UI |
Application Dictionary (KB-217 planned) |
📋 Planned |
AD_Tab |
Dictionary |
Window tabs. |
GridTab |
UI |
Application Dictionary (KB-217 planned) |
📋 Planned |
AD_Process |
Dictionary |
Processes. |
MProcess • SvrProcess |
Process Framework |
Process Framework (KB-215 planned) |
📋 Planned |
System
| Database Table |
Area |
Purpose |
Related Objects |
Used By |
Documentation |
Status |
AD_User |
Security |
System users. |
MUser |
Authentication • API |
API Architecture (KB-301 planned) |
✅ Certified |
AD_Role |
Security |
Security roles. |
MRole |
Authorization |
Security Model (planned) |
📋 Planned |
AD_Org |
Organization |
Organizations. |
MOrg |
Multi-Organization |
Functional Documentation (planned) |
✅ Certified |
AD_Client |
Client |
Client configuration. |
MClient |
Entire Platform |
Infrastructure |
✅ Certified |
BLACK ERP Engineering Notes
The Engineering Explorer is designed as a navigation layer.
Every object listed here should eventually connect to:
- Engineering Standards
- Reference Manuals
- Functional Documentation
- Playbooks
- BLACK ERP Architecture
The objective is to navigate engineering knowledge from the object involved in the implementation rather than searching documents manually.