Árvore de páginas

Versões comparadas

Chave

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

...

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
DXXHistórico Contrato Carreteirode Pagamentos Repom

Tabelas Alteradas para inclusão de campos:

TabelaDescrição
DELCartões Op. Frota Motoristas
DUJContrato Fornecedor   
DTRComplemento da Viagem
Totvs custom tabs box items
defaultno
referenciaSX3


Campos Criados:

TABELACAMPOTIPOTAMANHOTITULOFORMATOVALIDRELACAOCONSULTA PADRÃOOpçõesWHENInicializador Padrão
DELDEL_SERMDFC3Série Manif !!!                                          TMSAF92Vld()                                                                                                                    IF(INCLUI,"",SF2->F2_SERMDF)                                                                                                                                                                                                                                                                                                                                                                                      
DUJDUJ_IDOPEC8Filial                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
DUJDUJ_RESPGR   C9Documento   @!                                           TMSAF93Vld()                                                                                                                                                                                                                                                    F2COEN                                                                                                                                                                                                                                                                            
DTRDNG_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                                            

...