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

Tabela 2410 SWN

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

Salve salve, blz?

 

 

Tabela SWN. #SWN

 

 

 

 

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
SWN DATA SWN990 Itens da NF de Importação Items de la Fact de Importacio Import Invoice Items E E E 0 N 17 WN_HAWB+WN_DOC+WN_SERIE+WN_PRODUTO+WN_DESCR EICDI154 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
SWN 01 WN_FILIAL C 2 0 Filial Filial do Sistema 1 N 033
SWN 02 WN_HAWB C 20 0 No. Conhec. No. Conhec. @! 1 S 148
SWN 03 WN_DOC C 9 0 No. N.F.E. No. N.F.E. @! 1 S 018
SWN 04 WN_DOCORI C 9 0 NF Origem NF Origem @! 1 S V R 018
SWN 05 WN_SERIE C 3 0 Série N.F.E. Série N.F.E. !!! 1 S 094
SWN 06 WN_SERORI C 3 0 Serie Origem Serie Origem !!! 1 S V R 094
SWN 07 WN_TEC C 10 0 T.E.C. T.E.C. @R 9999.99.99 1 S
SWN A7 WN_SDOCORI C 3 0 Série Orig. Série da NF Original !!! 1 N V R 095
SWN A6 WN_SDOC C 3 0 Série Doc. Série do Documento Fiscal !!! 1 N V R 095
SWN A5 WN_VLFECP N 14 2 Vl.ICMS FECP Valor de ICMS F.E.C.P. @E 99,999,999,999.99 1 S V R
SWN A4 WN_ALFECP N 6 2 % ICMS FECP Percentual ICMS F.E.C.P. @E 999.99 1 S V R
SWN 79 WN_DESCONI N 14 2 Vlr Desconto Valor Desconto @E 99,999,999,999.99 1 A R
SWN 78 WN_PREDICM N 6 2 %Red.B.ICMS % Redução Base ICMS @E 999.99 1 A R
SWN 77 WN_SEQ_ADI C 5 0 Seq Reg Seq Registro 99999 1 A R
SWN 76 WN_VICM_PD N 14 2 ICMS Pg. Des Valor ICMS pago no Desemb @E 99,999,999,999.99 1 S A R
SWN 75 WN_VICM_CP N 14 2 ICMS Cr.Pres Valor Cred Presumido ICMS @E 99,999,999,999.99 1 S A R
SWN 74 WN_VICMDIF N 14 2 ICMS Difer. Valor do ICMS diferido @E 99,999,999,999.99 1 S A R
SWN 73 WN_DESPICM N 14 2 Vl Desp ICMS Valor desp. Base ICMS @E 99,999,999,999.99 1 N A R
SWN 72 WN_NUMSEQ C 6 0 Num. Sequenc Numero de Sequencia @! 1 N
SWN 71 WN_VLDEDUC N 14 2 Deducoes Deducoes @E 99,999,999,999.99 1 A R
SWN 70 WN_VLACRES N 14 2 Acrescimos Acrescimos @E 99,999,999,999.99 1 A R
SWN 69 WN_INVO_DT D 8 0 Data Invoice Data da Invoice @D 1 N
SWN 68 WN_VLUCOF N 9 2 Vl Uni COFIN Vl Uni COFIN @E 999,999.99 1 S A R
SWN 67 WN_FOB_R N 14 2 Valor FOB R$ Valor FOB Real @E 99,999,999,999.99 1 N
SWN 66 WN_VLUPIS N 9 2 Vlr Unit PIS Vlr Unit PIS @E 999,999.99 1 S A R
SWN 65 WN_LOCAL C 2 0 Armazem Pad. Armazem Padrao p/Requis. @! 1 N 024
SWN 64 WN_VLRCOF N 14 2 Valor COFINS Valor COFINS @E 99,999,999,999.99 1 S A R
SWN 63 WN_VLRPIS N 14 2 Valor PIS Valor PIS @E 99,999,999,999.99 1 S A R
SWN 62 WN_PERCOF N 6 2 % COFINS % COFINS @E 999.99 1 S A R
SWN 61 WN_PERPIS N 6 2 % PIS % PIS @E 999.99 1 S A R
SWN 60 WN_VLDEVII N 14 2 Vlr Dev. II Vlr Dev. II @E 99,999,999,999.99 1 N V
SWN 59 WN_BASCOF N 14 2 Base COFINS Base COFINS @E 99,999,999,999.99 1 S A R
SWN 58 WN_BASPIS N 14 2 Base PIS Base PIS @E 99,999,999,999.99 1 S A R
SWN 57 WN_VLDEIPI N 14 2 Vlr Dev. IPI Vlr Dev. IPI @E 99,999,999,999.99 1 N V
SWN 56 WN_SEGUM C 2 0 2a. UM 2a. UM @! 1 N
SWN 55 WN_INVOICE C 20 0 Invoice . @! 1 148
SWN 54 WN_QTSEGUM N 14 5 Qtde 2a. UM Qtde 2a. UM @E 99,999,999.99999 1 N
SWN 53 WN_ADICAO C 3 0 Adicao . @! 1
SWN 52 WN_PACKING N 14 2 Packing Packing @E 99,999,999,999.99 Positivo() 1
SWN 51 WN_OUT_DES N 14 2 Outras Desp. Outras Despesas @E 99,999,999,999.99 Positivo() 1
SWN 50 WN_INLAND N 14 2 Inland Inland @E 99,999,999,999.99 Positivo() 1
SWN 49 WN_DESCONT N 14 2 Desconto Desconto @E 99,999,999,999.99 Positivo() 1
SWN 48 WN_LINHA N 4 0 Linha na NF Linha do item na NF 1 N
SWN 47 WN_BASEICM N 14 2 Base ICMS Base ICMS @E 99,999,999,999.99 1
SWN 46 WN_DTVALID D 8 0 Dt. Validade Dt. Validade 1 N
SWN 45 WN_NUMLOTE C 6 0 No. Sub Lote No. Sub Lote 1 N
SWN 44 WN_PO_EIC C 20 0 Pedido Pedido @! 1 N 148
SWN 43 WN_LOTECTL C 10 0 No. Lote No. Lote 1 N 068
SWN 42 WN_PGI_NUM C 10 0 No. PLI No. PLI @! 1 S
SWN 41 WN_TIPO_NF C 1 0 Tipo N.F. Tipo N.F. 1 N
SWN 40 WN_IPIBASE N 14 2 IPI Base IPI Base @E 99,999,999,999.99 1 N
SWN 39 WN_OUTR_US N 14 2 Despesa Despesa @E 99,999,999,999.99 1 N
SWN 38 WN_LOJA C 2 0 Loja Loja @! 1 N 002
SWN 37 WN_FORNECE C 6 0 Fornecedor Fornecedor @! 1 N 001
SWN 36 WN_OPERACA C 5 0 Operacao Operacao @! 1 N
SWN 35 WN_CFO C 5 0 C.F.O. C.F.O. @! 1 N
SWN 34 WN_CC C 5 0 Centro Custo Centro Custo @! 1 N 084
SWN 33 WN_SI_NUM C 6 0 No. da S.I. No. da S.I. @! 1 N 083
SWN 32 WN_FRETE N 14 2 Vlr.Frete Vlr.Frete @E 99,999,999,999.99 1 N
SWN 31 WN_DESPESA N 14 2 Vlr.Despesas Vlr.Despesas @E 99,999,999,999.99 1 N
SWN 30 WN_SEGURO N 14 2 Vlr.Seguro Vlr.Seguro @E 99,999,999,999.99 1 N
SWN 29 WN_CIF N 14 2 C.I.F. C.I.F. @E 99,999,999,999.99 1 N
SWN 28 WN_PESOL N 12 4 Peso Liquido Peso Liquido @E 9,999,999.9999 1 N
SWN 27 WN_VL_ICM N 14 2 Valor ICMS Valor ICMS @E 99,999,999,999.99 1 N
SWN 26 WN_RATEIO N 11 8 Rateio Rateio @E 99.99999999 1 N
SWN 25 WN_PRUNI N 15 7 Prc Unitario Prc Unitario @E 9,999,999.9999999 1 N
SWN 24 WN_IIVAL N 15 2 Vlr .I.I. Vlr .I.I. @E 999,999,999,999.99 1 N
SWN 23 WN_IITX N 6 2 Taxa I.I. Taxa I.I. @E 999.99 1 N
SWN 22 WN_IPIVAL N 15 2 Vlr .I.P.I. Vlr .I.P.I. @E 999,999,999,999.99 1 N
SWN 21 WN_IPITX N 6 2 Taxa I.P.I. Taxa I.P.I. @E 999.99 1 N
SWN 20 WN_UNI C 2 0 Unidade Unidade 1 N 122
SWN 19 WN_DESCR C 60 0 Descricao Descricao @! 1 N
SWN 18 WN_PRECO N 14 2 Preco Preco @E 99,999,999,999.99 1 N
SWN 17 WN_ICMS_A N 6 2 % ICMS % ICMS @E 999.99 1 N
SWN 16 WN_VALICM N 14 2 Valor ICMS Valor ICMS @E 99,999,999,999.99 1 S
SWN 15 WN_VALIPI N 14 2 Valor I.P.I. Valor I.P.I. @E 99,999,999,999.99 1 S
SWN 14 WN_VALOR N 14 2 Valor Valor @E 99,999,999,999.99 1 S
SWN 13 WN_QUANT N 14 5 Quantidade Quantidade @E 99,999,999.99999 1 S
SWN 12 WN_PRODUTO C 15 0 Produto Produto @! 1 S 030
SWN 11 WN_ITEM C 4 0 Nº Ítem Nº Ítem 9999 1 S
SWN 10 WN_PO_NUM C 20 0 Nº Pedido Nº Pedido @! 1 S 148
SWN 09 WN_EX_NBM C 3 0 Ex-NBM Ex-NBM @! 1 S
SWN 08 WN_EX_NCM C 3 0 Ex-NCM Ex-NCM @! 1 S
SWN A3 WN_DFABRI D 8 0 Data Fabric. Data de Fabricação Lote 1 S A R
SWN A2 WN_AFRMM N 14 2 Valor AFRMM Valor A.F.R.M.M. @E 99,999,999,999.99 1 S A R
SWN A1 WN_AC C 13 0 Ato Concess. Ato Concessorio 9999999999999 1 S A R
SWN A0 WN_NVE C 3 0 Tab N.V.E. Tabela N.V.E. @! 1 S V R
SWN 99 WN_ALPISM N 6 2 % M. PIS % Majorado PIS @E 999.99 Positivo() 1 N
SWN 98 WN_VLPISM N 14 2 Vl. M. PIS Vl. Majorado PIS @E 99,999,999,999.99 Positivo() 1 N
SWN 97 WN_ALCOFM N 6 2 % M. COFINS % Majorado Cofins @E 999.99 Positivo() 1 N A R
SWN 96 WN_VLCOFM N 14 2 Vl. M.COFINS Vl. Majorado Cofins @E 99,999,999,999.99 Positivo() 1 N A R
SWN 95 WN_ITEM_DA C 4 0 Item da DA Item do compras na DA 9999 1
SWN 94 WN_ID C 10 0 ID WF ID WorkFlow @! 1 S A R
SWN 93 WN_PLIM_CP N 6 2 %Max.Cred.Pr % Maximo de Cred.Presumid @E 999.99 1 S A R
SWN 92 WN_PICM_CP N 6 2 % Cred.Pres. % de Credito Presumido @E 999.99 1 S A R
SWN 91 WN_PICMDIF N 8 2 %Diferimento % de Diferimento @E 99,999.99 1 S A R
SWN 90 WN_PICM_PD N 12 2 %Min.ICMS Rc % Minimo de ICMS a Recolh @E 999,999,999.99 1 S A R
SWN 89 WN_INTDESP C 1 0 Integ. Desp. NF integ.pelo despachante 1 A R
SWN 88 WN_QTUCOF N 14 5 Qtde esp COF Qtde específica COFINS @E 99,999,999.99999 1 A R
SWN 87 WN_QTUPIS N 14 5 Qtde esp PIS Qtde específica PIS @E 99,999,999.99999 1 A R
SWN 86 WN_QTUIPI N 14 5 Qtde esp IPI Qtde específica IPI @E 99,999,999.99999 1 A R
SWN 85 WN_ALUIPI N 15 4 Aliq esp IPI Alíquota específica IPI @E 9,999,999,999.9999 1 A R
SWN 84 WN_DESPADU N 14 2 Vl Desp Adua Valor Despesas Aduaneiras @E 99,999,999,999.99 1 A R
SWN 83 WN_VLRIOF N 14 2 Valor IOF Valor IOF @E 99,999,999,999.99 1 A R
SWN 82 WN_FECPREC N 14 2 Vl.FECP Rec. Valor FECP a recolher @E 99,999,999,999.99 1 S A R
SWN 81 WN_FECPVLD N 14 2 Vl.FECP Dif. Valor FECP diferido @E 99,999,999,999.99 1 S A R
SWN 80 WN_FECPALD N 6 2 % FECP Dif. Perc.FECP Diferido @E 999.99 1 S A R

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
SWN 1 WN_FILIAL+WN_DOC+WN_SERIE+WN_TEC+WN_EX_NCM+WN_EX_NBM No. N.F.E. + Série N.F.E. + T.E.C. + Ex-NCM + Ex-NBM Nro.Fact.Ent + Ser.Fact.Ent + T.E.C. + Ex-NCM + Ex-NBM Infl.Inv.Nr. + Inf.Inv.Seri + TEC + Ex-NBM + Ex-NBM S S 2 3
SWN 2 WN_FILIAL+WN_DOC+WN_SERIE+WN_FORNECE+WN_LOJA No. N.F.E. + Série N.F.E. + Fornecedor + Loja Nro.Fact.Ent + Ser.Fact.Ent + Proveedor + Tienda Infl.Inv.Nr. + Inf.Inv.Seri + Supplier + Unit S S 2 3
SWN 3 WN_FILIAL+WN_HAWB+WN_TIPO_NF No. Conhec. + Tipo N.F. Num. Fact.Fl + Tipo Factura Inv.Freg.Nr. + Type Invocie S S 2 3
SWN 4 WN_FILIAL+WN_DOC+WN_SDOC+WN_TEC+WN_EX_NCM+WN_EX_NBM No. N.F.E. + Série Doc. + T.E.C. + Ex-NCM + Ex-NBM Nro.Fact.Ent + Serie Doc. + T.E.C. + Ex-NCM + Ex-NBM Infl.Inv.Nr. + Inv. Series + TEC + Ex-NBM + Ex-NBM S N 2 3
SWN 5 WN_FILIAL+WN_DOC+WN_SDOC+WN_FORNECE+WN_LOJA No. N.F.E. + Série Doc. + Fornecedor + Loja Nro.Fact.Ent + Serie Doc. + Proveedor + Tienda Infl.Inv.Nr. + Inv. Series + Supplier + Unit S N 2 3

 

 

 

 

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 @!
018 Documento de entrada/saída Documento de entrada/salida Inbound/outbound document 13 6 9 @!
024 Código de Armazém Codigo de Almacen Warehouse Code 6 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
068 Lote - rastreabilidade Lote - rastreabilidad Lot - Traceability 40 10 10
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 @!
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 !!!
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