Árvore de páginas

01. DADOS GERAIS

Linha de Produto:TOTVS Varejo Lojas
Segmento:Varejo
Módulo:SigaLoja (Controle de Loja)
Função:

Não há.

Ticket:Não há.
Story:DVARLOJ1-7153

02. SITUAÇÃO/REQUISITO

Gerar a publicação de Venda disponibilizada no Protheus permitindo a leitura dos dados de pagto (SL4) via Layout, pelo assinante TERCEIROS do processo de busca.

03. SOLUÇÃO

Integração entre sistemas TERCEIROS com o Protheus via SmartConnector.

Deverá ser cadastrado o assinante TERCEIROS, com o processo de venda ativo, e layout abaixo:

Json de Publicação Terceiros
{
	"L1_FILIAL": "01",
	"L1_CLIENTE": "&IIF( Empty(self:oRegistro['IdentificacaoCliente']), SuperGetMv('MV_CLIPAD', .F., '000001'), self:DePara('SA1', self:oRegistro['IdentificacaoCliente'], 2, 0) )",
	"L1_LOJA": "&IIF( Empty(self:oRegistro['IdentificacaoCliente']), SuperGetMv('MV_LOJAPAD', .F., '01'), self:DePara('SA1', self:oRegistro['IdentificacaoCliente'], 3, 0) )",
	"L1_OPERADO": "C06",
	"L1_EMISSAO": "&self:oRegistro['VendaData']",
	"L1_EMISNF": "&self:oRegistro['VendaData']",
	"L1_DTLIM": "&self:oRegistro['VendaData']",
	"L1_NUMMOV": "&SubStr(cValToChar(self:oRegistro['IdCaixa']),1,2)",
	"L1_NUMCFIS": "&self:oRegistro['Ccf']",
	"L1_DOC": "&self:oRegistro['Ccf']",
	"L1_SERIE": "&self:LayEstAuto('LG_SERIE')",
	"L1_SERPDV": "&cValToChar(self:oRegistro['SerieNota'])",
	"L1_SERSAT": "&IIF(self:oRegistro['ModeloFiscal'] == 1, self:oRegistro['Periferico']['NumeroSerie'], '')",
	"L1_KEYNFCE": "&self:oRegistro['Chaveacesso']",
	"L1_COMIS": 0,
	"L1_VLRTOT": "&self:oXmlSefaz:getTotal({'ICMSTot', 'vProd'}) - self:oXmlSefaz:getTotal({'ICMSTot', 'vDesc'}, 0) - self:oXmlSefaz:getTotal({'DescAcrEntr', 'vDescSubtot'}, 0)",
	"L1_VALBRUT": "&self:oXmlSefaz:getTotal({'ICMSTot', 'vProd'}) - self:oXmlSefaz:getTotal({'ICMSTot', 'vDesc'}, 0) - self:oXmlSefaz:getTotal({'DescAcrEntr', 'vDescSubtot'}, 0)",
	"L1_VLRLIQ": "&self:oXmlSefaz:getTotal({'ICMSTot', 'vProd'}) - self:oXmlSefaz:getTotal({'ICMSTot', 'vDesc'}, 0) - self:oXmlSefaz:getTotal({'DescAcrEntr', 'vDescSubtot'}, 0)",
	"L1_VALMERC": "&self:oXmlSefaz:getTotal({'ICMSTot', 'vProd'})",
	"L1_DESCONT": "&IIF(Len(self:oRegistro['VendaDescontoAcrescimos']) > 0 .And. self:oRegistro['VendaDescontoAcrescimos'][1]['Valor'] < 0 , Abs(self:oRegistro['VendaDescontoAcrescimos'][1]['Valor']), 0)",
	"L1_DESPESA": "&IIF(Len(self:oRegistro['VendaDescontoAcrescimos']) > 0 .And. self:oRegistro['VendaDescontoAcrescimos'][1]['Valor'] > 0 , self:oRegistro['VendaDescontoAcrescimos'][1]['Valor'], 0)",
	"L1_ORIGEM": "N",
	"L1_CGCCLI": "&IIF( Empty(self:oRegistro['CpfCnpjConsumidor']), '', self:oRegistro['CpfCnpjConsumidor'] )",
	"L1_CONDPG": "CN",
	"L1_SITUA": "IP",
	"L1_TIPO": "V",
	"L1_TIPOCLI": "F",
	"L1_ESPECIE": "&IIF( self:oRegistro['ModeloFiscal'] == 1, 'SATCE', IIF(self:oRegistro['ModeloFiscal'] == 2, 'NFCE', 'ECF') )",
	"L1_PDV": "&self:LayEstAuto('LG_PDV')",
	"L1_INDPRES": "&self:oXmlSefaz:get( , {'ide', 'indPres'}, '')",
	"SL2": [
		{
			"L2_FILIAL": "01",
			"L2_PRODUTO": "&self:oXmlSefaz:getDet({'prod', 'cProd'}, self:oRegistro['VendaItems'][nItem]['Sequencia'])",
			"L2_ITEM": "&StrZero(self:oRegistro['VendaItems'][nItem]['Sequencia'], TamSx3('L2_ITEM')[1])",
			"L2_DESCRI": "&self:oXmlSefaz:getDet({'prod', 'xProd'}, self:oRegistro['VendaItems'][nItem]['Sequencia'])",
			"L2_QUANT": "&self:oXmlSefaz:getDet({'prod', 'qCom'}, self:oRegistro['VendaItems'][nItem]['Sequencia'])",
			"L2_VRUNIT": "&self:oXmlSefaz:getDet({'prod', 'vUnCom'}, self:oRegistro['VendaItems'][nItem]['Sequencia'])",
			"L2_VLRITEM": "&self:oXmlSefaz:getDet({'prod', 'vProd'}, self:oRegistro['VendaItems'][nItem]['Sequencia'])",
			"L2_LOCAL": "&SuperGetMv('MV_LOCPAD', .F., '01')",
			"L2_UM": "&self:oXmlSefaz:getDet({'prod', 'uCom'}, self:oRegistro['VendaItems'][nItem]['Sequencia'])",
			"L2_VALDESC": "&self:oXmlSefaz:getDet({'prod', 'vDesc'}, self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_DESCPRO": "&self:oXmlSefaz:getDet({'prod', 'vRatDesc'}, self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_TES": "&SuperGetMv('MV_TESSAI', .F., '501', 'D MG 01')",
			"L2_EMISSAO": "&self:oRegistro['VendaData']",
			"L2_VEND": "&self:GetCadAux(self:oRegistro['VendaItems'][nItem]['Vendedor']['IdRetaguarda'],'OPERADOR DE LOJA','VENDEDOR')",
			"L2_CF": "&self:oXmlSefaz:getDet({'prod', 'CFOP'}, self:oRegistro['VendaItems'][nItem]['Sequencia'])",
			"L2_PICM": "&self:oXmlSefaz:getDetIcms('pICMS', self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_VALICM": "&self:oXmlSefaz:getDetIcms('vICMS', self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_BASEICM": "&self:oXmlSefaz:getDetIcms('vBC', self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_MODBC": "&self:oXmlSefaz:getDetIcms('modBC', self:oRegistro['VendaItems'][nItem]['Sequencia'], '0')",
			"L2_ORIGEM": "&self:oXmlSefaz:getDetIcms('Orig', self:oRegistro['VendaItems'][nItem]['Sequencia'], '0')",
			"L2_CLASFIS": "&self:oXmlSefaz:getDetIcms('Orig', self:oRegistro['VendaItems'][nItem]['Sequencia'], '') + self:oXmlSefaz:getDetIcms('CST', self:oRegistro['VendaItems'][nItem]['Sequencia'], '')",
			"L2_VALPS2": "&self:oXmlSefaz:getDetPIS('vPIS', self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_BASEPS2": "&self:oXmlSefaz:getDetPIS('vBC', self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_ALIQPS2": "&self:oXmlSefaz:getDetPIS('pPIS', self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_CSTPIS": "&self:oXmlSefaz:getDetPIS('CST', self:oRegistro['VendaItems'][nItem]['Sequencia'], '')",
			"L2_VALCF2": "&self:oXmlSefaz:getDetCOF('vCOFINS', self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_BASECF2": "&self:oXmlSefaz:getDetCOF('vBC', self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_ALIQCF2": "&self:oXmlSefaz:getDetCOF('pCOFINS', self:oRegistro['VendaItems'][nItem]['Sequencia'], 0)",
			"L2_CSTCOF": "&self:oXmlSefaz:getDetCOF('CST', self:oRegistro['VendaItems'][nItem]['Sequencia'], '')",
			"L2_BRICMS": "&self:oXmlSefaz:getDetIcms('vBCSTRet', self:oRegistro['VendaItems'][nItem]['Sequencia'], '0')",
			"L2_ICMSRET": "&self:oXmlSefaz:getDetIcms('vICMSSTRet', self:oRegistro['VendaItems'][nItem]['Sequencia'], '0')",
			"L2_ALQFCST": "&self:oXmlSefaz:getDetIcms('pFCPSTRet', self:oRegistro['VendaItems'][nItem]['Sequencia'], '0')",
			"L2_VFECPST": "&self:oXmlSefaz:getDetIcms('vFCPSTRet', self:oRegistro['VendaItems'][nItem]['Sequencia'], '0')",
			"L2_PREDIC": "&self:oXmlSefaz:getDetIcms('pRedBC', self:oRegistro['VendaItems'][nItem]['Sequencia'], '0')"
		}
	],
	"SL4": [
        {
            "L4_FILIAL": "01",
            "L4_DATA": "&self:oRegistro['VendaPagamentos'][nItem]['DataCadastro']",
            "L4_VALOR": "&self:oRegistro['VendaPagamentos'][nItem]['ValorPago']",
            "L4_ADMINIS": "&IIF(self:oRegistro['VendaPagamentos'][nItem]['PagamentoForma']['IdRetaguarda'] <> 'R$',self:DePara('SAE',self:oRegistro['VendaPagamentos'][nItem]['PagamentoOperadora']['Descricao'], 2, 0, .F., 'TERCEIROS'),'')",
            "L4_TROCO": "&self:oRegistro['VendaPagamentos'][nItem]['ValorTroco']",
            "L4_FORMA": "&self:DePara('SX5',self:oRegistro['VendaPagamentos'][nItem]['PagamentoForma']['IdRetaguarda'], 2, 0, .F., 'TERCEIROS')",
            "L4_NSUTEF": "&IIF(!Empty(self:oRegistro['VendaPagamentos'][nItem]['VendaPagamentoTefs']), self:oRegistro['VendaPagamentos'][nItem]['VendaPagamentoTefs'][nItem]['NsuHost'],'')",
            "L4_DOCTEF": "&IIF(!Empty(self:oRegistro['VendaPagamentos'][nItem]['VendaPagamentoTefs']), self:oRegistro['VendaPagamentos'][nItem]['VendaPagamentoTefs'][nItem]['NsuHost'],'')",
            "L4_BANDEIR": "&IIF(!Empty(self:oRegistro['VendaPagamentos'][nItem]['VendaPagamentoTefs']), self:oRegistro['VendaPagamentos'][nItem]['VendaPagamentoTefs'] [nItem]['Bandeira'],'')",
            "L4_PARCTEF": "&IIF(!Empty(self:oRegistro['VendaPagamentos'][nItem]['VendaPagamentoTefs']), self:oRegistro['VendaPagamentos'][nItem]['VendaPagamentoTefs'][nItem]['NumeroParcelas'],'')"
        }
    ]
}


04. DEMAIS INFORMAÇÕES

Informações sobre layouts da Venda

05. ASSUNTOS RELACIONADOS