Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

TMSAI84 - Histórico de Integrações

TMSAI86 - Job Envio

TMSAI87 - Job Retorno

TMSAI83 - Chaves Protheus e Portal 

TMSAI92 -  Integração de NFs Com Viagem

TMSAI93 -  Integração de NFs Avulsas

OMSA040 - Motoristas


DETALHAMENTO DA ATUALIZAÇÃO DE DICIONÁRIO CONFORME ABAS

Totvs custom tabs box
tabsDicionário SX2, Dicionário SX3, Dicionário SX7, Dicionário SIX
idsSX2,SX3,SX7,SIX
Totvs custom tabs box items
defaultyes
referenciaSX2

Criação de tabelas:

TabelaDescrição
DNEViagens do Faturamento        
DNFNotas da Viagem               
DNGCOLENT-N.FISCAL SEM VEICULO     Nota  Fiscal Sem Veículo Colent

Tabelas Alteradas para inclusão de campos:

TabelaDescrição
CC0Manifesto Documentos Fiscais  
DA4Motoristas
DN1Config Integr Coleta/Entrega  
DN6Fontes de Integração          
DN8Filiais Externas              

Criação de índices:

DLZ:

DN0:

DN1:

DN2:

DN3:

DN4:

DN5:

DN6:

DN7:

DN8:

DNB:

DNC:

Totvs custom tabs box items
defaultno
referenciaSX3

Criação de Campos:

TabelaCampoDescrição
CC0    CC0_OK  Mark  
CC0    CC0_STAINTStatus Integ
DA4    DA4_EMAIL Email    
DN1    DN1_NFSVEIEnv NF s Vei
DN1    DN1_NFSVEIGrv Hist  
DN1    DN1_ENVPOREnv Portal
DN6    DN6_CODIGOCod Fonte
DN6    DN6_DESCRIDescrição   
DN6    DN6_TIPARQTipo Arquivo
DN6    DN6_VCRIPTVer.Cript.  
DN6    DN6_VERSAOVers. Layout
DN8    DN8_ID  Id SAAS
DN8    DN8_ALIAS Alias Org.
DN8    DN8_FILEXTFil Externa 


Tabela DLZ (Configurações do Check List)Campos Criados:

Campo
TABELA
DLZ_SEQUEN
CAMPO
Tipo
TIPO
Caractere
TAMANHO
Tamanho
TITULO
6
FORMATO

Decimal

0

Formato

@!

Título

Sequência                

Descrição

Sequência                

Usado

Não

Obrigatório

Não

Browse

Não

Opções

When

Relação

IIF(ISINCALLSTACK("TMSAI80"),"",GETSXENUM( "DLZ", "DLZ_SEQUEN" ))                                    

Val. Sistema

NaoVazio()                                                                                                                      

Help

Sequência                

Totvs custom tabs box items
defaultno
referenciaSX7
AMPO 001DN6->DN6_DESCRI                                            DN8_DESFONDN61XFILIAL("DN6") + M->DN8_CODFON   
Totvs custom tabs box items
defaultno
referenciaSIX

Índice

Ordem

ChaveDescrição
DLZ4DLZ_FILIAL+DLZ_CODCON+DLZ_SEQUEN              Cod Config + Sequência                                                

Índice

Ordem

ChaveDescrição
DN01DN0_FILIAL+DN0_CODIGO                                                                                                                                           Código                                                                
DN02DN0_FILIAL+STR(DN0_CODMOD)+DN0_ATIVO+DN0_CODIGO       Cod Modulo + Ativo + Código                                           

Índice

Ordem

ChaveDescrição
DN11DN1_FILIAL+DN1_CODCON+DN1_SEQUEN          Cod Config + Sequência                                                

Índice

Ordem

ChaveDescrição
DN21DN2_FILIAL+DN2_CODFON+DN2_CODREG          Cod Fonte + Cod Registro                                              
DN22DN2_FILIAL+DN2_CODFON+STR(DN2_PRIORI)                Cod Fonte + Prioridade                                                

Índice

Ordem

ChaveDescrição
DN31DN3_FILIAL+DN3_CODFON+DN3_CODREG+DN3_SEQUEN  Cod Fonte + Cod Registro + Sequencia                                  
DN32DN3_FILIAL+DN3_CODFON+DN3_CODREG+DN3_CAMPO                                            Cod Fonte + Cod Registro + Campo                                      

Índice

Ordem

ChaveDescrição
DN41DN4_FILIAL+DN4_CODFON+DN4_CODREG+DN4_CHAVE                                Cod Fonte + Cod Registro + Chave                                      

Índice

Ordem

ChaveDescrição
DN51DN5_FILIAL+DN5_CODFON+DN5_CODREG+DN5_SEQUEN                                                   Cod Fonte + Cod Registro + Sequencia                                  
DN52DN5_FILIAL+DN5_CODFON+DN5_CODREG+DN5_IDEXT                  Cod Fonte + Cod Registro + ID Externo                                 
DN53DN5_FILIAL+DN5_CODFON+DN5_CODREG+DN5_PROCES   Cod Fonte + Cod Registro + Processo                                   
DN54DN5_FILIAL+DN5_CODFON+DN5_LOCALI                               Cod Fonte + Localizador                                               
DN55DN5_FILIAL+DN5_CODFON+DN5_PROCES+DN5_LOCALI             Cod Fonte + Processo + Localizador                                    
DN56DN5_FILIAL+DN5_FILORI+DN5_STATUS+DN5_SITUAC                                               Fil Origem + Status + Situação                                        

Índice

Ordem

ChaveDescrição
DN61DN6_FILIAL+DN6_CODIGO                                      Cod Fonte                                                             

Índice

Ordem

ChaveDescrição
DN71DN7_FILIAL+DN7_CODMOT+DN7_CODFON     Cd Motorista + Cod Fonte                                              

Índice

Ordem

ChaveDescrição
DN81DN8_FILIAL+DN8_CODFON+DN8_FILINT       Cod Fonte + Fil Integra                                               

Índice

Ordem

ChaveDescrição
DNB1DNB_FILIAL+DNB_CODFON+DNB_CODREG+DNB_REGDES                                                                  Cod Fonte + Cod Registro + Reg Destino                                

Índice

Ordem

ChaveDescrição
DNC1DNC_FILIAL+DNC_CODFON+DNC_PROCES                                  Cod Fonte + Processo                                                  

05. ASSUNTOS RELACIONADOS

VALIDRELACAOCONSULTA PADRÃOOpçõesWHENInicializador Padrão
CC0CC0_OK    C4Mark        
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
CC0CC0_STAINTC1Status Integ                                             Pertence("12") 2      1=Sim;2=Não                                                                                                                                                                                                                                                                 
DA4DA4_EMAIL C30Email                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
DN1DN1_NFSVEIC1Env NF s Vei@! Pertence("12")                                                                                                                  1      1=Sim;2=Não                                                                                                                                                                                                                                                                 
DN1DN1_GRVHSTC1Grv Hist    @! Pertence("12")                                                                                                                  1      1=Automático;2=Manual                                                                                                                                                                                                                                                       
DN1DN1_ENVPORC1Env Portal  @!                                           Pertence("12")                                                                                                                  1      1=Automático;2=Manual                                                                                                                                                                                                                                                       
DN6DN6_CODIGOC2Cod Fonte   @!                                           ExistChav("DN6")                                                                                                                                                                                                                                                                                                                                                                                      Inclui                                                                                                                                      
DN6DN6_DESCRIC30Descrição   @!                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
DN6DN6_TIPARQC1Tipo Arquivo@!                                           Pertence("123")                                                                                                                 1      1=Json;2=Text;3=XML                                                                                                                                                                                                                                                         
DN6DN6_VCRIPTC50Ver.Cript.  @!                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
DN6DN6_VERSAOC50Vers. Layout@!                                                                                                                                                                           TMSAI81EMB()                                                                                                                                                                                                                                                                                                                      TMSAI81EMB(.T.)                                                                 
DN8DN8_ID    C4Id SAAS                                                  TMSAI85Vld()                                                                                                                                                                                                                                                    DN8UNI                                                                                                                                                                                                                                                                            
DN8DN8_ALIAS C50Alias Org.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
DN8DN8_FILEXTC40Fil Externa                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
DNEDNE_FILIALC8Filial                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
DNEDNE_FILORIC8Fil Viagem                                                                                                                                                                               cFilAnt                                                                                                                                                                                                                                                                                                                                                                                                           
DNEDNE_VIAGEMC6Viagem      @!                                                                                                                                                                           GETSX8NUM("DNE","DNE_VIAGEM")                                                                                                                                                                                                                                                                                                                                                                                     
DNEDNE_CODVEIC8Cod Veiculo @!                                           ExistCpo('DA3')                                                                                                                                                                                                                                                 DTU                                                                                                                                   Tmsaf92Whe()                                                                                                                                
DNEDNE_MODVEIC30Mod Veículo @!                                                                                                                                                                           IF(INCLUI,"",POSICIONE("DA3",1,XFILIAL("DA3")+DNE->DNE_CODVEI,"DA3_DESC"))                                                                                                                                                                                                                                                        Posicione("DA3",1,xFilial("DA3")+DNE->DNE_CODVEI,"DA3_DESC")                    
DNEDNE_CODMOTC6Cod Motor   @!                                           TM92VldInt(M->DNE_CODMOT)                                                                                                                                                                                                                                       DTO                                                                                                                                   Tmsaf92Whe()                                                                                                                                
DNEDNE_NOMMOTC40Nome Motor  @!                                                                                                                                                                           IF(INCLUI,"",POSICIONE("DA4",1,XFILIAL("DA4")+DNE->DNE_CODMOT,"DA4_NOME"))                                                                                                                                                                                                                                                        Posicione("DA4",1,xFilial("DA4")+DNE->DNE_CODMOT,"DA4_NOME")                    
DNEDNE_STATUSC1Status      @!                                           Pertence("12")                                                                                                                  1      1=Em Aberto;2=Fechado                                                                                                                                                                                                                                                       
DNFDNF_FILIALC8Filial                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
DNFDNF_FILORIC8Fil Viagem                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
DNFDNF_VIAGEMC6Viagem      @!                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
DNFDNF_ITEM  C4Item        @!                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
DNFDNF_FILNFCC8Fil N Fiscal                                             TMSAF92Vld()                                                                                                                                                                                                                                                    SM0                                                                                                                                                                                                                                                                               
DNFDNF_DOC   C9Nota Fiscal @!                                           TMSAF92Vld()                                                                                                                                                                                                                                                    SF2DNF                                                                                                                                                                                                                                                                            
DNFDNF_SERIE C3Série       !!!                                          TMSAF92Vld()                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
DNFDNF_CODCLIC6Cod Cliente @!                                                                                                                                                                           IF(INCLUI,"",POSICIONE("SF2",1,DNF->(DNF_FILNFC+DNF_DOC+DNF_SERIE),"F2_CLIENTE"))                                                                                                                                                                                                                                                                                                                                 
DNFDNF_LOJCLIC2Loja Cliente@!                                                                                                                                                                           IF(INCLUI,"",SF2->F2_LOJA)                                                                                                                                                                                                                                                                                                                                                                                        
DNFDNF_NOMCLIC40Nome Cliente@!                                                                                                                                                                           IF(INCLUI,"",POSICIONE("SA1",1,XFILIAL("SA1",SF2->F2_FILIAL)+SF2->(F2_CLIENTE+F2_LOJA),"A1_NOME"))                                                                                                                                                                                                                                                                                                                
DNFDNF_NUMMDFC9Num Manif   @!                                                                                                                                                                           IF(INCLUI,"",SF2->F2_NUMMDF)                                                                                                                                                                                                                                                                                                                                                                                      
DNFDNF_SERMDFC3Série Manif !!!                                          TMSAF92Vld()                                                                                                                    IF(INCLUI,"",SF2->F2_SERMDF)                                                                                                                                                                                                                                                                                                                                                                                      
DNGDNG_FILIALC8Filial                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
DNGDNG_DOC   C9Documento   @!                                           TMSAF93Vld()                                                                                                                                                                                                                                                    F2COEN                                                                                                                                                                                                                                                                            
DNGDNG_SERIE C3Serie       !!!                                          TMSAF93Vld()                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
DNGDNG_STATUSC1Status                                                                                                                                                                                   1      1=Sem Histórico;2=Com Histórico;                                                                                                                                                                                                                                            




Totvs custom tabs box items
defaultno
referenciaSX7
CAMPOSEQUENCIAREGRACONTRA DOMINIOALIASORDEMCHAVECONDIÇÃO
DN8_ID    1TMSAI85Var("DN8_ALIAS")                                                                             DN8_ALIAS    0                                                                                                                                            
DN8_ID    2TMSAI85Var("DN8_FILEXT")                                                                            DN8_FILEXT   0                                                                                                                                            
DNE_CODMOT1DA4->DA4_NOME                                                                                       DNE_NOMMOTDA41xFilial("DA4") + M->DNE_CODMOT                                                                                                              
DNE_CODVEI1DA3->DA3_DESC                                                                                       DNE_MODVEIDA31xFilial("DA3") + M->DNE_CODVEI                                                                                                              
DNE_CODVEI2DA3->DA3_MOTORI                                                                                     DNE_CODMOT   0xFilial("DA3") + M->DNE_CODVEI                                                                      TM92VldInt(DA3->DA3_MOTORI)             
DNF_DOC   1Posicione("SF2",1,M->(DNF_FILNFC + DNF_DOC + DNF_SERIE),"F2_CLIENTE")                               DNF_CODCLI   0                                                                                                    TM92CndGat()                            
DNF_DOC   2Posicione("SF2",1,M->(DNF_FILNFC + DNF_DOC + DNF_SERIE),"F2_LOJA")                                  DNF_LOJCLI   0                                                                                                    TM92CndGat()                            
DNF_DOC   3SA1->A1_NOME                                                                                        DNF_NOMCLISA11xFilial("SA1") + M->DNF_CODCLI + M->DNF_LOJCLI                                                      TM92CndGat()                            
DNF_DOC   4Posicione("SF2",1,M->(DNF_FILNFC + DNF_DOC + DNF_SERIE),"F2_NUMMDF")                                DNF_NUMMDF   0                                                                                                    TM92CndGat()                            
DNF_DOC   5Posicione("SF2",1,M->(DNF_FILNFC + DNF_DOC + DNF_SERIE),"F2_SERMDF")                                DNF_SERMDF   0                                                                                                    TM92CndGat()                            
DNF_SERIE 1Posicione("SF2",1,M->(DNF_FILNFC + DNF_DOC + DNF_SERIE),"F2_CLIENTE")                               DNF_CODCLI   0                                                                                                    TM92CndGat()                            
DNF_SERIE 2Posicione("SF2",1,M->(DNF_FILNFC + DNF_DOC + DNF_SERIE),"F2_LOJA")                                  DNF_LOJCLI   0                                                                                                    TM92CndGat()                            
DNF_SERIE 3SA1->A1_NOME                                                                                        DNF_NOMCLISA11xFilial("SA1")+M->DNF_CODCLI+M->DNF_LOJCLI                                                          TM92CndGat()                            
DNF_SERIE 4Posicione("SF2",1,M->(DNF_FILNFC + DNF_DOC + DNF_SERIE),"F2_NUMMDF")                                DNF_NUMMDF   0                                                                                                    TM92CndGat()                            
DNF_SERIE 5Posicione("SF2",1,M->(DNF_FILNFC + DNF_DOC + DNF_SERIE),"F2_SERMDF")                                DNF_SERMDF   0                                                                                                    TM92CndGat()                            
Totvs custom tabs box items
defaultno
referenciaSIX

Criação de índices:

INDICEORDEMCHAVEDESCRIÇÃO
DNE1DNE_FILIAL+DNE_FILORI+DNE_VIAGEM                                                                                                                                Fil Viagem + Viagem                                                   
DNF1DNF_FILIAL+DNF_FILORI+DNF_VIAGEM+DNF_ITEM+DNF_FILNFC+DNF_DOC+DNF_SERIE  Fil Viagem + Viagem + Item + Fil N Fiscal + Nota Fiscal + Série       
DNF2DNF_FILIAL+DNF_FILNFC+DNF_DOC+DNF_SERIE+DNF_FILORI+DNF_VIAGEM Fil N Fiscal + Nota Fiscal + Série + Fil Viagem + Viagem              
DNG1DNG_FILIAL+DNG_DOC+DNG_SERIE+DNG_STATUSDocumento + Serie + Status                                            

05. ASSUNTOS RELACIONADOS



Templatedocumentos