Lançamentos contábeis, rateios e contas atuais — Pro
Notas, contas e centros de custo com valores nativos, sem totais presumidos.
NÃO OFICIAL — NÃO VALIDADA EM UMA INSTALAÇÃO ERP REAL. Para contabilidade e controladoria: escolha empresa, filial e período. Consulte o lançamento com débito e crédito, descrições e classificações atuais, valor nativo, histórico, complemento, lote e data extemporânea. Abra os rateios por centro de custo e as contas atuais em dois sub-botões; a leitura relacionada acontece ao abrir o botão.
Por que Cifru? Adapte as configurações à sua forma de trabalhar. Escolha os campos, filtros e detalhes de que precisa e leve para o celular informações que talvez não estejam disponíveis no aplicativo móvel do seu sistema de gestão. As possibilidades dependem dos dados acessíveis na fonte autorizada e do seu plano Cifru.
Pro: uma fonte, três listas, dois sub-botões; SELECT explícito, até 2.000 resultados por leitura, live e sem atualização periódica. Empresa, filial e período são filtros de consulta, não permissões de acesso nem garantia de custo baixo. Não totaliza despesas, receitas, saldo, lucro ou DRE. Débito e crédito não são somados como dois gastos.
O relatório NÃO fornece a unidade monetária. Confira-a na contabilidade do ERP antes de interpretar os valores. Exibe a representação nativa, sem símbolo, câmbio, arredondamento ou soma de valores. Rateios são grupos pelos campos selecionados e pelo valor nativo: o valor exibido é por linha, e a contagem informa quantas linhas têm esses mesmos campos. A contagem não é um multiplicador nem prova que os demais campos físicos sejam iguais. Não inventa uma sequência de rateio ou reconstrói contrapartidas. Zero, negativos, NULL e códigos desconhecidos não são transformados em outros significados.
A filial do rateio pode ser distinta da filial do lançamento; não impomos igualdade não documentada. Os cadastros são atuais, não snapshots históricos. Cadastros ausentes não eliminam registros; correspondências ambíguas de lançamento/conta/centro são recusadas pelo SELECT. Resultados vazios ou incompletos não provam inexistência de lançamentos: podem decorrer de limites, filtros, ambiguidades ou ausência de dados autorizados.
Pré-requisito: administrador confirma leitura autorizada dos quatro objetos dbo e colunas/tipos da instalação 5.10.4 SQL Server. dbo é contrato deste adaptador, não owner universal certificado. SQL direto não herda a sessão ou permissões Senior. Use leitor restrito a empresas/filiais autorizadas, inclusive para histórico livre. Não inclui CPF/CNPJ, banco, servidor ou credenciais. E648LCT convertido e tabelas históricas _HIS não estão incluídos. Não Oracle, GO UP, Senior X ou SeniorERP romeno.
Documentação selecionada e dados sintéticos; não validado em uma instalação ERP real, SQL Server ou iOS. Collation, índices, precisão física e desempenho precisam ser verificados na fonte. Não há promessa de compatibilidade com qualquer versão.
Documentação física/funcional: https://documentacao.senior.com.br/gestaoempresarialerp/5.10.4/menu_controladoria/f000inr_sql.htm
https://documentacao.senior.com.br/gestaoempresarialerp/5.10.4/menu_controladoria/f640lct.htm
Cobertura da galeria: 7 imagens complementares: cartão principal completo, os 18 campos úteis da nota, os 11 campos dos grupos de rateio e os quatro do cadastro atual da conta; ambos os sub-botões efetivamente abertos com cartões completos e continuações de Detalhes. Um registro representativo por rota, não todos os casos/empresas/estados. Cifru Android nativo com dados inteiramente fictícios e transporte sintético local, não conexão ou teste de ERP/SQL Server/iOS ou compra Pro. Valores nativos, sem unidade monetária fornecida ou totais inferidos. Home, filtros e RAW são privados; guia de fonte separado.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Lançamentos e rateios
- Details: Rateios por centro
- Details: Contas da nota
- Sub-button: Rateios por valor
- Sub-button: Contas da nota
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(CASE WHEN t.CODEMP IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODEMP)),N':',CONVERT(nvarchar(max),t.CODEMP)) END,N'|',CASE WHEN t.CODFIL IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODFIL)),N':',CONVERT(nvarchar(max),t.CODFIL)) END,N'|',CASE WHEN t.NUMLCT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.NUMLCT)),N':',CONVERT(nvarchar(max),t.NUMLCT)) END,N'|',CASE WHEN CONVERT(varchar(30),t.DATLCT,126) IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))),N':',CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))) END) AS EntryKey, t.CODEMP AS CompanyID, t.CODFIL AS BranchID, t.NUMLCT AS EntryID, CONCAT(N'D',CONVERT(varchar(30),t.DATLCT,126)) AS DateContext, t.CODEMP AS Company, t.CODFIL AS Branch, t.NUMLCT AS EntryNumber, t.DATLCT AS EntryDate, t.DATEXT AS ExtemporaneousDate, t.CTADEB AS DebitAccount, t.CTACRE AS CreditAccount, t.CODHPD AS HistoryCode, t.CPLLCT AS Complement, t.NUMLOT AS Lot, t.SITLCT AS EntryStatus, t.TIPLCT AS EntryType, CASE WHEN t.CTADEB IS NULL OR t.CTADEB=0 THEN N'Sem conta informada' ELSE COALESCE(d.DESCTA,N'Cadastro atual não disponível') END AS DebitName, CASE WHEN t.CTACRE IS NULL OR t.CTACRE=0 THEN N'Sem conta informada' ELSE COALESCE(c.DESCTA,N'Cadastro atual não disponível') END AS CreditName, d.CLACTA AS DebitClassification, c.CLACTA AS CreditClassification, CONVERT(varchar(80),t.VLRLCT) AS RecordedAmount, N'Valor nativo; unidade monetária não fornecida por este relatório' AS MonetaryContext FROM dbo.E640LCT t LEFT JOIN dbo.E045PLA d ON d.CODEMP=t.CODEMP AND d.CTARED=t.CTADEB LEFT JOIN dbo.E045PLA c ON c.CODEMP=t.CODEMP AND c.CTARED=t.CTACRE WHERE t.CODEMP IS NOT NULL AND t.CODFIL IS NOT NULL AND t.NUMLCT IS NOT NULL AND (SELECT COUNT(1) FROM dbo.E640LCT z WHERE z.CODEMP=t.CODEMP AND z.NUMLCT=t.NUMLCT)=1 AND (SELECT COUNT(1) FROM dbo.E045PLA q WHERE q.CODEMP=t.CODEMP AND q.CTARED=t.CTADEB)<=1 AND (SELECT COUNT(1) FROM dbo.E045PLA q WHERE q.CODEMP=t.CODEMP AND q.CTARED=t.CTACRE)<=1
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CASE WHEN g.CODEMP IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.CODEMP)),N':',CONVERT(nvarchar(max),g.CODEMP)) END,N'|',CASE WHEN g.NUMLCT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.NUMLCT)),N':',CONVERT(nvarchar(max),g.NUMLCT)) END,N'|',CASE WHEN g.FILRAT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.FILRAT)),N':',CONVERT(nvarchar(max),g.FILRAT)) END,N'|',CASE WHEN CONVERT(varchar(30),g.DATLCT,126) IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),CONVERT(varchar(30),g.DATLCT,126))),N':',CONVERT(nvarchar(max),CONVERT(varchar(30),g.DATLCT,126))) END,N'|',CASE WHEN g.CTARED IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.CTARED)),N':',CONVERT(nvarchar(max),g.CTARED)) END,N'|',CASE WHEN g.CODCCU IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.CODCCU)),N':',CONVERT(nvarchar(max),g.CODCCU)) END,N'|',CASE WHEN g.DEBCRE IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.DEBCRE)),N':',CONVERT(nvarchar(max),g.DEBCRE)) END,N'|',CASE WHEN g.SITRAT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.SITRAT)),N':',CONVERT(nvarchar(max),g.SITRAT)) END,N'|',CASE WHEN g.NativeValue IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.NativeValue)),N':',CONVERT(nvarchar(max),g.NativeValue)) END) AS AllocationKey, CONCAT(CASE WHEN t.CODEMP IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODEMP)),N':',CONVERT(nvarchar(max),t.CODEMP)) END,N'|',CASE WHEN t.CODFIL IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODFIL)),N':',CONVERT(nvarchar(max),t.CODFIL)) END,N'|',CASE WHEN t.NUMLCT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.NUMLCT)),N':',CONVERT(nvarchar(max),t.NUMLCT)) END,N'|',CASE WHEN CONVERT(varchar(30),t.DATLCT,126) IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))),N':',CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))) END) AS EntryKey, t.CODEMP AS CompanyID, t.CODFIL AS BranchID, t.NUMLCT AS EntryID, CONCAT(N'D',CONVERT(varchar(30),t.DATLCT,126)) AS DateContext, g.CODCCU AS CentreCode, COALESCE(n.DESCCU,N'Cadastro atual não disponível') AS CentreName, g.CTARED AS AccountCode, COALESCE(a.DESCTA,N'Cadastro atual não disponível') AS AccountName, CASE g.DEBCRE WHEN N'D' THEN N'D · Débito' WHEN N'C' THEN N'C · Crédito' ELSE COALESCE(g.DEBCRE,N'Não informada') END AS Nature, g.FILRAT AS AllocationBranch, g.DATLCT AS AllocationDate, g.SITRAT AS AllocationStatus, g.NativeRows AS GroupedRows, CONVERT(varchar(80),g.NativeValue) AS GroupedAmount, N'Valor nativo; unidade monetária não fornecida por este relatório' AS MonetaryContext FROM (SELECT r.CODEMP, r.NUMLCT, r.FILRAT, r.DATLCT, r.CTARED, r.CODCCU, r.DEBCRE, r.SITRAT, r.VLRRAT AS NativeValue, COUNT(1) AS NativeRows FROM dbo.E640RAT r WHERE r.CODEMP=:company AND r.NUMLCT=:entry GROUP BY r.CODEMP, r.NUMLCT, r.FILRAT, r.DATLCT, r.CTARED, r.CODCCU, r.DEBCRE, r.SITRAT, r.VLRRAT) g INNER JOIN dbo.E640LCT t ON t.CODEMP=g.CODEMP AND t.NUMLCT=g.NUMLCT LEFT JOIN dbo.E044CCU n ON n.CODEMP=g.CODEMP AND n.CODCCU=g.CODCCU LEFT JOIN dbo.E045PLA a ON a.CODEMP=g.CODEMP AND a.CTARED=g.CTARED WHERE t.CODEMP=:company AND t.CODFIL=:branch AND t.NUMLCT=:entry AND CONCAT(N'D',CONVERT(varchar(30),t.DATLCT,126))=:date_context AND (SELECT COUNT(1) FROM dbo.E640LCT z WHERE z.CODEMP=t.CODEMP AND z.NUMLCT=t.NUMLCT)=1 AND (SELECT COUNT(1) FROM dbo.E045PLA q WHERE q.CODEMP=g.CODEMP AND q.CTARED=g.CTARED)<=1 AND (SELECT COUNT(1) FROM dbo.E044CCU u WHERE u.CODEMP=g.CODEMP AND u.CODCCU=g.CODCCU)<=1
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CONCAT(CASE WHEN t.CODEMP IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODEMP)),N':',CONVERT(nvarchar(max),t.CODEMP)) END,N'|',CASE WHEN t.CODFIL IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODFIL)),N':',CONVERT(nvarchar(max),t.CODFIL)) END,N'|',CASE WHEN t.NUMLCT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.NUMLCT)),N':',CONVERT(nvarchar(max),t.NUMLCT)) END,N'|',CASE WHEN CONVERT(varchar(30),t.DATLCT,126) IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))),N':',CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))) END),N'|',CASE WHEN a.CTARED IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),a.CTARED)),N':',CONVERT(nvarchar(max),a.CTARED)) END) AS AccountKey, CONCAT(CASE WHEN t.CODEMP IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODEMP)),N':',CONVERT(nvarchar(max),t.CODEMP)) END,N'|',CASE WHEN t.CODFIL IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODFIL)),N':',CONVERT(nvarchar(max),t.CODFIL)) END,N'|',CASE WHEN t.NUMLCT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.NUMLCT)),N':',CONVERT(nvarchar(max),t.NUMLCT)) END,N'|',CASE WHEN CONVERT(varchar(30),t.DATLCT,126) IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))),N':',CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))) END) AS EntryKey, t.CODEMP AS CompanyID, t.CODFIL AS BranchID, t.NUMLCT AS EntryID, CONCAT(N'D',CONVERT(varchar(30),t.DATLCT,126)) AS DateContext, a.CTARED AS AccountCode, a.DESCTA AS AccountName, a.CLACTA AS AccountClassification, CASE a.ANASIN WHEN N'A' THEN N'Analítica' WHEN N'S' THEN N'Sintética' ELSE COALESCE(a.ANASIN,N'Não informada') END AS AccountKind FROM dbo.E045PLA a INNER JOIN dbo.E640LCT t ON a.CODEMP=t.CODEMP AND (a.CTARED=t.CTADEB OR a.CTARED=t.CTACRE) WHERE t.CODEMP=:company AND t.CODFIL=:branch AND t.NUMLCT=:entry AND CONCAT(N'D',CONVERT(varchar(30),t.DATLCT,126))=:date_context AND (SELECT COUNT(1) FROM dbo.E640LCT z WHERE z.CODEMP=t.CODEMP AND z.NUMLCT=t.NUMLCT)=1 AND (SELECT COUNT(1) FROM dbo.E045PLA q WHERE q.CODEMP=a.CODEMP AND q.CTARED=a.CTARED)<=1
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Senior Gestão Empresarial — SQL Server",
"id": "D50EF799-19E0-50F6-88C1-B7B6CC454986",
"kind": "sqlServer",
"requiredObjects": [
"dbo.E044CCU",
"dbo.E045PLA",
"dbo.E640LCT",
"dbo.E640RAT"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Senior Gestão Empresarial",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "9B778DF2-8864-5D75-B52B-B65C02445B73",
"key": "EntryDate",
"type": "date"
},
{
"direction": "ascending",
"id": "28208454-97DF-56AF-968F-43A5D7841192",
"key": "EntryKey",
"type": "text"
}
],
"id": "AE1C26E2-369A-5DF6-96A3-75980896F436",
"mappings": [
{
"commonFieldKey": "",
"key": "EntryKey",
"label": "Chave interna do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EntryKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyID",
"label": "Contexto interno da empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BranchID",
"label": "Contexto interno da filial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BranchID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryID",
"label": "Contexto interno do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DateContext",
"label": "Contexto interno da data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DateContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Company",
"label": "Empresa (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Company",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Branch",
"label": "Filial do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Branch",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EntryNumber",
"label": "Referência do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryNumber",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EntryDate",
"label": "Data do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ExtemporaneousDate",
"label": "Data extemporânea registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExtemporaneousDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DebitAccount",
"label": "Conta reduzida — débito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DebitAccount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CreditAccount",
"label": "Conta reduzida — crédito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CreditAccount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HistoryCode",
"label": "Histórico padrão (referência)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HistoryCode",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Complement",
"label": "Complemento do histórico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Complement",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Lot",
"label": "Lote (referência)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Lot",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryStatus",
"label": "Situação do lançamento — código ERP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EntryStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryType",
"label": "Tipo do lançamento — código ERP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EntryType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DebitName",
"label": "Conta de débito — descrição atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DebitName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CreditName",
"label": "Conta de crédito — descrição atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DebitClassification",
"label": "Classificação atual — débito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DebitClassification",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CreditClassification",
"label": "Classificação atual — crédito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditClassification",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RecordedAmount",
"label": "Valor registrado do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RecordedAmount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MonetaryContext",
"label": "Unidade dos valores",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MonetaryContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Lançamentos e rateios",
"primaryKey": "EntryKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Complement",
"EntryStatus",
"EntryType",
"DebitName",
"CreditName",
"DebitClassification",
"CreditClassification",
"RecordedAmount",
"MonetaryContext"
],
"sourceID": "D50EF799-19E0-50F6-88C1-B7B6CC454986",
"sqlQuery": "SELECT CONCAT(CASE WHEN t.CODEMP IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODEMP)),N':',CONVERT(nvarchar(max),t.CODEMP)) END,N'|',CASE WHEN t.CODFIL IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODFIL)),N':',CONVERT(nvarchar(max),t.CODFIL)) END,N'|',CASE WHEN t.NUMLCT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.NUMLCT)),N':',CONVERT(nvarchar(max),t.NUMLCT)) END,N'|',CASE WHEN CONVERT(varchar(30),t.DATLCT,126) IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))),N':',CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))) END) AS EntryKey, t.CODEMP AS CompanyID, t.CODFIL AS BranchID, t.NUMLCT AS EntryID, CONCAT(N'D',CONVERT(varchar(30),t.DATLCT,126)) AS DateContext, t.CODEMP AS Company, t.CODFIL AS Branch, t.NUMLCT AS EntryNumber, t.DATLCT AS EntryDate, t.DATEXT AS ExtemporaneousDate, t.CTADEB AS DebitAccount, t.CTACRE AS CreditAccount, t.CODHPD AS HistoryCode, t.CPLLCT AS Complement, t.NUMLOT AS Lot, t.SITLCT AS EntryStatus, t.TIPLCT AS EntryType, CASE WHEN t.CTADEB IS NULL OR t.CTADEB=0 THEN N'Sem conta informada' ELSE COALESCE(d.DESCTA,N'Cadastro atual não disponível') END AS DebitName, CASE WHEN t.CTACRE IS NULL OR t.CTACRE=0 THEN N'Sem conta informada' ELSE COALESCE(c.DESCTA,N'Cadastro atual não disponível') END AS CreditName, d.CLACTA AS DebitClassification, c.CLACTA AS CreditClassification, CONVERT(varchar(80),t.VLRLCT) AS RecordedAmount, N'Valor nativo; unidade monetária não fornecida por este relatório' AS MonetaryContext FROM dbo.E640LCT t LEFT JOIN dbo.E045PLA d ON d.CODEMP=t.CODEMP AND d.CTARED=t.CTADEB LEFT JOIN dbo.E045PLA c ON c.CODEMP=t.CODEMP AND c.CTARED=t.CTACRE WHERE t.CODEMP IS NOT NULL AND t.CODFIL IS NOT NULL AND t.NUMLCT IS NOT NULL AND (SELECT COUNT(1) FROM dbo.E640LCT z WHERE z.CODEMP=t.CODEMP AND z.NUMLCT=t.NUMLCT)=1 AND (SELECT COUNT(1) FROM dbo.E045PLA q WHERE q.CODEMP=t.CODEMP AND q.CTARED=t.CTADEB)<=1 AND (SELECT COUNT(1) FROM dbo.E045PLA q WHERE q.CODEMP=t.CODEMP AND q.CTARED=t.CTACRE)<=1",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Senior Gestão Empresarial",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "40BA2E5B-F167-5A36-AE4D-362F809A344D",
"key": "AllocationDate",
"type": "date"
},
{
"direction": "ascending",
"id": "05298CA0-52AE-5059-A69C-ACE2FC4F7EFD",
"key": "AllocationKey",
"type": "text"
}
],
"id": "816416BB-C107-540C-8CD5-B783DBFBCE68",
"mappings": [
{
"commonFieldKey": "",
"key": "AllocationKey",
"label": "Chave interna do grupo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AllocationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryKey",
"label": "Chave interna do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EntryKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyID",
"label": "Contexto interno da empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BranchID",
"label": "Contexto interno da filial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BranchID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryID",
"label": "Contexto interno do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DateContext",
"label": "Contexto interno da data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DateContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CentreCode",
"label": "Centro de custo (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CentreCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CentreName",
"label": "Centro de custo — descrição atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CentreName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountCode",
"label": "Conta reduzida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountCode",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountName",
"label": "Conta — descrição atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Nature",
"label": "Débito / crédito registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Nature",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationBranch",
"label": "Filial do rateio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationBranch",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationDate",
"label": "Data registrada no rateio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationStatus",
"label": "Situação do rateio — código ERP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AllocationStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "GroupedRows",
"label": "Linhas com os mesmos campos selecionados",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "GroupedRows",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "GroupedAmount",
"label": "Valor nativo por linha deste grupo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "GroupedAmount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MonetaryContext",
"label": "Unidade dos valores",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MonetaryContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Rateios por valor",
"primaryKey": "AllocationKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyID",
"id": "50EEA77F-6B82-5BD5-9876-D0BFF00779F8",
"name": "company",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "BranchID",
"id": "BC1D25FF-6BC1-5D05-84E0-A20C60CFBFB8",
"name": "branch",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "EntryID",
"id": "4CE452D7-1655-5C5B-98E7-DBB3AA884AB7",
"name": "entry",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DateContext",
"id": "62237C1F-8C3A-583A-BDAD-767E298CC77C",
"name": "date_context",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CentreCode",
"CentreName",
"AccountName",
"Nature",
"AllocationStatus",
"GroupedAmount",
"MonetaryContext"
],
"sourceID": "D50EF799-19E0-50F6-88C1-B7B6CC454986",
"sqlQuery": "SELECT CONCAT(CASE WHEN g.CODEMP IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.CODEMP)),N':',CONVERT(nvarchar(max),g.CODEMP)) END,N'|',CASE WHEN g.NUMLCT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.NUMLCT)),N':',CONVERT(nvarchar(max),g.NUMLCT)) END,N'|',CASE WHEN g.FILRAT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.FILRAT)),N':',CONVERT(nvarchar(max),g.FILRAT)) END,N'|',CASE WHEN CONVERT(varchar(30),g.DATLCT,126) IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),CONVERT(varchar(30),g.DATLCT,126))),N':',CONVERT(nvarchar(max),CONVERT(varchar(30),g.DATLCT,126))) END,N'|',CASE WHEN g.CTARED IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.CTARED)),N':',CONVERT(nvarchar(max),g.CTARED)) END,N'|',CASE WHEN g.CODCCU IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.CODCCU)),N':',CONVERT(nvarchar(max),g.CODCCU)) END,N'|',CASE WHEN g.DEBCRE IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.DEBCRE)),N':',CONVERT(nvarchar(max),g.DEBCRE)) END,N'|',CASE WHEN g.SITRAT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.SITRAT)),N':',CONVERT(nvarchar(max),g.SITRAT)) END,N'|',CASE WHEN g.NativeValue IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),g.NativeValue)),N':',CONVERT(nvarchar(max),g.NativeValue)) END) AS AllocationKey, CONCAT(CASE WHEN t.CODEMP IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODEMP)),N':',CONVERT(nvarchar(max),t.CODEMP)) END,N'|',CASE WHEN t.CODFIL IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODFIL)),N':',CONVERT(nvarchar(max),t.CODFIL)) END,N'|',CASE WHEN t.NUMLCT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.NUMLCT)),N':',CONVERT(nvarchar(max),t.NUMLCT)) END,N'|',CASE WHEN CONVERT(varchar(30),t.DATLCT,126) IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))),N':',CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))) END) AS EntryKey, t.CODEMP AS CompanyID, t.CODFIL AS BranchID, t.NUMLCT AS EntryID, CONCAT(N'D',CONVERT(varchar(30),t.DATLCT,126)) AS DateContext, g.CODCCU AS CentreCode, COALESCE(n.DESCCU,N'Cadastro atual não disponível') AS CentreName, g.CTARED AS AccountCode, COALESCE(a.DESCTA,N'Cadastro atual não disponível') AS AccountName, CASE g.DEBCRE WHEN N'D' THEN N'D · Débito' WHEN N'C' THEN N'C · Crédito' ELSE COALESCE(g.DEBCRE,N'Não informada') END AS Nature, g.FILRAT AS AllocationBranch, g.DATLCT AS AllocationDate, g.SITRAT AS AllocationStatus, g.NativeRows AS GroupedRows, CONVERT(varchar(80),g.NativeValue) AS GroupedAmount, N'Valor nativo; unidade monetária não fornecida por este relatório' AS MonetaryContext FROM (SELECT r.CODEMP, r.NUMLCT, r.FILRAT, r.DATLCT, r.CTARED, r.CODCCU, r.DEBCRE, r.SITRAT, r.VLRRAT AS NativeValue, COUNT(1) AS NativeRows FROM dbo.E640RAT r WHERE r.CODEMP=:company AND r.NUMLCT=:entry GROUP BY r.CODEMP, r.NUMLCT, r.FILRAT, r.DATLCT, r.CTARED, r.CODCCU, r.DEBCRE, r.SITRAT, r.VLRRAT) g INNER JOIN dbo.E640LCT t ON t.CODEMP=g.CODEMP AND t.NUMLCT=g.NUMLCT LEFT JOIN dbo.E044CCU n ON n.CODEMP=g.CODEMP AND n.CODCCU=g.CODCCU LEFT JOIN dbo.E045PLA a ON a.CODEMP=g.CODEMP AND a.CTARED=g.CTARED WHERE t.CODEMP=:company AND t.CODFIL=:branch AND t.NUMLCT=:entry AND CONCAT(N'D',CONVERT(varchar(30),t.DATLCT,126))=:date_context AND (SELECT COUNT(1) FROM dbo.E640LCT z WHERE z.CODEMP=t.CODEMP AND z.NUMLCT=t.NUMLCT)=1 AND (SELECT COUNT(1) FROM dbo.E045PLA q WHERE q.CODEMP=g.CODEMP AND q.CTARED=g.CTARED)<=1 AND (SELECT COUNT(1) FROM dbo.E044CCU u WHERE u.CODEMP=g.CODEMP AND u.CODCCU=g.CODCCU)<=1",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Senior Gestão Empresarial",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "846BE8DF-D787-5169-BE01-B6292DE0457C",
"key": "AccountCode",
"type": "number"
},
{
"direction": "ascending",
"id": "D5B71B7F-A683-5FCE-93DE-AFE3EBA82A9B",
"key": "AccountKey",
"type": "text"
}
],
"id": "0807D549-6F5F-5483-9476-3680DB2BFDB2",
"mappings": [
{
"commonFieldKey": "",
"key": "AccountKey",
"label": "Chave interna da conta no lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryKey",
"label": "Chave interna do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EntryKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyID",
"label": "Contexto interno da empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BranchID",
"label": "Contexto interno da filial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BranchID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryID",
"label": "Contexto interno do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DateContext",
"label": "Contexto interno da data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DateContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountCode",
"label": "Conta reduzida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountCode",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountName",
"label": "Conta — descrição atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountClassification",
"label": "Classificação atual da conta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountClassification",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountKind",
"label": "Analítica / sintética — cadastro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountKind",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Contas da nota",
"primaryKey": "AccountKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyID",
"id": "50EEA77F-6B82-5BD5-9876-D0BFF00779F8",
"name": "company",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "BranchID",
"id": "BC1D25FF-6BC1-5D05-84E0-A20C60CFBFB8",
"name": "branch",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "EntryID",
"id": "4CE452D7-1655-5C5B-98E7-DBB3AA884AB7",
"name": "entry",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DateContext",
"id": "62237C1F-8C3A-583A-BDAD-767E298CC77C",
"name": "date_context",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"AccountName",
"AccountClassification",
"AccountKind"
],
"sourceID": "D50EF799-19E0-50F6-88C1-B7B6CC454986",
"sqlQuery": "SELECT CONCAT(CONCAT(CASE WHEN t.CODEMP IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODEMP)),N':',CONVERT(nvarchar(max),t.CODEMP)) END,N'|',CASE WHEN t.CODFIL IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODFIL)),N':',CONVERT(nvarchar(max),t.CODFIL)) END,N'|',CASE WHEN t.NUMLCT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.NUMLCT)),N':',CONVERT(nvarchar(max),t.NUMLCT)) END,N'|',CASE WHEN CONVERT(varchar(30),t.DATLCT,126) IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))),N':',CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))) END),N'|',CASE WHEN a.CTARED IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),a.CTARED)),N':',CONVERT(nvarchar(max),a.CTARED)) END) AS AccountKey, CONCAT(CASE WHEN t.CODEMP IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODEMP)),N':',CONVERT(nvarchar(max),t.CODEMP)) END,N'|',CASE WHEN t.CODFIL IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.CODFIL)),N':',CONVERT(nvarchar(max),t.CODFIL)) END,N'|',CASE WHEN t.NUMLCT IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),t.NUMLCT)),N':',CONVERT(nvarchar(max),t.NUMLCT)) END,N'|',CASE WHEN CONVERT(varchar(30),t.DATLCT,126) IS NULL THEN N'N' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))),N':',CONVERT(nvarchar(max),CONVERT(varchar(30),t.DATLCT,126))) END) AS EntryKey, t.CODEMP AS CompanyID, t.CODFIL AS BranchID, t.NUMLCT AS EntryID, CONCAT(N'D',CONVERT(varchar(30),t.DATLCT,126)) AS DateContext, a.CTARED AS AccountCode, a.DESCTA AS AccountName, a.CLACTA AS AccountClassification, CASE a.ANASIN WHEN N'A' THEN N'Analítica' WHEN N'S' THEN N'Sintética' ELSE COALESCE(a.ANASIN,N'Não informada') END AS AccountKind FROM dbo.E045PLA a INNER JOIN dbo.E640LCT t ON a.CODEMP=t.CODEMP AND (a.CTARED=t.CTADEB OR a.CTARED=t.CTACRE) WHERE t.CODEMP=:company AND t.CODFIL=:branch AND t.NUMLCT=:entry AND CONCAT(N'D',CONVERT(varchar(30),t.DATLCT,126))=:date_context AND (SELECT COUNT(1) FROM dbo.E640LCT z WHERE z.CODEMP=t.CODEMP AND z.NUMLCT=t.NUMLCT)=1 AND (SELECT COUNT(1) FROM dbo.E045PLA q WHERE q.CODEMP=a.CODEMP AND q.CTARED=a.CTARED)<=1",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "27FCE24D-537B-50D5-8262-68CAB270F4F5",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "09E90B16-BBDC-5188-BBDC-02904CD25637",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "816416BB-C107-540C-8CD5-B783DBFBCE68",
"title": "Rateios por centro",
"urlKey": ""
},
{
"id": "5461EA28-5B49-50F4-A9D6-167122A4AA9A",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "BBEA745C-17B3-5CFE-A5EB-775C4BCB25EE",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "0807D549-6F5F-5483-9476-3680DB2BFDB2",
"title": "Contas da nota",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Company",
"label": "Empresa (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Branch",
"label": "Filial do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EntryDate",
"label": "Data do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DebitName",
"label": "Débito — cadastro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CreditName",
"label": "Crédito — cadastro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "RecordedAmount",
"label": "Valor registrado do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "AE1C26E2-369A-5DF6-96A3-75980896F436",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Company",
"label": "Empresa (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Branch",
"label": "Filial do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EntryNumber",
"label": "Referência do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EntryDate",
"label": "Data do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ExtemporaneousDate",
"label": "Data extemporânea registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DebitAccount",
"label": "Conta reduzida — débito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CreditAccount",
"label": "Conta reduzida — crédito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HistoryCode",
"label": "Histórico padrão (referência)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Complement",
"label": "Complemento do histórico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Lot",
"label": "Lote (referência)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EntryStatus",
"label": "Situação do lançamento — código ERP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EntryType",
"label": "Tipo do lançamento — código ERP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DebitName",
"label": "Conta de débito — descrição atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CreditName",
"label": "Conta de crédito — descrição atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DebitClassification",
"label": "Classificação atual — débito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CreditClassification",
"label": "Classificação atual — crédito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "RecordedAmount",
"label": "Valor registrado do lançamento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MonetaryContext",
"label": "Unidade dos valores",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "AAC696D6-C90E-5B82-AAC2-8EB01B5B6765",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "57EDC61E-B805-5A55-8259-D2D89CD71C94",
"includeAllOption": false,
"key": "EntryDate",
"title": "Período do lançamento",
"type": "date"
},
{
"id": "4BF88980-9B8D-50C1-9855-0539AB07083E",
"includeAllOption": false,
"key": "Company",
"title": "Empresa",
"type": "number"
},
{
"id": "09C34107-FD4B-5591-9028-2A11061533E4",
"includeAllOption": false,
"key": "Branch",
"title": "Filial do lançamento",
"type": "number"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "9B778DF2-8864-5D75-B52B-B65C02445B73",
"key": "EntryDate",
"type": "date"
},
{
"direction": "ascending",
"id": "28208454-97DF-56AF-968F-43A5D7841192",
"key": "EntryKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "EntryNumber",
"systemImage": "doc.text",
"title": "Lançamentos e rateios",
"titleKey": "Complement"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CentreCode",
"label": "Centro de custo (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Nature",
"label": "Débito / crédito registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocationBranch",
"label": "Filial do rateio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocationDate",
"label": "Data registrada no rateio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GroupedRows",
"label": "Linhas neste grupo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GroupedAmount",
"label": "Valor por linha",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "816416BB-C107-540C-8CD5-B783DBFBCE68",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CentreCode",
"label": "Centro de custo (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CentreName",
"label": "Centro de custo — descrição atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountCode",
"label": "Conta reduzida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountName",
"label": "Conta — descrição atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Nature",
"label": "Débito / crédito registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocationBranch",
"label": "Filial do rateio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocationDate",
"label": "Data registrada no rateio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocationStatus",
"label": "Situação do rateio — código ERP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GroupedRows",
"label": "Linhas com os mesmos campos selecionados",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GroupedAmount",
"label": "Valor nativo por linha deste grupo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MonetaryContext",
"label": "Unidade dos valores",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "BE33B7CD-BAD5-5CEA-AEFF-FB99EA4D97FE",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "40BA2E5B-F167-5A36-AE4D-362F809A344D",
"key": "AllocationDate",
"type": "date"
},
{
"direction": "ascending",
"id": "05298CA0-52AE-5059-A69C-ACE2FC4F7EFD",
"key": "AllocationKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountName",
"systemImage": "doc.text",
"title": "Rateios por valor",
"titleKey": "CentreName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountClassification",
"label": "Classificação atual da conta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountKind",
"label": "Tipo da conta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "0807D549-6F5F-5483-9476-3680DB2BFDB2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountCode",
"label": "Conta reduzida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountName",
"label": "Conta — descrição atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountClassification",
"label": "Classificação atual da conta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountKind",
"label": "Analítica / sintética — cadastro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "56B18186-D065-5398-AD09-750E2B1C126C",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "846BE8DF-D787-5169-BE01-B6292DE0457C",
"key": "AccountCode",
"type": "number"
},
{
"direction": "ascending",
"id": "D5B71B7F-A683-5FCE-93DE-AFE3EBA82A9B",
"key": "AccountKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountCode",
"systemImage": "doc.text",
"title": "Contas da nota",
"titleKey": "AccountName"
}
],
"relations": [
{
"childDatasetID": "816416BB-C107-540C-8CD5-B783DBFBCE68",
"childKey": "EntryKey",
"id": "09E90B16-BBDC-5188-BBDC-02904CD25637",
"name": "Rateios por centro",
"parentDatasetID": "AE1C26E2-369A-5DF6-96A3-75980896F436",
"parentKey": "EntryKey"
},
{
"childDatasetID": "0807D549-6F5F-5483-9476-3680DB2BFDB2",
"childKey": "EntryKey",
"id": "BBEA745C-17B3-5CFE-A5EB-775C4BCB25EE",
"name": "Contas da nota",
"parentDatasetID": "AE1C26E2-369A-5DF6-96A3-75980896F436",
"parentKey": "EntryKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Senior Gestão Empresarial",
"changelog": "Novo dossiê Pro de notas contábeis, grupos de rateio por valor e contas atuais; galeria nativa DEMO, não validado em ERP real.",
"configurationLanguages": [
"pt"
],
"countries": [
"BR"
],
"createdAt": "2026-10-11T00:00:00Z",
"description": "NÃO OFICIAL — NÃO VALIDADA EM UMA INSTALAÇÃO ERP REAL. Para contabilidade e controladoria: escolha empresa, filial e período. Consulte o lançamento com débito e crédito, descrições e classificações atuais, valor nativo, histórico, complemento, lote e data extemporânea. Abra os rateios por centro de custo e as contas atuais em dois sub-botões; a leitura relacionada acontece ao abrir o botão.\n\nPor que Cifru? Adapte as configurações à sua forma de trabalhar. Escolha os campos, filtros e detalhes de que precisa e leve para o celular informações que talvez não estejam disponíveis no aplicativo móvel do seu sistema de gestão. As possibilidades dependem dos dados acessíveis na fonte autorizada e do seu plano Cifru.\n\nPro: uma fonte, três listas, dois sub-botões; SELECT explícito, até 2.000 resultados por leitura, live e sem atualização periódica. Empresa, filial e período são filtros de consulta, não permissões de acesso nem garantia de custo baixo. Não totaliza despesas, receitas, saldo, lucro ou DRE. Débito e crédito não são somados como dois gastos.\n\nO relatório NÃO fornece a unidade monetária. Confira-a na contabilidade do ERP antes de interpretar os valores. Exibe a representação nativa, sem símbolo, câmbio, arredondamento ou soma de valores. Rateios são grupos pelos campos selecionados e pelo valor nativo: o valor exibido é por linha, e a contagem informa quantas linhas têm esses mesmos campos. A contagem não é um multiplicador nem prova que os demais campos físicos sejam iguais. Não inventa uma sequência de rateio ou reconstrói contrapartidas. Zero, negativos, NULL e códigos desconhecidos não são transformados em outros significados.\n\nA filial do rateio pode ser distinta da filial do lançamento; não impomos igualdade não documentada. Os cadastros são atuais, não snapshots históricos. Cadastros ausentes não eliminam registros; correspondências ambíguas de lançamento/conta/centro são recusadas pelo SELECT. Resultados vazios ou incompletos não provam inexistência de lançamentos: podem decorrer de limites, filtros, ambiguidades ou ausência de dados autorizados.\n\nPré-requisito: administrador confirma leitura autorizada dos quatro objetos dbo e colunas/tipos da instalação 5.10.4 SQL Server. dbo é contrato deste adaptador, não owner universal certificado. SQL direto não herda a sessão ou permissões Senior. Use leitor restrito a empresas/filiais autorizadas, inclusive para histórico livre. Não inclui CPF/CNPJ, banco, servidor ou credenciais. E648LCT convertido e tabelas históricas _HIS não estão incluídos. Não Oracle, GO UP, Senior X ou SeniorERP romeno.\n\nDocumentação selecionada e dados sintéticos; não validado em uma instalação ERP real, SQL Server ou iOS. Collation, índices, precisão física e desempenho precisam ser verificados na fonte. Não há promessa de compatibilidade com qualquer versão.\n\nDocumentação física/funcional: https://documentacao.senior.com.br/gestaoempresarialerp/5.10.4/menu_controladoria/f000inr_sql.htm\nhttps://documentacao.senior.com.br/gestaoempresarialerp/5.10.4/menu_controladoria/f640lct.htm\n\nCobertura da galeria: 7 imagens complementares: cartão principal completo, os 18 campos úteis da nota, os 11 campos dos grupos de rateio e os quatro do cadastro atual da conta; ambos os sub-botões efetivamente abertos com cartões completos e continuações de Detalhes. Um registro representativo por rota, não todos os casos/empresas/estados. Cifru Android nativo com dados inteiramente fictícios e transporte sintético local, não conexão ou teste de ERP/SQL Server/iOS ou compra Pro. Valores nativos, sem unidade monetária fornecida ou totais inferidos. Home, filtros e RAW são privados; guia de fonte separado.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "3FDD12E2-5913-57A4-8ED6-60501BD2A7E4",
"rootButtonCount": 1,
"summary": "Notas, contas e centros de custo com valores nativos, sem totais presumidos.",
"tags": [
"Senior Gestão Empresarial",
"SQL Server",
"Contabilidade",
"Controladoria",
"Centros de custo",
"Pro"
],
"title": "Lançamentos contábeis, rateios e contas atuais — Pro"
}
}