Significance of current status of Serial number in MTL_SERIAL_NUMBERS

We have serial number table (MTL_SERIAL_NUMBERS) the column ‘CURRENT_STATUS’ indicates the status of a serial number. The column is populated with a number. For example, 3 means resides in stores. This means that the serial number has an associated onhand quantity and should be available to transact.

Once you ship the order and serial number got used , then current status got set to 4 !!

Here is a list of common serial number statuses and ids:

Current Status Codes (ID and Description)
————————————————–
1 Defined but not used
3 Resides in stores 
4 Issued out of stores
5 Resides in intransit
6 Pending status
7 Resides in receiving
8 Resides in WIP