# In account\_account what is right and left columns

**URL:** https://discuss.tryton.org/t/in-account-account-what-is-right-and-left-columns/8157
**Category:** Developer
**Tags:** accounting
**Created:** [January 5, 2025, 3:08pm UTC](https://discuss.tryton.org/t/in-account-account-what-is-right-and-left-columns/8157 "2025-01-05T15:08:55Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![herve\_02](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/h/7ea924/32.png) [@herve\_02](https://discuss.tryton.org/u/herve_02)
#### Post date: [January 5, 2025, 3:08pm UTC](https://discuss.tryton.org/t/in-account-account-what-is-right-and-left-columns/8157/1 "2025-01-05T15:08:56Z")

</div>

i as wondering what are the left and right column in the model account\_account and if there is an impact somewhere ?

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [January 5, 2025, 11:38pm UTC](https://discuss.tryton.org/t/in-account-account-what-is-right-and-left-columns/8157/2 "2025-01-05T23:38:26Z")

</div>

They are used for MPTT: [Fields — Tryton server](https://docs.tryton.org/latest/server/ref/fields.html#trytond.model.fields.Many2One.left)

---

<div class="post-metadata">

### Author: ![herve\_02](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/h/7ea924/32.png) [@herve\_02](https://discuss.tryton.org/u/herve_02)
#### Post date: [January 7, 2025, 4:35pm UTC](https://discuss.tryton.org/t/in-account-account-what-is-right-and-left-columns/8157/3 "2025-01-07T16:35:19Z")

</div>

i already read that written on klyngon would do the same for me ,-)

When i create line by sql… what happens if i do not give values (there will be a reconstruct ? so not a problèm ?

---

<div class="post-metadata">

### Author: ![udono](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/udono/32/2114_2.png) [@udono](https://discuss.tryton.org/u/udono)
#### Post date: [January 7, 2025, 4:49pm UTC](https://discuss.tryton.org/t/in-account-account-what-is-right-and-left-columns/8157/4 "2025-01-07T16:49:09Z")

</div>

> [@herve\_02](#):
>
> When i create line by sql… what happens if i do not give values (there will be a reconstruct ? so not a problèm ?

it is explained in the [warning of the `left` attribute](https://docs.tryton.org/latest/server/ref/fields.html#trytond.model.fields.Many2One.left):

> The MPTT Tree will be rebuild on database update if one record is found having left or right field value equals to the default or NULL.