Differences

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

Link to this comparison view

ar_sql_report [2019/01/30 09:22]
127.0.0.1 external edit 		ar_sql_report [2019/01/30 17:33]
admin
Line 1: Line 1:
-======  ====== 
- 
- 
- 
 ===== Explanation of SQL ===== ===== Explanation of SQL =====
- 
- 
- 
 This query provides the raw data used in the A/R report. This query provides the raw data used in the A/R report.
  
Line 13: Line 6:
 ===== Risk of Data Corruption if Run Improperly ===== ===== Risk of Data Corruption if Run Improperly =====
  
-**None**. This is a selection query and no data is modified in the running of it. +**None**. This is a selection query and no data is modified in the running of it. Modifications done through direct SQL **are permanent and non-reversable**.
- +
- +
- +
-modifications done through direct SQL **are permanent and non-reversable**. +
  
  
Line 63: Line 51:
  where GLAccountID = 14  where GLAccountID = 14
  and EntryDateTime   and EntryDateTime 
 +</code>