| id_empresa |
int(11)
|
|
|
|
| status |
enum('ATIVO', 'BLOQUEADO')
|
utf8mb4_general_ci
|
|
|
| CNPJ |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| xNome |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| xFant |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| IE |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| CRT |
enum('1', '4')
|
utf8mb4_general_ci
|
|
|
| logomarca |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| favicon |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| CEP |
varchar(16)
|
utf8mb4_general_ci
|
|
|
| xLgr |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| nro |
varchar(16)
|
utf8mb4_general_ci
|
|
|
| xCpl |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| xBairro |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| fone |
varchar(11)
|
utf8mb4_general_ci
|
|
|
| natOp |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| serie |
varchar(3)
|
utf8mb4_general_ci
|
|
|
| verProc |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| nNF_homologacao |
int(11)
|
|
|
|
| nNF_producao |
int(11)
|
|
|
|
| tpAmb_NFe |
int(11)
|
|
|
|
| nNFC_homologacao |
int(11)
|
|
|
|
| nNFC_producao |
int(11)
|
|
|
|
| tpAmb_NFCe |
int(11)
|
|
|
|
| CSC_Id |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| CSC |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| certificado |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| senha_do_certificado |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| data_vencimento_certificado |
date
|
|
|
|
| nsu_dfe_atual |
bigint(20)
|
|
|
|
| max_nsu_dfe |
bigint(20)
|
|
|
|
| ult_consulta_dfe_em |
datetime
|
|
|
|
| modulo_fiscal |
int(11)
|
|
|
|
| ncm_padrao |
varchar(8)
|
utf8mb4_general_ci
|
|
|
| cest_padrao |
varchar(7)
|
utf8mb4_general_ci
|
|
|
| csosn_padrao |
varchar(3)
|
utf8mb4_general_ci
|
|
|
| cfop_interno_padrao |
varchar(4)
|
utf8mb4_general_ci
|
|
|
| cfop_externo_padrao |
varchar(4)
|
utf8mb4_general_ci
|
|
|
| cst_pis_cofins_padrao |
varchar(2)
|
utf8mb4_general_ci
|
|
|
| layout_pdv |
enum('PADRAO', 'TOUCH')
|
utf8mb4_general_ci
|
|
|
| exibir_foto_produto_pdv |
enum('SIM', 'NAO')
|
utf8mb4_general_ci
|
|
|
| segmento |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| id_uf |
int(11)
|
|
|
|
| id_municipio |
int(11)
|
|
|
 Visualizar valores estrangeiros
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| deleted_at |
datetime
|
|
|
|
