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

Tabela 2410 SW4

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

Salve salve, blz?

 

 

Tabela SW4. #SW4

 

 

 

 

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
SW4 DATA SW4990 Capa Preparação de Licença Imp Portada Preparacion de Licenci Imp License Preparation Cover E E E 0 W4_FILIAL+W4_PGI_NUM N 17 W4_PGI_NUM+W4_NAT_LSI+W4_GI_NUM+W4_COD_ORI+W4_COD_RES GI400MAIN 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
SW4 01 W4_FILIAL C 2 0 Filial Filial do Sistema 1 N 033
SW4 05 W4_GI_NUM C 13 0 No. da L.I. No. da L.I. @R 9999-99/999999-9 1 S V
SW4 06 W4_DT D 8 0 Data da L.I. Dt. da L.I. @D 1 S V
SW4 07 W4_DT_VEN D 8 0 Dt Vencto Dt Vencto. 1 N
SW4 08 W4_FLUXO C 1 0 Tipo de G.I. Fluxo @! 1 N
SW4 09 W4_COD_ORI C 3 0 Pais Origem Pais Origem 9999 ExistCpo("SYA",M->W4_COD_ORI) SYA 1 N
SW4 10 W4_COD_DES C 5 0 Porto Destin Porto Destin 99999 ExistCpo("SY9",M->W4_COD_DES) SY9 1 N
SW4 12 W4_CONSIG C 2 0 Consignatar. Consignatar. @! 1 N
SW4 13 W4_COMM_AG N 6 2 Comissao Ag. Comissao Ag. @E 999.99 1 N
SW4 20 W4_POS_NUM C 20 0 No. dos POs No. dos POs @! 1 N
SW4 21 W4_APLIC C 30 0 Aplicacao Aplicacao @! 1 N
SW4 22 W4_MOEDA C 3 0 Moeda Moeda @! ExistCpo("SYF",M->W4_MOEDA) SYF 1 S A R
SW4 24 W4_TEXTO34 C 6 0 Campo 34 Campo 34 1 N
SW4 25 W4_DT_ENVI D 8 0 Dt Envio Dt Envio @D 1 N
SW4 26 W4_OBS C 70 0 Obs Obs @! 1 N
SW4 27 W4_EMITIDA C 1 0 Emitida S/N Emitida? S/N @! 1 N
SW4 28 W4_DTEDCEX D 8 0 Dt Ent.DECEX Dt.Ent.DECEX @D 1 N
SW4 29 W4_DTSDCEX D 8 0 Dt Sai.DECEX Dt.Sai.DECEX @D 1 N
SW4 30 W4_CUSTOEM N 14 2 Custo Emiss. Custo Emiss. @E 99,999,999,999.99 1 N
SW4 31 W4_PORTASN C 1 0 PortariaS/N Portaria?S/N @! 1 N
SW4 32 W4_PORTADI C 6 0 No. D.I. No. D.I. @! 1 N
SW4 33 W4_PORTADT D 8 0 Data D.I. Data D.I. @D 1 N
SW4 34 W4_SUFRAMA C 1 0 Suframa S/N Suframa? S/N @! IF(GetMV("MV_SUFRAMA"),Pertence("SN"),.F.) "N" 1 N
SW4 35 W4_DT_SUFR D 8 0 Data Suframa Data Suframa @D 1 N
SW4 36 W4_AVERBNO C 25 0 No.Averbacao No.Averbacao @! 1 N
SW4 37 W4_AVERBDT D 8 0 Dt Averbacao Dt.Averbacao @D 1 N
SW4 38 W4_UTILIZA N 3 0 Utilizacao Utilizacao 999 1 N
SW4 39 W4_DECIMAL L 1 0 Decimal Decimal ? 1 N
SW4 40 W4_EMIS_BF C 1 0 Befiex S/N Befiex emitido S/N ? @! IF(GetMV("MV_LOGISTI"),Pertence("SN"),.F.) 1 N
SW4 41 W4_ID_GI C 4 0 Identif. Identif. @! 1 N V
SW4 42 W4_PRAZO N 5 0 Prazo Prazo 99999 1 N V
SW4 43 W4_RECNO N 5 0 No. Registro No. Registro 99999 1 N V
SW4 44 W4_DESLIN1 C 48 0 Desc.Gener. Desc.Gener. @! 1 N V
SW4 45 W4_FLAG C 3 0 Flag Flag 1 N V
SW4 46 W4_VM_TX34 M 60 0 Campo 34 Campo 34 E_MSMM(SW4->W4_TEXTO34,60) 1 N V
SW4 55 W4_INCOTER C 8 0 Incoterm Incoterm @! Vazio() .Or. ExistCpo("SYJ",M->W4_INCOTER) SYJ 1 S A R
SW4 56 W4_COD_PRO C 3 0 Pais Proced. Pais Proced. 9999 ExistCpo("SYA",M->W4_COD_PRO) SYA 1 N
SW4 67 W4_COD_MSG C 3 0 Codigo MSG Codigo da Mensagem 999 ExistCpo("SY7",AVKEY("3","Y7_POGI")+M->w4_cod_msg, 3) ME1 1 S N R
SW4 68 W4_DESC_GE C 6 0 Obs Obs 1 N V
SW4 69 W4_VM_DESG M 60 0 Complem Desc. Gener. E_MSMM(SW4->W4_DESC_GE,60) 1 N V
SW4 70 W4_SISCOME L 1 0 Siscomex Siscomex Sim Nao ? 1 N
SW4 76 W4_HAWB_DA C 20 0 Processo DA Processo DA @! 1 N 148
SW4 79 W4_ID C 10 0 ID WF ID WorkFlow @! 1 N A R
SW4 02 W4_PGI_NUM C 10 0 No. da PLI No. da PLI @! existchav("SW4",M->W4_PGI_NUM,,"EXISTPLI") 1 S 1
SW4 03 W4_NAT_LSI C 2 0 Natur.Oper. Natureza da Operacao @! ExistCpo("SJV") SJV 1 N A R 1
SW4 04 W4_PGI_DT D 8 0 Data da PLI Dt. da PLI @D 1 S 1
SW4 11 W4_IMPORT C 2 0 Importador Importador @! 1 S V R 1
SW4 62 W4_ATO_CON C 13 0 Ato Conces. Ato Concessorio @R 9999-99-999999-9 SPACE(13) 1 S 1
SW4 63 W4_SUB_ATO C 1 0 Sub Ato Sub Ato @! 1 S 1
SW4 18 W4_URF_DES C 7 0 URF Despacho URF de Despacho 9999999 E_SJ0Codigo(M->W4_URF_DES,"W4_URF_DES") .AND. ExistCpo("SJ0",M->W4_URF_DES) IF(GETMV("MV_SUFRAMA"),"227600 ",SPACE(07)) URF 1 S S 2
SW4 19 W4_VM_URFD C 50 0 Des.URF Desp Desc. URF de Despacho @! E_Field("W4_URF_DES","J0_DESC",,,1) 1 S V V 2
SW4 23 W4_DESCONT N 14 2 Desconto Desconto @E 99,999,999,999.99 Positivo() 1 S GI400When('W4_DESCONT') 2
SW4 47 W4_URF_CHE C 7 0 URF Chegada URF de Chegada 9999999 E_SJ0Codigo(M->W4_URF_CHE,"W4_URF_CHE") .AND. ExistCpo("SJ0",M->W4_URF_CHE) IF(GETMV("MV_SUFRAMA"),"227600 ",SPACE(07)) URF 1 S S 2
SW4 48 W4_VM_URFC C 50 0 Des.URF Cheg Desc. URF de Chegada @! E_Field("W4_URF_CHE","J0_DESC",,,1) 1 S V V 2
SW4 49 W4_COMUNIC C 13 0 Com. Compra Comunicacao de Compra @R 9999-99-999999-9 1 S 2
SW4 50 W4_COND_ME C 1 0 Cond Mercad Condicao da Mercadoria @S10 "1" 1 N A 1=Normal;2=Fabricado/Encomendado;3=Material Usado 2
SW4 51 W4_REG_TRI C 1 0 Reg. Tribut. Regime Tributario @! (Vazio() .OR. ExistCpo('SJP', M->W4_REG_TRI)) .AND. GI400RegTri(M->W4_REG_TRI) SP_ 1 S S A R 2
SW4 52 W4_VM_REGT C 60 0 Des. Regime Descricao Reg. Tributacao @! E_Field('W4_REG_TRI','JP_DESC',,,1) 1 N V V 2
SW4 53 W4_REGIMP C 2 0 Fundam.Legal Fundamento Legal @! Vazio() .OR. (ExistCpo('SY8', M->W4_REGIMP) .AND. GI400Val('REGIMP')) SY_ 1 S S A R !Empty(M->W4_REG_TRI) 2
SW4 54 W4_VM_REGI C 50 0 Des. Fundam. Descricao Fundamentacao @! E_Field("W4_REGIMP","Y8_DES",,,1) 1 S V V 2
SW4 60 W4_AGSECEX C 5 0 Ag. Secex Agencia Secex @R 9999-9 Vazio().OR.ExistCpo("SJ9",M->W4_AGSECEX) SJ9 1 S S 2
SW4 61 W4_VM_AGSE C 50 0 Des.Ag.Secex Desc. Agencia Secex @! E_Field("W4_AGSECEX","J9_DESC",,,1) 1 S V V 2
SW4 64 W4_ACO_TAR C 1 0 Ac.Tarifario Acordo Tarifario 9 Vazio().OR.Pertence('1234 ') 1 S 1=MERCOSUL;2=ALADI;3=OMC;4=SGPC 2
SW4 65 W4_LISUBST C 10 0 Substitutiva Substitutiva @R 99/9999999-9 1 S 2
SW4 66 W4_DTLIBSU D 8 0 Liber. Sufr. Dt. Liberacao Suframa @D CTOD("") 1 S 2
SW4 71 W4_TIPO_DO C 1 0 Tipo Docto Tipo do Documento 9 Pertence('123') "1" 1 S 1=Normal;2=Substitutiva;3=Cancelamento 2
SW4 72 W4_TIPOAPL C 6 0 Tipo Aplic. Tipo de Aplicacao 999999 Vazio().OR.ExistCpo("SX5","Y4"+M->W4_TIPOAPL) Y4 1 S S 2
SW4 73 W4_VM_TPAP C 50 0 Desc.Tipo AP Desc. Tipo de Aplicacao @! IF(!Empty(M->W4_TIPOAPL),Tabela("Y4",M->W4_TIPOAPL),Space(50)) 1 S V V 2
SW4 74 W4_PROD_SU C 11 0 Prod.Suframa Produto Suframa @R 99999999999 GI400VALID(M->W4_PROD_SU) SYZ 1 S S INCLUI 2
SW4 75 W4_VM_PZFM C 50 0 Des.Prod ZFM Desc. Produto ZFM @! E_Field("W4_PROD_SU","YZ_DESCR",,,1) 1 S V V 2
SW4 14 W4_FOB_TOT N 14 2 FOB FOB @E 99,999,999,999.99 1 S V 3
SW4 15 W4_INLAND N 14 2 Inland Inland @E 99,999,999,999.99 Positivo() 1 S GI400When('W4_INLAND') 3
SW4 16 W4_PACKING N 14 2 Packing Packing @E 99,999,999,999.99 Positivo() 1 S GI400When('W4_PACKING') 3
SW4 17 W4_FRETEIN N 14 2 Int'l Freigh Int'l Freigh @E 99,999,999,999.99 Positivo() 1 S GI400When('W4_FRETEIN') 3
SW4 57 W4_COND_PA C 5 0 Cond. Pagto Cond. Pagto @! SY6 1 S S A R 3
SW4 58 W4_DIAS_PA N 3 0 Dias Pagto Dias Pagto 999 EMPTY(M->W4_COND_PA).OR.ExistCpo("SY6",M->W4_COND_PA+STR(M->W4_DIAS_PA,3)) 1 S S A R 3
SW4 59 W4_VM_COPA C 50 0 Cond. Pagto Cond. Pagto @! E_FIELD2(M->W4_COND_PA+STR(M->W4_DIAS_PA,3),"SY6",1,,"SY6->Y6_DESC_P",60) 1 S V V 3
SW4 77 W4_OUT_DES N 14 2 Outras Desp. Outras Desp. @E 99,999,999,999.99 Positivo() 1 N V 3
SW4 78 W4_FREINC C 1 0 Frete Incl. Frete Incluso @! Pertence("12") "2" 1 N 1=Sim;2=Nao GI400When('W4_FREINC') 3
SW4 80 W4_SEGURO N 14 2 Seguro Seguro @E 99,999,999,999.99 Positivo() 1 N V R GI400When('W4_SEGURO') 3
SW4 81 W4_SEGINC C 1 0 Seg. Incl. Seguro Incluso @! Pertence('12') '2' 1 N A R 1=Sim;2=Nao GI400When('W4_SEGINC') 3

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
SW4 1 W4_FILIAL+W4_PGI_NUM No. da PLI Nro. PLI Nr PLI S S 2 3
SW4 2 W4_FILIAL+W4_GI_NUM No. da L.I. Nro. L.I. Imp.Lic.Nbr S S 2 3
SW4 3 W4_FILIAL+DTOS(W4_DT_VEN) Dt Vencto Fch.Vencim. Due Date S S 2 3
SW4 4 W4_FILIAL+DTOS(W4_DTSDCEX)+DTOS(W4_DTEDCEX)+DTOS(W4_DT_SUFR) Dt Sai.DECEX + Dt Ent.DECEX + Data Suframa Fch.Sal.DECE + Fch.Ent.DECE + Fch.Z.Libre SEDEX OutfDt + SEDEX Inf.Dt + Suframa Date 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
W4_AGSECEX 001 SJ9->J9_DESC W4_VM_AGSE P S SJ9 1 XFILIAL("SJ9")+M->W4_AGSECEX S
W4_COD_MSG 001 M->W4_VM_DESG:=MSMM(SY7->Y7_TEXTO,65) W4_VM_DESG P S SY7 1 xFilial("SY7")+M->W4_COD_MSG S
W4_COND_PA 001 MSMM(SY6->Y6_DESC_P,50) W4_VM_COPA P S SY6 1 XFILIAL("SY6")+M->W4_COND_PA S
W4_COND_PA 002 M->W4_DIAS_PA:=SY6->Y6_DIAS_PA W4_DIAS_PA P N 0 S
W4_DIAS_PA 001 MSMM(SY6->Y6_DESC_P,50) W4_VM_COPA P S SY6 1 xFilial("SW6")+M->W4_COND_PA+STR(M->W4_DIAS_PA,3,0) S
W4_PROD_SU 001 SYZ->YZ_DESCR W4_VM_PZFM P S SYZ 1 XFILIAL("SYZ")+M->W4_PROD_SU S
W4_REG_TRI 001 SJP->JP_DESC W4_VM_REGT P S SJP 1 xFilial('SJP')+M->W4_REG_TRI S
W4_REGIMP 001 SY8->Y8_DES W4_VM_REGI P S SY8 1 xFilial("SY8")+M->W4_REGIMP S
W4_TIPOAPL 001 SX5->X5_DESCRI W4_VM_TPAP P S SX5 1 XFILIAL("SX5")+"Y4"+M->W4_TIPOAPL S
W4_URF_CHE 001 SJ0->J0_DESC W4_VM_URFC P S SJ0 1 XFILIAL("SJ0")+M->W4_URF_CHE S
W4_URF_DES 001 SJ0->J0_DESC W4_VM_URFD P S SJ0 1 XFILIAL("SJ0")+M->W4_URF_DES 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
SW4 001 SW5 W4_PGI_NUM W5_PGI_NUM 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
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2
148 Imp.Purchase/Hawb/Invoice/Prof Imp.Purchase/Hawb/Invoice/Prof Imp.Purchase/Hawb/Invoice/Prof 30 15 20 @!

 

 

 

 

 

 

 

 

 

 

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