Detalhes da Tabela

meus_impostos | Database: devprojetos_emissor | Conexão: Teste migração

Estrutura da Tabela

Field Type Null Key Default Extra
id int(11) NO PRI auto_increment
idUsuario int(11) YES MUL
userIdMaster int(11) YES
nome varchar(100) NO
descricao varchar(255) YES
padrao tinyint(1) YES 0
regime_tributario varchar(20) YES normal
icms_orig varchar(1) YES 0
icms_cst varchar(4) YES
icms_csosn varchar(4) YES
icms_modBC varchar(1) YES 3
icms_aliquota decimal(10,2) YES 0.00
icms_pRedBC decimal(10,2) YES 0.00
icms_st_aliquota decimal(10,2) YES 0.00
icms_st_mva decimal(10,2) YES 0.00
fcp_aliquota decimal(10,2) YES 0.00
fcp_st_aliquota decimal(10,2) YES 0.00
icms_desonerado decimal(10,2) YES 0.00
motivo_desoneracao varchar(2) YES
difal_aliquota decimal(10,2) YES 0.00
difal_partilha decimal(10,2) YES 0.00
cBenef varchar(10) YES
pis_cst varchar(4) YES
pis_aliquota decimal(10,2) YES 0.00
pis_modBC varchar(1) YES 3
cofins_cst varchar(4) YES
cofins_aliquota decimal(10,2) YES 0.00
cofins_modBC varchar(1) YES 3
ipi_cst varchar(4) YES
ipi_aliquota decimal(10,2) YES 0.00
ipi_modBC varchar(1) YES 3
ipi_enquadramento varchar(3) YES 999
cfop_padrao varchar(4) YES 5102
natureza_operacao int(11) YES
cbs_aliquota decimal(10,2) YES 0.00
ibs_aliquota decimal(10,2) YES 0.00
is_aliquota decimal(10,2) YES 0.00
situacao tinyint(1) YES 1
lastUser int(11) YES
created_at timestamp YES CURRENT_TIMESTAMP
updated_at timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP

Dados da Tabela (máx. 100 linhas)

id idUsuario userIdMaster nome descricao padrao regime_tributario icms_orig icms_cst icms_csosn icms_modBC icms_aliquota icms_pRedBC icms_st_aliquota icms_st_mva fcp_aliquota fcp_st_aliquota icms_desonerado motivo_desoneracao difal_aliquota difal_partilha cBenef pis_cst pis_aliquota pis_modBC cofins_cst cofins_aliquota cofins_modBC ipi_cst ipi_aliquota ipi_modBC ipi_enquadramento cfop_padrao natureza_operacao cbs_aliquota ibs_aliquota is_aliquota situacao lastUser created_at updated_at
4 Lucro Real - Venda Interestadual Regime Normal - Lucro Real (PIS/COFINS não cumulativo) 0 normal 0 60 3 12.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 01 1.65 3 01 7.60 3 00 0.00 3 999 6102 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
5 Lucro Real - Venda com ST Regime Normal com Substituição Tributária 0 normal 0 60 3 18.00 0.00 18.00 50.00 0.00 0.00 0.00 0.00 0.00 01 1.65 3 01 7.60 3 00 0.00 3 999 5405 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
6 Lucro Presumido - Venda Regime Normal - Lucro Presumido (PIS/COFINS cumulativo) 1 normal 0 60 3 12.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 01 0.65 3 01 3.00 3 00 0.00 3 999 6102 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
7 Lucro Presumido - Marketplace Vendas em Marketplaces (Mercado Livre, Shopee, Amazon) 0 normal 0 60 3 18.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 MPLACE 01 0.65 3 01 3.00 3 53 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
8 Simples Nacional - Comércio Simples Nacional - Sem permissão de crédito ICMS 0 sn 0 102 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
9 Simples Nacional - Com Crédito Simples Nacional - Com permissão de crédito ICMS 0 sn 0 101 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
10 Simples Nacional - Marketplace Vendas em Marketplaces pelo Simples 0 sn 0 500 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
11 Simples Nacional - Indústria Simples Nacional para industrialização 0 sn 0 102 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5101 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
12 MEI - Comércio Microempreendedor Individual - Comércio 0 mei 0 102 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
13 MEI - Serviço Microempreendedor Individual - Prestação de Serviço 0 mei 0 900 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5933 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
14 Isento de Impostos Produtos isentos/imunes (ex: livros, alimentos básicos) 0 normal 0 40 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 07 0.00 3 07 0.00 3 53 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:42:18 2026-05-30 10:47:13
15 Lucro Presumido - Venda Regime Normal - Lucro Presumido (PIS 0,65% / COFINS 3%) 1 normal 0 60 3 12.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 01 0.65 3 01 3.00 3 00 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:47:13 2026-05-30 10:47:13
16 Lucro Real - Venda Interestadual Regime Normal - Lucro Real (PIS 1,65% / COFINS 7,60%) 0 normal 0 60 3 12.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 01 1.65 3 01 7.60 3 00 0.00 3 999 6102 0.00 0.00 0.00 1 2026-05-30 10:47:13 2026-05-30 10:47:13
17 Lucro Presumido - Marketplace Vendas em Marketplaces (ML, Shopee, Amazon) 0 normal 0 60 3 18.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 01 0.65 3 01 3.00 3 53 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:47:13 2026-05-30 10:47:13
18 Lucro Real - Venda com ST Regime Normal com Substituição Tributária 0 normal 0 60 3 18.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 01 1.65 3 01 7.60 3 00 0.00 3 999 5405 0.00 0.00 0.00 1 2026-05-30 10:47:13 2026-05-30 10:47:13
19 Simples Nacional - Comércio Simples Nacional - Sem permissão de crédito ICMS 0 sn 0 102 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:47:13 2026-05-30 10:47:13
20 Simples Nacional - Com Crédito Simples Nacional - Com permissão de crédito ICMS 0 sn 0 101 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:47:13 2026-05-30 10:47:13
21 Simples Nacional - Marketplace Vendas em Marketplaces pelo Simples 0 sn 0 500 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:47:13 2026-05-30 10:47:13
22 MEI - Comércio Microempreendedor Individual - Comércio 0 mei 0 102 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:47:13 2026-05-30 10:47:13
23 MEI - Serviço Microempreendedor Individual - Prestação de Serviço 0 mei 0 900 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49 0.00 3 49 0.00 3 99 0.00 3 999 5933 0.00 0.00 0.00 1 2026-05-30 10:47:13 2026-05-30 10:47:13
24 Isento de Impostos Produtos isentos/imunes (livros, alimentos básicos) 0 normal 0 40 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 07 0.00 3 07 0.00 3 53 0.00 3 999 5102 0.00 0.00 0.00 1 2026-05-30 10:47:13 2026-05-30 10:47:13
25 419 419 Perfil QA Teste QA 0 normal 0 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3 0.00 3 0.00 3 999 5102 0.00 0.00 0.00 1 419 2026-06-17 21:09:42 2026-06-17 21:09:42
Voltar para Tabelas Voltar para Bases