Thanks again, although I don't see whether you said you had been given your Article 31b rights before giving your statement. This is important since you originally said you were appealing the false official statement charge and not the possession charge. Now you are saying you want to appeal the orders violation charge. So, I am not sure which charge you are appealing. If you are appealing the false official statement, then if you were a suspect when you gave your statement, but were not read your rights, then this wouldn't be a false official statement since the questioning would have violated Article 31b of the Manual for Courts-Martial. However, if you were either not a suspect or were read your rights and then gave a false statement, it could be charged. If you are saying that the clear evidence that the GO had that you did not make a false statement, then you would have a basis for appeal and just need to discuss the facts in your appeal.
As for the orders violation itself, if the order says "possession" is a violation, then it doesn't matter what your intent was as far as the alcohol goes after you possessed it, you would still be guilty of an orders violation. On the other hand the order says "possess with the intent to consume," then you can try to argue that you were going to get rid of it. However, on appeal, it is unlikely that the reviewer will second guess the GO's judgment as to whether or not they believed your version of the facts.
As for your security clearance suspension, that can be indefinite. In other words, it is entirely up to the GO as to whether your security clearance is reinstated or permanently withdraw. Obviously, if they are going to retain you in your job, instead of being relieved for cause, then they will have to reinstate you so that you can do your job. But, again, up to the chain of command.
Finally, whether or not you will go to a show cause board is also up to the chain of command and headquarters. If you are not relieved for cause, it is highly unlikely you will have to show cause. If you are relieved from you job, then it might be more likely. It really depends on your chain of commands attitude about you, your service record and the numbers of excess officers (if any), that the Army is trying to cut.
Please feel free to add facts that you didn't before or ask follow up questions if you have them.