Differences

This shows you the differences between two versions of the page.

Link to this comparison view

— control_sql_-_customer_write_offs [2019/01/27 11:28] (current)
Line 1: Line 1:
 +======  ======
 +
 +
 +
 +===== Explanation of SQL =====
 +
 +
 +
 +To locate all write offs in the system by company name.
 +
 +
 +
 +===== Risk of Data Corruption if Run Improperly =====
 +
 +**None**. This is a selection query and no data is modified in the running of it.
 +
 +
 +
 +===== SQL =====
 +
 +
 +
 +select * from gl
 +
 +
 +
 +where glaccountid=51
 +
 +
 +
 +order by entrydatetime
 +
 +
 +
 +===== Version Information =====
 +  * Entered : __/__/2009
 +  * Version :
 +
 +
 +