I’ve been exporting some transactions from the ERPNext database and noticed that the name column in the “tabGL Entry” table is not fixed.
This has caused us to see duplicates because of assuming that name was sort of an “id” column.
I noticed that there is a to_rename field and that it gets changed to false and the name changed periodically.
I haven’t been able to deduce the frequency but it seems to be on the hour?
Can someone explain or confirm this behavior?
Thanks John, We’ve had to work around the problem by using creation as a unique id, when the renaming occurs the modified and creation times are not affected. The creation time is specific enough (to the microsecond) to make a pseudo unique id.