Is "Line" from transactions not accessable in Suit...
# suiteql
m
Is "Line" from transactions not accessable in SuiteQL? I can only find linesequencenumber
Is there any workaround?
j
it’s
transactionline
Annoyingly it does not appear properly in the side menu in the Records Browser.
m
I meant the transactionline table.. Line Number does not seem to be available
b
the line field on a transaction represents the line id
it is not the same as the line sequence number, nor is it the same as the line index parameter used by suitescript
m
Sorry, I was really diffuse. I am looking for "line number" on the items sublist.
b
you want the line sequence number
m
No, you can not use that if you want to do a CSV-update with the results for instance
b
you will want to learn the difference between the different ways to identify a line on a transaction
there is the id, which is unique per transaction
m
I know.
b
there is the sequence number, which goes from 1 to however many lines there are
m
I know that too.
But please tell me more of what I should learn
b
line sequence number can be changed by removing or inserting lines
which are you looking for
m
No, I am looking fore the line number. In saved searches e.g. the field name is "line". That is what you. can make updates against
b
as mentioned earlier, the line is the line id
m
Yes, and that's the field I want to access via SuiteQL
b
known as the id on a transaction line
m
ah great, thank you
b
you dont really want to call the line id the line number, they are different things
👆 1