| | 1 | 108 | {"type":"column","categories":"item.type","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 40 | {"table":"transaction","relationships":["item"],"type":"table","fields":[{"table":"item","column":"type","type":"STRING","showAt":null,"format":"list:itemTypes"},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"service_order_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money"}],"filters":[{"field":"transaction.service_order_id","operator":"not_empty","condition":"AND","value":null,"references":"service_order","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.final_value","operator":"$gte","condition":"AND","value":0.01,"references":null,"format":null,"type":"DECIMAL"}],"aggregates":[{"table":"item","column":"type","group":true,"sum":false,"avg":false,"max":false,"min":false},{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"hideDetails":true} | 2016-07-04 18:06:17.7+00 | 2022-12-09 15:17:28.987+00 | | | 177 | | | REL-000040 | table | | Ordens de serviço - Custos por tipo de item no mês atual | transaction |
| | | | {"type":"column","categories":"transaction.date","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 | 3676 | {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"item","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"item_description","type":"TEXT","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"doc_number","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:transactionTypes","type":"STRING","isDatePeriod":false,"translated":null,"lineNumber":3},{"field":"transaction.date","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":4},{"field":"item.type","operator":"equal","condition":"AND","value":["Despesa de Viagem"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:itemTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":5}],"aggregates":[{"table":"item","column":"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":"vehicle_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"item_description","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"supplier_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"doc_number","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"expense_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"item","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[]} | 2022-12-12 14:37:31.398+00 | 2022-12-12 14:37:31.414+00 | | 870 | | | 870 | REL-003676 | matrix | Despesas de Viagens em linha errada, Estacionamento de Sem Parar ir para linha de pedágio e KM Excedido ir para linha de manutenção | Despesas Linha Errada (Estacionamento e Km Excedido) | transaction |
| | | | {"type":"column","categories":"transaction.date","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}} | 235 | 3709 | {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"item","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:transactionTypes","type":"STRING","isDatePeriod":false,"translated":null,"lineNumber":1},{"field":"transaction.date","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":2},{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[1422,1421],"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":3}],"aggregates":[{"table":"item","column":"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":"supplier_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"item","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[]} | 2022-12-12 16:46:39.609+00 | 2022-12-12 16:46:39.632+00 | | 870 | | | 870 | REL-003709 | matrix | Despesas com Pedágio Sem Parar geral ano 2022 | Despesas - Pedágio Sem Parar mensal ano 2022 | transaction |
| | | | {"type":"column","categories":"transaction.date","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}} | 235 | 3710 | {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"item","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:transactionTypes","type":"STRING","isDatePeriod":false,"translated":null,"lineNumber":4},{"field":"transaction.date","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":5},{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[2290],"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":6}],"aggregates":[{"table":"item","column":"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":"supplier_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"item","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[]} | 2022-12-12 16:47:31.176+00 | 2022-12-12 16:47:31.189+00 | | 870 | | | 870 | REL-003710 | matrix | Despesas com Pedágio Move Mais geral ano 2022 | Despesas - Pedágio Move Mais mensal ano 2022 | transaction |
| | | | {"type":"column","categories":"transaction.date","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}} | 565 | 3743 | {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"item","column":"sub_system_id","type":"INTEGER","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:transactionTypes","type":"STRING","isDatePeriod":false,"translated":null,"lineNumber":3},{"field":"transaction.date","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":4}],"aggregates":[{"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":"item","column":"sub_system_id","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"item","column":"sub_system_id","isHeaderColumn":true,"desc":true}],"groupBy":[]} | 2022-12-12 20:14:07.803+00 | 2022-12-12 20:47:19.756+00 | 2022-12-12 20:47:19.753+00 | 77 | 77 | 77 | 77 | REL-003743 | matrix | Despesas em geral ano 2022 | Despesas - Custos totais mensal ano 2022 V2 para teste | transaction |
| | | | | 2 | 3881 | {"table":"transaction","relationships":[],"type":"table","fields":[{"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":"expense_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"invoice_due_date","type":"DATE","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":"doc_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[1892,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},{"field":"transaction.invoice_due_date","operator":"empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"groupBy":[]} | 2022-12-15 18:39:34.876+00 | 2022-12-16 18:48:14.788+00 | | 77 | 77 | | 77 | REL-003881 | table | atualizar as despesas da smartech com o vencimento da fatura , de acordo com está no sistema , buscar pela ait. Após excluir | Despesas Smartech , atualizada a data do vencimento da fatura | transaction |
| | | | | 2 | 3845 | {"table":"item","relationships":[],"type":"table","fields":[{"table":"item","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null},{"table":"item","column":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"item","column":"active","type":"BOOLEAN","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"item","column":"created_by_sofit","type":"BOOLEAN","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"item.type","operator":"equal","condition":"AND","value":["Imposto e Taxa"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:itemTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":1}],"aggregates":[{"table":"item","column":"type","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} | 2022-12-13 19:48:36.555+00 | 2022-12-13 19:48:36.575+00 | | 77 | | | 77 | REL-003845 | table | Cristhian analisar quais deve ser trocados | Tipo imposto e taxa | item |
| | | | {"type":"column","categories":"expense.observation","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 | 3844 | {"table":"transaction","relationships":["expense","vehicle"],"type":"table","fields":[{"table":"expense","column":"observation","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","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":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"subsidiary_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":"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":"invoice","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}],"filters":[{"field":"expense.supplier_id","operator":"equal","condition":"AND","value":[1422,1421],"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},{"field":"transaction.invoice","operator":"equal","condition":"AND","value":null,"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":2},{"field":"transaction.vehicle_id","operator":"empty","condition":"AND","value":null,"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":3}],"aggregates":[{"table":"transaction","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false},{"table":"expense","column":"observation","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} | 2022-12-13 19:26:44.319+00 | 2022-12-14 19:58:42.688+00 | 2022-12-14 19:58:42.684+00 | 77 | 77 | 77 | 77 | REL-003844 | table | Serve exclusivamente para fechamento de fatura do sem parar dos veiculos próprios | Fechamento de fatura do sem parar - fechamento de terceiros | transaction |
| | | | | 2 | 3879 | {"table":"transaction","relationships":["item"],"type":"table","fields":[{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"item","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null}],"filters":[{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[478,586,1683,4532,14581,1229],"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},{"field":"item.type","operator":"equal","condition":"AND","value":["Despesa de Viagem","Despesa Administrativa"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:itemTypes","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":2}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} | 2022-12-15 18:28:39.448+00 | 2022-12-15 18:28:39.491+00 | | 77 | | | 77 | REL-003879 | table | trocar o tipo para pedágio, após fazer , excluir o relatório | Estacionamento - trocar o tipo | transaction |
| | | | | 2 | 3880 | {"table":"transaction","relationships":["item"],"type":"table","fields":[{"table":"transaction","column":"name","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":"item","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null}],"filters":[{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[10927,9692],"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":3}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} | 2022-12-15 18:34:49.528+00 | 2022-12-15 18:34:49.555+00 | | 77 | | | 77 | REL-003880 | table | trocar o tipo para manutenção , após excluir o relatório | Km excedido excluir | transaction |