[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

@max_morais_dmm
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

@max_morais_dmm
Thank you so much…
Understood.