Árvore de páginas

Versões comparadas

Chave

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

...

  1. Ainda em Dicionário de Dados posicione na tabela TXR e clique em editar
  2. Posicione o cursor em Dicionário de dados e clique em Incluir 
  3. Realize o preenchimento da tabela TXR:
X3_CAMPOX3_TIPOX3_TAMANHOX3_DECIMALX3_TITULOX3_DESCRICX3_RELACAOX3_F3X3_PICTUREX3_BROWSEX3_VISUALX3_CONTEXTX3_VLDUSER

TXR_FILIALC80Filial      Filial do Sistema                                                                                                                                              @!                                           N

                                                                                                                                

TXR_CODIGOC60Cod. FacilitCodigo do Facilitador    GETSXENUM('TXR','TXR_CODIGO')                                                                                                         @!                                           SVR                                                                                                                                

TXR_DESC  C300Desc. FaciliDescricao Facilitador                                                                                                                                          @!                                           SAR                                                                                                                                

TXR_CODAA0C60Base Op.    Base Operacional                                                                                                                                         AA0   @!                                           NARVazio() .Or. ExistCpo('AA0')                                                                                                    

TXR_DSCAA0C300Desc. Base  Desc. Base Operacional   IIF(!INCLUI,ALLTRIM( POSICIONE("AA0",1,XFILIAL('AA0')+TXR->TXR_CODAA0,"AA0_DESCRI")),"")                                              @!                                           NVV                                                                                                                                


Criação de índice da tabela TXR: 

...

  1. Ainda em Dicionário de Dados posicione na tabela TXR e clique em editar
  2. Posicione o cursor em Dicionário de dados e clique em Incluir 
  3. Realize o preenchimento da tabela TXR:


TXS_FILIALC80Filial      

Filial do Sistema                                                                                                                                              @!                                           N

                                                                                                                                
TXS_CODIGOC60Codigo      
Codigo                   GETSXENUM('TXS','TXS_CODIGO')                                                                                                         @!                                           NVR                                                                                                                                
TXS_CODTXRC60Cod. Cabec  
Codigo do Cabecalho                                                                                                                                            @!                                           NAR                                                                                                                                
TXS_CODPRDC300Cod. Produto
Codigo do Produto                                                                                                                                        TECPRD@!                                           NAR EXISTCPO('SB1') .AND. EXISTCPO('SB5') .AND. AT740VLDPRD( 1, FWFLDGET("TXS_CODPRD") )                                           
TXS_DESCRIC300Desc. Produt
Descricao do Produto     ATINIPADMVC("TECA984A","TXSDETAIL",'B1_DESC','SB1',1, "XFILIAL('SB1')+TXS->TXS_CODPRD")                                               @!                                           NVV                                                                                                                                
TXS_QUANTSN40Quant. Suger
Quantidade Sugerida                                                                                                                                            @E 9999                                      NARPositivo()                                                                                                                      
TXS_VLUNITN142Vl. Unitario
Valor Unitario                                                                                                                                                 @E 99,999,999,999.99                         NARPositivo()                                                                                                                      
TXS_FUNCAOC50Funcao      
Codigo da Funcao                                                                                                                                         SRJ   @!                                           NARExistCpo("SRJ")                                                                                                                 
TXS_DESFUNC200Descricao   
Descricao da Funcao      ATINIPADMVC("TECA984A","TXSDETAIL",'RJ_DESC','SRJ',1, "XFILIAL('SRJ')+TXS->TXS_FUNCAO")                                               @!                                           NVV                                                                                                                                
TXS_TURNO C30Turno       

Codigo do Turno                                                                                                                                          TFFSR6@!                                           NARExistCpo("SR6")                                                                                                                 
TXS_DESTURC500Desc. Turn  
Descricao do Turno       ATINIPADMVC("TECA984A","TXSDETAIL",'R6_DESC','SR6',1, "XFILIAL('SR6')+TXS->TXS_TURNO")                                                @!                                           NVV                                                                                                                                
TXS_ESCALAC60Cod. Escala 
Codigo da Escala                                                                                                                                         TDW   @!                                           NARExistCpo('TDW')                                                                                                                 
TXS_DSCESCC600Desc. Escala
Descricao da Escala      ATINIPADMVC("TECA984A","TXSDETAIL",'TDW_DESC','TDW',1, "XFILIAL('TDW')+TXS->TXS_ESCALA")                                              @!!                                          NVV                                                                                                                                
TXS_CARGO C50Cargo       

Cargo do Recurso                                                                                                                                         SQ3ABO@!                                           NARVazio() .Or. ExistCpo('SQ3')                                                                                                    
TXS_DSCCARC300Desc. Cargo 
Descricao do Cargo       ATINIPADMVC("TECA984A","TXSDETAIL",'Q3_DESCSUM','SQ3',1, "XFILIAL('SQ3')+TXS->TXS_CARGO")                                             @!                                           NVV                                                                                                                                
TXS_TES   C30Tipo Saida  
Tipo de Saida                                                                                                                                            SF4   @!                                           NARExistCpo("SF4") .AND. FwFldGet("TXS_TES") > "500"                                                                               
TXS_CALCMDM100Mem. de Calc
Memoria de calculo                                                                                                                                                                                          NAR                                                                                                                                
TXS_PLACODC60Cod. Planilh
Codigo Planilha de Preco                                                                                                                                       @!                                           NAR                                                                                                                                
TXS_PLAREVC30Revisao Plan
Revisao Planilha de Preco                                                                                                                                      @999                                         NAR                                                                                                                                

Criação de índice da tabela TXS: 

...