Ajude o site desativando o bloqueador de anúncio
Cabeçalho

Tabela 2410 GWM

Autor: Eurai Criado: 01/03/2025 Atualizado: 01/03/2025 Protheus
Postagem

Salve salve, blz?

 

 

Tabela GWM. #GWM

 

 

 

 

SX2 - TABELA

X2_CHAVE X2_PATH X2_ARQUIVO X2_NOME X2_NOMESPA X2_NOMEENG X2_ROTINA X2_MODO X2_MODOUN X2_MODOEMP X2_DELET X2_TTS X2_UNICO X2_PYME X2_MODULO X2_DISPLAY X2_SYSOBJ X2_USROBJ X2_POSLGT X2_CLOB X2_AUTREC X2_TAMFIL X2_TAMUN X2_TAMEMP X2_STAMP X2_INSDT
GWM DATA GWM990 RATEIO CONTABIL DE FRETE PROR. CONTAB. DE FLETE FREIGHT ACCOUNTING APPORTIONME E E E 0 GWM_FILIAL+GWM_TPDOC+GWM_CDESP+GWM_CDTRP+GWM_SERDOC+GWM_NRDOC+DTOS(GWM_DTEMIS)+GWM_CDTPDC+GWM_EMISDC+GWM_SERDC+GWM_NRDC+GWM_GRPCTB+GWM_SEQGW8 S 78 1 2 2 2 0 0

 

 

 

 

SX3 - CAMPOS

X3_ARQUIVO X3_ORDEM X3_CAMPO X3_TIPO X3_TAMANHO X3_DECIMAL X3_TITULO X3_DESCRIC X3_PICTURE X3_VALID X3_RELACAO X3_F3 X3_NIVEL X3_TRIGGER X3_BROWSE X3_VISUAL X3_CONTEXT X3_OBRIGAT X3_CBOX X3_PICTVAR X3_WHEN X3_INIBRW X3_GRPSXG X3_FOLDER
GWM 01 GWM_FILIAL C 2 0 Filial Filial do Sistema 1 N 033
GWM 02 GWM_TPDOC C 1 0 Tipo Docto Tipo de documento Pertence("1234") "1" 1 S A R 1=Calculo Frete;2=CTRC/NFS;3=Contrato Autonomo;4=Estimativa inclui
GWM 03 GWM_CDESP C 5 0 Especie DF Especie do Docto Frete @! ExistCpo("GVT") GVTFRT 1 S A R INCLUI
GWM 04 GWM_CDTRP C 14 0 Transp. Transportador @! ExistCpo("GU3") GU3TRP 1 S A R inclui 052
GWM 05 GWM_DSTRP C 80 0 Nome Nome do transportador. IF(!INCLUI,POSICIONE("GU3",1,XFILIAL("GU3")+GWM->GWM_CDTRP,"GU3_NMEMIT"),"") 1 N V V 059
GWM 06 GWM_SERDOC C 5 0 Serie Docto Serie do documento @! 1 S A R inclui
GWM 07 GWM_NRDOC C 16 0 Nr Docto Numero do documento @! 1 S A R inclui
GWM 08 GWM_DTEMIS D 8 0 Data Emissao Data de Emissao 1 S A R
GWM 09 GWM_CDTPDC C 5 0 Tipo DC Tipo Docto Carga @! ExistCpo("GV5",M->GWM_CDTPDC) GV5 1 S A R inclui
GWM 10 GWM_DSTPDC C 50 0 Descricao Descricao Tipo DC @! IF(!INCLUI,POSICIONE("GV5",1,XFILIAL("GV5")+GWM->GWM_CDTPDC,"GV5_DSTPDC")," ") 1 N V V
GWM 11 GWM_EMISDC C 14 0 Emissor DC Emissor Docto. Carga @! ExistCpo("GU3") GU3GUC 1 S A R inclui 052
GWM 12 GWM_NMEMIT C 80 0 Nome Nome do emissor IF(!INCLUI,POSICIONE("GU3",1,XFILIAL("GU3")+GWM->GWM_EMISDC,"GU3_NMEMIT"),"") 1 N V V 059
GWM 13 GWM_SERDC C 3 0 Serie DC Serie Documento Carga !!! 1 S A R inclui 094
GWM 14 GWM_NRDC C 16 0 Nr DC Nr. Documento Carga @! 1 S A R inclui
GWM 15 GWM_SEQGW8 C 5 0 Sequência Sequência 99999 1 N V R
GWM 16 GWM_DTEMDC D 8 0 Data Emis DC Data Emissao Doc Carga 1 S V
GWM 17 GWM_ITEM C 16 0 Item Item @! NAOVAZIO() .AND. TEXTO() 1 S A R 055
GWM 18 GWM_UNINEG C 3 0 Unid Negocio Unidade de Negócio 1 N A R 132
GWM 19 GWM_GRPCTB C 140 0 Grupo Ctbl Grupo Contabil @! 1 N V R
GWM 20 GWM_GRP1 C 20 0 Grupo 1 Grupo contabil 1 @! 1 S A R inclui
GWM 21 GWM_GRP2 C 20 0 Grupo 2 Grupo contabil 2 @! 1 S A R inclui
GWM 22 GWM_GRP3 C 20 0 Grupo 3 Grupo contabil 3 @! 1 S A R inclui
GWM 23 GWM_GRP4 C 20 0 Grupo 4 Grupo contabil 4 @! 1 S A R inclui
GWM 24 GWM_GRP5 C 20 0 Grupo 5 Grupo contabil 5 @! 1 S A R inclui
GWM 25 GWM_GRP6 C 20 0 Grupo 6 Grupo contabil 6 @! 1 S A R inclui
GWM 26 GWM_GRP7 C 20 0 Grupo 7 Grupo contabil 7 @! 1 S A R inclui
GWM 27 GWM_CTINAU C 20 0 INSS Aut Conta INSS Autonomo @! ExistCpo("GUE") GUE 1 N A R 056
GWM 28 GWM_CCINAU C 20 0 C C INSS Aut Centro Custo INSS Autonom @! Vazio() .OR. ExistCpo("GUH") 1 N A R 057
GWM 29 GWM_DSCTIA C 50 0 Descricao Descricao da Conta @! IF(!INCLUI,POSICIONE("GUE",1,XFILIAL("GUE")+GWM->GWM_CTINAU,"GUE_TITULO")," ") 1 N V V
GWM 30 GWM_DSCCIA C 60 0 Descricao CC Descricao Centro Custo @! IF(!INCLUI,POSICIONE("GUH",1,XFILIAL("GUH")+GWM->GWM_CCINAU,"GUH_DESC")," ") 1 N V V
GWM 31 GWM_CTINEM C 20 0 INSS Embarc Conta INSS Embarcador @! GUE 1 S A R 056
GWM 32 GWM_DSCTIE C 50 0 Desc Conta Descricao da Conta @! IF(!INCLUI,POSICIONE("GUE",1,XFILIAL("GUE")+GWM->GWM_CTINEM,"GUE_TITULO")," ") 1 S V V
GWM 33 GWM_CCINEM C 20 0 CC INSS Emb Centro Custo INSS Embarc @! Vazio() .OR. ExistCpo("GUH") 1 S A R 057
GWM 34 GWM_DSCCIE C 60 0 Desc CCusto Descricao Centro Custo @! IF(!INCLUI,POSICIONE("GUH",1,XFILIAL("GUH")+GWM->GWM_CCINEM,"GUH_DESC")," ") 1 S V V
GWM 35 GWM_CTIRRF C 20 0 IRRF Conta IRRF @! ExistCpo("GUE") GUE 1 N A R 056
GWM 36 GWM_DSCTIR C 50 0 Descricao Descricao da Conta @! IF(!INCLUI,POSICIONE("GUE",1,XFILIAL("GUE")+GWM->GWM_CTIRRF,"GUE_TITULO")," ") 1 N V V
GWM 37 GWM_CCIRRF C 20 0 C C IRRF Centro Custo IRRF @! Vazio() .OR. ExistCpo("GUH") 1 N A R 057
GWM 38 GWM_DSCCIR C 60 0 Descricao CC Descricao Centro Custo @! IF(!INCLUI,POSICIONE("GUH",1,XFILIAL("GUH")+GWM->GWM_CCIRRF,"GUH_DESC")," ") 1 N V V
GWM 39 GWM_CTSEST C 20 0 SEST/SENAT Conta SEST/SENAT @! ExistCpo("GUE") GUE 1 N A R 056
GWM 40 GWM_DSCTSE C 50 0 Descricao Descricao da Conta @! IF(!INCLUI,POSICIONE("GUE",1,XFILIAL("GUE")+GWM->GWM_CTSEST,"GUE_TITULO")," ") 1 N V V
GWM 41 GWM_CCSEST C 20 0 C C SEST Centro Custo SEST @! Vazio() .OR. ExistCpo("GUH") 1 N A R 057
GWM 42 GWM_DSCCSE C 60 0 Descricao CC Descricao Centro Custo @! IF(!INCLUI,POSICIONE("GUH",1,XFILIAL("GUH")+GWM->GWM_CCSEST,"GUH_DESC")," ") 1 N V V
GWM 43 GWM_CTISS C 20 0 ISS Conta ISS @! ExistCpo("GUE") GUE 1 N A R 056
GWM 44 GWM_DSCTIS C 50 0 Descricao Descricao da Conta @! IF(!INCLUI,POSICIONE("GUE",1,XFILIAL("GUE")+GWM->GWM_CTISS,"GUE_TITULO")," ") 1 N V V
GWM 45 GWM_CCISS C 20 0 C C ISS Centro Custo ISS @! Vazio() .OR. ExistCpo("GUH") 1 N A R 057
GWM 46 GWM_DSCCIS C 60 0 Descricao CC Descricao Centro Custo @! IF(!INCLUI,POSICIONE("GUH",1,XFILIAL("GUH")+GWM->GWM_CCISS,"GUH_DESC")," ") 1 N V V
GWM 47 GWM_CTICMS C 20 0 ICMS Conta ICMS @! GUE 1 N A R 056
GWM 48 GWM_DSCTIC C 50 0 Descricao Descricao da Conta @! IF(!INCLUI,POSICIONE("GUE",1,XFILIAL("GUE")+GWM->GWM_CTICMS,"GUE_TITULO")," ") 1 N V V
GWM 49 GWM_CCICMS C 20 0 C C ICMS Centro Custo ICMS @! Vazio() .OR. ExistCpo("GUH") 1 N A R 057
GWM 50 GWM_DSCCIC C 60 0 Descricao CC Descricao Centro Custo @! IF(!INCLUI,POSICIONE("GUH",1,XFILIAL("GUH")+GWM->GWM_CCICMS,"GUH_DESC")," ") 1 N V V
GWM 51 GWM_CTPIS C 20 0 PIS Conta PIS @! GUE 1 N A R 056
GWM 52 GWM_DSCTPI C 50 0 Descricao Descricao da Conta @! IF(!INCLUI,POSICIONE("GUE",1,XFILIAL("GUE")+GWM->GWM_CTPIS,"GUE_TITULO")," ") 1 N V V
GWM 53 GWM_CCPIS C 20 0 C C PIS Centro Custo PIS @! Vazio() .OR. ExistCpo("GUH") 1 N A R 057
GWM 54 GWM_DSCCPI C 60 0 Descricao CC Descricao Centro Custo @! IF(!INCLUI,POSICIONE("GUH",1,XFILIAL("GUH")+GWM->GWM_CCPIS,"GUH_DESC")," ") 1 N V V
GWM 55 GWM_CTCOFI C 20 0 COFINS Conta COFINS @! GUE 1 N A R 056
GWM 56 GWM_DSCTCO C 50 0 Descricao Descricao da Conta @! IF(!INCLUI,POSICIONE("GUE",1,XFILIAL("GUE")+GWM->GWM_CTCOFI,"GUE_TITULO")," ") 1 N V V
GWM 57 GWM_CCCOFI C 20 0 C C COFI Centro Custo COFI @! Vazio() .OR. ExistCpo("GUH") 1 N A R 057
GWM 58 GWM_DSCCCO C 60 0 Descricao CC Descricao Centro Custo @! IF(!INCLUI,POSICIONE("GUH",1,XFILIAL("GUH")+GWM->GWM_CCCOFI,"GUH_DESC")," ") 1 N V V
GWM 59 GWM_CTFRET C 20 0 Fretes Conta Frete @! GUE 1 S A R 056
GWM 60 GWM_DSCTFR C 50 0 Descricao Descricao da Conta @! IF(!INCLUI,POSICIONE("GUE",1,XFILIAL("GUE")+GWM->GWM_CTFRET,"GUE_TITULO")," ") 1 S V V
GWM 61 GWM_CCFRET C 20 0 C C Frete Centro Custo Frete @! Vazio() .OR. ExistCpo("GUH") 1 S A R 057
GWM 62 GWM_DSCCFR C 60 0 Descricao CC Descricao Centro Custo @! IF(!INCLUI,POSICIONE("GUH",1,XFILIAL("GUH")+GWM->GWM_CCFRET,"GUH_DESC")," ") 1 S V V
GWM 63 GWM_VLINAU N 12 2 Pes INSS Aut Valor de INSS Autonomo @E 999,999,999.99 1 S A R
GWM 64 GWM_VLINEM N 12 2 Pes INSS Emb Valor de INSS Embarcador @E 999,999,999.99 1 S A R
GWM 65 GWM_VLIRRF N 12 2 Peso IRRF Valor de IRRF @E 999,999,999.99 1 S A R
GWM 66 GWM_VLSEST N 12 2 Peso SEST Valor de SEST/SENAT @E 999,999,999.99 1 S A R
GWM 67 GWM_VLISS N 12 2 Peso ISS Valor de ISS @E 999,999,999.99 1 S A R
GWM 68 GWM_VLICMS N 12 2 Peso ICMS Valor de ICMS Peso @E 999,999,999.99 1 S A R
GWM 69 GWM_VLPIS N 12 2 Peso PIS Valor de PIS @E 999,999,999.99 1 S A R
GWM 70 GWM_VLCOFI N 12 2 Peso COFINS Valor de COFINS Peso @E 999,999,999.99 1 S A R
GWM 71 GWM_VLFRET N 12 2 Peso Frete Valor de Frete @E 999,999,999.99 1 S A R
GWM 72 GWM_VLINA1 N 12 2 Val INSS Aut Valor de INSS Autonomo @E 999,999,999.99 1 S A R
GWM 73 GWM_VLINE1 N 12 2 Val INSS Emb Valor de INSS Embarcador @E 999,999,999.99 1 S A R
GWM 74 GWM_VLIRR1 N 12 2 Val IRRF Valor de IRRF @E 999,999,999.99 1 S A R
GWM 75 GWM_VLSES1 N 12 2 Val SEST Valor de SEST/SENAT @E 999,999,999.99 1 S A R
GWM 76 GWM_VLISS1 N 12 2 Val ISS Valor de ISS @E 999,999,999.99 1 S A R
GWM 77 GWM_VLICM1 N 12 2 Val ICMS Valor de ICMS @E 999,999,999.99 1 S A R
GWM 78 GWM_VLPIS1 N 12 2 Val PIS Valor de PIS @E 999,999,999.99 1 S A R
GWM 79 GWM_VLCOF1 N 12 2 Val COFINS Valor de COFINS @E 999,999,999.99 1 S A R
GWM 80 GWM_VLFRE1 N 12 2 Val Frete Valor de Frete @E 999,999,999.99 1 S A R
GWM 81 GWM_VLINA2 N 12 2 Qtd INSS Aut Valor de INSS Autonomo @E 999,999,999.99 1 S A R
GWM 82 GWM_VLINE2 N 12 2 Qtd INSS Emb Valor de INSS Embarcador @E 999,999,999.99 1 S A R
GWM 83 GWM_VLICM2 N 12 2 Qtd ICMS Valor de ICMS @E 999,999,999.99 1 S A R
GWM 84 GWM_VLIRR2 N 12 2 Qtd IRRF Valor de IRRF @E 999,999,999.99 1 S A R
GWM 85 GWM_VLSES2 N 12 2 Qtd SEST Valor de SEST/SENAT @E 999,999,999.99 1 S A R
GWM 86 GWM_VLISS2 N 12 2 Qtd ISS Valor de ISS @E 999,999,999.99 1 S A R
GWM 87 GWM_VLPIS2 N 12 2 Qtd PIS Valor de PIS @E 999,999,999.99 1 S A R
GWM 88 GWM_VLCOF2 N 12 2 Qtd COFINS Valor de COFINS @E 999,999,999.99 1 S A R
GWM 89 GWM_VLFRE2 N 12 2 Qtd Frete Valor de Frete @E 999,999,999.99 1 S A R
GWM 90 GWM_VLINA3 N 12 2 Vol INSS Aut Valor de INSS Autonomo @E 999,999,999.99 1 S A R
GWM 91 GWM_VLINE3 N 12 2 Vol INSS Emb Valor de INSS Embarcador @E 999,999,999.99 1 S A R
GWM 92 GWM_VLIRR3 N 12 2 Vol IRRF Valor de IRRF @E 999,999,999.99 1 S A R
GWM 93 GWM_VLSES3 N 12 2 Vol SEST Valor de SEST/SENAT @E 999,999,999.99 1 S A R
GWM 94 GWM_VLISS3 N 12 2 Vol ISS Valor de ISS @E 999,999,999.99 1 S A R
GWM 95 GWM_VLICM3 N 12 2 Vol ICMS Valor de ICMS @E 999,999,999.99 1 S A R
GWM 96 GWM_VLPIS3 N 12 2 Vol PIS Valor de PIS @E 999,999,999.99 1 S A R
GWM 97 GWM_VLCOF3 N 12 2 Vol COFINS Valor de COFINS @E 999,999,999.99 1 S A R
GWM 98 GWM_VLFRE3 N 12 2 Vol Frete Valor de Frete @E 999,999,999.99 1 S A R
GWM 99 GWM_PCRAT N 9 5 % Rateio Percentual de Rateio @E 999.99999 1 S A R
GWM A0 GWM_PEDAG N 9 2 Pes Pedagio Valor de Pedagio @E 999,999.99 Positivo() 1 N A R
GWM A1 GWM_PEDAG1 N 9 2 Val Pedagio Valor de Pedagio @E 999,999.99 Positivo() 1 N A R
GWM A2 GWM_PEDAG2 N 9 2 Qtd Pedagio Valor de Pedagio @E 999,999.99 Positivo() 1 N A R
GWM A3 GWM_PEDAG3 N 9 2 Vol Pedagio Valor de Pedagio @E 999,999.99 Positivo() 1 N A R
GWM A4 GWM_SDOCDC C 3 0 Série Doc. Série do Documento Fiscal !!! 1 N V R 095

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
GWM 1 GWM_FILIAL+GWM_TPDOC+GWM_CDESP+GWM_CDTRP+GWM_SERDOC+GWM_NRDOC+DTOS(GWM_DTEMIS)+GWM_CDTPDC+GWM_EMISDC+GWM_SERDC+GWM_NRDC+GWM_SEQGW8 Tipo Docto + Especie DF + Transp. + Serie Docto + Nr Docto + Data Emis Tipo Docto + Especie DF + Transp. + Serie Docto + Nr Docto + Fecha Emi Doc. Type + Specie DF + Carrier + Doc. Series + Doc Nmb + Issue Date + S S 2 3
GWM 2 GWM_FILIAL+GWM_CDTPDC+GWM_EMISDC+GWM_SERDC+GWM_NRDC Tipo DC + Emissor DC + Serie DC + Nr DC Tipo DC + Emisor DC + Serie DC + Nr DC LD Type + Issuer DC + C.D.Series + DC Nm S S 2 3
GWM 3 GWM_EMISDC+GWM_FILIAL+DTOS(GWM_DTEMIS) Emissor DC + Filial + Data Emissao Emisor DC + Sucursal + Fecha Emis. Issuer DC + Branch + Issue Date S S 2 3
GWM 4 GWM_FILIAL+GWM_TPDOC+GWM_CDESP+GWM_CDTRP+GWM_SERDOC+GWM_NRDOC+DTOS(GWM_DTEMIS)+GWM_CDTPDC+GWM_EMISDC+GWM_SDOCDC+GWM_NRDC+GWM_SEQGW8 Tipo Docto + Especie DF + Transp. + Serie Docto + Nr Docto + Data Emis Tipo Docto + Especie DF + Transp. + Serie Docto + Nr Docto + Fecha Emi Doc. Type + Specie DF + Carrier + Doc. Series + Doc Nmb + Issue Date + S N 2 3
GWM 5 GWM_FILIAL+GWM_CDTPDC+GWM_EMISDC+GWM_SDOCDC+GWM_NRDC Tipo DC + Emissor DC + Série Doc. + Nr DC Tipo DC + Emisor DC + Serie Doc. + Nr DC LD Type + Issuer DC + Inv. Series + DC Nm S N 2 3

 

 

 

 

SXG - Grupo de Campos

XG_GRUPO XG_DESCRI XG_DESSPA XG_DESENG XG_SIZEMAX XG_SIZEMIN XG_SIZE XG_PICTURE
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2
052 Código do Emitente Cód Emisor Issuer Code 15 9 14 @!
055 Código do Item Codigo del Item Item Code 30 16 16 @!
056 Conta Contábil GFE Cuenta contable GFE GFE Ledger Account 70 20 20 @!
057 Centro de Custo GFE Centro de costo GFE GFE Cost Center 20 9 20 @!
059 Descrição de Emitente Descripcion de Emisor Description of Issuer 80 50 80
094 Id de Controle dos doc.fiscais Id de Control dos doc.fiscales Control ID of invoices 14 3 3 !!!
095 Série dos documentos fiscais Serie de documentos fiscales Invoice series 3 3 3 !!!
132 Unidade de Negócio. Unidad de negocio. Business Unit 8 3 3

 

 

 

 

 

 

 

 

 

 

Gostou? Compartilhe com seus amigos e deixe um comentário! ??

Um abraço, e até a próxima  

 

 

 

 

 

📰 Posts Relacionados

ASSINE A NEWSLETTER

Cadastrando...

PIX uDesenv

PIX QR Code para depósito

Clique para doar

Siga-nos

YouTube GitHub LinkedIn

Parceiros

Tudo em ADVPL - Blog parceiro

Blog ADVPL