Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. CKG Edit ====== Control SQL - GL Out of Balance By Order ====== ==Explanation of SQL== This query shows the ordernumber in the gl when you have just the transaction id. ===== Risk of Data Corruption if Run Improperly ===== **Low**. No data is modified in the running of this query. ===== SQL ===== <code sql> select ordernumber from transheader where id= </code> ===== Version Information ===== * Entered : 9/08/2009 * Version : Control 4.3