Total CC Charges

SQL query for LightSpeed Retail (R-Series)

Calculate the total credit card charges incurred.

SELECT SUM(CCCharges.amount) AS total_cc_charges FROM CCCharges

LightSpeed Retail (R-Series) data model

Table C C Charges

Table Customers

Table Discounts

Table Employees

Table Employee Hours

Table Inventory Transfers

Table Inventory Transfer Items

Table Items

Table Manufacturers

Table Orders

Table Order Lines

Table Payment Types

Table Quotes

Table Registers

Table Sales

Table Sale Lines

Table Sale Payments

Table Serialized

Table Shops

Table Vendors

Table Workorders

Magical SQL for LightSpeed Retail (R-Series) with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Total CC Charges

SQL query for LightSpeed Retail (R-Series)

LightSpeed Retail (R-Series) data model

Magical SQL for LightSpeed Retail (R-Series) with Peliqan.io

Let AI do the work for you

Ready to get instant access to all your company data ?

Ready to get instant access to
all your company data ?