ER model
Openbravo ERP
Version 1.0

Visit us at www.openbravo.com

Preface
This document represents Openbravo’s Entity Relation Diagram (ERD), created with data obtained from the Application Dictionary. The aim of the document is not to get a formal ERD, but to get a complete view of the tables and columns behind the functionalities of Openbravo ERP.

The diagram has been separated into several chapters according to the main functional modules of the ERP. The same table might appear in different chapters but only once in detail. This is done to emphasize the relation among the main tables of the chapter with the rest of the diagram. All the relations are represented among the examples, but those not representative in the chapter have been deleted.

The not implemented columns are those ones that aren’t being used in the ERP. They can be part of deleted functionalities, hidden or not used functionalities or they are about to be developed.

The tables of Openbravo have some common characteristics. All tables must have a unique primary key with columnname like tablename+ ID. The table name has to follow the prefix policy: • A: asset management • AD: application dictionary • C: core functionality • I: import temporary tables and processes • M: material management • FACT: Accounting tables. • GL: general ledger • MA: manufacturing • MRP: material resource • S: service management • CUS, PD, US, ZZ: personal developments. Common columns of all tables: • Created: date of record creation. 2/461

• CreatedBy: id of the user that has created the record. • Updated: date of the last update of the record. • UpdatedBy: id of the user that has commit the last update. • IsActive: logic delete of the record. • AD Client ID: id of the client owner of the record. AD Client ID = 0 is System client for System Administrator use. • AD Org ID: id of the organization owner of the record. AD Org ID = = is Asterisk organization that shares the record to all the organizations