Árvore de páginas

Versões comparadas

Chave

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

...

Após o preenchimento dos dados da tabela TXS clique em confirmar


Criação de Campos:

1-) Acesse Configurador > Base de Dados > Dicionário > Bases de Dados

2-) Clique em 
Dicionário de Dados posicione o cursor em campos e selecione a tabela onde este campo será inserido e clique em editar

3-) Clique em Incluir

4-) Preencha os campos da tabela TXS conforme tabela abaixo:

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                                                                                                                                

...

                                                                                                                                    

04. DEMAIS INFORMAÇÕES

Não há



05. ASSUNTOS RELACIONADOS

  • Não há