Skip to Content

OSRN and OSRI Tables to Find Status

Hi Everyone,

I am just writing a few queries and wanted to ask if someone could help with this one. I just want first to check an Serial Numbers status. Version 9.3 PL5.

In the OSRN table definition, it lists the column status as having a value of 0,1,2 to represent the status (Available, Unavailable and allocated). When i query this table all this column has is null. (Its a 5 year old database working with serial numbers all the time).

select * from OSRN where Status is not null
>> This Returns 0 Rows.

So is this column no longer used? does anyone know why the status column in OSRN is NULL?

So then I move onto OSRI, this has a status column, but it is only 0 or 1 (Available / Unavailable). This works OK, but Allocated would be a great addition.

So the question is, is there an easy way to get the serial number status of allocated? Or do i need to trawl through the SRI1 table to find its allocation?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 10, 2020 at 01:50 PM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.