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
268 3980 {"table":"transaction","relationships":["item"],"type":"table","fields":[{"table":"item","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:itemTypes","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}],"filters":[{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[478,10927],"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":"item","column":"type","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[],"hideDetails":false} 2022-12-22 19:11:33.138+00 2022-12-22 19:17:54.472+00 2022-12-22 19:17:54.468+00 77 77 77 77 REL-003980 table Excluir - somente para conferencia do item atualizado transaction
268 3947 {"table":"transaction","relationships":["item"],"type":"table","fields":[{"table":"item","column":"type","type":"STRING","showAt":null,"showInHours":false,"format":"list:itemTypes","daysEvaluatedColumns":null},{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"final_value","type":"DECIMAL","showAt":null,"showInHours":false,"format":"Money","daysEvaluatedColumns":null},{"table":"transaction","column":"expense_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.item_id","operator":"equal","condition":"AND","value":[478,10927],"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":"item","column":"type","group":true,"sum":false,"avg":false,"max":false,"min":false,"stddev":false}],"preview":false,"orderBy":[],"groupBy":[]} 2022-12-22 16:56:27.79+00 2022-12-22 16:56:27.821+00 77 77 REL-003947 table serve para comprovar que foi trocado o tipo do item do km excedido e estacionamento. Segue as despesas atualizadas troca do item transaction
1 163 {"type":"column","categories":"transaction.created_at","values":[{"column":"_formula.Quantidade de registros","rawColumn":"_formula.Quantidade de registros","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 5318 {"table":"transaction","relationships":[],"type":"matrix","fields":[{"table":"transaction","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":"list:transactionTypes","daysEvaluatedColumns":null},{"table":"transaction","column":"created_at","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"is_full_period":false},{"table":"_formula","column":"Quantidade de registros","type":"formula","query":"COUNT(DISTINCT transaction.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"transaction"}]}],"filters":[{"field":"transaction.created_at","operator":"dynamic_period","condition":"AND","value":"sub_60_days:this_day","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":"transaction","column":"type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"created_at","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"transaction","column":"created_at","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2024-04-15 16:44:58.384+00 2024-04-16 03:01:28.462+00 2024-04-16 03:01:28.462+00 -1 REL-005318 matrix Usabilidade - Data de criação transaction
565 1610 {"table":"vehicle","relationships":[],"type":"table","fields":[{"table":"vehicle","column":"license_plate","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_611","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"renavam","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"chassis_number","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"dut_uf_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_34","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_379","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_group_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_142","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"model_identification","type":"STRING","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"fabrication_year","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"model_year","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"vehicle_deactivation_cause_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"disponibility","type":"STRING","showAt":null,"showInHours":false,"format":"list:vehicleDisponibility","daysEvaluatedColumns":null},{"table":"vehicle","column":"deactivation_date","type":"DATE","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"cf_478","type":"TEXT","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"vehicle","column":"rental_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"vehicle.vehicle_group_id","operator":"$ne","condition":"AND","value":[316,315],"variableValue":null,"variableValueType":null,"variableValueTranslated":null,"conditionType":"fixed","references":"vehicle_group","format":null,"type":"INTEGER","isFixedPeriod":false,"isDatePeriod":false,"isDynamicPeriod":false,"isNotInTable":false,"translated":null,"lineNumber":4},{"field":"vehicle.cf_34","operator":"$ne","condition":"AND","value":"MACAN","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}],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-09-21 13:30:02.743+00 2023-07-28 12:56:51.466+00 514 276 514 REL-001610 table Inventario (Ativos e Inativos) vehicle
1 196 {"type":"column","categories":"transaction.created_at","values":[{"column":"_formula.Quantidade de registros","rawColumn":"_formula.Quantidade de registros","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 5351 {"table":"transaction","relationships":[],"type":"matrix","fields":[{"table":"transaction","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":"list:transactionTypes","daysEvaluatedColumns":null},{"table":"transaction","column":"created_at","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"is_full_period":false},{"table":"_formula","column":"Quantidade de registros","type":"formula","query":"COUNT(DISTINCT transaction.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"relatedTables":[{"table":"transaction"}]}],"filters":[{"field":"transaction.created_at","operator":"dynamic_period","condition":"AND","value":"sub_60_days:this_day","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":"transaction","column":"type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"created_at","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"transaction","column":"created_at","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2024-04-15 17:04:06.363+00 2024-04-16 03:01:28.488+00 2024-04-16 03:01:28.488+00 -1 REL-005351 matrix Usabilidade - Data de criação U60D transaction
268 3984 {"table":"transaction","relationships":[],"type":"table","fields":[{"table":"transaction","column":"item_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"sub_system_id","type":"INTEGER","showAt":null,"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[],"aggregates":[],"preview":false,"orderBy":[],"groupBy":[]} 2022-12-22 19:51:12.509+00 2022-12-22 19:54:36.151+00 2022-12-22 19:54:36.146+00 77 77 77 77 REL-003984 table fghgfxh transaction
2 3981 {"table":"transaction","relationships":[],"type":"table","fields":[{"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":"supplier_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":"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-22 19:21:58.926+00 2022-12-22 19:37:53.056+00 2022-12-22 19:37:53.048+00 77 77 77 77 REL-003981 table Smartech - sem vencimento da fatura transaction
1 229 {"type":"column","categories":"transaction.created_at","values":[{"column":"_formula.Quantidade de registros","rawColumn":"_formula.Quantidade de registros","summarizer":"formula","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 1 5384 {"table":"transaction","relationships":[],"type":"matrix","fields":[{"table":"transaction","column":"type","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":"list:transactionTypes","daysEvaluatedColumns":null},{"table":"transaction","column":"created_at","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"is_full_period":false},{"table":"_formula","column":"Quantidade de registros","type":"formula","query":"COUNT(DISTINCT transaction.id)","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null}],"filters":[{"field":"transaction.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":"transaction","column":"type","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"vertical"},{"table":"transaction","column":"created_at","group":true,"sum":null,"avg":null,"max":null,"min":null,"matrix_type":"horizontal"}],"preview":false,"orderBy":[{"table":"transaction","column":"created_at","isHeaderColumn":true,"desc":false}],"groupBy":[]} 2024-04-16 03:01:28.504+00 2024-04-16 03:01:28.515+00 REL-005384 matrix Usabilidade - Data de criação (ano atual) transaction
{"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 3983 {"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.type","operator":"equal","condition":"AND","value":["expense"],"references":null,"format":"list:transactionTypes","type":"STRING","variableValue":null,"variableValueType":null,"conditionType":"fixed","isDatePeriod":false,"translated":null},{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"this_month:this_month","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-12-22 19:47:13.661+00 2022-12-22 19:54:26.688+00 2022-12-22 19:54:26.685+00 77 77 77 77 REL-003983 matrix testestestrstresw transaction
{"type":"column","categories":"transaction.date","values":[{"column":"transaction.final_value","rawColumn":"transaction.final_value__sum__","summarizer":"sum","axis":0,"isMainValue":true}],"legend":{"enabled":true}} 2 3982 {"table":"transaction","relationships":["item"],"type":"matrix","fields":[{"table":"item","column":"cf_943","type":"STRING","showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null},{"table":"transaction","column":"date","type":"DATE","date_config":["month","year"],"showAt":{"inner":true,"total":true},"showInHours":false,"format":null,"daysEvaluatedColumns":null,"is_full_period":false},{"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}],"filters":[{"field":"transaction.date","operator":"dynamic_period","condition":"AND","value":"last_month:last_month","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":"item","column":"cf_943","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}],"groupBy":[]} 2022-12-22 19:41:05.207+00 2022-12-22 19:54:31.833+00 2022-12-22 19:54:31.831+00 77 77 77 77 REL-003982 matrix teste rg log transaction