Export to CSV

Data

static external_id created_by_sofit app_id chart report_folder_id id content created_at updated_at deleted_at created_by_id updated_by_id deleted_by_id owner_by_id name type description title main_table
1 64 1 9 {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"item","column":"cost_type","type":"STRING","format":"list:transactionCostTypes","showAt":{"inner":true,"total":true},"translated":"Tipo de custo"},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"format":null,"showAt":{"inner":true,"total":true},"translated":"Data"},{"table":"_formula","column":"Custo por Km Rodado","type":"formula","query":"SUM(transaction.final_value)","format":null,"customReportAgg":"sum","showAt":{"inner":true,"total":true}},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"format":"Money","showAt":{"inner":true,"total":true},"translated":"Valor total"},{"table":"transaction","column":"traveled_distance","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"format":null,"showAt":{"inner":false,"total":true},"translated":"Distância percorrida"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_month:this_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true,"isNotInTable":false},{"field":"transaction.type","operator":"$ne","condition":"AND","value":["revenue"],"references":null,"format":"list:transactionTypes","type":"STRING","isNotInTable":false},{"field":"transaction.register_type","operator":"not_empty","condition":"AND","value":null,"references":null,"format":"list:transactionRegisterTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false}],"aggregates":[{"table":"item","column":"cost_type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"date","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"transaction","column":"traveled_distance","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false}],"isCustomReport":true,"customReportQueries":["kmCost"]} 2016-06-29 21:23:34.077+00 2020-04-15 14:13:29.986+00 REL-000009 matrix Despesas - Custos por km rodado por tipo de custo no mês atual transaction
1 82 {"table":"vehicle_model_version","relationships":["model"],"type":"table","fields":[{"table":"vehicle_model_version","column":"vehicle_model_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle_model_version","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-07-13 18:07:45.006+00 2022-07-13 18:31:43.252+00 2022-07-13 18:31:43.248+00 77 77 77 77 REL-000082 table MODELOS E VERSÕES vehicle_model_version
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.quantity","rawColumn":"transaction.quantity__sum__","axis":0,"summarizer":"sum","isMainValue":true},{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":false}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":true,"showAllRecords":false,"recordsToShow":10},"show_values":{"enabled":true}} 4 116 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"doc_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[1],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"supplier","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Veículo","id":"transaction.vehicle_id"},{"table":"transaction","column":"quantity","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"transaction","column":"unit_value","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-07-13 20:07:41.119+00 2022-07-13 20:09:19.048+00 77 77 77 REL-000116 table Mostra as despesas importadas do sistema da smartec. No sofit , elas estão somente como despesas. Despesas da Smartec transaction
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 37 149 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Veículo","id":"transaction.vehicle_id"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"unit_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-07-18 19:26:33.75+00 2022-07-18 19:26:33.916+00 210 210 REL-000149 table Relatorio de despesas atuais transaction
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 37 150 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.date","operator":"$gte","condition":"AND","value":"2021-01-01T03:00:00.000Z","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":true,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"field":"transaction.date","operator":"$lte","condition":"AND","value":"2022-01-01T02:59:59.999Z","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":true,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Veículo","id":"transaction.vehicle_id"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"unit_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-07-18 19:28:02.953+00 2022-07-18 19:28:03.142+00 210 210 REL-000150 table Relatorio de despesas do ano anterior transaction
{"type":"column","categories":"ct_34.cf_648","values":[{"column":"ct_34.cf_654","rawColumn":"ct_34.cf_654__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 433 2697 {"table":"ct_34","relationships":[],"type":"matrix","fields":[{"table":"ct_34","column":"cf_654","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_647","type":"DECIMAL","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_648","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"ct_34","column":"cf_658","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"ct_34.cf_658","operator":"equal","condition":"AND","value":"RG LOG","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":4},{"field":"ct_34.cf_656","operator":"equal","condition":"AND","value":"VOLVO","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":5},{"field":"ct_34.cf_647","operator":"equal","condition":"AND","value":2022,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DECIMAL","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":6}],"aggregates":[{"table":"ct_34","column":"cf_654","group":false,"sum":true,"avg":false,"max":false,"min":false},{"table":"ct_34","column":"cf_647","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal","translated":"ano","id":"ct_34.cf_647"},{"table":"ct_34","column":"cf_648","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"frota","id":"ct_34.cf_648"},{"table":"ct_34","column":"cf_658","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical","translated":"propriedade","id":"ct_34.cf_658"}],"preview":false,"orderBy":[{"table":"ct_34","column":"cf_647","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2022-10-25 13:30:04.454+00 2022-10-25 13:30:04.737+00 870 870 REL-002697 matrix Relatório de emissões de CO2 referente ano 2022 TOTAL Emissão CO2 (VOLVO) ct_34
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"show_values":{"enabled":true},"use_diferent_color":{},"stacked_column":{"enabled":false},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null}} 2 184 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"standard_consumption","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"real_consumption","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Veículo","id":"transaction.vehicle_id"}],"preview":false,"orderBy":[],"groupBy":[]} 2022-07-20 19:50:07.519+00 2022-07-20 19:50:07.565+00 210 210 REL-000184 table Serve para analisar todas as despesas por veículo Relatorio de Despesas Gerais transaction
{"type":"column","categories":"service_order.vehicle_id","values":[{"column":"_formula.Quantidade","rawColumn":"_formula.Quantidade","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 1 1133 {"table":"service_order","relationships":["vehicle"],"type":"table","fields":[{"table":"service_order","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"_formula","column":"Quantidade","type":"formula","query":"COUNT(DISTINCT service_order.id)","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"service_order"}]},{"table":"service_order","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:serviceOrderTypes","daysEvaluatedColumns":null},{"table":"service_order","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"service_finish_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"total_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"service_order","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"service_order.created_at","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":true,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[{"table":"service_order","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Veículo","id":"service_order.vehicle_id"}],"preview":false,"orderBy":[],"groupBy":[],"hideDetails":true} 2022-09-06 12:46:22.153+00 2023-09-04 19:49:56.137+00 77 343 77 REL-001133 table Ordens de serviço criadas no mês atual Ordens criadas no mês atual service_order
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 37 151 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.date","operator":"$gte","condition":"AND","value":"2022-01-01T03:00:00.000Z","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":true,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1},{"field":"transaction.date","operator":"$lte","condition":"AND","value":"2023-01-01T02:59:59.999Z","variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":true,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Veículo","id":"transaction.vehicle_id"},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"unit_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-07-18 19:28:54.657+00 2022-08-30 20:00:48.072+00 210 376 210 REL-000151 table Relatorio de despesas do ano atual transaction
{"type":"column","categories":"transaction.vehicle_id","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","axis":0,"summarizer":"sum","isMainValue":true}],"legend":{"enabled":true},"filters":{"showOnlyFirstRecords":false,"showAllRecords":true,"recordsToShow":null},"show_values":{"enabled":true}} 2 185 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"odometer","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"standard_consumption","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"real_consumption","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[7867,1761,5008,2021,7868,1760,514,4989],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"transaction","column":"vehicle_id","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false,"translated":"Veículo","id":"transaction.vehicle_id"}],"preview":false,"orderBy":[],"groupBy":[]} 2022-07-20 19:53:33.816+00 2022-07-20 19:53:33.838+00 210 210 REL-000185 table Serve para analisar todas as despesas por veículo Relatorio de Despesas com abastecimento por veículo transaction