[SOLVED]: Use of 'idx' field in the tables of ERPNext

Hi all,

Can anyone let me know the use of ‘idx’ field in the tables of ERPNext database please?

@Amalendu this field determine the dragged ordem for grid rows.

When you have a sub-table, the ordem of each record in UI is managed by this field

Thank you for your quick reply!
And can you please make me know this too, when this column is get updated. When I listen all tables, almost all rows are having ‘idx’ 0.

Thank you.

@Amalendu only when a row is a children of another, take a look into Sales Order Item

Thank you so much…