Histórico da Página

...

Totvs custom tabs box

tabs	Implementação,Imagens
ids	apis_imagens

CONFIGURAÇÕES e FILTROS

Possibilitará ao usuário buscar as configurações cadastradas no conciliador e também os filtros para obter os dados de origem e destino.

Totvs custom tabs box items

default	yes
referencia	configuracoes_filtros

Será necessário desenvolvimento de API para recuperar as configurações adicionadas pelo usuário e os filtros a serem utilizados, deverá buscar essas informações no nos campos QLB_CODCFG, QLB_DESCFG e QLB_FILTER.

matchsetting

Bloco de código

language	coldfusion
theme	DJango
firstline	1
title	Json Request
linenumbers	true
collapse	true

[]

Bloco de código

language	coldfusion
theme	DJango
firstline	1
title	Json Response
linenumbers	true
collapse	true

{
    "items": [
        {
            "filter": {
                "tabdes": [
                    {
                        "order": "01",
                        "field": "CT2_DATA",
                        "title": "Data Lcto",
                        "type": "D",
                        "size": 8,
                        "picture": "99/99/9999",
                        "decimal": 0,
                        "operation": ">="
                    },
                    {
                        "order": "02",
                        "field": "CT2_DATA",
                        "title": "Data Lcto",
                        "type": "D",
                        "size": 8,
                        "picture": "99/99/9999",
                        "decimal": 0,
                        "operation": "<="
                    },
                    {
                        "order": "03",
                        "field": "CT2_LOTE",
                        "title": "Numero Lote",
                        "type": "C",
                        "size": 6,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "04",
                        "field": "CT2_DEBITO",
                        "title": "Cta Debito",
                        "type": "C",
                        "size": 20,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "05",
                        "field": "CT2_CCD",
                        "title": "C Custo Deb",
                        "type": "C",
                        "size": 9,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "06",
                        "field": "CT2_ITEMD",
                        "title": "Item Debito",
                        "type": "C",
                        "size": 9,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "07",
                        "field": "CT2_CLVLDB",
                        "title": "Cl Vlr Deb",
                        "type": "C",
                        "size": 9,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    }
                ],
                "tabori": [
                    {
                        "order": "10",
                        "field": "E1_TIPO",
                        "title": "Tipo",
                        "type": "C",
                        "size": 3,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "11",
                        "field": "E1_NATUREZ",
                        "title": "Natureza",
                        "type": "C",
                        "size": 10,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "12",
                        "field": "E1_VALOR",
                        "title": "Vlr.Titulo",
                        "type": "N",
                        "size": 16,
                        "picture": "@E 9,999,999,999,999.99",
                        "decimal": 2,
                        "operation": ">="
                    },
                    {
                        "order": "13",
                        "field": "E1_VALOR",
                        "title": "Vlr.Titulo",
                        "type": "N",
                        "size": 16,
                        "picture": "@E 9,999,999,999,999.99",
                        "decimal": 2,
                        "operation": "=<"
                    },
                    {
                        "order": "01",
                        "field": "E1_EMISSAO",
                        "title": "DT Emissao",
                        "type": "D",
                        "size": 8,
                        "picture": "",
                        "decimal": 0,
                        "operation": ">="
                    },
                    {
                        "order": "02",
                        "field": "E1_EMISSAO",
                        "title": "DT Emissao",
                        "type": "D",
                        "size": 8,
                        "picture": "",
                        "decimal": 0,
                        "operation": "<="
                    },
                    {
                        "order": "03",
                        "field": "E1_VENCREA",
                        "title": "Vencto real",
                        "type": "D",
                        "size": 8,
                        "picture": "",
                        "decimal": 0,
                        "operation": ">="
                    },
                    {
                        "order": "04",
                        "field": "E1_VENCREA",
                        "title": "Vencto real",
                        "type": "D",
                        "size": 8,
                        "picture": "",
                        "decimal": 0,
                        "operation": "<="
                    },
                    {
                        "order": "05",
                        "field": "E1_CLIENTE",
                        "title": "Cliente",
                        "type": "C",
                        "size": 6,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "06",
                        "field": "E1_LOJA",
                        "title": "Loja",
                        "type": "C",
                        "size": 2,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "07",
                        "field": "E1_PREFIXO",
                        "title": "Prefixo",
                        "type": "C",
                        "size": 3,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "08",
                        "field": "E1_NUM",
                        "title": "No. Titulo",
                        "type": "C",
                        "size": 9,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": ">="
                    },
                    {
                        "order": "09",
                        "field": "E1_NUM",
                        "title": "No. Titulo",
                        "type": "C",
                        "size": 9,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "=<"
                    }
                ]
            },
            "tabdes": "LANCAMENTOS CONTABEIS(CT2)",
            "codcfg": "0101",
            "tabori": "CONTAS A RECEBER(SE1)",
            "value": "T1||0101",
            "branch": "",
            "label": "0101-CONTABIL X CONTAS A RECEBER"
        },
        {
            "filter": {
                "tabdes": [
                    {
                        "order": "01",
                        "field": "CT2_DATA",
                        "title": "Data Lcto",
                        "type": "D",
                        "size": 8,
                        "picture": "99/99/9999",
                        "decimal": 0,
                        "operation": ">="
                    },
                    {
                        "order": "02",
                        "field": "CT2_DATA",
                        "title": "Data Lcto",
                        "type": "D",
                        "size": 8,
                        "picture": "99/99/9999",
                        "decimal": 0,
                        "operation": "<="
                    },
                    {
                        "order": "03",
                        "field": "CT2_LOTE",
                        "title": "Numero Lote",
                        "type": "C",
                        "size": 6,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "04",
                        "field": "CT2_CREDIT",
                        "title": "Cta Credito",
                        "type": "C",
                        "size": 20,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "05",
                        "field": "CT2_CCC",
                        "title": "C Custo Crd",
                        "type": "C",
                        "size": 9,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "06",
                        "field": "CT2_ITEMC",
                        "title": "Item Credito",
                        "type": "C",
                        "size": 9,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "07",
                        "field": "CT2_CLVLCR",
                        "title": "Cl Vlr Cred",
                        "type": "C",
                        "size": 9,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    }
                ],
                "tabori": [
                    {
                        "order": "10",
                        "field": "E2_TIPO",
                        "title": "Tipo",
                        "type": "C",
                        "size": 3,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "11",
                        "field": "E2_NATUREZ",
                        "title": "Natureza",
                        "type": "C",
                        "size": 10,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "12",
                        "field": "E2_VALOR",
                        "title": "Vlr.Titulo",
                        "type": "N",
                        "size": 16,
                        "picture": "@E 9,999,999,999,999.99",
                        "decimal": 2,
                        "operation": ">="
                    },
                    {
                        "order": "13",
                        "field": "E2_VALOR",
                        "title": "Vlr.Titulo",
                        "type": "N",
                        "size": 16,
                        "picture": "@E 9,999,999,999,999.99",
                        "decimal": 2,
                        "operation": "=<"
                    },
                    {
                        "order": "01",
                        "field": "E2_EMISSAO",
                        "title": "DT Emissao",
                        "type": "D",
                        "size": 8,
                        "picture": "",
                        "decimal": 0,
                        "operation": ">="
                    },
                    {
                        "order": "02",
                        "field": "E2_EMISSAO",
                        "title": "DT Emissao",
                        "type": "D",
                        "size": 8,
                        "picture": "",
                        "decimal": 0,
                        "operation": "<="
                    },
                    {
                        "order": "03",
                        "field": "E2_VENCREA",
                        "title": "Vencto Real",
                        "type": "D",
                        "size": 8,
                        "picture": "",
                        "decimal": 0,
                        "operation": ">="
                    },
                    {
                        "order": "04",
                        "field": "E2_VENCREA",
                        "title": "Vencto Real",
                        "type": "D",
                        "size": 8,
                        "picture": "",
                        "decimal": 0,
                        "operation": "<="
                    },
                    {
                        "order": "05",
                        "field": "E2_FORNECE",
                        "title": "Fornecedor",
                        "type": "C",
                        "size": 6,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "06",
                        "field": "E2_LOJA",
                        "title": "Loja",
                        "type": "C",
                        "size": 2,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "07",
                        "field": "E2_PREFIXO",
                        "title": "Prefixo",
                        "type": "C",
                        "size": 3,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "="
                    },
                    {
                        "order": "08",
                        "field": "E2_NUM",
                        "title": "No. Titulo",
                        "type": "C",
                        "size": 9,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": ">="
                    },
                    {
                        "order": "09",
                        "field": "E2_NUM",
                        "title": "No. Titulo",
                        "type": "C",
                        "size": 9,
                        "picture": "@!",
                        "decimal": 0,
                        "operation": "=<"
                    }
                ]
            },
            "tabdes": "LANCAMENTOS CONTABEIS(CT2)",
            "codcfg": "0102",
            "tabori": "CONTAS A PAGAR(SE2)",
            "value": "T1||0102",
            "branch": "",
            "label": "0102-CONTABIL X CONTAS A PAGAR"
        }
    ],
    "hasNext": false,
    "po_sync_date": "2021-08-25T17:19:20Z"
}

Totvs custom tabs box items

default	no
referencia	filtros_imagens

API para criar as tabelas e popular temporárias origem e destino, conterá os campos utilizados e as informações das tabelas, utilizará os campos QLB_TABORI, QLB_TABDES, QLB_FIELDS, QLB_REGORI e QLB_REGDES.

matchprocessing

Bloco de código

language	coldfusion
theme	DJango
firstline	1
title	Json Request
linenumbers	true
collapse	true

{
"codcfg": "0101",
"date": "20210728",
"time": "16:12",
"user": "a.santos",
"tabdes": [
{
     "field": "CT2_DATA",
"operation": ">=",
"value": "20210701",
"type": "D"
},
{
"field": "CT2_DATA",
"operation": "<=",
"value": "20210731",
"type": "D"
},
{
"field": "CT2_LOTE",
"operation": "=",
"value": "008850",
"type": "C"
},
{
"field": "(CT2_DEBITO OR CT2_CREDIT)",
"operation": "=",
"value": "",
"type": "C"
},
{
"field": "(CT2_CCD OR CT2_CCC)",
"operation": "=",
"value": "",
"type": "C"
},
{
"field": "(CT2_ITEMD OR CT2_ITEMC)",
"operation": "=",
"value": "",
"type": "C"
},
{
"field": "(CT2_CLVLDB OR CT2_CLVLCR)",
"operation": "=",
"value": "",
"type": "C"
}
],
"tabori": [
{
"field": "E1_TIPO",
"operation": "=",
"value": "",
"type": "C"
},
{
"field": "E1_NATUREZ",
"operation": "=",
"value": "",
"type": "C"
},
{
"field": "E1_VALOR",
"operation": ">=",
"value": 0.00,
"type": "N"
},
{
"field": "E1_VALOR",
"operation": "<=",
"value": 1000.00,
"type": "N"
},
{
"field": "E1_EMISSAO",
"operation": ">=",
"value": "20210701",
"type": "D"
},
{
"field": "E1_EMISSAO",
"operation": "<=",
"value": "20210731",
"type": "D"
},
{
"field": "E1_VENCREA",
"operation": ">=",
"value": "",
"type": "D"
},
{
"field": "E1_VENCREA",
"operation": "<=",
"value": "",
"type": "D"
},
{
"field": "E1_CLIENTE",
"operation": "=",
"value": "",
"type": "C"
},
{
"field": "E1_LOJA",
"operation": "=",
"value": "",
"type": "C"
},
{
"field": "E1_PREFIXO",
"operation": "=",
"value": "",
"type": "C"
},
{
"field": "E1_NUM",
"operation": ">=",
"value": "",
"type": "C"
},
{
"field": "E1_NUM",
"operation": "=<",
"value": "",
"type": "C"
}
]
}

Bloco de código

language	coldfusion
theme	DJango
firstline	1
title	Json Response
linenumbers	true
collapse	true

[]

Image Removed

...

GRID

Apresenta os lançamentos contábeis e os lançamentos da origem baseados nos filtros que o cliente selecionou.

...

Árvore de páginas

Versões comparadas

Versão antiga 16

Nova versão 17

Chave

CONFIGURAÇÕES e FILTROS

GRID