Odoo Server (MOVED TO GITHUB)

table name in openerp

Asked by Bushair

Hi,
How to find the database table name in openerp?
For example, i would like to know in which database table the following details are stroed?

1) List of partners
2)List of suppliers
3)List of customers
4)Customer balance
5)Supplier balance

How to find the table name ?

thanks

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Vinay Rana (OpenERP) (vra-openerp) said : 		#1

Hello Bushair,

You can easily find the related object name from Administration/Customization/Database Structure/Objects menu.
With the help of object name you can easily find the table name, In maximum cases table name is similar like object name. You are needed to put ' _' instead of '.'. But some cases It is possible that the table name is not similar like object name(If programmer gave _table attribute or class name with different name string.).In this time you need to manually search the name of table name from the class with help of object name.

Hope this will help you.

Thanks.

Revision history for this message
Serpent Consulting Services (serpent-consulting-services) said : 		#2

Bushair,

Since 6.1, you can activate the debug mode (developer mode) and over here you will see details regading the model.

Thanks.

Can you help with this problem?

Provide an answer of your own, or ask Bushair for more information if necessary.

To post a message you must log in.