Pedidos de compra + itens e produto — Pro
Empresa e período na abertura; operação histórica, Detalhes completos e itens/produto sob demanda.
NÃO OFICIAL — NÃO VALIDADA EM UMA INSTALAÇÃO ERP REAL. Para equipes de compras e abastecimento e gestores: escolha empresa e período de negociação. Consulte pedidos, parceiro, operação histórica, datas registradas, observações, valores originais, frete, descontos e ICMS/IPI. Abra Itens do pedido com quantidades, unidade do item, entrega registrada, controle, local, CFOP, valores e código de pendência; a Ficha do produto traz referências, marca, NCM e parâmetros gerais atuais.
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 sob demanda; somente SELECT, live, no máximo 2.000 resultados por leitura, sem refresh periódico. A abertura limita DTNEG, não prazo de entrega, baixa ou saldo histórico. Seleciona exclusivamente TIPMOV=O (Pedido de Compra). Notas faturadas, devoluções e outros movimentos não são incluídos. Status e pendência são códigos nativos: não inventa status ativo, cancelado, atraso ou quantidade ainda devida.
NUNOTA e NUNOTA+SEQUENCIA identificam documento/item e ficam ocultos. Número comercial da nota não é inferido por causa de grafias conflitantes na documentação. A operação usa CODTIPOPER e a versão DHTIPOPER=DHALTER, não a versão mais recente. Outros cadastros são ATUAIS, não snapshots da emissão. Cadastros ausentes ou repetidos não multiplicam nem apagam pedido/item; nomes não únicos ficam indisponíveis. As fichas exigem produto único; identidades nulas/repetidas são recusadas. Cada sub-botão revalida pedido, empresa, tipo, dia de negociação selecionado e, na ficha, sequência/produto. O período usa os filtros nativos de abertura com as duas datas; o dia do pedido é revalidado em cada sub-botão. A empresa do item é mostrada separadamente; não impõe igualdade não documentada com a empresa do cabeçalho.
Quantidades e valores preservam a representação original como texto, inclusive zero, negativos e NULL. Unidade do item é CODVOL da linha, não a unidade atual do produto; não converte unidades nem soma produtos. Total do item vem de VLRTOT, nunca QTDNEG×VLRUNIT. Descontos e impostos ficam separados: não recalcula total líquido, lucro ou impostos, não adiciona impostos duas vezes e não pressupõe moeda/câmbio. Confira a moeda na fonte antes de interpretar valores. Mínimo/máximo do produto são parâmetros gerais, não estoque atual.
O administrador deve confirmar os sete objetos dbo, 59 nomes selecionados e identidades/datas/tipos da instalação SQL Server. dbo é requisito do adaptador, não owner universal provado. O portal v2.0 não identifica versão ERP e os tipos Oracle do manual não certificam DDL SQL Server. Confirmar índices, collation, timeout e plano de execução; limite de resultados não garante consulta barata. Busca local abrange só dados carregados. SQL direto não herda permissões do ERP: usar leitor SELECT restrito às empresas, itens e dados autorizados, não apenas filtro visual. Não envia pedidos nem altera estoque. Sem credenciais, CPF/CNPJ, NF-e ou dados bancários. Não pacote Oracle nem acesso automático ao Cloud. Testes documentais/sintéticos; não testada em ERP, SQL Server ou iOS reais. Capturas reais do Cifru Android com dados DEMO integralmente inventados; sem conexão ou registros de um Sankhya real.
Estrutura física e relações: https://developer.sankhya.com.br/docs/operacoes-comerciais
Tipos de movimento: https://ajuda.sankhya.com.br/hc/pt-br/articles/360044601114-Campos-para-An%C3%A1lise-de-Giro
Cobertura da galeria: 8 imagens complementares mostram card completo de um pedido DEMO, todas as continuações dos 20 Detalhes do pedido, 18 do item e dez da ficha atual do produto, com os dois sub-botões realmente abertos. Empresa/período são selecionados na abertura. Outros pedidos, itens, empresas e casos adversariais não estão todos retratados. Cifru Android com transporte sintético local, não conexão ou teste em ERP/SQL Server/iOS, desempenho ou compra Pro. Home, listagem ampla e RAW ficam privados; guia da fonte separado.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Pedidos de compra
- Details: Itens do pedido
- Details: Ficha do produto
- Sub-button: Itens do pedido
- Sub-button: Ficha do produto
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 CONVERT(varchar(max), c.NUNOTA) AS DocumentKey, CONVERT(varchar(max), c.CODEMP) AS CompanyKey, CONVERT(date, c.DTNEG) AS ScopeDay, p.NOMEPARC AS Partner, CASE WHEN e.CODEMP IS NOT NULL THEN CONCAT(e.RAZAOSOCIAL,N' · ',c.CODEMP) ELSE CONCAT(N'Empresa sem nome único · ',c.CODEMP) END AS Company, o.DESCROPER AS Operation, CONVERT(date, c.DTNEG) AS Negotiated, c.DTFATUR AS InvoicedAt, c.DTENTSAI AS EntryExitAt, c.OBSERVACAO AS Observation, CONVERT(varchar(max), c.VLRNOTA) AS Value, CONVERT(varchar(max), c.VLRFRETE) AS Freight, CONVERT(varchar(max), c.VLRDESCTOT) AS HeaderDiscount, CONVERT(varchar(max), c.VLRDESCTOTITEM) AS ItemDiscount, CONVERT(varchar(max), c.BASEICMS) AS ICMSBase, CONVERT(varchar(max), c.VLRICMS) AS ICMS, CONVERT(varchar(max), c.BASEIPI) AS IPIBase, CONVERT(varchar(max), c.VLRIPI) AS IPI, CONVERT(varchar(max), c.PERCDESC) AS DiscountPercent, c.TIPFRETE AS FreightType, c.STATUSNOTA AS Status, CASE WHEN o.CODTIPOPER IS NOT NULL THEN N'Único — versão do pedido' ELSE N'Ausente ou repetido — conferir' END AS OperationState, CASE WHEN p.CODPARC IS NOT NULL THEN N'Único — cadastro atual' ELSE N'Ausente ou repetido — conferir' END AS PartnerState FROM dbo.TGFCAB c LEFT JOIN dbo.TGFPAR p ON p.CODPARC=c.CODPARC AND (SELECT COUNT_BIG(*) FROM dbo.TGFPAR u WHERE u.CODPARC=p.CODPARC)=1 LEFT JOIN dbo.TSIEMP e ON e.CODEMP=c.CODEMP AND (SELECT COUNT_BIG(*) FROM dbo.TSIEMP u WHERE u.CODEMP=e.CODEMP)=1 LEFT JOIN dbo.TGFTOP o ON o.CODTIPOPER=c.CODTIPOPER AND o.DHALTER=c.DHTIPOPER AND (SELECT COUNT_BIG(*) FROM dbo.TGFTOP u WHERE u.CODTIPOPER=o.CODTIPOPER AND u.DHALTER=o.DHALTER)=1 WHERE c.TIPMOV='O' AND c.NUNOTA IS NOT NULL AND c.CODEMP IS NOT NULL AND (SELECT COUNT_BIG(*) FROM dbo.TGFCAB u WHERE u.NUNOTA=c.NUNOTA)=1 AND c.DTNEG IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONVERT(varchar(max), c.NUNOTA) AS DocumentKey, CONVERT(varchar(max), c.CODEMP) AS CompanyKey, CONVERT(date, c.DTNEG) AS ScopeDay, CONCAT(CONVERT(varchar(max), i.NUNOTA),N'|',CONVERT(varchar(max), i.SEQUENCIA)) AS LineKey, CONVERT(varchar(max), i.SEQUENCIA) AS OriginLineKey, CONVERT(varchar(max), i.CODPROD) AS ProductKey, CONVERT(varchar(max), c.NUNOTA) AS OriginDocumentKey, p.DESCRPROD AS Product, p.REFERENCIA AS Reference, CONVERT(varchar(max), i.CODEMP) AS ItemCompany, l.DESCRLOCAL AS Location, i.CONTROLE AS Control, i.CODVOL AS Unit, CONVERT(varchar(max), i.QTDNEG) AS Quantity, CONVERT(varchar(max), i.QTDENTREGUE) AS Delivered, CONVERT(varchar(max), i.VLRUNIT) AS UnitValue, CONVERT(varchar(max), i.VLRTOT) AS LineValue, CONVERT(varchar(max), i.VLRDESC) AS LineDiscount, CONVERT(varchar(max), i.VLRICMS) AS ICMS, CONVERT(varchar(max), i.BASEIPI) AS IPIBase, CONVERT(varchar(max), i.CODCFO) AS CFOP, CONVERT(varchar(max), i.PERCDESC) AS DiscountPercent, i.PENDENTE AS Pending, CASE WHEN p.CODPROD IS NOT NULL THEN N'Único — cadastro atual' ELSE N'Ausente ou repetido — conferir' END AS ProductState, CASE WHEN l.CODLOCAL IS NOT NULL THEN N'Único — cadastro atual' ELSE N'Ausente ou repetido — conferir' END AS LocationState FROM dbo.TGFCAB c INNER JOIN dbo.TGFITE i ON i.NUNOTA=c.NUNOTA LEFT JOIN dbo.TGFPRO p ON p.CODPROD=i.CODPROD AND (SELECT COUNT_BIG(*) FROM dbo.TGFPRO u WHERE u.CODPROD=p.CODPROD)=1 LEFT JOIN dbo.TGFLOC l ON l.CODLOCAL=i.CODLOCALORIG AND (SELECT COUNT_BIG(*) FROM dbo.TGFLOC u WHERE u.CODLOCAL=l.CODLOCAL)=1 WHERE c.TIPMOV='O' AND c.NUNOTA IS NOT NULL AND c.CODEMP IS NOT NULL AND (SELECT COUNT_BIG(*) FROM dbo.TGFCAB u WHERE u.NUNOTA=c.NUNOTA)=1 AND c.DTNEG IS NOT NULL AND c.NUNOTA=:document AND c.CODEMP=:company AND CONVERT(date, c.DTNEG)=:selected_day AND i.NUNOTA IS NOT NULL AND i.SEQUENCIA IS NOT NULL AND (SELECT COUNT_BIG(*) FROM dbo.TGFITE u WHERE u.NUNOTA=i.NUNOTA AND u.SEQUENCIA=i.SEQUENCIA)=1
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONVERT(varchar(max), c.NUNOTA) AS DocumentKey, CONVERT(varchar(max), c.CODEMP) AS CompanyKey, CONVERT(date, c.DTNEG) AS ScopeDay, CONVERT(varchar(max), i.NUNOTA) AS OriginDocumentKey, CONVERT(varchar(max), c.CODEMP) AS OriginCompanyKey, CONCAT(CONVERT(varchar(max), i.NUNOTA),N'|',CONVERT(varchar(max), i.SEQUENCIA)) AS LineKey, CONVERT(varchar(max), i.SEQUENCIA) AS OriginLineKey, CONVERT(varchar(max), i.CODPROD) AS OriginProductKey, CONVERT(varchar(max), p.CODPROD) AS ProductKey, p.DESCRPROD AS Product, p.REFERENCIA AS Reference, p.CODVOL AS CatalogueUnit, p.MARCA AS Brand, p.REFFORN AS SupplierReference, p.NCM AS NCM, CONVERT(varchar(max), p.ESTMIN) AS GeneralMin, CONVERT(varchar(max), p.ESTMAX) AS GeneralMax, CONVERT(varchar(max), p.DESCMAX) AS MaxDiscount, CONVERT(varchar(max), p.COMVEND) AS Commission FROM dbo.TGFCAB c INNER JOIN dbo.TGFITE i ON i.NUNOTA=c.NUNOTA INNER JOIN dbo.TGFPRO p ON p.CODPROD=i.CODPROD AND (SELECT COUNT_BIG(*) FROM dbo.TGFPRO u WHERE u.CODPROD=p.CODPROD)=1 WHERE c.TIPMOV='O' AND c.NUNOTA IS NOT NULL AND c.CODEMP IS NOT NULL AND (SELECT COUNT_BIG(*) FROM dbo.TGFCAB u WHERE u.NUNOTA=c.NUNOTA)=1 AND c.DTNEG IS NOT NULL AND c.NUNOTA=:document AND c.CODEMP=:company AND CONVERT(date, c.DTNEG)=:selected_day AND i.NUNOTA IS NOT NULL AND i.SEQUENCIA IS NOT NULL AND (SELECT COUNT_BIG(*) FROM dbo.TGFITE u WHERE u.NUNOTA=i.NUNOTA AND u.SEQUENCIA=i.SEQUENCIA)=1 AND i.SEQUENCIA=:line AND i.CODPROD=:product
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sankhya Om — SQL Server",
"id": "B4DEE981-581C-57DB-951A-69CEB6E826EE",
"kind": "sqlServer",
"requiredObjects": [
"dbo.TGFCAB",
"dbo.TGFITE",
"dbo.TGFLOC",
"dbo.TGFPAR",
"dbo.TGFPRO",
"dbo.TGFTOP",
"dbo.TSIEMP"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sankhya Om",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "03285F1C-502B-5C15-AC9B-66C1CB05FACC",
"key": "Negotiated",
"type": "date"
},
{
"direction": "ascending",
"id": "6C99D094-05D0-5681-9500-0CA5504BECC9",
"key": "DocumentKey",
"type": "text"
}
],
"id": "E3F31C14-839C-55CE-A2C1-9DA7682F936D",
"mappings": [
{
"commonFieldKey": "",
"key": "DocumentKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ScopeDay",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ScopeDay",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Partner",
"label": "Parceiro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Partner",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Company",
"label": "Empresa do pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Company",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Operation",
"label": "Operação histórica",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Operation",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Negotiated",
"label": "Data de negociação",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Negotiated",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoicedAt",
"label": "Data de faturamento registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoicedAt",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryExitAt",
"label": "Data de entrada/saída registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryExitAt",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Observation",
"label": "Observações do pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Observation",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Value",
"label": "Valor original do pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Value",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Freight",
"label": "Frete original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Freight",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderDiscount",
"label": "Desconto total registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderDiscount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemDiscount",
"label": "Desconto total de itens registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemDiscount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ICMSBase",
"label": "Base ICMS original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ICMSBase",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ICMS",
"label": "ICMS original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ICMS",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IPIBase",
"label": "Base IPI original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IPIBase",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IPI",
"label": "IPI original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IPI",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountPercent",
"label": "Desconto (%) registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountPercent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FreightType",
"label": "Tipo de frete — código",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FreightType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Status",
"label": "Status da nota — código",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OperationState",
"label": "Histórico de operação",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OperationState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartnerState",
"label": "Cadastro do parceiro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartnerState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Pedidos de compra",
"primaryKey": "DocumentKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Partner",
"Company",
"Operation",
"Observation",
"Value",
"Freight",
"HeaderDiscount",
"ItemDiscount",
"ICMSBase",
"ICMS",
"IPIBase",
"IPI",
"DiscountPercent",
"FreightType",
"Status",
"OperationState",
"PartnerState"
],
"sourceID": "B4DEE981-581C-57DB-951A-69CEB6E826EE",
"sqlQuery": "SELECT CONVERT(varchar(max), c.NUNOTA) AS DocumentKey, CONVERT(varchar(max), c.CODEMP) AS CompanyKey, CONVERT(date, c.DTNEG) AS ScopeDay, p.NOMEPARC AS Partner, CASE WHEN e.CODEMP IS NOT NULL THEN CONCAT(e.RAZAOSOCIAL,N' · ',c.CODEMP) ELSE CONCAT(N'Empresa sem nome único · ',c.CODEMP) END AS Company, o.DESCROPER AS Operation, CONVERT(date, c.DTNEG) AS Negotiated, c.DTFATUR AS InvoicedAt, c.DTENTSAI AS EntryExitAt, c.OBSERVACAO AS Observation, CONVERT(varchar(max), c.VLRNOTA) AS Value, CONVERT(varchar(max), c.VLRFRETE) AS Freight, CONVERT(varchar(max), c.VLRDESCTOT) AS HeaderDiscount, CONVERT(varchar(max), c.VLRDESCTOTITEM) AS ItemDiscount, CONVERT(varchar(max), c.BASEICMS) AS ICMSBase, CONVERT(varchar(max), c.VLRICMS) AS ICMS, CONVERT(varchar(max), c.BASEIPI) AS IPIBase, CONVERT(varchar(max), c.VLRIPI) AS IPI, CONVERT(varchar(max), c.PERCDESC) AS DiscountPercent, c.TIPFRETE AS FreightType, c.STATUSNOTA AS Status, CASE WHEN o.CODTIPOPER IS NOT NULL THEN N'Único — versão do pedido' ELSE N'Ausente ou repetido — conferir' END AS OperationState, CASE WHEN p.CODPARC IS NOT NULL THEN N'Único — cadastro atual' ELSE N'Ausente ou repetido — conferir' END AS PartnerState FROM dbo.TGFCAB c LEFT JOIN dbo.TGFPAR p ON p.CODPARC=c.CODPARC AND (SELECT COUNT_BIG(*) FROM dbo.TGFPAR u WHERE u.CODPARC=p.CODPARC)=1 LEFT JOIN dbo.TSIEMP e ON e.CODEMP=c.CODEMP AND (SELECT COUNT_BIG(*) FROM dbo.TSIEMP u WHERE u.CODEMP=e.CODEMP)=1 LEFT JOIN dbo.TGFTOP o ON o.CODTIPOPER=c.CODTIPOPER AND o.DHALTER=c.DHTIPOPER AND (SELECT COUNT_BIG(*) FROM dbo.TGFTOP u WHERE u.CODTIPOPER=o.CODTIPOPER AND u.DHALTER=o.DHALTER)=1 WHERE c.TIPMOV='O' AND c.NUNOTA IS NOT NULL AND c.CODEMP IS NOT NULL AND (SELECT COUNT_BIG(*) FROM dbo.TGFCAB u WHERE u.NUNOTA=c.NUNOTA)=1 AND c.DTNEG IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sankhya Om",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "05680B87-7CA6-589B-9011-85A6D18C904B",
"mappings": [
{
"commonFieldKey": "",
"key": "DocumentKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ScopeDay",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ScopeDay",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginLineKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginLineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginDocumentKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginDocumentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Product",
"label": "Produto atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Product",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Reference",
"label": "Referência atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Reference",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemCompany",
"label": "Empresa registrada no item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Location",
"label": "Local de origem atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Location",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Control",
"label": "Controle registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Control",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Unit",
"label": "Unidade deste item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Unit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Quantity",
"label": "Quantidade negociada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Quantity",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Delivered",
"label": "Quantidade entregue registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Delivered",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UnitValue",
"label": "Valor unitário original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UnitValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineValue",
"label": "Total original do item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineDiscount",
"label": "Desconto original do item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineDiscount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ICMS",
"label": "ICMS original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ICMS",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IPIBase",
"label": "Base IPI original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IPIBase",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CFOP",
"label": "CFOP registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CFOP",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountPercent",
"label": "Desconto (%) registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountPercent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Pending",
"label": "Pendente — código registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Pending",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProductState",
"label": "Cadastro do produto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LocationState",
"label": "Cadastro do local",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LocationState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Itens do pedido",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ScopeDay",
"id": "4A0BDD1C-E6BA-5BF6-996F-CC1B8EF9B009",
"name": "selected_day",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocumentKey",
"id": "574D43EF-A896-5511-8B4E-5B616AB730E4",
"name": "document",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyKey",
"id": "C905D209-15ED-577C-9498-9072963B3153",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Product",
"Reference",
"ItemCompany",
"Location",
"Control",
"Unit",
"Quantity",
"Delivered",
"UnitValue",
"LineValue",
"LineDiscount",
"ICMS",
"IPIBase",
"CFOP",
"DiscountPercent",
"Pending",
"ProductState",
"LocationState"
],
"sourceID": "B4DEE981-581C-57DB-951A-69CEB6E826EE",
"sqlQuery": "SELECT CONVERT(varchar(max), c.NUNOTA) AS DocumentKey, CONVERT(varchar(max), c.CODEMP) AS CompanyKey, CONVERT(date, c.DTNEG) AS ScopeDay, CONCAT(CONVERT(varchar(max), i.NUNOTA),N'|',CONVERT(varchar(max), i.SEQUENCIA)) AS LineKey, CONVERT(varchar(max), i.SEQUENCIA) AS OriginLineKey, CONVERT(varchar(max), i.CODPROD) AS ProductKey, CONVERT(varchar(max), c.NUNOTA) AS OriginDocumentKey, p.DESCRPROD AS Product, p.REFERENCIA AS Reference, CONVERT(varchar(max), i.CODEMP) AS ItemCompany, l.DESCRLOCAL AS Location, i.CONTROLE AS Control, i.CODVOL AS Unit, CONVERT(varchar(max), i.QTDNEG) AS Quantity, CONVERT(varchar(max), i.QTDENTREGUE) AS Delivered, CONVERT(varchar(max), i.VLRUNIT) AS UnitValue, CONVERT(varchar(max), i.VLRTOT) AS LineValue, CONVERT(varchar(max), i.VLRDESC) AS LineDiscount, CONVERT(varchar(max), i.VLRICMS) AS ICMS, CONVERT(varchar(max), i.BASEIPI) AS IPIBase, CONVERT(varchar(max), i.CODCFO) AS CFOP, CONVERT(varchar(max), i.PERCDESC) AS DiscountPercent, i.PENDENTE AS Pending, CASE WHEN p.CODPROD IS NOT NULL THEN N'Único — cadastro atual' ELSE N'Ausente ou repetido — conferir' END AS ProductState, CASE WHEN l.CODLOCAL IS NOT NULL THEN N'Único — cadastro atual' ELSE N'Ausente ou repetido — conferir' END AS LocationState FROM dbo.TGFCAB c INNER JOIN dbo.TGFITE i ON i.NUNOTA=c.NUNOTA LEFT JOIN dbo.TGFPRO p ON p.CODPROD=i.CODPROD AND (SELECT COUNT_BIG(*) FROM dbo.TGFPRO u WHERE u.CODPROD=p.CODPROD)=1 LEFT JOIN dbo.TGFLOC l ON l.CODLOCAL=i.CODLOCALORIG AND (SELECT COUNT_BIG(*) FROM dbo.TGFLOC u WHERE u.CODLOCAL=l.CODLOCAL)=1 WHERE c.TIPMOV='O' AND c.NUNOTA IS NOT NULL AND c.CODEMP IS NOT NULL AND (SELECT COUNT_BIG(*) FROM dbo.TGFCAB u WHERE u.NUNOTA=c.NUNOTA)=1 AND c.DTNEG IS NOT NULL AND c.NUNOTA=:document AND c.CODEMP=:company AND CONVERT(date, c.DTNEG)=:selected_day AND i.NUNOTA IS NOT NULL AND i.SEQUENCIA IS NOT NULL AND (SELECT COUNT_BIG(*) FROM dbo.TGFITE u WHERE u.NUNOTA=i.NUNOTA AND u.SEQUENCIA=i.SEQUENCIA)=1",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sankhya Om",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "BA1B20C3-FA27-55B0-9CF9-39D89B744872",
"mappings": [
{
"commonFieldKey": "",
"key": "DocumentKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ScopeDay",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ScopeDay",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginDocumentKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginDocumentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginCompanyKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginCompanyKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginLineKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginLineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginProductKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Identidade interna — não exibida",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Product",
"label": "Produto atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Product",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Reference",
"label": "Referência atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Reference",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CatalogueUnit",
"label": "Unidade padrão atual — sem conversão",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CatalogueUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Brand",
"label": "Marca atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Brand",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SupplierReference",
"label": "Referência do fornecedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierReference",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NCM",
"label": "NCM atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NCM",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "GeneralMin",
"label": "Estoque mínimo geral",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "GeneralMin",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "GeneralMax",
"label": "Estoque máximo geral",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "GeneralMax",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MaxDiscount",
"label": "Desconto máximo configurado (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MaxDiscount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Commission",
"label": "Comissão configurada (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Commission",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Ficha do produto",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ScopeDay",
"id": "4A0BDD1C-E6BA-5BF6-996F-CC1B8EF9B009",
"name": "selected_day",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocumentKey",
"id": "574D43EF-A896-5511-8B4E-5B616AB730E4",
"name": "document",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyKey",
"id": "C905D209-15ED-577C-9498-9072963B3153",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OriginLineKey",
"id": "9D5490F9-09DB-5C91-9F43-977FAF9FF1EE",
"name": "line",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ProductKey",
"id": "BFDB3451-402D-52F2-B469-1306B0AB7455",
"name": "product",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Product",
"Reference",
"CatalogueUnit",
"Brand",
"SupplierReference",
"NCM",
"GeneralMin",
"GeneralMax",
"MaxDiscount",
"Commission"
],
"sourceID": "B4DEE981-581C-57DB-951A-69CEB6E826EE",
"sqlQuery": "SELECT CONVERT(varchar(max), c.NUNOTA) AS DocumentKey, CONVERT(varchar(max), c.CODEMP) AS CompanyKey, CONVERT(date, c.DTNEG) AS ScopeDay, CONVERT(varchar(max), i.NUNOTA) AS OriginDocumentKey, CONVERT(varchar(max), c.CODEMP) AS OriginCompanyKey, CONCAT(CONVERT(varchar(max), i.NUNOTA),N'|',CONVERT(varchar(max), i.SEQUENCIA)) AS LineKey, CONVERT(varchar(max), i.SEQUENCIA) AS OriginLineKey, CONVERT(varchar(max), i.CODPROD) AS OriginProductKey, CONVERT(varchar(max), p.CODPROD) AS ProductKey, p.DESCRPROD AS Product, p.REFERENCIA AS Reference, p.CODVOL AS CatalogueUnit, p.MARCA AS Brand, p.REFFORN AS SupplierReference, p.NCM AS NCM, CONVERT(varchar(max), p.ESTMIN) AS GeneralMin, CONVERT(varchar(max), p.ESTMAX) AS GeneralMax, CONVERT(varchar(max), p.DESCMAX) AS MaxDiscount, CONVERT(varchar(max), p.COMVEND) AS Commission FROM dbo.TGFCAB c INNER JOIN dbo.TGFITE i ON i.NUNOTA=c.NUNOTA INNER JOIN dbo.TGFPRO p ON p.CODPROD=i.CODPROD AND (SELECT COUNT_BIG(*) FROM dbo.TGFPRO u WHERE u.CODPROD=p.CODPROD)=1 WHERE c.TIPMOV='O' AND c.NUNOTA IS NOT NULL AND c.CODEMP IS NOT NULL AND (SELECT COUNT_BIG(*) FROM dbo.TGFCAB u WHERE u.NUNOTA=c.NUNOTA)=1 AND c.DTNEG IS NOT NULL AND c.NUNOTA=:document AND c.CODEMP=:company AND CONVERT(date, c.DTNEG)=:selected_day AND i.NUNOTA IS NOT NULL AND i.SEQUENCIA IS NOT NULL AND (SELECT COUNT_BIG(*) FROM dbo.TGFITE u WHERE u.NUNOTA=i.NUNOTA AND u.SEQUENCIA=i.SEQUENCIA)=1 AND i.SEQUENCIA=:line AND i.CODPROD=:product",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "FCB9AD9E-B8D0-5553-B250-5E4FB15A9ACA",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "F05FB970-558A-5EAA-ADE8-087DA7F51612",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "05680B87-7CA6-589B-9011-85A6D18C904B",
"title": "Itens do pedido",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Company",
"label": "Empresa do pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Negotiated",
"label": "Data de negociação",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Value",
"label": "Valor original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Status da nota — código",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E3F31C14-839C-55CE-A2C1-9DA7682F936D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Partner",
"label": "Parceiro atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Company",
"label": "Empresa do pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Operation",
"label": "Operação histórica",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Negotiated",
"label": "Data de negociação",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoicedAt",
"label": "Data de faturamento registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EntryExitAt",
"label": "Data de entrada/saída registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Observation",
"label": "Observações do pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Value",
"label": "Valor original do pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Freight",
"label": "Frete original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HeaderDiscount",
"label": "Desconto total registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItemDiscount",
"label": "Desconto total de itens registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ICMSBase",
"label": "Base ICMS original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ICMS",
"label": "ICMS original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IPIBase",
"label": "Base IPI original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IPI",
"label": "IPI original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FreightType",
"label": "Tipo de frete — código",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Status da nota — código",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DiscountPercent",
"label": "Desconto (%) registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OperationState",
"label": "Histórico de operação",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PartnerState",
"label": "Cadastro do parceiro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "593850E8-EA2E-5914-B608-C06D5366CFA5",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "9C153B78-7C0D-568B-8938-7E3E2D046F7D",
"includeAllOption": false,
"key": "Negotiated",
"title": "Escolher período de negociação",
"type": "date"
},
{
"id": "A9FE535F-5C97-5C2D-99C2-CB6354DC3005",
"includeAllOption": false,
"key": "Company",
"title": "Escolher empresa autorizada",
"type": "text"
},
{
"id": "99A80537-8FE8-5419-A2BD-73C83CF3E18F",
"includeAllOption": true,
"key": "Status",
"title": "Status registrado — opcional",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "03285F1C-502B-5C15-AC9B-66C1CB05FACC",
"key": "Negotiated",
"type": "date"
},
{
"direction": "ascending",
"id": "6C99D094-05D0-5681-9500-0CA5504BECC9",
"key": "DocumentKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Operation",
"systemImage": "doc.text",
"title": "Pedidos de compra",
"titleKey": "Partner"
},
{
"actions": [
{
"id": "2F87C5E9-7DAF-5361-BD31-F6FDE3836A7B",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "39DA0A73-A182-5957-87CE-C352B4D39174",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "BA1B20C3-FA27-55B0-9CF9-39D89B744872",
"title": "Ficha do produto",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Unit",
"label": "Unidade deste item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Quantity",
"label": "Quantidade",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Delivered",
"label": "Entrega registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineValue",
"label": "Total original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Pending",
"label": "Pendente — código registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "05680B87-7CA6-589B-9011-85A6D18C904B",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Product",
"label": "Produto atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Reference",
"label": "Referência atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItemCompany",
"label": "Empresa registrada no item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Location",
"label": "Local de origem atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Control",
"label": "Controle registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Unit",
"label": "Unidade deste item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Quantity",
"label": "Quantidade negociada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Delivered",
"label": "Quantidade entregue registrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UnitValue",
"label": "Valor unitário original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineValue",
"label": "Total original do item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineDiscount",
"label": "Desconto original do item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ICMS",
"label": "ICMS original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IPIBase",
"label": "Base IPI original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CFOP",
"label": "CFOP registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Pending",
"label": "Pendente — código registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DiscountPercent",
"label": "Desconto (%) registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProductState",
"label": "Cadastro do produto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LocationState",
"label": "Cadastro do local",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "5B032646-1084-5C60-B3C2-0AA25CD69908",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Reference",
"systemImage": "doc.text",
"title": "Itens do pedido",
"titleKey": "Product"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CatalogueUnit",
"label": "Unidade padrão",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Brand",
"label": "Marca atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NCM",
"label": "NCM atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GeneralMin",
"label": "Mínimo geral",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GeneralMax",
"label": "Máximo geral",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "BA1B20C3-FA27-55B0-9CF9-39D89B744872",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Product",
"label": "Produto atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Reference",
"label": "Referência atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Brand",
"label": "Marca atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CatalogueUnit",
"label": "Unidade padrão atual — sem conversão",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SupplierReference",
"label": "Referência do fornecedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NCM",
"label": "NCM atual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GeneralMin",
"label": "Estoque mínimo geral",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GeneralMax",
"label": "Estoque máximo geral",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MaxDiscount",
"label": "Desconto máximo configurado (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Commission",
"label": "Comissão configurada (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "68BE4833-F096-5F3F-881D-6F58988CDD26",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Reference",
"systemImage": "doc.text",
"title": "Ficha do produto",
"titleKey": "Product"
}
],
"relations": [
{
"childDatasetID": "05680B87-7CA6-589B-9011-85A6D18C904B",
"childKey": "OriginDocumentKey",
"id": "F05FB970-558A-5EAA-ADE8-087DA7F51612",
"name": "Itens do pedido",
"parentDatasetID": "E3F31C14-839C-55CE-A2C1-9DA7682F936D",
"parentKey": "DocumentKey"
},
{
"childDatasetID": "BA1B20C3-FA27-55B0-9CF9-39D89B744872",
"childKey": "LineKey",
"id": "39DA0A73-A182-5957-87CE-C352B4D39174",
"name": "Ficha do produto",
"parentDatasetID": "05680B87-7CA6-589B-9011-85A6D18C904B",
"parentKey": "LineKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sankhya Om",
"changelog": "Novo dossiê Pro de pedidos de compra, itens e produto; galeria nativa fictícia, 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 equipes de compras e abastecimento e gestores: escolha empresa e período de negociação. Consulte pedidos, parceiro, operação histórica, datas registradas, observações, valores originais, frete, descontos e ICMS/IPI. Abra Itens do pedido com quantidades, unidade do item, entrega registrada, controle, local, CFOP, valores e código de pendência; a Ficha do produto traz referências, marca, NCM e parâmetros gerais atuais.\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 sob demanda; somente SELECT, live, no máximo 2.000 resultados por leitura, sem refresh periódico. A abertura limita DTNEG, não prazo de entrega, baixa ou saldo histórico. Seleciona exclusivamente TIPMOV=O (Pedido de Compra). Notas faturadas, devoluções e outros movimentos não são incluídos. Status e pendência são códigos nativos: não inventa status ativo, cancelado, atraso ou quantidade ainda devida.\n\nNUNOTA e NUNOTA+SEQUENCIA identificam documento/item e ficam ocultos. Número comercial da nota não é inferido por causa de grafias conflitantes na documentação. A operação usa CODTIPOPER e a versão DHTIPOPER=DHALTER, não a versão mais recente. Outros cadastros são ATUAIS, não snapshots da emissão. Cadastros ausentes ou repetidos não multiplicam nem apagam pedido/item; nomes não únicos ficam indisponíveis. As fichas exigem produto único; identidades nulas/repetidas são recusadas. Cada sub-botão revalida pedido, empresa, tipo, dia de negociação selecionado e, na ficha, sequência/produto. O período usa os filtros nativos de abertura com as duas datas; o dia do pedido é revalidado em cada sub-botão. A empresa do item é mostrada separadamente; não impõe igualdade não documentada com a empresa do cabeçalho.\n\nQuantidades e valores preservam a representação original como texto, inclusive zero, negativos e NULL. Unidade do item é CODVOL da linha, não a unidade atual do produto; não converte unidades nem soma produtos. Total do item vem de VLRTOT, nunca QTDNEG×VLRUNIT. Descontos e impostos ficam separados: não recalcula total líquido, lucro ou impostos, não adiciona impostos duas vezes e não pressupõe moeda/câmbio. Confira a moeda na fonte antes de interpretar valores. Mínimo/máximo do produto são parâmetros gerais, não estoque atual.\n\nO administrador deve confirmar os sete objetos dbo, 59 nomes selecionados e identidades/datas/tipos da instalação SQL Server. dbo é requisito do adaptador, não owner universal provado. O portal v2.0 não identifica versão ERP e os tipos Oracle do manual não certificam DDL SQL Server. Confirmar índices, collation, timeout e plano de execução; limite de resultados não garante consulta barata. Busca local abrange só dados carregados. SQL direto não herda permissões do ERP: usar leitor SELECT restrito às empresas, itens e dados autorizados, não apenas filtro visual. Não envia pedidos nem altera estoque. Sem credenciais, CPF/CNPJ, NF-e ou dados bancários. Não pacote Oracle nem acesso automático ao Cloud. Testes documentais/sintéticos; não testada em ERP, SQL Server ou iOS reais. Capturas reais do Cifru Android com dados DEMO integralmente inventados; sem conexão ou registros de um Sankhya real.\n\nEstrutura física e relações: https://developer.sankhya.com.br/docs/operacoes-comerciais\nTipos de movimento: https://ajuda.sankhya.com.br/hc/pt-br/articles/360044601114-Campos-para-An%C3%A1lise-de-Giro\n\nCobertura da galeria: 8 imagens complementares mostram card completo de um pedido DEMO, todas as continuações dos 20 Detalhes do pedido, 18 do item e dez da ficha atual do produto, com os dois sub-botões realmente abertos. Empresa/período são selecionados na abertura. Outros pedidos, itens, empresas e casos adversariais não estão todos retratados. Cifru Android com transporte sintético local, não conexão ou teste em ERP/SQL Server/iOS, desempenho ou compra Pro. Home, listagem ampla e RAW ficam privados; guia da fonte separado.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "791513C8-2A71-57D5-9925-8D375676EC26",
"rootButtonCount": 1,
"summary": "Empresa e período na abertura; operação histórica, Detalhes completos e itens/produto sob demanda.",
"tags": [
"Sankhya Om",
"SQL Server",
"Compras",
"Pedidos",
"Itens",
"Produto",
"Pro"
],
"title": "Pedidos de compra + itens e produto — Pro"
}
}