Títulos a pagar, movimentos e fornecedor — Pro
Vencimentos, saldo atual, negociação e dois sub-botões por empresa/filial.
NÃO OFICIAL — NÃO VALIDADA EM UMA INSTALAÇÃO ERP REAL. Para contas a pagar, compras, tesouraria e gestão: escolha empresa, filial e período de vencimento antes da leitura. Veja o fornecedor, a situação nativa, os vencimentos, o pagamento provável, o valor original e o saldo atual. Abra Movimentos registrados para consultar transação, datas de movimento e pagamento, valor registrado e líquido; ou Fornecedor atual para contatos e endereço. Detalhes mostram também os parâmetros de moeda, descontos e negociação, com referências à nota e ordem de compra.
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 SQL Server, três listas com Detalhes completos e dois sub-botões sob demanda. Somente SELECT; até 2.000 linhas por leitura, sem refresh periódico. O período é do vencimento prorrogado, não da emissão nem do movimento. O saldo é atual, não histórico na data selecionada. Estreitamento de filtros e limite de linhas não garantem consulta barata: confira índices, timeout e plano de execução. Busca/filtros locais atuam somente nas linhas carregadas e não são autorização entre empresas/filiais.
A identidade inclui empresa, filial, número textual, tipo E fornecedor; os movimentos acrescentam a sequência. Preserva zeros à esquerda, espaços internos e delimitadores. Os dois sub-botões revalidam toda essa chave. Mantém títulos cancelados, liquidados, créditos, valores negativos, zeros, NULL e códigos desconhecidos; a situação não é inferida da data ou do saldo. Cadastro do fornecedor é atual, não snapshot histórico; ausência do cadastro não elimina o título. Referências numéricas não são links nem prova de autorização fiscal.
Valores monetários originais são apresentados como texto sem arredondamento imposto. A denominação dos valores registrados vem do país da empresa, separada da moeda/índice base do título e das cotações. Moeda ausente é avisada, nunca substituída por BRL/R$ ou pela moeda base do título. Confira a unidade na instalação. Juros, multa, desconto, outros negociados e sua validade são parâmetros registrados, não valores calculados para pagar hoje. Sem soma multimoeda, câmbio, saldo reconstruído ou cálculo de liquidação. Data do movimento e data de pagamento são distintas. Um movimento não é necessariamente saída de caixa; não executa pagamentos, baixas ou aprovações nem interpreta o módulo como permissão. Ausência de movimentos não prova pagamento ou saldo zero.
Sem CPF/CNPJ, contas bancárias, PIX, códigos de barras de pagamento ou credenciais. Use leitor SQL autorizado de mínimo privilégio; SQL direto não herda restrições do ERP. Notas livres e contatos podem ser confidenciais: revise direitos na fonte. O pacote não contém servidor, senha ou dados empresariais. Base documental Senior 5.10.4, dbo, SQL Server 2012+. Confirme unicidade das chaves/cadastros, tipos, collation e datas date/datetime na importação. Vencimentos anteriores a 1901 não entram; nenhuma data é inventada. Documentação de importação/API não é DDL físico instalado. Testes documentais/sintéticos e imagens DEMO não são testes ERP reais. Não se aplica automaticamente a Oracle, GO UP, Senior X ou SeniorERP da Romênia.
Documentação: https://documentacao.senior.com.br/gestaoempresarialerp/5.10.4/menu_recursos/consistencia_padrao_cpagar_e501tcp.htm
https://documentacao.senior.com.br/gestaoempresarialerp/5.10.4/menu_financas/f501tcp.htm
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Títulos a pagar
- Details: Movimentos registrados
- Details: Fornecedor atual
- Sub-button: Movimentos do título a pagar
- Sub-button: Fornecedor atual do título
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(t.CODEMP,N':',t.CODFIL,N':',t.CODFOR,N':',DATALENGTH(t.NUMTIT),N':',t.NUMTIT,N':',DATALENGTH(t.CODTPT),N':',t.CODTPT) AS TitleKey, t.CODEMP AS CompanyID, t.CODFIL AS BranchID, t.CODFOR AS SupplierID, CONCAT(N'T',t.NUMTIT) AS TitleContext, CONCAT(N'P',t.CODTPT) AS TypeContext, CONCAT(t.NUMTIT,N' / ',t.CODTPT) AS Title, COALESCE(NULLIF(s.NOMFOR,N''),N'Cadastro não disponível') AS Supplier, CASE t.SITTIT WHEN N'AO' THEN N'AO · Aberto ao Órgão de Proteção ao Crédito' WHEN N'AN' THEN N'AN · Aberto Negociação' WHEN N'AA' THEN N'AA · Aberto Advogado' WHEN N'AB' THEN N'AB · Aberto Normal' WHEN N'AC' THEN N'AC · Aberto Cartório' WHEN N'AE' THEN N'AE · Aberto Encontro de Contas' WHEN N'AI' THEN N'AI · Aberto Impostos' WHEN N'AJ' THEN N'AJ · Aberto Retorno Jurídico' WHEN N'AP' THEN N'AP · Aberto Protestado' WHEN N'AR' THEN N'AR · Aberto Representante' WHEN N'AS' THEN N'AS · Aberto Suspenso' WHEN N'AV' THEN N'AV · Aberto Gestão de Pessoas' WHEN N'AX' THEN N'AX · Aberto Externo' WHEN N'CA' THEN N'CA · Cancelado' WHEN N'CE' THEN N'CE · Aberto CE (Preparação Cobrança Escritural)' WHEN N'CO' THEN N'CO · Aberto Cobrança' WHEN N'LQ' THEN N'LQ · Liquidado Normal' WHEN N'LC' THEN N'LC · Liquidado Cartório' WHEN N'LI' THEN N'LI · Liquidado Impostos' WHEN N'LM' THEN N'LM · Liquidado Compensado' WHEN N'LO' THEN N'LO · Liquidado Cobrança' WHEN N'LP' THEN N'LP · Liquidado Protestado' WHEN N'LS' THEN N'LS · Liquidado Substituído' WHEN N'LV' THEN N'LV · Liquidado Gestão de Pessoas' WHEN N'LX' THEN N'LX · Liquidado Externo' WHEN N'PE' THEN N'PE · Aberto PE (Pagamento Eletrônico)' ELSE CASE WHEN t.SITTIT IS NULL THEN N'Não informada' ELSE CONCAT(N'Código nativo: ',t.SITTIT) END END AS Status, CASE WHEN NULLIF(p.CODMOE,N'') IS NULL THEN N'Não informada — conferir no ERP' ELSE CONCAT(p.CODMOE,CASE WHEN NULLIF(b.DESMOE,N'') IS NULL THEN N'' ELSE CONCAT(N' · ',b.DESMOE) END) END AS CompanyCurrency, CONCAT(t.CODTNS,CASE WHEN NULLIF(n.DESTNS,N'') IS NULL THEN N'' ELSE CONCAT(N' · ',n.DESTNS) END) AS TitleTransaction, t.CODEMP AS Company, t.CODFIL AS Branch, t.DATEMI AS IssueDate, t.VCTORI AS OriginalDue, t.VCTPRO AS CurrentDue, t.DATPPT AS PlannedPayment, t.DATDSC AS DiscountDate, t.DATNEG AS NegotiatedDate, CONVERT(varchar(80),t.VLRORI) AS OriginalAmount, CONVERT(varchar(80),t.VLRABE) AS OpenAmount, t.CODMOE AS TitleCurrency, CONVERT(varchar(80),t.COTEMI) AS IssueRate, t.OBSTCP AS Notes, CONVERT(varchar(80),t.VLRDSC) AS DiscountAmount, t.PERDSC AS DiscountPercent, CONVERT(varchar(80),t.JRSNEG) AS NegotiatedInterest, CONVERT(varchar(80),t.MULNEG) AS NegotiatedFine, CONVERT(varchar(80),t.DSCNEG) AS NegotiatedDiscount, CONVERT(varchar(80),t.OUTNEG) AS NegotiatedOther, CONVERT(varchar(80),t.COTNEG) AS NegotiatedRate, t.NUMNFC AS OriginInvoice, t.NUMOCP AS PurchaseOrder FROM dbo.E501TCP t LEFT JOIN dbo.E095FOR s ON s.CODFOR=t.CODFOR LEFT JOIN dbo.E001TNS n ON n.CODEMP=t.CODEMP AND n.CODTNS=t.CODTNS LEFT JOIN dbo.E070EMP e ON e.CODEMP=t.CODEMP LEFT JOIN dbo.E006PAI p ON p.CODPAI=e.CODPAI LEFT JOIN dbo.E031MOE b ON b.CODMOE=p.CODMOE WHERE t.CODEMP IS NOT NULL AND t.CODFIL IS NOT NULL AND t.NUMTIT IS NOT NULL AND t.CODTPT IS NOT NULL AND t.CODFOR IS NOT NULL AND t.VCTPRO>='19010101'
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CONCAT(m.CODEMP,N':',m.CODFIL,N':',m.CODFOR,N':',DATALENGTH(m.NUMTIT),N':',m.NUMTIT,N':',DATALENGTH(m.CODTPT),N':',m.CODTPT),N':',m.SEQMOV) AS MovementKey, CONCAT(m.CODEMP,N':',m.CODFIL,N':',m.CODFOR,N':',DATALENGTH(m.NUMTIT),N':',m.NUMTIT,N':',DATALENGTH(m.CODTPT),N':',m.CODTPT) AS TitleKey, m.CODEMP AS CompanyID, m.CODFIL AS BranchID, m.CODFOR AS SupplierID, CONCAT(N'T',m.NUMTIT) AS TitleContext, CONCAT(N'P',m.CODTPT) AS TypeContext, CONCAT(m.NUMTIT,N' / ',m.CODTPT) AS Title, CASE WHEN NULLIF(p.CODMOE,N'') IS NULL THEN N'Não informada — conferir no ERP' ELSE CONCAT(p.CODMOE,CASE WHEN NULLIF(b.DESMOE,N'') IS NULL THEN N'' ELSE CONCAT(N' · ',b.DESMOE) END) END AS CompanyCurrency, CONCAT(m.CODTNS,CASE WHEN NULLIF(n.DESTNS,N'') IS NULL THEN N'' ELSE CONCAT(N' · ',n.DESTNS) END) AS MovementTransaction, n.LISMOD AS MovementModule, m.SEQMOV AS MovementNumber, m.DATMOV AS MovementDate, m.DATPGT AS PaymentDate, CONVERT(varchar(80),m.VLRMOV) AS MovementAmount, CONVERT(varchar(80),m.VLRLIQ) AS MovementNet FROM dbo.E501MCP m INNER JOIN dbo.E501TCP t ON t.CODEMP=m.CODEMP AND t.CODFIL=m.CODFIL AND t.NUMTIT=m.NUMTIT AND t.CODTPT=m.CODTPT AND t.CODFOR=m.CODFOR LEFT JOIN dbo.E001TNS n ON n.CODEMP=m.CODEMP AND n.CODTNS=m.CODTNS LEFT JOIN dbo.E070EMP e ON e.CODEMP=m.CODEMP LEFT JOIN dbo.E006PAI p ON p.CODPAI=e.CODPAI LEFT JOIN dbo.E031MOE b ON b.CODMOE=p.CODMOE WHERE m.CODEMP=:company AND m.CODFIL=:branch AND m.CODFOR=:supplier AND CONCAT(N'T',m.NUMTIT)=:title_context AND CONCAT(N'P',m.CODTPT)=:type_context AND m.CODEMP IS NOT NULL AND m.CODFIL IS NOT NULL AND m.NUMTIT IS NOT NULL AND m.CODTPT IS NOT NULL AND m.CODFOR IS NOT NULL AND m.SEQMOV IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(t.CODEMP,N':',t.CODFIL,N':',t.CODFOR,N':',DATALENGTH(t.NUMTIT),N':',t.NUMTIT,N':',DATALENGTH(t.CODTPT),N':',t.CODTPT) AS TitleKey, t.CODEMP AS CompanyID, t.CODFIL AS BranchID, t.CODFOR AS SupplierID, CONCAT(N'T',t.NUMTIT) AS TitleContext, CONCAT(N'P',t.CODTPT) AS TypeContext, CASE s.SITFOR WHEN 'A' THEN N'Ativo' WHEN 'I' THEN N'Inativo' ELSE COALESCE(s.SITFOR,N'Não informada') END AS SupplierStatus, CASE s.TIPFOR WHEN 'J' THEN N'Pessoa jurídica' WHEN 'F' THEN N'Pessoa física' ELSE COALESCE(s.TIPFOR,N'Não informada') END AS PersonType, s.NOMFOR AS SupplierName, s.APEFOR AS TradeName, s.CIDFOR AS City, s.SIGUFS AS State, s.ENDFOR AS Street, s.NENFOR AS StreetNumber, s.CPLEND AS AddressExtra, s.BAIFOR AS District, s.FONFOR AS Phone, s.FONFO2 AS Phone2, s.FONFO3 AS Phone3, s.INTNET AS Email FROM dbo.E095FOR s INNER JOIN dbo.E501TCP t ON t.CODFOR=s.CODFOR WHERE t.CODEMP=:company AND t.CODFIL=:branch AND t.CODFOR=:supplier AND CONCAT(N'T',t.NUMTIT)=:title_context AND CONCAT(N'P',t.CODTPT)=:type_context AND t.CODEMP IS NOT NULL AND t.CODFIL IS NOT NULL AND t.NUMTIT IS NOT NULL AND t.CODTPT IS NOT NULL AND t.CODFOR IS NOT NULL
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Senior Gestão Empresarial — SQL Server",
"id": "8A275667-D941-5878-8BCF-84F8B8D987FE",
"kind": "sqlServer",
"requiredObjects": [
"dbo.E001TNS",
"dbo.E006PAI",
"dbo.E031MOE",
"dbo.E070EMP",
"dbo.E095FOR",
"dbo.E501MCP",
"dbo.E501TCP"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Senior Gestão Empresarial",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "A823AD41-2F2F-5735-9829-E2ABAC3341A2",
"key": "CurrentDue",
"type": "date"
},
{
"direction": "ascending",
"id": "F094C9A1-3511-5EF8-A6DF-28F2E4E65492",
"key": "TitleKey",
"type": "text"
}
],
"id": "F56922DD-FA2A-5DBB-8406-7E6B5AAC1AFF",
"mappings": [
{
"commonFieldKey": "",
"key": "TitleKey",
"label": "Chave interna do título",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TitleKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyID",
"label": "Chave interna da empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BranchID",
"label": "Chave interna da filial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BranchID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierID",
"label": "Chave interna do fornecedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TitleContext",
"label": "Contexto interno do título",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TitleContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TypeContext",
"label": "Contexto interno do tipo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TypeContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Title",
"label": "Título / tipo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Title",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Supplier",
"label": "Fornecedor atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Supplier",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Status",
"label": "Situação registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Status",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyCurrency",
"label": "Moeda da empresa — valores abaixo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TitleTransaction",
"label": "Transação do título",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TitleTransaction",
"type": "text",
"visibleInDetail": true,
"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 (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Branch",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "IssueDate",
"label": "Emissão",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IssueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginalDue",
"label": "Vencimento original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginalDue",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrentDue",
"label": "Vencimento prorrogado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CurrentDue",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PlannedPayment",
"label": "Pagamento provável",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PlannedPayment",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountDate",
"label": "Data do desconto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NegotiatedDate",
"label": "Validade da negociação",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NegotiatedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginalAmount",
"label": "Valor original registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OriginalAmount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OpenAmount",
"label": "Valor em aberto atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OpenAmount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TitleCurrency",
"label": "Moeda / índice base do título (parâmetro)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TitleCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IssueRate",
"label": "Cotação de emissão registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "IssueRate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Notes",
"label": "Observação do título",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Notes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountAmount",
"label": "Desconto registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DiscountAmount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountPercent",
"label": "Desconto registrado (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountPercent",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NegotiatedInterest",
"label": "Juros negociados registrados",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NegotiatedInterest",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NegotiatedFine",
"label": "Multa negociada registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NegotiatedFine",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NegotiatedDiscount",
"label": "Desconto negociado registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NegotiatedDiscount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NegotiatedOther",
"label": "Outros negociados registrados",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NegotiatedOther",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NegotiatedRate",
"label": "Cotação negociada registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NegotiatedRate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginInvoice",
"label": "Nota de entrada ERP (referência)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginInvoice",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchaseOrder",
"label": "Ordem de compra (referência)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PurchaseOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Títulos a pagar",
"primaryKey": "TitleKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Title",
"Supplier",
"Status",
"CompanyCurrency",
"TitleTransaction",
"OriginalAmount",
"OpenAmount",
"TitleCurrency",
"IssueRate",
"Notes",
"DiscountAmount",
"NegotiatedInterest",
"NegotiatedFine",
"NegotiatedDiscount",
"NegotiatedOther",
"NegotiatedRate"
],
"sourceID": "8A275667-D941-5878-8BCF-84F8B8D987FE",
"sqlQuery": "SELECT CONCAT(t.CODEMP,N':',t.CODFIL,N':',t.CODFOR,N':',DATALENGTH(t.NUMTIT),N':',t.NUMTIT,N':',DATALENGTH(t.CODTPT),N':',t.CODTPT) AS TitleKey, t.CODEMP AS CompanyID, t.CODFIL AS BranchID, t.CODFOR AS SupplierID, CONCAT(N'T',t.NUMTIT) AS TitleContext, CONCAT(N'P',t.CODTPT) AS TypeContext, CONCAT(t.NUMTIT,N' / ',t.CODTPT) AS Title, COALESCE(NULLIF(s.NOMFOR,N''),N'Cadastro não disponível') AS Supplier, CASE t.SITTIT WHEN N'AO' THEN N'AO · Aberto ao Órgão de Proteção ao Crédito' WHEN N'AN' THEN N'AN · Aberto Negociação' WHEN N'AA' THEN N'AA · Aberto Advogado' WHEN N'AB' THEN N'AB · Aberto Normal' WHEN N'AC' THEN N'AC · Aberto Cartório' WHEN N'AE' THEN N'AE · Aberto Encontro de Contas' WHEN N'AI' THEN N'AI · Aberto Impostos' WHEN N'AJ' THEN N'AJ · Aberto Retorno Jurídico' WHEN N'AP' THEN N'AP · Aberto Protestado' WHEN N'AR' THEN N'AR · Aberto Representante' WHEN N'AS' THEN N'AS · Aberto Suspenso' WHEN N'AV' THEN N'AV · Aberto Gestão de Pessoas' WHEN N'AX' THEN N'AX · Aberto Externo' WHEN N'CA' THEN N'CA · Cancelado' WHEN N'CE' THEN N'CE · Aberto CE (Preparação Cobrança Escritural)' WHEN N'CO' THEN N'CO · Aberto Cobrança' WHEN N'LQ' THEN N'LQ · Liquidado Normal' WHEN N'LC' THEN N'LC · Liquidado Cartório' WHEN N'LI' THEN N'LI · Liquidado Impostos' WHEN N'LM' THEN N'LM · Liquidado Compensado' WHEN N'LO' THEN N'LO · Liquidado Cobrança' WHEN N'LP' THEN N'LP · Liquidado Protestado' WHEN N'LS' THEN N'LS · Liquidado Substituído' WHEN N'LV' THEN N'LV · Liquidado Gestão de Pessoas' WHEN N'LX' THEN N'LX · Liquidado Externo' WHEN N'PE' THEN N'PE · Aberto PE (Pagamento Eletrônico)' ELSE CASE WHEN t.SITTIT IS NULL THEN N'Não informada' ELSE CONCAT(N'Código nativo: ',t.SITTIT) END END AS Status, CASE WHEN NULLIF(p.CODMOE,N'') IS NULL THEN N'Não informada — conferir no ERP' ELSE CONCAT(p.CODMOE,CASE WHEN NULLIF(b.DESMOE,N'') IS NULL THEN N'' ELSE CONCAT(N' · ',b.DESMOE) END) END AS CompanyCurrency, CONCAT(t.CODTNS,CASE WHEN NULLIF(n.DESTNS,N'') IS NULL THEN N'' ELSE CONCAT(N' · ',n.DESTNS) END) AS TitleTransaction, t.CODEMP AS Company, t.CODFIL AS Branch, t.DATEMI AS IssueDate, t.VCTORI AS OriginalDue, t.VCTPRO AS CurrentDue, t.DATPPT AS PlannedPayment, t.DATDSC AS DiscountDate, t.DATNEG AS NegotiatedDate, CONVERT(varchar(80),t.VLRORI) AS OriginalAmount, CONVERT(varchar(80),t.VLRABE) AS OpenAmount, t.CODMOE AS TitleCurrency, CONVERT(varchar(80),t.COTEMI) AS IssueRate, t.OBSTCP AS Notes, CONVERT(varchar(80),t.VLRDSC) AS DiscountAmount, t.PERDSC AS DiscountPercent, CONVERT(varchar(80),t.JRSNEG) AS NegotiatedInterest, CONVERT(varchar(80),t.MULNEG) AS NegotiatedFine, CONVERT(varchar(80),t.DSCNEG) AS NegotiatedDiscount, CONVERT(varchar(80),t.OUTNEG) AS NegotiatedOther, CONVERT(varchar(80),t.COTNEG) AS NegotiatedRate, t.NUMNFC AS OriginInvoice, t.NUMOCP AS PurchaseOrder FROM dbo.E501TCP t LEFT JOIN dbo.E095FOR s ON s.CODFOR=t.CODFOR LEFT JOIN dbo.E001TNS n ON n.CODEMP=t.CODEMP AND n.CODTNS=t.CODTNS LEFT JOIN dbo.E070EMP e ON e.CODEMP=t.CODEMP LEFT JOIN dbo.E006PAI p ON p.CODPAI=e.CODPAI LEFT JOIN dbo.E031MOE b ON b.CODMOE=p.CODMOE WHERE t.CODEMP IS NOT NULL AND t.CODFIL IS NOT NULL AND t.NUMTIT IS NOT NULL AND t.CODTPT IS NOT NULL AND t.CODFOR IS NOT NULL AND t.VCTPRO>='19010101'",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Senior Gestão Empresarial",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "50ADEC3C-B267-514D-BC68-0235C49D25AA",
"key": "MovementDate",
"type": "date"
},
{
"direction": "ascending",
"id": "3A359890-D23E-53B8-B412-0A891F86A176",
"key": "MovementKey",
"type": "text"
}
],
"id": "A9350300-1B32-516C-927A-F6AC76510D7E",
"mappings": [
{
"commonFieldKey": "",
"key": "MovementKey",
"label": "Chave interna do movimento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MovementKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TitleKey",
"label": "Chave interna do título",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TitleKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyID",
"label": "Chave interna da empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BranchID",
"label": "Chave interna da filial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BranchID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierID",
"label": "Chave interna do fornecedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TitleContext",
"label": "Contexto interno do título",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TitleContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TypeContext",
"label": "Contexto interno do tipo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TypeContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Title",
"label": "Título / tipo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Title",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyCurrency",
"label": "Moeda da empresa — valores abaixo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MovementTransaction",
"label": "Transação do movimento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MovementTransaction",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MovementModule",
"label": "Módulo da transação (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MovementModule",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MovementNumber",
"label": "Movimento (sequência)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MovementNumber",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MovementDate",
"label": "Data do movimento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MovementDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaymentDate",
"label": "Data de pagamento registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PaymentDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MovementAmount",
"label": "Valor do movimento registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MovementAmount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MovementNet",
"label": "Valor líquido do movimento registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MovementNet",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Movimentos do título a pagar",
"primaryKey": "MovementKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyID",
"id": "003D4915-D19D-5042-9E7C-A349854C7AA7",
"name": "company",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "BranchID",
"id": "931BD351-8AB2-5140-B325-F7E26C8B39DF",
"name": "branch",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SupplierID",
"id": "9004BE78-5056-59F8-B2E8-6579A834F4E9",
"name": "supplier",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TitleContext",
"id": "28D8D92E-7844-55BB-9470-32289FA3A358",
"name": "title_context",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TypeContext",
"id": "F6B03A30-72AA-58E6-80E7-5C347591D637",
"name": "type_context",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Title",
"CompanyCurrency",
"MovementTransaction",
"MovementModule",
"MovementAmount",
"MovementNet"
],
"sourceID": "8A275667-D941-5878-8BCF-84F8B8D987FE",
"sqlQuery": "SELECT CONCAT(CONCAT(m.CODEMP,N':',m.CODFIL,N':',m.CODFOR,N':',DATALENGTH(m.NUMTIT),N':',m.NUMTIT,N':',DATALENGTH(m.CODTPT),N':',m.CODTPT),N':',m.SEQMOV) AS MovementKey, CONCAT(m.CODEMP,N':',m.CODFIL,N':',m.CODFOR,N':',DATALENGTH(m.NUMTIT),N':',m.NUMTIT,N':',DATALENGTH(m.CODTPT),N':',m.CODTPT) AS TitleKey, m.CODEMP AS CompanyID, m.CODFIL AS BranchID, m.CODFOR AS SupplierID, CONCAT(N'T',m.NUMTIT) AS TitleContext, CONCAT(N'P',m.CODTPT) AS TypeContext, CONCAT(m.NUMTIT,N' / ',m.CODTPT) AS Title, CASE WHEN NULLIF(p.CODMOE,N'') IS NULL THEN N'Não informada — conferir no ERP' ELSE CONCAT(p.CODMOE,CASE WHEN NULLIF(b.DESMOE,N'') IS NULL THEN N'' ELSE CONCAT(N' · ',b.DESMOE) END) END AS CompanyCurrency, CONCAT(m.CODTNS,CASE WHEN NULLIF(n.DESTNS,N'') IS NULL THEN N'' ELSE CONCAT(N' · ',n.DESTNS) END) AS MovementTransaction, n.LISMOD AS MovementModule, m.SEQMOV AS MovementNumber, m.DATMOV AS MovementDate, m.DATPGT AS PaymentDate, CONVERT(varchar(80),m.VLRMOV) AS MovementAmount, CONVERT(varchar(80),m.VLRLIQ) AS MovementNet FROM dbo.E501MCP m INNER JOIN dbo.E501TCP t ON t.CODEMP=m.CODEMP AND t.CODFIL=m.CODFIL AND t.NUMTIT=m.NUMTIT AND t.CODTPT=m.CODTPT AND t.CODFOR=m.CODFOR LEFT JOIN dbo.E001TNS n ON n.CODEMP=m.CODEMP AND n.CODTNS=m.CODTNS LEFT JOIN dbo.E070EMP e ON e.CODEMP=m.CODEMP LEFT JOIN dbo.E006PAI p ON p.CODPAI=e.CODPAI LEFT JOIN dbo.E031MOE b ON b.CODMOE=p.CODMOE WHERE m.CODEMP=:company AND m.CODFIL=:branch AND m.CODFOR=:supplier AND CONCAT(N'T',m.NUMTIT)=:title_context AND CONCAT(N'P',m.CODTPT)=:type_context AND m.CODEMP IS NOT NULL AND m.CODFIL IS NOT NULL AND m.NUMTIT IS NOT NULL AND m.CODTPT IS NOT NULL AND m.CODFOR IS NOT NULL AND m.SEQMOV IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Senior Gestão Empresarial",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "F094C9A1-3511-5EF8-A6DF-28F2E4E65492",
"key": "TitleKey",
"type": "text"
}
],
"id": "FDBE243C-4671-5EFF-9BD4-00A8C3DB5E8A",
"mappings": [
{
"commonFieldKey": "",
"key": "TitleKey",
"label": "Chave interna do título",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TitleKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyID",
"label": "Chave interna da empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BranchID",
"label": "Chave interna da filial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BranchID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierID",
"label": "Chave interna do fornecedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TitleContext",
"label": "Contexto interno do título",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TitleContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TypeContext",
"label": "Contexto interno do tipo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TypeContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierStatus",
"label": "Situação do cadastro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupplierStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PersonType",
"label": "Tipo de pessoa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PersonType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Nome do cadastro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TradeName",
"label": "Nome fantasia atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TradeName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "City",
"label": "Cidade",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "City",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "State",
"label": "UF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "State",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Street",
"label": "Endereço atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Street",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StreetNumber",
"label": "Número",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StreetNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AddressExtra",
"label": "Complemento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AddressExtra",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "District",
"label": "Bairro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "District",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Phone",
"label": "Telefone cadastrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Phone",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Phone2",
"label": "Telefone alternativo 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Phone2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Phone3",
"label": "Telefone alternativo 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Phone3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Email",
"label": "E-mail cadastrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Email",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Fornecedor atual do título",
"primaryKey": "TitleKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyID",
"id": "003D4915-D19D-5042-9E7C-A349854C7AA7",
"name": "company",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "BranchID",
"id": "931BD351-8AB2-5140-B325-F7E26C8B39DF",
"name": "branch",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SupplierID",
"id": "9004BE78-5056-59F8-B2E8-6579A834F4E9",
"name": "supplier",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TitleContext",
"id": "28D8D92E-7844-55BB-9470-32289FA3A358",
"name": "title_context",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TypeContext",
"id": "F6B03A30-72AA-58E6-80E7-5C347591D637",
"name": "type_context",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"SupplierStatus",
"PersonType",
"SupplierName",
"TradeName",
"City",
"State",
"Street",
"StreetNumber",
"AddressExtra",
"District",
"Phone",
"Phone2",
"Phone3",
"Email"
],
"sourceID": "8A275667-D941-5878-8BCF-84F8B8D987FE",
"sqlQuery": "SELECT CONCAT(t.CODEMP,N':',t.CODFIL,N':',t.CODFOR,N':',DATALENGTH(t.NUMTIT),N':',t.NUMTIT,N':',DATALENGTH(t.CODTPT),N':',t.CODTPT) AS TitleKey, t.CODEMP AS CompanyID, t.CODFIL AS BranchID, t.CODFOR AS SupplierID, CONCAT(N'T',t.NUMTIT) AS TitleContext, CONCAT(N'P',t.CODTPT) AS TypeContext, CASE s.SITFOR WHEN 'A' THEN N'Ativo' WHEN 'I' THEN N'Inativo' ELSE COALESCE(s.SITFOR,N'Não informada') END AS SupplierStatus, CASE s.TIPFOR WHEN 'J' THEN N'Pessoa jurídica' WHEN 'F' THEN N'Pessoa física' ELSE COALESCE(s.TIPFOR,N'Não informada') END AS PersonType, s.NOMFOR AS SupplierName, s.APEFOR AS TradeName, s.CIDFOR AS City, s.SIGUFS AS State, s.ENDFOR AS Street, s.NENFOR AS StreetNumber, s.CPLEND AS AddressExtra, s.BAIFOR AS District, s.FONFOR AS Phone, s.FONFO2 AS Phone2, s.FONFO3 AS Phone3, s.INTNET AS Email FROM dbo.E095FOR s INNER JOIN dbo.E501TCP t ON t.CODFOR=s.CODFOR WHERE t.CODEMP=:company AND t.CODFIL=:branch AND t.CODFOR=:supplier AND CONCAT(N'T',t.NUMTIT)=:title_context AND CONCAT(N'P',t.CODTPT)=:type_context AND t.CODEMP IS NOT NULL AND t.CODFIL IS NOT NULL AND t.NUMTIT IS NOT NULL AND t.CODTPT IS NOT NULL AND t.CODFOR IS NOT NULL",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "CA71692C-592F-52AC-9945-BE92C78B0E17",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "15C26064-8D4E-5A48-859E-AE94CB6B40F8",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "A9350300-1B32-516C-927A-F6AC76510D7E",
"title": "Movimentos registrados",
"urlKey": ""
},
{
"id": "C63F7DD8-8F51-5488-BDDD-C77EB09E0488",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "D0B502E2-FC74-50F1-8B9B-9E634B1BD024",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "FDBE243C-4671-5EFF-9BD4-00A8C3DB5E8A",
"title": "Fornecedor atual",
"urlKey": ""
}
],
"badgeKey": "Status",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CompanyCurrency",
"label": "Moeda da empresa — valores abaixo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Company",
"label": "Empresa (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Branch",
"label": "Filial (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OriginalDue",
"label": "Vencimento original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrentDue",
"label": "Vencimento prorrogado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OriginalAmount",
"label": "Valor original registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OpenAmount",
"label": "Valor em aberto atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "F56922DD-FA2A-5DBB-8406-7E6B5AAC1AFF",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Title",
"label": "Título / tipo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Supplier",
"label": "Fornecedor atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Situação registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "CompanyCurrency",
"label": "Moeda da empresa — valores abaixo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "TitleTransaction",
"label": "Transação do título",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Company",
"label": "Empresa (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Branch",
"label": "Filial (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Datas e acompanhamento",
"detailRole": "information",
"isVisible": true,
"key": "IssueDate",
"label": "Emissão",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Datas e acompanhamento",
"detailRole": "information",
"isVisible": true,
"key": "OriginalDue",
"label": "Vencimento original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Datas e acompanhamento",
"detailRole": "information",
"isVisible": true,
"key": "CurrentDue",
"label": "Vencimento prorrogado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Datas e acompanhamento",
"detailRole": "information",
"isVisible": true,
"key": "PlannedPayment",
"label": "Pagamento provável",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Datas e acompanhamento",
"detailRole": "information",
"isVisible": true,
"key": "DiscountDate",
"label": "Data do desconto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Parâmetros e negociação — sem recálculo",
"detailRole": "information",
"isVisible": true,
"key": "NegotiatedDate",
"label": "Validade da negociação",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "OriginalAmount",
"label": "Valor original registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "OpenAmount",
"label": "Valor em aberto atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parâmetros e negociação — sem recálculo",
"detailRole": "information",
"isVisible": true,
"key": "TitleCurrency",
"label": "Moeda / índice base do título (parâmetro)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parâmetros e negociação — sem recálculo",
"detailRole": "information",
"isVisible": true,
"key": "IssueRate",
"label": "Cotação de emissão registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Datas e acompanhamento",
"detailRole": "information",
"isVisible": true,
"key": "Notes",
"label": "Observação do título",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "DiscountAmount",
"label": "Desconto registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parâmetros e negociação — sem recálculo",
"detailRole": "information",
"isVisible": true,
"key": "DiscountPercent",
"label": "Desconto registrado (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "NegotiatedInterest",
"label": "Juros negociados registrados",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "NegotiatedFine",
"label": "Multa negociada registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "NegotiatedDiscount",
"label": "Desconto negociado registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "NegotiatedOther",
"label": "Outros negociados registrados",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parâmetros e negociação — sem recálculo",
"detailRole": "information",
"isVisible": true,
"key": "NegotiatedRate",
"label": "Cotação negociada registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "OriginInvoice",
"label": "Nota de entrada ERP (referência)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "PurchaseOrder",
"label": "Ordem de compra (referência)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "1F0E7FA6-C992-5C0F-86C2-140A9F42F36B",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "D4380767-E84E-50CF-B1C0-323BA2F1E652",
"includeAllOption": false,
"key": "CurrentDue",
"title": "Período do vencimento prorrogado",
"type": "date"
},
{
"id": "4BF88980-9B8D-50C1-9855-0539AB07083E",
"includeAllOption": false,
"key": "Company",
"title": "Empresa",
"type": "number"
},
{
"id": "4646DAB5-14F7-57B7-9366-BD95181409C7",
"includeAllOption": false,
"key": "Branch",
"title": "Filial",
"type": "number"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "A823AD41-2F2F-5735-9829-E2ABAC3341A2",
"key": "CurrentDue",
"type": "date"
},
{
"direction": "ascending",
"id": "F094C9A1-3511-5EF8-A6DF-28F2E4E65492",
"key": "TitleKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Title",
"systemImage": "doc.text",
"title": "Títulos a pagar",
"titleKey": "Supplier"
},
{
"actions": [],
"badgeKey": "MovementNumber",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CompanyCurrency",
"label": "Moeda da empresa — valores abaixo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MovementDate",
"label": "Data do movimento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaymentDate",
"label": "Data de pagamento registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MovementAmount",
"label": "Valor do movimento registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MovementNet",
"label": "Valor líquido do movimento registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "A9350300-1B32-516C-927A-F6AC76510D7E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Title",
"label": "Título / tipo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "CompanyCurrency",
"label": "Moeda da empresa — valores abaixo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "MovementTransaction",
"label": "Transação do movimento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "MovementModule",
"label": "Módulo da transação (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "MovementNumber",
"label": "Movimento (sequência)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Datas e acompanhamento",
"detailRole": "information",
"isVisible": true,
"key": "MovementDate",
"label": "Data do movimento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Datas e acompanhamento",
"detailRole": "information",
"isVisible": true,
"key": "PaymentDate",
"label": "Data de pagamento registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "MovementAmount",
"label": "Valor do movimento registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Valores registrados — moeda da empresa",
"detailRole": "information",
"isVisible": true,
"key": "MovementNet",
"label": "Valor líquido do movimento registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "846FC9BA-30C1-5A7C-985D-7619C569F49F",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "50ADEC3C-B267-514D-BC68-0235C49D25AA",
"key": "MovementDate",
"type": "date"
},
{
"direction": "ascending",
"id": "3A359890-D23E-53B8-B412-0A891F86A176",
"key": "MovementKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Title",
"systemImage": "doc.text",
"title": "Movimentos do título a pagar",
"titleKey": "MovementTransaction"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SupplierStatus",
"label": "Situação do cadastro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TradeName",
"label": "Nome fantasia atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "State",
"label": "UF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Phone",
"label": "Telefone cadastrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Email",
"label": "E-mail cadastrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "FDBE243C-4671-5EFF-9BD4-00A8C3DB5E8A",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "SupplierStatus",
"label": "Situação do cadastro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "PersonType",
"label": "Tipo de pessoa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Nome do cadastro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "TradeName",
"label": "Nome fantasia atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "City",
"label": "Cidade",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "State",
"label": "UF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Street",
"label": "Endereço atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "StreetNumber",
"label": "Número",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "AddressExtra",
"label": "Complemento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "District",
"label": "Bairro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Phone",
"label": "Telefone cadastrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Phone2",
"label": "Telefone alternativo 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Phone3",
"label": "Telefone alternativo 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contexto registrado",
"detailRole": "information",
"isVisible": true,
"key": "Email",
"label": "E-mail cadastrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D4817F35-2107-5A07-9A59-99FE4E5B5E32",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "F094C9A1-3511-5EF8-A6DF-28F2E4E65492",
"key": "TitleKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "City",
"systemImage": "doc.text",
"title": "Fornecedor atual do título",
"titleKey": "SupplierName"
}
],
"relations": [
{
"childDatasetID": "A9350300-1B32-516C-927A-F6AC76510D7E",
"childKey": "TitleKey",
"id": "15C26064-8D4E-5A48-859E-AE94CB6B40F8",
"name": "Movimentos registrados",
"parentDatasetID": "F56922DD-FA2A-5DBB-8406-7E6B5AAC1AFF",
"parentKey": "TitleKey"
},
{
"childDatasetID": "FDBE243C-4671-5EFF-9BD4-00A8C3DB5E8A",
"childKey": "TitleKey",
"id": "D0B502E2-FC74-50F1-8B9B-9E634B1BD024",
"name": "Fornecedor atual",
"parentDatasetID": "F56922DD-FA2A-5DBB-8406-7E6B5AAC1AFF",
"parentKey": "TitleKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Senior Gestão Empresarial",
"configurationLanguages": [
"pt"
],
"countries": [
"BR"
],
"createdAt": "2026-10-10T00:00:00Z",
"description": "NÃO OFICIAL — NÃO VALIDADA EM UMA INSTALAÇÃO ERP REAL. Para contas a pagar, compras, tesouraria e gestão: escolha empresa, filial e período de vencimento antes da leitura. Veja o fornecedor, a situação nativa, os vencimentos, o pagamento provável, o valor original e o saldo atual. Abra Movimentos registrados para consultar transação, datas de movimento e pagamento, valor registrado e líquido; ou Fornecedor atual para contatos e endereço. Detalhes mostram também os parâmetros de moeda, descontos e negociação, com referências à nota e ordem de compra.\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 SQL Server, três listas com Detalhes completos e dois sub-botões sob demanda. Somente SELECT; até 2.000 linhas por leitura, sem refresh periódico. O período é do vencimento prorrogado, não da emissão nem do movimento. O saldo é atual, não histórico na data selecionada. Estreitamento de filtros e limite de linhas não garantem consulta barata: confira índices, timeout e plano de execução. Busca/filtros locais atuam somente nas linhas carregadas e não são autorização entre empresas/filiais.\n\nA identidade inclui empresa, filial, número textual, tipo E fornecedor; os movimentos acrescentam a sequência. Preserva zeros à esquerda, espaços internos e delimitadores. Os dois sub-botões revalidam toda essa chave. Mantém títulos cancelados, liquidados, créditos, valores negativos, zeros, NULL e códigos desconhecidos; a situação não é inferida da data ou do saldo. Cadastro do fornecedor é atual, não snapshot histórico; ausência do cadastro não elimina o título. Referências numéricas não são links nem prova de autorização fiscal.\n\nValores monetários originais são apresentados como texto sem arredondamento imposto. A denominação dos valores registrados vem do país da empresa, separada da moeda/índice base do título e das cotações. Moeda ausente é avisada, nunca substituída por BRL/R$ ou pela moeda base do título. Confira a unidade na instalação. Juros, multa, desconto, outros negociados e sua validade são parâmetros registrados, não valores calculados para pagar hoje. Sem soma multimoeda, câmbio, saldo reconstruído ou cálculo de liquidação. Data do movimento e data de pagamento são distintas. Um movimento não é necessariamente saída de caixa; não executa pagamentos, baixas ou aprovações nem interpreta o módulo como permissão. Ausência de movimentos não prova pagamento ou saldo zero.\n\nSem CPF/CNPJ, contas bancárias, PIX, códigos de barras de pagamento ou credenciais. Use leitor SQL autorizado de mínimo privilégio; SQL direto não herda restrições do ERP. Notas livres e contatos podem ser confidenciais: revise direitos na fonte. O pacote não contém servidor, senha ou dados empresariais. Base documental Senior 5.10.4, dbo, SQL Server 2012+. Confirme unicidade das chaves/cadastros, tipos, collation e datas date/datetime na importação. Vencimentos anteriores a 1901 não entram; nenhuma data é inventada. Documentação de importação/API não é DDL físico instalado. Testes documentais/sintéticos e imagens DEMO não são testes ERP reais. Não se aplica automaticamente a Oracle, GO UP, Senior X ou SeniorERP da Romênia.\n\nDocumentação: https://documentacao.senior.com.br/gestaoempresarialerp/5.10.4/menu_recursos/consistencia_padrao_cpagar_e501tcp.htm\nhttps://documentacao.senior.com.br/gestaoempresarialerp/5.10.4/menu_financas/f501tcp.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "4C1CEA87-2061-5A5D-9904-687BB26183C2",
"rootButtonCount": 1,
"summary": "Vencimentos, saldo atual, negociação e dois sub-botões por empresa/filial.",
"tags": [
"Senior Gestão Empresarial",
"SQL Server",
"Contas a pagar",
"Tesouraria",
"Compras",
"Pro"
],
"title": "Títulos a pagar, movimentos e fornecedor — Pro"
}
}