What is lft & rgt in account doctype?

[vivek]

I came across these 2 fields in account doctype. What are they actually used for?

[revant_one]

Those fields are required to generate tree view for a doctype

Create Tree View and a Tree Browser for any DocType

I created reference / tutorial app for creating Tree/Chart views for doctype http://revant.github.io/tree_view Useful Posts: Fields in Doctype : Tree tree_name - Data parent_tree - Link:Tree is_group - Select:Yes/No lft - Int rgt - Int old_parent - Link:Tree tree.py Tree Browser Page:

[ManasSolanki]

These fields are used for creating a tree structure for the account doctype.

[vivek]

@revant_one @ManasSolanki . I noticed that this field is also being used to order accounts in reports? I am trying to have the direct expense display above indirect expense in P&L . Where do i tinker around exactly to achieve this?

[Maheswari_Subramania]

Reviving this topic.

@revant_one are the fields lft and rgt used only for tree view purposes, is it possible to safely restrict the scope of lft and rgt fields to one single company?

As explained by @vigneshsekar here [Requesting Help] Optimised approach to create Chart of Accounts,
our use case requires us to store data related to multiple independent companies, each with its own Chart of accounts. While we programmatically create the COA for one company, we observe that the lft and rgt for other companies’ accounts are also updated, slowing down the performance. To avoid this, we would like the COA for each company to have its own range of lft and rgt.

Any help or suggestions in this regard will be much appreciated.