Status field on Requisition Line Table

navuser1

Dear All,

I'm working in Nav 2009 SP1 and found that the Status field has option values like 0,1,2,..,10 in the Requisition Line Table. Can somebody tell me the meaning of these options values in Nav ?

0 for Open
1 for Released
and other ?

Kindly reply.

kriki

Copied straight from help:

Status Field
The Requisition Line Table


This field shows the status of the demand order and is only filled for "passive" planning lines representing order headers. The field can show two sets of status types, depending on whether the planning line is for a sales order or a production order.

Lines that represent sales demand can show a status of Open or Released - copied from the sales order.

Lines that represent production demand can show a status of Planned, Firm Planned, or Released - copied from the production order.

Some tech-talk:
If you have an option field in which you have to store different types of options, depending on the table from where it comes, the best way is to name your options 0,1,2,3 because 0 can have different meanings.
It is also possible to use an integer (integer and option are almost 100% compatible), but this has some limitations when creating filters through properties.