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

Tabela 2410 SW8

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

Salve salve, blz?

 

 

Tabela SW8. #SW8

 

 

 

 

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
SW8 DATA SW8990 Itens de Invoices Items de Invoices Invoices Items E E E 0 W8_FILIAL+W8_HAWB+W8_INVOICE+W8_PO_NUM+W8_POSICAO+W8_PGI_NUM N 17 W8_HAWB+W8_FORN+W8_INVOICE+W8_COD_I EICIV110 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
SW8 01 W8_FUNREG C 2 0 Fund. Legal Fundamento Legal @! 1
SW8 02 W8_MOTADI C 2 0 Mot.Adm.Tem. Motivo Admissao Temporari @! 1
SW8 03 W8_FILIAL C 2 0 Filial Filial do Sistema 1 N 033
SW8 04 W8_HAWB C 20 0 Processo Processo @! 1 N 148
SW8 05 W8_FORN C 6 0 Fornecedor Fornecedor @! 1 S N 001
SW8 06 W8_FORLOJ C 2 0 Loja Fo. Loja Fo. @! 1 002
SW8 07 W8_INVOICE C 20 0 Invoice Invoice @! 1 S 148
SW8 08 W8_COD_I C 15 0 Codigo Item Codigo Item @! 1 S 030
SW8 09 W8_QTDE N 14 5 Quantidade Quantidade @E 99,999,999.99999 1 S
SW8 10 W8_PRECO N 15 7 Preco Preco @E 9,999,999.9999999 1 S
SW8 11 W8_PO_NUM C 20 0 No. do P.O. No. do P.O. @! 1 S 148
SW8 12 W8_PGI_NUM C 10 0 No. PLI No. PLI @! 1 S
SW8 13 W8_CC C 5 0 Cliente Int. Cliente Int. @! 1 S 084
SW8 14 W8_SI_NUM C 6 0 No. da S.I. No. da S.I. @! 1 S 083
SW8 15 W8_FABR C 6 0 Fabricante Fabricante @! 1 S S 001
SW8 16 W8_FABLOJ C 2 0 Loja Fa. Loja Fa. @! 1 002
SW8 17 W8_REG N 4 0 Parcela Parcela 99 1 S
SW8 18 W8_DT_EMIS D 8 0 Emissão Emissão @D 1 N
SW8 19 W8_SEQ_LI C 3 0 Seq LI Sequencia LI 999 1 S
SW8 20 W8_FLUXO C 1 0 Fluxo Fluxo 9 1 S
SW8 21 W8_POSICAO C 4 0 Posicao Posicao 9999 1 S
SW8 22 W8_DESC_DI C 6 0 Cod.Desc.Ite Cod.Desc.Ite @! 1 N
SW8 23 W8_DESC_VM M 65 0 Descricao It Descricao Item @! 1 N V V
SW8 24 W8_INLAND N 14 2 Inland Charg Inland Charges @E 99,999,999,999.99 1 S
SW8 25 W8_OUTDESP N 14 2 Outr. Desp. Outras Despesas @E 99,999,999,999.99 1 S
SW8 26 W8_PACKING N 14 2 Packing Char Packing Charges @E 99,999,999,999.99 1 S
SW8 27 W8_FRETEIN N 14 2 Int'l Freigh Int'l Freight @E 99,999,999,999.99 1 S
SW8 28 W8_DESCONT N 14 2 Desconto Desconto @E 99,999,999,999.99 1 S
SW8 29 W8_ADICAO C 3 0 Adicao Adicao @! 1 S
SW8 30 W8_FOBTOTR N 14 2 FOB Total R$ FOB Total R$ @E 99,999,999,999.99 1 S
SW8 31 W8_PRECO_R N 14 2 Preco Preco @E 99,999,999,999.99 1 S
SW8 32 W8_VLMLE N 14 2 VMLV Moeda VMLV Moeda @E 99,999,999,999.99 1 S
SW8 33 W8_TEC C 10 0 Pos.IPI/NCM Pos.IPI/NCM @R 9999.99.99 SYD 1 S
SW8 34 W8_EX_NCM C 3 0 Ex-NCM Excecao da NCM @! WD2 1 S
SW8 35 W8_EX_NBM C 3 0 Ex-NBM Excecao da NBM @! WD3 1 S
SW8 36 W8_VLFREMN N 14 2 Frete CC R$ Valor Frete Moeda Naciona @E 99,999,999,999.99 1 S
SW8 37 W8_VLSEGMN N 14 2 Seguro R$ Valor Seguro Moeda Nacion @E 99,999,999,999.99 1 S
SW8 38 W8_VLII N 15 2 I.I. R$ Valor II @E 999,999,999,999.99 1 S
SW8 39 W8_VLDEVII N 15 2 Vl Dev II R$ Valor Devido I.I. (R$) @E 999,999,999,999.99 1 N V R
SW8 40 W8_VLIPI N 15 2 I.P.I. R$ Valor IPI @E 999,999,999,999.99 1 S
SW8 41 W8_VLDEIPI N 15 2 Vl De IPI R$ Valor Devido do IPI em R$ @E 999,999,999,999.99 1 N A R
SW8 42 W8_BASEICM N 15 2 Base ICMS R$ Base ICMS @E 999,999,999,999.99 1 S
SW8 43 W8_VLICMS N 15 2 I.C.M.S. R$ Valor ICMS @E 999,999,999,999.99 1 S
SW8 44 W8_VLACRES N 15 2 Acrescimo R$ Valor dos Acrescimos @E 999,999,999,999.99 1 S
SW8 45 W8_VLDEDU N 15 2 Deducao R$ Valor das Deducoes @E 999,999,999,999.99 1 S
SW8 46 W8_BASEII N 15 2 Base I.I. R$ Base I.I. @E 999,999,999,999.99 1 S
SW8 47 W8_AC C 13 0 Ato Concess. Ato Concessorio 9999999999999 1 S
SW8 48 W8_ACISEN C 13 0 Ato Isencao Ato Concessorio Isencao 9999999999999 1 S
SW8 49 W8_SEQSIS C 3 0 Posicao ED2 Posicao do Item no ED2 999 1 N
SW8 50 W8_QT_AC N 14 5 Qtd. no A.C. Quantidade baixada no AC @E 99,999,999.99999 Positivo() 1 N
SW8 51 W8_QT_AC2 N 14 5 Qt. Comp. AC Qtd. comp. baixada no AC @E 99,999,999.99999 Positivo() 1 N
SW8 52 W8_VL_AC N 15 2 Valor no AC Valor baixado no AC @E 999,999,999,999.99 Positivo() 1 N
SW8 53 W8_UNID C 2 0 Unid. Medida Unidade de Medida do Item 1 N 122
SW8 54 W8_ISENTOT C 1 0 Isenc. Total Isencao Total? @! "1" 1 N 1=Sim;2=Nao
SW8 55 W8_SALISEN N 14 2 Saldo Isenc. Saldo Isencao @E 99,999,999,999.99 1 N
SW8 56 W8_FASEDR C 1 0 Fase Drawbac Fase no Drawback @! 1 N 1=Pedido de Drawback;2=Ato Concessorio
SW8 57 W8_BASPIS N 15 2 Base PIS Base PIS @E 999,999,999,999.99 POSITIVO(M->W8_BASPIS) 1 S A R
SW8 58 W8_PRECO_F N 14 2 FOB Aduana FOB Aduana @E 99,999,999,999.99 Positivo() .AND. DI600InvValid('PRECO_F') 1 S A R
SW8 59 W8_BASCOF N 15 2 Base COFINS Base COFINS @E 999,999,999,999.99 POSITIVO(M->W8_BASCOF) 1 S A R
SW8 60 W8_PERPIS N 6 2 % PIS % PIS @E 999.99 POSITIVO(M->W8_PERPIS) 1 S A R
SW8 61 W8_REGTRI C 1 0 Reg.Trib. II Reg. Trib. II @! 1 N V
SW8 62 W8_PERCOF N 6 2 % COFINS % COFINS @E 999.99 POSITIVO(M->W8_PERCOF) 1 S A R
SW8 63 W8_TACOII C 1 0 Tp Acordo II Tp Aco II @! 1 N V
SW8 64 W8_VLRPIS N 15 2 Valor PIS Valor PIS @E 999,999,999,999.99 POSITIVO(M->W8_VLRPIS) 1 S A R
SW8 65 W8_ACO_II C 3 0 Acor Tari II Acor Tar II @! 1 N V
SW8 66 W8_VLRCOF N 15 2 Valor COFINS Valor COFINS @E 999,999,999,999.99 POSITIVO(M->W8_VLRCOF) 1 S A R
SW8 67 W8_VLUPIS N 9 2 Vlr Unit PIS Vlr Unit PIS @E 999,999.99 POSITIVO(M->W8_VLUPIS) 1 S A
SW8 68 W8_VLUCOF N 9 2 Vl Uni COFIN Vl Uni COFIN @E 999,999.99 POSITIVO(M->W8_VLUCOF) 1 S A R
SW8 69 W8_TAXASIS N 14 2 Taxa SISCOME Taxa SISCOMEX @E 99,999,999,999.99 1 S V R
SW8 70 W8_QTDE_UM N 14 5 Quant. Unid. Quant. Unid. @E 99,999,999.99999 1 S
SW8 71 W8_OPERACA C 5 0 Operacao Operacao @! 1 S V R
SW8 72 W8_NVE C 3 0 Tab N.V.E. Tabela N.V.E. @! 1 S V R
SW8 73 W8_REG_PC C 1 0 Reg Trib P/C Reg tributario p/ PIS/COF @! 1 A R
SW8 74 W8_FUN_PC C 2 0 Fund Leg P/C Fund legal p/ PIS/COFINS 1 A R
SW8 75 W8_FRB_PC C 2 0 Fund Red P/C Fund. p/ redução de base @! 1 A R
SW8 76 W8_VLDEPIS N 15 2 V.Devido PIS Valor Devido do PIS @E 999,999,999,999.99 1 V R
SW8 77 W8_VLDECOF N 15 2 V.Devido COF Valor Devido do COFINS @E 999,999,999,999.99 1 V R
SW8 78 W8_REGIPI C 1 0 Reg Trib IPI Regime Tributário do IPI @! 1 A R
SW8 79 W8_SEQ_ADI C 5 0 Seq. Reg. Seq Registro 99999 1 A R
SW8 80 W8_GRUPORT C 3 0 Grp RegTri Grp RegTri 999 1 A R
SW8 81 W8_PICMDIF N 8 4 %Diferimento % de Diferimento @E 999.9999 1 S A R
SW8 82 W8_VICMDIF N 12 2 Diferimento Valor do ICMS Diferido @E 999,999,999.99 1 S A R
SW8 83 W8_PICM_CP N 6 2 %Max.Cr.Pres %Max. de Cred. Presumido @E 999.99 1 S A R
SW8 84 W8_PCREPRE N 6 2 % Cred.Pres. % de Credito Presumido @E 999.99 1 S A R
SW8 85 W8_VICM_CP N 12 2 Cred. Presum Valor Cred. Presum. ICMS @E 999,999,999.99 1 S A R
SW8 86 W8_ICMS_PD N 6 2 %Min.ICMS Rc %Min. de ICMS a Recolher @E 999.99 1 S A R
SW8 87 W8_VLICMDV N 12 2 ICMS Devido Valor do ICMS Devido @E 999,999,999.99 1 S A R
SW8 88 W8_D_BAICM N 14 2 Desp.B.ICMS Despesa Base ICMS @E 99,999,999,999.99 POSITIVO(M->W8_D_BAICM) 1 N A R
SW8 89 W8_CODOPE C 2 0 Cód. Ope. Es Cód. Operacão Especial @! ValidOpe('W8_CODOPE') EJ0 1 S S
SW8 90 W8_DESOPE C 60 0 Desc. Op. Es Desc Operacão Especial @! Posicione('EJ0',1,xFilial('EJ0') + M->W8_CODOPE ,'EJ0_DESC') 1 S V V avField("W8_CODOPE" ,'EJ0_DESC',,.T.)
SW8 91 W8_PESO_BR N 14 5 Peso Bru Uni Peso Bruto Unitario @E 99,999,999.99999 Positivo() 1 S A R
SW8 92 W8_CODMAT C 10 0 Cod Matriz Codigo da Matriz 9999999999 ExistCpo('EJB',M->W6_IMPORT+M->W8_CODMAT,1) EJB 1 S
SW8 93 W8_VLCOFM N 9 2 Vl. M.COFINS Vl. Majorado Cofins @E 999,999.99 Positivo() 1 N A R
SW8 94 W8_SEGURO N 14 2 Seguro Seguro @E 99,999,999,999.99 1 N A
SW8 95 W8_VLPISM N 9 2 Vl. M.PIS Vl. Majorado PIS @E 999,999.99 Positivo() 1 N
SW8 96 W8_ALFECP N 6 2 % ICMS FECP Percentual ICMS F.E.C.P @E 999.99 1 S V R
SW8 97 W8_VLFECP N 12 2 Vl.ICMS FECP Valor de ICMS F.E.C.P. @E 999,999,999.99 1 N V R
SW8 98 W8_FECPALD N 6 2 % FECP Dif. Perc.FECP Diferido @E 999.99 1 S A R
SW8 99 W8_FECPVLD N 15 2 Vl.FECP Dif. Valor FECP diferido @E 999,999,999,999.99 1 S A R
SW8 A0 W8_FECPREC N 15 2 Vl.FECP Rec. Valor FECP a recolher @E 999,999,999,999.99 1 S A R

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
SW8 1 W8_FILIAL+W8_HAWB+W8_INVOICE+W8_FORN+W8_FORLOJ Processo + Invoice + Fornecedor + Loja Fo. Proceso + Invoice + Proveedor + Loja Prov. Process + Invoice + Supplier + Unit Fo. S S 2 3
SW8 2 W8_FILIAL+W8_INVOICE+W8_FORN+W8_FORLOJ Invoice + Fornecedor + Loja Fo. Invoice + Proveedor + Loja Prov. Invoice + Supplier + Unit Fo. S S 2 3
SW8 3 W8_FILIAL+W8_HAWB+W8_PGI_NUM+W8_PO_NUM+W8_SI_NUM+W8_CC+W8_COD_I+STR(W8_REG,4,0) Processo + No. PLI + No. do P.O. + No. da S.I. + Cliente Int. + Codigo Proceso + No. PLI + Nº del P.O. + No. de S.I. + Cliente Int. + Codigo Process + PLI. No. + P.O. No. + S.I. No. + Int. Client + Item Code + I S S 2 3
SW8 4 W8_FILIAL+W8_HAWB+W8_ADICAO Processo + Adicao Proceso + Adicion Process + Addition S S 2 3
SW8 5 W8_FILIAL+W8_AC+W8_COD_I Ato Concess. + Codigo Item Acto Conces. + Codigo Item Conces. Act + Item Code S S 2 3
SW8 6 W8_FILIAL+W8_HAWB+W8_INVOICE+W8_PO_NUM+W8_POSICAO+W8_PGI_NUM Processo + Invoice + No. do P.O. + Posicao + No. PLI Proceso + Invoice + Nº del P.O. + Posicion + No. PLI Process + Invoice + P.O. No. + Status + PLI. No. 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
W8_CODOPE 001 EJ0->EJ0_DESC W8_DESOPE P S EJ0 1 xFilial('EJ0')+M->W8_CODOPE S
W8_FABR 001 '' W8_FABLOJ P N 0 !AvCpo("SA2", W8_FABR + W8_FABLOJ) S
W8_FORN 001 '' W8_FORLOJ P N 0 !AvCpo("SA2", W8_FORN + W8_FORLOJ) 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
SW8 001 SWV W8_HAWB+W8_INVOICE+W8_PGI_NUM+W8_PO_NUM+W8_POSICAO WV_HAWB+WV_INVOICE+WV_PGI_NUM+WV_PO_NUM+WV_POSICAO S N N S S 2 2
SW8 002 ED2 W8_HAWB+W8_INVOICE+W8_PO_NUM+W8_POSICAO+W8_PGI_NUM ED2_HAWB+ED2_INVOIC+ED2_PO_NUM+ED2_POSICA+ED2_PGI_NU S 1 N S S 2 2
SW8 003 EDD W8_AC+W8_HAWB+W8_PO_NUM+W8_PGI_NUM+W8_INVOICE+W8_COD_I+W8_POSICAO+W8_SEQSIS EDD_AC+EDD_HAWB+EDD_PO_NUM+EDD_PGI_NU+EDD_INVOIC+EDD_ITEM+EDD_POSICA+EDD_SEQSII 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 @!
030 Tamanho do Produto Tamano del Producto Product Size 30 15 15 @!
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2
083 Num. Solicitação de Importação Num. Solicitud de Importacion Import Request Number 15 6 6 @!
084 Unidade Requisitante Unidad Requeriente Requester Unit 15 5 5 @!
122 Unidade de Medida Unidad de medida Measure Unit 10 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