Odoo 10

From Objectif Client Inc
Revision as of 05:08, 26 August 2015 by Nicolas Rollin (talk | contribs) (Created page with " ===Account Link=== Account Master <syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight> <pre> id |...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Account Link

Account Master

select id, name from account_account where name in ('Product Sales', 'Expenses');
 id | name
-----+---------------
  19 | Product Sales
  23 | Expenses
(2 rows)

Property

select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';
 id | name | type | fields_id | value_reference | res_id
----+--------------------------------+----------+-----------+--------------------+--------
  4 | property_account_expense_categ | many2one | 1947 | account.account,23 |
  5 | property_account_income_categ | many2one | 1948 | account.account,19 |
(2 rows)

Model

select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);
  id | model | name | relation | field_description
------+------------------+--------------------------------+-----------------+-------------------
 1947 | product.category | property_account_expense_categ | account.account | Expense Account
 1948 | product.category | property_account_income_categ | account.account | Income Account
(2 rows)