Quote: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.
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.