Tabela SW6 no Protheus

A tabela SW6 do Protheus está descrita no dicionário (SX2) como “Capa Declaração de Importação”. Possui 236 campos e 11 índices e chave única W6_FILIAL+W6_HAWB. Abaixo estão tipo, tamanho e descrição de cada campo, os índices e um exemplo de consulta SQL.

Propriedades da tabela

Código

SW6

Nome

Capa Declaração de Importação

Nome (inglês)

Import Declaration Cover

Compartilhamento por filial

Exclusivo

Compartilhamento por unidade

Exclusivo

Compartilhamento por empresa

Exclusivo

Chave única

W6_FILIAL+W6_HAWB

Campos / índices

236 / 11

Perguntas frequentes sobre a tabela SW6

O que é a tabela SW6?

É a tabela “Capa Declaração de Importação” do ERP TOTVS Protheus, com 236 campos definidos no dicionário SX3.

Qual é a chave única da tabela SW6?

A chave única é W6_FILIAL+W6_HAWB.

Quais são os índices da tabela SW6?

A tabela tem 11 índices. O principal (ordem 1) usa a chave W6_FILIAL+W6_HAWB.

Qual é o nome físico da tabela SW6 no banco de dados?

No banco, o nome é o código da tabela seguido do código da empresa (no dicionário de referência desta consulta: SW6990). Em ADVPL, use RetSqlName("SW6") para obter o nome correto do ambiente.

Exemplo de consulta SQL da tabela SW6

Modelo gerado a partir da estrutura da tabela. Ajuste os filtros ao seu cenário.

SELECT
    W6_FININV,
    W6_FILIAL,
    W6_HAWB,
    W6_FINFRE,
    W6_DT_HAWB,
    W6_PEDFAT,
    W6_PREFIXF,
    W6_PO_NUM,
    W6_IMPCO,
    W6_DESP,
    W6_NUMDUPF,
    W6_TIPOF,
    W6_DESPNOM,
    W6_REF_DES,
    W6_PARCELF,
    W6_FINSEG,
    W6_DTRECDO,
    W6_FAT_DES,
    W6_PREFIXS,
    W6_DT_ETD,
    W6_NUMDUPS,
    W6_DT_ETA,
    W6_TIPOS,
    W6_LOCAL,
    W6_PARCELS,
    W6_LOCALN,
    W6_TITINAN,
    W6_TIPODES,
    W6_UFDESEM,
    W6_VM_TDES,
    W6_IMPORT,
    W6_IMPORVM,
    W6_DT_ENCE,
    W6_DT_EMB,
    W6_VIA_TRA,
    W6_DESCVIA,
    W6_ORIGEM,
    W6_DEST,
    W6_PAISPRO,
    W6_DT_AVE,
    W6_TIPOCON,
    W6_VM_TCON,
    W6_HOUSE,
    W6_PRCARGA,
    W6_MAWB,
    W6_NOMEVE,
    W6_IDENTVE,
    W6_VIAGEM,
    W6_CONEVE1,
    W6_CONEET1,
    W6_CONEPO1,
    W6_CONEVE2,
    W6_CONEET2,
    W6_CONEPO2,
    W6_CHEG,
    W6_AGENTE,
    W6_AGENTEN,
    W6_TRANSIN,
    W6_TRANSVM,
    W6_PAISVEI,
    W6_PAISNOM,
    W6_ARMADOR,
    W6_ARMNOME,
    W6_TIPODOC,
    W6_UTILCON,
    W6_IDEMANI,
    W6_PESO_BR,
    W6_MT3,
    W6_VOLUME,
    W6_PESO_TX,
    W6_PESOL,
    W6_PESOTOT,
    W6_PESO_TO,
    W6_CONTA20,
    W6_CONTA40,
    W6_CON40HC,
    W6_OUT_CTN,
    W6_CURRIER,
    W6_OUTROS,
    W6_FREMOED,
    W6_VLFREPP,
    W6_VLFRECC,
    W6_VLFRETN,
    W6_TX_FRET,
    W6_VL_FRET,
    W6_DIASP_F,
    W6_DTLANCF,
    W6_CONDP_F,
    W6_VENCFRE,
    W6_CO_CARG,
    W6_COD_SEG,
    W6_DTLANCS,
    W6_NORMATI,
    W6_SEGDESC,
    W6_SEGPERC,
    W6_SEGBASE,
    W6_SEGMOED,
    W6_VL_USSE,
    W6_TX_SEG,
    W6_VLSEGMN,
    W6_NF_SEG,
    W6_CONDP_S,
    W6_CORRETO,
    W6_VENCSEG,
    W6_DIASP_S,
    W6_TRANS,
    W6_DESCTRA,
    W6_MULTIMO,
    W6_TX_US_D,
    W6_VLMLEMN,
    W6_FOB_TOT,
    W6_INLAND,
    W6_PACKING,
    W6_NR_PROC,
    W6_NR_DSE,
    W6_NR_DDE,
    W6_DT_DSE,
    W6_UL_DSE,
    W6_DESCONT,
    W6_FRETEIN,
    W6_OUTDESP,
    W6_FOB_GER,
    W6_DT_DOC,
    W6_NF_ENT,
    W6_SE_NF,
    W6_DT_NF,
    W6_VL_NF,
    W6_DT_ENTR,
    W6_NF_COMP,
    W6_SE_NFC,
    W6_CALCAUT,
    W6_DT_NFC,
    W6_RECOF,
    W6_DTRECOF,
    W6_OK,
    W6_NF_TRAN,
    W6_VL_NFC,
    W6_TIPOREG,
    W6_STDUIMP,
    W6_DTREG_D,
    W6_DI_NUM,
    W6_VERSAO,
    W6_DA_NUM,
    W6_DA_DT,
    W6_DA_CHEG,
    W6_DT,
    W6_DT_DESE,
    W6_REC_ALF,
    W6_VM_RECA,
    W6_MODAL_D,
    W6_URF_DES,
    W6_VM_UDES,
    W6_URF_ENT,
    W6_TAB_PC,
    W6_VM_UENT,
    W6_INSTRDE,
    W6_INSTRVM,
    W6_PROCVIN,
    W6_PROCVVM,
    W6_VOLUMES,
    W6_VOLUMVM,
    W6_SETORRA,
    W6_ARMAZEM,
    W6_BCOPGTO,
    W6_AGEPGTO,
    W6_CTAPGTO,
    W6_DEBITOS,
    W6_FUNDAP,
    W6_DEBITVM,
    W6_COMPLEM,
    W6_MSG_COM,
    W6_VM_COMP,
    W6_OBS,
    W6_VM_OBS,
    W6_QTD_ADI,
    W6_PRO_IMP,
    W6_CGC_OUT,
    W6_CONTAB,
    W6_PROB_DI,
    W6_PRVENTR,
    W6_LOTE,
    W6_PRVDESE,
    W6_ARQ,
    W6_ENV_ORI,
    W6_TOT_REC,
    W6_TIPOFEC,
    W6_NACIONA,
    W6_DT_DTA,
    W6_NUMDUP,
    W6_FREPPCC,
    W6_VLFR_CO,
    W6_INCOTER,
    W6_COND_PA,
    W6_DIAS_PA,
    W6_DESCRPG,
    W6_NR_PRO,
    W6_TX_FOB,
    W6_FOBMOE,
    W6_ENVFLG1,
    W6_CANAL,
    W6_ADICAOK,
    W6_FORN,
    W6_LOJA,
    W6_STATUS,
    W6_DSI,
    W6_FORNECF,
    W6_LOJAF,
    W6_FORNECS,
    W6_LOJAS,
    W6_QBRPICO,
    W6_MERCTRA,
    W6_DIRE,
    W6_DEMERCO,
    W6_REINIC,
    W6_REFINAL,
    W6_IMPENC,
    W6_ID_EMB,
    W6_DI_OBS,
    W6_VMDIOBS,
    W6_ID_ENC,
    W6_ID_ENCE,
    W6_ID_PRV,
    W6_DI_HIS,
    W6_SEGINV,
    W6_TITOK,
    W6_IDLOTE,
    W6_REGAL,
    W6_FFREINT,
    W6_FFRELOJ,
    W6_FORMREG,
    W6_REGMANU,
    W6_VSMANU,
    W6_DTMANU,
    W6_SDOC,
    W6_SDOCC,
    W6_TOT_PRO
FROM SW6
WHERE
    D_E_L_E_T_ = ' '
    AND W6_FININV = 'VALOR'
    AND W6_FILIAL = 'VALOR'
    AND W6_HAWB = 'VALOR'
    AND W6_FINFRE = 'VALOR'
    AND W6_DT_HAWB BETWEEN '20261101' AND '20261130'
    AND W6_PEDFAT = 'VALOR'
    AND W6_PREFIXF = 'VALOR'
    AND W6_PO_NUM = 'VALOR'
    AND W6_IMPCO = 'VALOR'
    AND W6_DESP = 'VALOR'
    AND W6_NUMDUPF = 'VALOR'
    AND W6_TIPOF = 'VALOR'
    AND W6_DESPNOM = 'VALOR'
    AND W6_REF_DES = 'VALOR'
    AND W6_PARCELF = 'VALOR'
    AND W6_FINSEG = 'VALOR'
    AND W6_DTRECDO BETWEEN '20261101' AND '20261130'
    AND W6_FAT_DES = 'VALOR'
    AND W6_PREFIXS = 'VALOR'
    AND W6_DT_ETD BETWEEN '20261101' AND '20261130'
    AND W6_NUMDUPS = 'VALOR'
    AND W6_DT_ETA BETWEEN '20261101' AND '20261130'
    AND W6_TIPOS = 'VALOR'
    AND W6_LOCAL = 'VALOR'
    AND W6_PARCELS = 'VALOR'
    AND W6_LOCALN = 'VALOR'
    AND W6_TITINAN = 'VALOR'
    AND W6_TIPODES = 'VALOR'
    AND W6_UFDESEM = 'VALOR'
    AND W6_VM_TDES = 'VALOR'
    AND W6_IMPORT = 'VALOR'
    AND W6_IMPORVM = 'VALOR'
    AND W6_DT_ENCE BETWEEN '20261101' AND '20261130'
    AND W6_DT_EMB BETWEEN '20261101' AND '20261130'
    AND W6_VIA_TRA = 'VALOR'
    AND W6_DESCVIA = 'VALOR'
    AND W6_ORIGEM = 'VALOR'
    AND W6_DEST = 'VALOR'
    AND W6_PAISPRO = 'VALOR'
    AND W6_DT_AVE BETWEEN '20261101' AND '20261130'
    AND W6_TIPOCON = 'VALOR'
    AND W6_VM_TCON = 'VALOR'
    AND W6_HOUSE = 'VALOR'
    AND W6_PRCARGA = 'VALOR'
    AND W6_MAWB = 'VALOR'
    AND W6_NOMEVE = 'VALOR'
    AND W6_IDENTVE = 'VALOR'
    AND W6_VIAGEM = 'VALOR'
    AND W6_CONEVE1 = 'VALOR'
    AND W6_CONEET1 BETWEEN '20261101' AND '20261130'
    AND W6_CONEPO1 = 'VALOR'
    AND W6_CONEVE2 = 'VALOR'
    AND W6_CONEET2 BETWEEN '20261101' AND '20261130'
    AND W6_CONEPO2 = 'VALOR'
    AND W6_CHEG BETWEEN '20261101' AND '20261130'
    AND W6_AGENTE = 'VALOR'
    AND W6_AGENTEN = 'VALOR'
    AND W6_TRANSIN = 'VALOR'
    AND W6_TRANSVM = 'VALOR'
    AND W6_PAISVEI = 'VALOR'
    AND W6_PAISNOM = 'VALOR'
    AND W6_ARMADOR = 'VALOR'
    AND W6_ARMNOME = 'VALOR'
    AND W6_TIPODOC = 'VALOR'
    AND W6_UTILCON = 'VALOR'
    AND W6_IDEMANI = 'VALOR'
    AND W6_PESO_BR = 0
    AND W6_MT3 = 0
    AND W6_VOLUME = 'VALOR'
    AND W6_PESO_TX = 0
    AND W6_PESOL = 0
    AND W6_PESOTOT = 0
    AND W6_PESO_TO = 0
    AND W6_CONTA20 = 0
    AND W6_CONTA40 = 0
    AND W6_CON40HC = 0
    AND W6_OUT_CTN = 'VALOR'
    AND W6_CURRIER = 'VALOR'
    AND W6_OUTROS = 0
    AND W6_FREMOED = 'VALOR'
    AND W6_VLFREPP = 0
    AND W6_VLFRECC = 0
    AND W6_VLFRETN = 0
    AND W6_TX_FRET = 0
    AND W6_VL_FRET = 0
    AND W6_DIASP_F = 0
    AND W6_DTLANCF BETWEEN '20261101' AND '20261130'
    AND W6_CONDP_F = 'VALOR'
    AND W6_VENCFRE BETWEEN '20261101' AND '20261130'
    AND W6_CO_CARG = 'VALOR'
    AND W6_COD_SEG = 'VALOR'
    AND W6_DTLANCS BETWEEN '20261101' AND '20261130'
    AND W6_NORMATI = 'VALOR'
    AND W6_SEGDESC = 'VALOR'
    AND W6_SEGPERC = 0
    AND W6_SEGBASE = 'VALOR'
    AND W6_SEGMOED = 'VALOR'
    AND W6_VL_USSE = 0
    AND W6_TX_SEG = 0
    AND W6_VLSEGMN = 0
    AND W6_NF_SEG = 'VALOR'
    AND W6_CONDP_S = 'VALOR'
    AND W6_CORRETO = 'VALOR'
    AND W6_VENCSEG BETWEEN '20261101' AND '20261130'
    AND W6_DIASP_S = 0
    AND W6_TRANS = 'VALOR'
    AND W6_DESCTRA = 'VALOR'
    AND W6_MULTIMO = 'VALOR'
    AND W6_TX_US_D = 0
    AND W6_VLMLEMN = 0
    AND W6_FOB_TOT = 0
    AND W6_INLAND = 0
    AND W6_PACKING = 0
    AND W6_NR_PROC = 'VALOR'
    AND W6_NR_DSE = 'VALOR'
    AND W6_NR_DDE = 'VALOR'
    AND W6_DT_DSE BETWEEN '20261101' AND '20261130'
    AND W6_UL_DSE = 'VALOR'
    AND W6_DESCONT = 0
    AND W6_FRETEIN = 0
    AND W6_OUTDESP = 0
    AND W6_FOB_GER = 0
    AND W6_DT_DOC BETWEEN '20261101' AND '20261130'
    AND W6_NF_ENT = 'VALOR'
    AND W6_SE_NF = 'VALOR'
    AND W6_DT_NF BETWEEN '20261101' AND '20261130'
    AND W6_VL_NF = 0
    AND W6_DT_ENTR BETWEEN '20261101' AND '20261130'
    AND W6_NF_COMP = 'VALOR'
    AND W6_SE_NFC = 'VALOR'
    AND W6_CALCAUT = 'VALOR'
    AND W6_DT_NFC BETWEEN '20261101' AND '20261130'
    AND W6_RECOF = 'VALOR'
    AND W6_DTRECOF BETWEEN '20261101' AND '20261130'
    AND W6_OK = 'VALOR'
    AND W6_NF_TRAN = 'VALOR'
    AND W6_VL_NFC = 0
    AND W6_TIPOREG = 'VALOR'
    AND W6_STDUIMP = 'VALOR'
    AND W6_DTREG_D BETWEEN '20261101' AND '20261130'
    AND W6_DI_NUM = 'VALOR'
    AND W6_VERSAO = 'VALOR'
    AND W6_DA_NUM = 0
    AND W6_DA_DT BETWEEN '20261101' AND '20261130'
    AND W6_DA_CHEG BETWEEN '20261101' AND '20261130'
    AND W6_DT BETWEEN '20261101' AND '20261130'
    AND W6_DT_DESE BETWEEN '20261101' AND '20261130'
    AND W6_REC_ALF = 'VALOR'
    AND W6_VM_RECA = 'VALOR'
    AND W6_MODAL_D = 'VALOR'
    AND W6_URF_DES = 'VALOR'
    AND W6_VM_UDES = 'VALOR'
    AND W6_URF_ENT = 'VALOR'
    AND W6_TAB_PC = 'VALOR'
    AND W6_VM_UENT = 'VALOR'
    AND W6_INSTRDE = 'VALOR'
    AND W6_INSTRVM = 'VALOR'
    AND W6_PROCVIN = 'VALOR'
    AND W6_PROCVVM = 'VALOR'
    AND W6_VOLUMES = 'VALOR'
    AND W6_VOLUMVM = 'VALOR'
    AND W6_SETORRA = 'VALOR'
    AND W6_ARMAZEM = 'VALOR'
    AND W6_BCOPGTO = 'VALOR'
    AND W6_AGEPGTO = 'VALOR'
    AND W6_CTAPGTO = 'VALOR'
    AND W6_DEBITOS = 'VALOR'
    AND W6_FUNDAP = 'VALOR'
    AND W6_DEBITVM = 'VALOR'
    AND W6_COMPLEM = 'VALOR'
    AND W6_MSG_COM = 'VALOR'
    AND W6_OBS = 'VALOR'
    AND W6_QTD_ADI = 0
    AND W6_PRO_IMP = 'VALOR'
    AND W6_CGC_OUT = 'VALOR'
    AND W6_CONTAB BETWEEN '20261101' AND '20261130'
    AND W6_PROB_DI = 'VALOR'
    AND W6_PRVENTR BETWEEN '20261101' AND '20261130'
    AND W6_LOTE = 'VALOR'
    AND W6_PRVDESE BETWEEN '20261101' AND '20261130'
    AND W6_ARQ = 'VALOR'
    AND W6_ENV_ORI BETWEEN '20261101' AND '20261130'
    AND W6_TOT_REC = 0
    AND W6_TIPOFEC = 'VALOR'
    AND W6_NACIONA = 'VALOR'
    AND W6_DT_DTA BETWEEN '20261101' AND '20261130'
    AND W6_NUMDUP = 'VALOR'
    AND W6_FREPPCC = 'VALOR'
    AND W6_VLFR_CO = 0
    AND W6_INCOTER = 'VALOR'
    AND W6_COND_PA = 'VALOR'
    AND W6_DIAS_PA = 0
    AND W6_DESCRPG = 'VALOR'
    AND W6_NR_PRO = 'VALOR'
    AND W6_TX_FOB = 0
    AND W6_FOBMOE = 'VALOR'
    AND W6_ENVFLG1 = 'VALOR'
    AND W6_CANAL = 'VALOR'
    AND W6_ADICAOK = 'VALOR'
    AND W6_FORN = 'VALOR'
    AND W6_LOJA = 'VALOR'
    AND W6_STATUS = 'VALOR'
    AND W6_DSI = 'VALOR'
    AND W6_FORNECF = 'VALOR'
    AND W6_LOJAF = 'VALOR'
    AND W6_FORNECS = 'VALOR'
    AND W6_LOJAS = 'VALOR'
    AND W6_QBRPICO = 'VALOR'
    AND W6_MERCTRA = 'VALOR'
    AND W6_DIRE = 'VALOR'
    AND W6_DEMERCO = 'VALOR'
    AND W6_REINIC = 'VALOR'
    AND W6_REFINAL = 'VALOR'
    AND W6_IMPENC = 'VALOR'
    AND W6_ID_EMB = 'VALOR'
    AND W6_DI_OBS = 'VALOR'
    AND W6_ID_ENC = 'VALOR'
    AND W6_ID_ENCE = 'VALOR'
    AND W6_ID_PRV = 'VALOR'
    AND W6_DI_HIS = 'VALOR'
    AND W6_SEGINV = 0
    AND W6_TITOK = 'VALOR'
    AND W6_IDLOTE = 'VALOR'
    AND W6_REGAL = 'VALOR'
    AND W6_FFREINT = 'VALOR'
    AND W6_FFRELOJ = 'VALOR'
    AND W6_FORMREG = 'VALOR'
    AND W6_REGMANU = 'VALOR'
    AND W6_VSMANU = 'VALOR'
    AND W6_DTMANU BETWEEN '20261101' AND '20261130'
    AND W6_SDOC = 'VALOR'
    AND W6_SDOCC = 'VALOR'
    AND W6_TOT_PRO = 0

Outras tabelas relacionadas

• SW0 Capa de Solicitação Importação
• SW1 Itens Solicitação Importação
• SW2 Capa de Purchase Order
• SW3 Itens de Purchase Order
• SW4 Capa Preparação de Licença Imp
• SW5 Itens Preparação Licença Imp
• SW7 Itens Declaração de Importação
• SW8 Itens de Invoices
• SW9 Capa de Invoices
• SWA Capa de Câmbio
• SWB Itens de Câmbio
• SWC Carta Crédito

Dicionário Protheus · atualizado em 13/10/2026. Voltar ao índice do dicionário.