Each Journal Entry Line has a `lineuniquekey` fiel...
# general
i
Each Journal Entry Line has a
lineuniquekey
field (accessible via SuiteScript), with a value like "23412050". It uniquely identifies the line within the scope of a given Journal Entry (i.e. no two lines within the same entry will have the same lineuniquekey). Does this uniqueness guarantee extend beyond the scope of a single Journal Entry? I.e. is it safe to assume no two lines belonging to different Journal Entries can have the same lineuniquekey either?
d
goes even further, lineuniquekey is unique across ALL transaction types
lineid
is unique across a single transaction, and is what you'd actually use if you were updating the transaction (via suitescript, csv, etc). there's also
Line Sequence Number
, which is just the row number of the line on the transaction.
i
This is great to know, thanks! Is the uniqueness scope of lineuniquekey documented anywhere?
s
notable that although
lineuniquekey
is unique across transaction types, it is not available on all transaction types. No explanation on why not.
i
I'm curious, how do we know it's unique across transaction types? I can't find that documented anywhere.
s
Behind the scenes transactions seem to all be in the same database table?