It looks like this field is to flag complete (or closed) and incomplete (or open) sales orders.
 
If the flag is 'X', then it is an open order.
If the flag is 'Y', then it is a closed order.
 
However, if you view a closed order through SO-A, and then exit the order without saving changes, it leaves this flag with a ' ' in it.
 
On the other hand, If while looking at an existing order,  you get the message 'This customer has exceded their credit limit, do you wish to continue' and you answer 'No', then this field is left with a ' ' in it also.
 
So the ' ' value could flag an open, or closed order.
 
I have two Questions:
1. Is ' ' a valid value for this field?
2. What does a ' ' value flag?
 
-------------
Lynn - Can you shed some light on this??
 

The valid values for this field are:

• blank
• X
• Y

 
Blank indicates that the SO had an invoice but the SO was re-opened and the user that opened it just exited without saving and responding to the "close" question; X indicates an order that had an invoice created but the order is not closed yet;  and Y indicates an invoiced and closed order.

Quote:

 
As I indicated in my first post ... Blank can flag open or closed.  This flag should not be changed to blank when you get the 'This customer has exceded ...' message.
 
I do not see any reason for a value of Blank.  Further, I do not see any reason for leaving an order in the "open" state (with a blank in this field) if you choose to not save changes when exiting a previously closed order.
 
The reason I am asking about this field is because I have written a PHP application that allows our customers to view their open order status directly from the DBA datafiles.  I was going to use this field to filter only the open orders.  Instead, I am going to have to use a aggregate function to sum the QTY remaining to ship.