| | | | | 1 | 5285 | {"table":"warehouse_item","relationships":[],"type":"table","fields":[{"table":"warehouse_item","column":"warehouse_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"warehouse_item","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"warehouse_item","column":"on_hand_balance","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"warehouse_item","column":"pr_last_purshase","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"warehouse_item","column":"weighted_average_pr","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"warehouse_item","column":"on_hand_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"warehouse_item","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"warehouse_item.created_at","operator":"$gte","condition":"AND","value":"2023-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":"warehouse_item.created_at","operator":"$lte","condition":"AND","value":"2023-10-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":"warehouse_item","column":"on_hand_value","group":false,"sum":true,"avg":false,"max":false,"min":false}],"preview":false,"orderBy":[{"table":"warehouse_item","column":"item_id","isHeaderColumn":true,"desc":true}],"groupBy":[]} | 2023-10-23 11:52:48.205+00 | 2023-10-23 11:53:28.399+00 | | 276 | 276 | | 276 | REL-005285 | table | Saldo dos itens em estoque por depósito | Estoque - Saldo dos itens em estoque por depósito | warehouse_item |
| | | | | 565 | 3475 | {"table":"service_order","relationships":[],"type":"table","fields":[{"table":"service_order","column":"observation","type":"TEXT","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":"name","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"vehicle_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"status","type":"STRING","showAt":null,"showInHours":false,"format":"list:serviceOrderStatus","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},{"table":"service_order","column":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"service_start_date","type":"DATE","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":"problem_description","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"updated_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"request_reason","type":"STRING","showAt":null,"showInHours":false,"format":"list:requestReasonsSO","daysEvaluatedColumns":null}],"filters":[{"field":"service_order.total_cost","operator":"$lte","condition":"AND","value":0,"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":3},{"field":"service_order.status","operator":"equal","condition":"AND","value":["finished"],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":null,"format":"list:serviceOrderStatus","type":"STRING","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":4},{"field":"service_order.created_at","operator":"$gte","condition":"AND","value":"2022-12-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":5},{"field":"service_order.created_at","operator":"$lte","condition":"AND","value":"2023-03-22T02: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":5}],"aggregates":[{"table":"service_order","column":"observation","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"service_order","column":"name","isHeaderColumn":true,"desc":false}],"groupBy":[]} | 2022-11-25 18:28:18.152+00 | 2023-04-04 12:55:58.778+00 | | 276 | 276 | | 276 | REL-003475 | table | | Ordens de serviço fechada sem despesa | service_order |
| | | | {"type":"column","categories":"transaction.date","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} | 1 | 3541 | {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"item","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"format":"list:itemTypes","translated":"Tipo"},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"format":null,"translated":"Data"},{"table":"transaction","column":"final_value","type":"DECIMAL","summarizers":{"sum":true,"avg":false,"max":false,"min":false},"showAt":{"inner":true,"total":true},"format":"Money","translated":"Valor total"}],"filters":[{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[1683],"references":"item","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isDatePeriod":false,"translated":null},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_year:this_year","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isNotInTable":false,"isDatePeriod":false,"daysInPeriod":null,"frequencyInPeriod":null,"translated":null}],"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}],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":false},{"table":"item","column":"type","isHeaderColumn":true,"desc":false}],"groupBy":[],"having":[]} | 2022-11-29 18:59:58.49+00 | 2022-11-29 19:01:43.985+00 | 2022-11-29 19:01:43.981+00 | 77 | 77 | 77 | 77 | REL-003541 | matrix | | Despesas do ano atual com Pedágio | transaction |
| | | | | 565 | 3474 | {"table":"stock_entry_item","relationships":["stock_entry"],"type":"table","fields":[{"table":"stock_entry","column":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Fornecedor"},{"table":"stock_entry_item","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Item"},{"table":"stock_entry_item","column":"stock_entry_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Entrada de estoque"},{"table":"stock_entry_item","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Data"},{"table":"stock_entry_item","column":"warehouse_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Depósito"},{"table":"stock_entry_item","column":"quantity","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Quantidade"},{"table":"stock_entry_item","column":"stock_balance","type":"DECIMAL","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Saldo após movimentação"},{"table":"stock_entry_item","column":"unit_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null,"translated":"Valor unitário"},{"table":"stock_entry_item","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null,"translated":"Valor total"},{"table":"stock_entry_item","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Usuário que criou"},{"table":"stock_entry_item","column":"doc_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Nº de documento"}],"filters":[{"field":"stock_entry_item.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":true,"isDatePeriod":false,"translated":null}],"aggregates":[{"table":"stock_entry_item","column":"final_value","group":false,"sum":true,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[{"table":"stock_entry_item","column":"item_id","isHeaderColumn":true,"desc":true}],"groupBy":[],"having":[]} | 2022-11-25 18:23:57.153+00 | 2022-12-07 19:10:34.263+00 | | 276 | 276 | | 276 | REL-003474 | table | Auditoria das entradas de estoque por itens nos últimos 60 dias | Estoque - Auditoria das entradas de estoque por itens - U30d | stock_entry_item |
| | | | | 1 | 3576 | {"table":"transaction","relationships":["expense"],"type":"table","fields":[{"table":"transaction","column":"date","type":"DATE","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":"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":"supplier_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"created_by_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[1551],"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":2}],"aggregates":[],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"groupBy":[]} | 2022-12-05 14:50:41.23+00 | 2022-12-09 15:15:04.709+00 | 2022-12-09 15:15:04.704+00 | 77 | 177 | 177 | 77 | REL-003576 | table | | Item do registo do move mais errado | 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 | 3542 | {"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":"item","column":"cf_943","type":"STRING","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}],"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":"item","column":"cf_943","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-11-29 19:25:21.936+00 | 2022-12-26 19:20:00.383+00 | | 870 | 177 | | 870 | REL-003542 | matrix | Despesas em geral ano 2022 | Despesas - Custos totais mensal ano 2022 | transaction |
| | | | | 268 | 3543 | {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Despesa"},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Item"},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null,"translated":"Valor total"},{"table":"transaction","column":"date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null,"translated":"Data"}],"filters":[{"field":"transaction.supplier_id","operator":"equal","condition":"AND","value":[2290,1422,1421],"references":"supplier","format":null,"type":"INTEGER","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"translated":null},{"field":"transaction.date","operator":"$gte","condition":"AND","value":"2022-07-01T03:00:00.000Z","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":true,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"translated":null},{"field":"transaction.date","operator":"$lte","condition":"AND","value":"2023-01-01T02:59:59.999Z","references":null,"format":null,"type":"DATE","variableValue":null,"variableValueType":null,"conditionType":"fixed","isFixedPeriod":true,"isDynamicPeriod":false,"isNotInTable":false,"isDatePeriod":false,"translated":null}],"aggregates":[],"preview":false,"orderBy":[{"table":"transaction","column":"date","isHeaderColumn":true,"desc":true}],"groupBy":[],"having":[]} | 2022-11-29 19:52:43.444+00 | 2022-11-29 19:58:50.204+00 | | 77 | 77 | | 77 | REL-003543 | table | | teste | transaction |
| | | | | 565 | 727 | {"table":"service_order","relationships":[],"type":"table","fields":[{"table":"service_order","column":"name","type":"STRING","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":"created_at","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"service_order","column":"supplier_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":"total_foreseen_cost","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"service_order","column":"request_reason","type":"STRING","showAt":null,"showInHours":false,"format":"list:requestReasonsSO","daysEvaluatedColumns":null},{"table":"service_order","column":"doc_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} | 2022-08-18 19:48:32.193+00 | 2022-12-01 13:20:47.603+00 | | 376 | 276 | | 376 | REL-000727 | table | | ordens criadas | service_order |
| | 1 | 143 | | 1 | 62 | {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"supplier_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"date","type":"DATE","showAt":null,"format":null},{"table":"transaction","column":"vehicle_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"format":null},{"table":"transaction","column":"quantity","type":"DECIMAL","showAt":null,"format":null},{"table":"transaction","column":"unit_value","type":"DECIMAL","showAt":null,"format":"Money"},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"format":"Money"}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","references":null,"format":null,"type":"DATE","isFixedPeriod":false,"isDynamicPeriod":true},{"field":"transaction.type","operator":"equal","condition":"AND","value":["expense"],"references":null,"format":"list:transactionTypes","type":"STRING","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.item_id","operator":"not_empty","condition":"AND","value":null,"references":"item","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false},{"field":"transaction.vehicle_id","operator":"not_empty","condition":"AND","value":null,"references":"vehicle","format":null,"type":"INTEGER","isFixedPeriod":false,"isDynamicPeriod":false}],"aggregates":[{"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":false}],"hideDetails":false} | 2018-04-03 13:33:02.875+00 | 2022-12-02 12:02:36.251+00 | | 1 | 276 | | 1 | REL-000062 | table | | Despesas - Despesas por fornecedor mês anterior - detalhado | 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 | 3843 | {"table":"transaction","relationships":["expense","vehicle"],"type":"table","fields":[{"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":"expense","column":"observation","type":"TEXT","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},{"table":"transaction","column":"observation","type":"TEXT","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":"22182324614","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}],"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}],"preview":false,"orderBy":[],"groupBy":[],"hideDetails":false} | 2022-12-13 19:26:06.724+00 | 2022-12-14 20:21:10.932+00 | | 77 | 77 | | 77 | REL-003843 | table | Serve exclusivamente para fechamento de fatura do sem parar dos veiculos próprios | Fechamento de fatura do sem parar | transaction |