Script – SQL Collection

Jack Gerrard



  • Version
  • 1000 Download
  • 6.19 KB File Size
  • 1 File Count
  • 19/01/2017 Create Date
  • 26/02/2018 Last Updated
  • Please login to download

A collection of useful SQL scripts which can be used in your favourite SQL Editor or added to uniCenta oPOS and include:

  • Clear Transactions - Clear uniCenta oPOS data except Categories and Products
  • Daily Sales - Exactly that!
  • Day Of Month - Sales by day per month
  • Hourly Sales - Exactly that!
  • Month Of Year - Sales by Month
  • Monthly Sales - Sales by Month
  • Week Of Year - Week number of Year
  • Weekly in Year - Weekly sales
  • Yearly Sales - Compare historical sales

File
uniCenta oPOS additional SQL scripts