| id |
int(11)
|
|
|
|
| ruc |
varchar(13)
|
utf8mb4_general_ci
|
|
|
| razon_social |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| nombre_comercial |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| direccion_matriz |
text
|
utf8mb4_general_ci
|
|
|
| obligado_contabilidad |
enum('SI', 'NO')
|
utf8mb4_general_ci
|
|
|
| ambiente |
enum('1', '2')
|
utf8mb4_general_ci
|
|
|
| estado |
enum('ACTIVA', 'INACTIVA')
|
utf8mb4_general_ci
|
|
|
| fecha_creacion |
timestamp
|
|
|
|
| certificado_p12 |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| clave_certificado |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| fecha_vencimiento_certificado |
date
|
|
|
|
| estab |
varchar(3)
|
utf8mb4_general_ci
|
|
|
| correo |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| telefono |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| pto_emi |
varchar(3)
|
utf8mb4_general_ci
|
|
|
| smtp_host |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| smtp_port |
int(11)
|
|
|
|
| smtp_secure |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| smtp_user |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| smtp_pass |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| smtp_from_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| smtp_activo |
tinyint(1)
|
|
|
|
| correo_facturacion |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| regimen |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| contribuyente_especial_resolucion |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| gran_contribuyente_resolucion |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| artesano_resolucion |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| agente_retencion_resolucion |
varchar(80)
|
utf8mb4_general_ci
|
|
|