Credit Card Account
Posted: Sat Aug 20, 2016 2:43 am
when i use my credits cards, i can't see in this sql inform. how can i change for see the credit card movements? only see the movemet in Chekinggs acount.
-- TODO: Update payee name in line 19. select strftime('%Y', t.TRANSDATE) as YEAR , total(case when '01' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Enero , total(case when '02' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Febrero , total(case when '03' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Marzo , total(case when '04' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Abril , total(case when '05' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Mayo , total(case when '06' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Junio , total(case when '07' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Julio , total(case when '08' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Agosto , total(case when '09' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Septiembre , total(case when '10' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Octubre , total(case when '11' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Noviembre , total(case when '12' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Diciembrefrom CHECKINGACCOUNT_V1 as tinner join ACCOUNTLIST_V1 as a on a.ACCOUNTID = t.ACCOUNTIDinner join CURRENCYFORMATS_V1 as c on c.CURRENCYID = a.CURRENCYIDinner join SUBCATEGORY_V1 as p on t.SUBCATEGID = p.SUBCATEGIDwhere p.SUBCATEGNAME = 'Supermercado' and t.TRANSCODE='Withdrawal' and t.STATUS <> 'V'group by yearorder by year desc;
-- TODO: Update payee name in line 19. select strftime('%Y', t.TRANSDATE) as YEAR , total(case when '01' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Enero , total(case when '02' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Febrero , total(case when '03' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Marzo , total(case when '04' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Abril , total(case when '05' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Mayo , total(case when '06' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Junio , total(case when '07' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Julio , total(case when '08' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Agosto , total(case when '09' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Septiembre , total(case when '10' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Octubre , total(case when '11' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Noviembre , total(case when '12' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Diciembrefrom CHECKINGACCOUNT_V1 as tinner join ACCOUNTLIST_V1 as a on a.ACCOUNTID = t.ACCOUNTIDinner join CURRENCYFORMATS_V1 as c on c.CURRENCYID = a.CURRENCYIDinner join SUBCATEGORY_V1 as p on t.SUBCATEGID = p.SUBCATEGIDwhere p.SUBCATEGNAME = 'Supermercado' and t.TRANSCODE='Withdrawal' and t.STATUS <> 'V'group by yearorder by year desc;