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

Tabela 2410 DUY

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

Salve salve, blz?

 

 

Tabela DUY. #DUY

 

 

 

 

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
DUY DATA DUY990 Grupos de Regiões Grupos regiones Region Groups C E E 0 DUY_FILIAL+DUY_GRPVEN S 43 DUY_FILIAL+DUY_GRPVEN+DUY_DESCRI+DUY_GRPSUP+DUY_EST+DUY_CATGRP+DUY_GRPVEN+DUY_FILDES+DUY_CODMUN TMSA115 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
DUY 01 DUY_FILIAL C 2 0 Filial Filial do Sistema 1 S 033
DUY 02 DUY_GRPVEN C 6 0 Grupo Regiao Grupo de Regiao @! TmsA115Vld() 1 S TMSA115Whe('DUY_GRPVEN')
DUY 03 DUY_DESCRI C 30 0 Descricao Descricao @! NaoVazio() 1 S TMSA115Whe('DUY_DESCRI')
DUY 04 DUY_GRPSUP C 6 0 Grp.Superior Grupo Superior @! 1 V TMSA115Whe('DUY_GRPSUP')
DUY 05 DUY_EST C 2 0 Estado Estado @! TmsA115Vld() TmsA120Ini(1) 12 1 S A R TMSA115Whe('DUY_EST')
DUY 06 DUY_FILDES C 2 0 Fil.Destino Filial de Destino Vazio() .Or. TMSValidEmp(cEmpAnt+M->DUY_FILDES) TmsA120Ini(2) DLB 1 V TMSA115Whe('DUY_FILDES') 033
DUY 07 DUY_CDRCOL C 6 0 Cod.Reg.Col. Codigo da Regiao Coligada @! TmsA115Vld() DUY1 1 TMSA115Whe('DUY_CDRCOL')
DUY 08 DUY_REGCOL C 30 0 Reg.Coligada Regiao Coligada @! If(Inclui,"",TmsA115Ini()) 1 V V TMSA115Whe('DUY_REGCOL')
DUY 09 DUY_CATREG C 1 0 Categ.Regiao Categoria da Regiao @! Pertence("12") "1" 1 V R 1=Praca a Praca; 2=Regiao Base para Taxa TMSA115Whe('DUY_CATREG')
DUY 10 DUY_CDRTAX C 6 0 Cod.Reg.Taxa Cod.Regiao Base para Taxa @! 1 V R TMSA115Whe('DUY_CDRTAX')
DUY 11 DUY_CATGRP C 1 0 Categ.Grupo Categoria do Grupo @! Pertence("123") "3" 1 V R 1=Estado;2=Filial;3=Regiao TMSA115Whe('DUY_CATGRP')
DUY 12 DUY_REGISE C 1 0 Reg. Isenta Regiao Isenta de Impostos @! Pertence("12") "2" 1 S 1=Sim;2=Nao TMSA115Whe('DUY_REGISE')
DUY 13 DUY_ALQISS N 5 2 Aliq. ISS Aliquota do ISS @E 99.99 Positivo() 1 N A R TMSA115Whe('DUY_ALQISS')
DUY 14 DUY_PAIS C 3 0 País Codigo do País @! Vazio() .Or. ExistCpo('SYA',M->DUY_PAIS,1) SYA 1 S TMSA115Whe('DUY_PAIS')
DUY 15 DUY_DEPAIS C 25 0 Desc.País Descrição do País @! Iif(Inclui,'',E_Field('DUY_PAIS','YA_DESCR')) 1 V V
DUY 16 DUY_CODMUN C 5 0 Cd.Municipio Código do Município @9 TmsA115Vld() CC2DUY 1 N A R TMSA115Whe('DUY_CODMUN')
DUY 17 DUY_PORTMS C 1 0 Portal TMS? Utiliza no portal TMS Pertence("12") "2" 1 N A R 1=Sim;2=Nao
DUY 18 DUY_CODFOR C 6 0 Cod Fornec Código do Fornecedor @! Vazio() .Or. ExistCpo("SA2",M->DUY_CODFOR+AllTrim(M->DUY_LOJFOR)) FOR 1 S N A R 001
DUY 19 DUY_LOJFOR C 2 0 Loja Fornec Loja do Fornecedor @! Vazio() .Or. ExistCpo("SA2",M->DUY_CODFOR+M->DUY_LOJFOR) 1 S N A R 002
DUY 20 DUY_NOMFOR C 50 0 Nome Fornec Nome do Fornecedor @! Iif(Inclui,"",Posicione("SA2",1,xFilial("SA2") + M->DUY_CODFOR + M->DUY_LOJFOR,"A2_NOME")) 1 N V V 177

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
DUY 1 DUY_FILIAL+DUY_GRPVEN Grupo Regiao Grupo Region Region Group S S 2 3
DUY 2 DUY_FILIAL+DUY_GRPSUP Grp.Superior Grp.Superior Top Group S S 2 3
DUY 3 DUY_FILIAL+DUY_DESCRI+DUY_EST Descricao + Estado Descripcion + Estado Description + State S S 2 3
DUY 4 DUY_FILIAL+DUY_EST+DUY_CATGRP+DUY_GRPVEN Estado + Categ.Grupo + Grupo Regiao Estado + Categ.Grupo + Grupo Region State + Categ.Group + Region Group S S 2 3
DUY 5 DUY_FILIAL+DUY_FILDES+DUY_CATGRP+DUY_GRPVEN Fil.Destino + Categ.Grupo + Grupo Regiao Suc.Destino + Categ.Grupo + Grupo Region Dest. Branch + Categ.Group + Region Group S S 2 3
DUY 6 DUY_FILIAL+DUY_EST+DUY_CODMUN Estado + Cd.Municipio Estado + Cd.Municipio State + Municip. Cd S S 2 3

 

 

 

 

SX7 - GATILHOS

X7_CAMPO X7_SEQUENC X7_REGRA X7_CDOMIN X7_TIPO X7_SEEK X7_ALIAS X7_ORDEM X7_CHAVE X7_CONDIC X7_PROPRI
DUY_CODFOR 001 SA2->A2_NOME DUY_NOMFOR P S SA2 1 xFilial("SA2") + M->DUY_CODFOR + M->DUY_LOJFOR S
DUY_LOJFOR 001 SA2->A2_NOME DUY_NOMFOR P S SA2 1 xFilial("SA2") + M->DUY_CODFOR + M->DUY_LOJFOR S
DUY_PAIS 001 SYA->YA_DESCR DUY_DEPAIS P S SYA 1 xFilial("SYA")+M->DUY_PAIS !Empty(M->DUY_PAIS) S

 

 

 

 

SX9 - Relacionamento entre Tabelas

X9_DOM X9_IDENT X9_CDOM X9_EXPDOM X9_EXPCDOM X9_PROPRI X9_LIGDOM X9_LIGCDOM X9_CONDSQL X9_USEFIL X9_ENABLE X9_VINFIL X9_CHVFOR
DUY 001 DT1 DUY_GRPVEN DT1_CDRORI S 1 N S S 2 2
DUY 002 DT1 DUY_GRPVEN DT1_CDRDES S 1 N S S 2 2
DUY 003 DT0 DUY_GRPVEN DT0_CDRORI S 1 N S S 2 2
DUY 004 DT0 DUY_GRPVEN DT0_CDRDES S 1 N S S 2 2
DUY 005 DTA DUY_FILDES DTA_FILDCA S 1 N S S 2 2
DUY 006 DW1 DUY_GRPVEN DW1_CDRORI S 1 N S S 2 2
DUY 007 DW1 DUY_GRPVEN DW1_CDRDES S 1 N S S 2 2
DUY 008 DV8 DUY_GRPVEN DV8_CDRDES S 1 N S S 2 2
DUY 009 DNA DUY_GRPVEN DNA_CODREG S 1 N S S 2 2
DUY 010 DWD DUY_GRPVEN DWD_CODREG S 1 N S S 2 2
DUY 011 DWI DUY_GRPVEN DWI_CDRORI S 1 N S S 2 2
DUY 012 DWI DUY_GRPVEN DWI_CDRDES S 1 N S S 2 2
DUY 013 DUN DUY_GRPVEN DUN_CDRDES S 1 N S S 2 2
DUY 014 DUN DUY_GRPVEN DUN_CDRDCA S 1 N S S 2 2
DUY 015 DTQ DUY_GRPVEN DTQ_CDRDES S 1 N S S 2 2
DUY 016 DTQ DUY_GRPVEN DTQ_CDRORI S 1 N S S 2 2
DUY 017 DEF DUY_GRPVEN DEF_CDRORI S 1 N S S 2 2
DUY 018 DEF DUY_GRPVEN DEF_CDRDES S 1 N S S 2 2
DUY 019 DEF DUY_GRPVEN DEF_CDRCAL S 1 N S S 2 2
DUY 020 DI5 DUY_GRPVEN DI5_CDRFRO S 1 N S S 2 2
DUY 021 DTB DUY_GRPVEN DTB_CDRDES S 1 N S S 2 2
DUY 022 DTD DUY_GRPVEN DTD_CDRORI S 1 N S S 2 2
DUY 023 DTD DUY_GRPVEN DTD_CDRDES S 1 N S S 2 2
DUY 024 DU5 DUY_GRPVEN DU5_CDRORI S 1 N S S 2 2
DUY 025 DU5 DUY_GRPVEN DU5_CDRDES S 1 N S S 2 2
DUY 026 DLL DUY_GRPVEN DLL_CODREG S 1 1 S S 2 2
DUY 027 DLM DUY_GRPVEN DLM_CODREG S 1 1 S S 2 2
DUY 028 DT5 DUY_GRPVEN DT5_CDRORI S 1 N S S 2 2
DUY 029 DT5 DUY_GRPVEN DT5_CDRDCA S 1 N S S 2 2
DUY 030 DVC DUY_GRPVEN DVC_CDRORI S 1 N S S 2 2
DUY 031 DVC DUY_GRPVEN DVC_CDRDES S 1 N S S 2 2
DUY 032 DTP DUY_GRPVEN DTP_CALRAT S 1 N S S 2 2
DUY 033 DTP DUY_GRPVEN DTP_ORIRAT S 1 N S S 2 2
DUY 034 DMP DUY_GRPVEN DMP_CDRDES S 1 N S S 2 2
DUY 035 DMP DUY_GRPVEN DMP_CDRORI S 1 N S S 2 2
DUY 036 DUL DUY_GRPVEN DUL_CDRDES S 1 N S S 2 2
DUY 037 DUE DUY_GRPVEN DUE_CDRSOL S 1 N S S 2 2
DUY 038 SA1 DUY_GRPVEN A1_CDRDES S 1 N S S 2 2
DUY 039 DU6 DUY_GRPVEN DU6_CDRDES S 1 N S S 2 2
DUY 040 DTN DUY_GRPVEN DTN_GRPVEN S 1 N S S 2 2
DUY 041 DIK DUY_GRPVEN DIK_CDRORI S 1 N S S 2 2
DUY 042 DIK DUY_GRPVEN DIK_CDRCAL S 1 N S S 2 2
DUY 043 DIK DUY_GRPVEN DIK_CDRDES S 1 N S S 2 2
DUY 044 DWL DUY_GRPVEN DWL_CDRORI S 1 N S S 2 2
DUY 045 DWL DUY_GRPVEN DWL_CDRBAS S 1 N S S 2 2
DUY 046 DWL DUY_GRPVEN DWL_CDRDES S 1 N S S 2 2
DUY 047 DLJ DUY_GRPVEN DLJ_CODREG S 1 1 S S 2 2
DUY 048 DLK DUY_GRPVEN DLK_CODREG S 1 1 S S 2 2
DUY 049 DEA DUY_GRPVEN DEA_CDRDES S 1 N S S 2 2
DUY 050 DUY DUY_GRPVEN DUY_CDRCOL S 1 N S S 2 2
DUY 051 DD7 DUY_GRPVEN DD7_CODREG S 1 N S S 2 2
DUY 052 DUR DUY_GRPVEN DUR_GRPVEN S 1 N S S 2 2
DUY 053 DY6 DUY_GRPVEN DY6_CDRDES S 1 N S S 2 2
DUY 054 DAJ DUY_GRPVEN DAJ_CODREG S 1 N S S 2 2
DUY 055 DVZ DUY_GRPVEN DVZ_CDRDES S 1 N S S 2 2
DUY 056 DVZ DUY_GRPVEN DVZ_CDRORI S 1 N S S 2 2
DUY 057 DWV DUY_GRPVEN DWV_CDRBAS S 1 N S S 2 2
DUY 058 DWV DUY_GRPVEN DWV_CODREG S 1 N S S 2 2
DUY 059 DY7 DUY_GRPVEN DY7_CODREG S 1 N S S 2 2
DUY 060 DW7 DUY_GRPVEN DW7_CDRDES S 1 N S S 2 2
DUY 061 DW7 DUY_GRPVEN DW7_CDRORI S 1 N S S 2 2
DUY 062 DLA DUY_GRPVEN DLA_CODREG S 1 1 S S 2 2
DUY 063 DLN DUY_GRPVEN DLN_CODREG S 1 1 S S 2 2
DUY 064 DI2 DUY_GRPVEN DI2_CODREG S 1 N S S 2 2
DUY 065 DMO DUY_GRPVEN DMO_CDRDES S 1 N S S 2 2
DUY 066 DMO DUY_GRPVEN DMO_CDRORI S 1 N S S 2 2
DUY 067 DTK DUY_GRPVEN DTK_CDRORI S 1 N S S 2 2
DUY 068 DTK DUY_GRPVEN DTK_CDRDES S 1 N S S 2 2
DUY 069 DT4 DUY_GRPVEN DT4_CDRORI S 1 N S S 2 2
DUY 070 DT4 DUY_GRPVEN DT4_CDRDES S 1 N S S 2 2
DUY 071 DVA DUY_GRPVEN DVA_CDRDES S 1 N S S 2 2
DUY 072 DVA DUY_GRPVEN DVA_CDRORI S 1 N S S 2 2
DUY 073 DTH DUY_GRPVEN DTH_CDRCAL S 1 N S S 2 2
DUY 074 DTH DUY_GRPVEN DTH_CDRDES S 1 N S S 2 2
DUY 075 DTC DUY_GRPVEN DTC_CDRCAL S 1 N S S 2 2
DUY 076 DTC DUY_GRPVEN DTC_CDRDES S 1 N S S 2 2
DUY 077 DTC DUY_GRPVEN DTC_CDRORI S 1 1 S S 2 2
DUY 078 DTC DUY_GRPVEN DTC_CDRPER S 1 N S S 2 2
DUY 079 DIL DUY_GRPVEN DIL_CDRDES S 1 N S S 2 2
DUY 080 DIL DUY_GRPVEN DIL_CDRORI S 1 N S S 2 2
DUY 081 DA8 DUY_GRPVEN DA8_CDOMDF S 1 N S S 2 2
DUY 082 DA8 DUY_GRPVEN DA8_CDRCAL S 1 N S S 2 2
DUY 083 DTC DUY_GRPVEN DTC_CALRAT S 1 N S S 2 2
DUY 084 DTC DUY_GRPVEN DTC_ORIRAT S 1 N S S 2 2
DUY 085 TRX DUY_GRPVEN TRX_GRPVEN S 1 N S S 2 2
DUY 086 DWY DUY_GRPVEN DWY_CDRDES S 1 N S S 2 2
DUY 087 DA8 DUY_GRPVEN DA8_CDRORI S 1 N S S 2 2
DUY 088 DEI DUY_GRPVEN DEI_CDRORI S 1 N S S 2 2
DUY 089 SS2 DUY_GRPVEN S2_CDRDES S 1 N S S 2 2
DUY 090 DDD DUY_GRPVEN DDD_CDRORI S 1 N S S 2 2
DUY 091 DVN DUY_GRPVEN DVN_CDRORI S 1 N S S 2 2
DUY 092 DVN DUY_GRPVEN DVN_CDRDES S 1 N S S 2 2
DUY 093 DTV DUY_GRPVEN DTV_CDRDES S 1 N S S 2 2
DUY 094 DWM DUY_GRPVEN DWM_CODREG S 1 N S S 2 2

 

 

 

 

SXG - Grupo de Campos

XG_GRUPO XG_DESCRI XG_DESSPA XG_DESENG XG_SIZEMAX XG_SIZEMIN XG_SIZE XG_PICTURE
001 Codigo Cliente/Fornecedor Codigo Cliente/Proveedor Customer/Supplier Code 20 6 6 @!
002 Loja Cliente/Fornecedor Tienda Cliente/Proveedor Customer/Supplier Unit 4 2 2 @!
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2
177 Nome do Fornecedor Nombre del proveedor Supplier Name 254 50 50 @!

 

 

 

 

 

 

 

 

 

 

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