| id |
int(11)
|
|
|
|
| fechaapertura |
date
|
|
|
|
| abiertopor |
varchar(200)
|
latin1_swedish_ci
|
|
|
| estado |
varchar(50)
|
latin1_swedish_ci
|
|
|
| producto |
varchar(300)
|
latin1_swedish_ci
|
|
|
| lote |
varchar(50)
|
latin1_swedish_ci
|
|
|
| proveedor |
varchar(200)
|
utf8_general_ci
|
|
|
| cliente |
varchar(300)
|
latin1_swedish_ci
|
|
|
| clienteamixstore |
varchar(200)
|
utf8_general_ci
|
|
|
| codcliente |
int(11)
|
|
|
|
| factura |
varchar(50)
|
latin1_swedish_ci
|
|
|
| empresatransporte |
varchar(200)
|
utf8_general_ci
|
|
|
| reclamacion |
longtext
|
latin1_swedish_ci
|
|
|
| muestras |
varchar(2)
|
latin1_swedish_ci
|
|
|
| correctiva |
longtext
|
latin1_swedish_ci
|
|
|
| preventiva |
longtext
|
latin1_swedish_ci
|
|
|
| imagen |
varchar(200)
|
latin1_swedish_ci
|
|
|
| imagen2 |
varchar(500)
|
latin1_swedish_ci
|
|
|
| acciones |
longtext
|
latin1_swedish_ci
|
|
|
| tratamientocliente |
longtext
|
latin1_swedish_ci
|
|
|
| tiponc |
varchar(200)
|
latin1_swedish_ci
|
|
|
| subtipo |
varchar(100)
|
utf8_general_ci
|
|
|
| subtipob |
varchar(100)
|
utf8_general_ci
|
|
|
| reembolso |
decimal(10,2)
|
|
|
|
| cierra |
varchar(200)
|
latin1_swedish_ci
|
|
|
| fechacierre |
date
|
|
|
|
| respuesta |
longtext
|
latin1_swedish_ci
|
|
|
| clientecliente |
tinyint(1)
|
|
|
|
| tipofallo |
varchar(1000)
|
utf8_general_ci
|
|
|
| recogida_bultos |
int(11)
|
|
|
|
| recogida_peso |
decimal(10,2)
|
|
|
|
| recogida_factura |
varchar(50)
|
latin1_swedish_ci
|
|
|
| recogida_envio |
varchar(50)
|
latin1_swedish_ci
|
|
|
| recogida_abonar |
varchar(2)
|
latin1_swedish_ci
|
|
|
| recogida_portes |
varchar(2)
|
latin1_swedish_ci
|
|
|
| recogida_reponer |
varchar(2)
|
latin1_swedish_ci
|
|
|
| recogida_repuesto |
varchar(2)
|
latin1_swedish_ci
|
|
|
| recogida_fecha |
date
|
|
|
|
| recogida_factura2 |
varchar(50)
|
latin1_swedish_ci
|
|
|
| recogida_albinterno |
varchar(100)
|
utf8_general_ci
|
|
|
| recogida_tipoempresa |
varchar(200)
|
utf8_general_ci
|
|
|
| recogida_cuantiarepo |
decimal(10,2)
|
|
|
|
| recogida_fechaabono |
date
|
|
|
|
| recogida_albaranabono |
varchar(25)
|
utf8_general_ci
|
|
|
| recogida_facturaabono |
varchar(25)
|
utf8_general_ci
|
|
|
| recogida_motivonoreposicion |
longtext
|
utf8_general_ci
|
|
|
| recogida_motivonoabono |
longtext
|
utf8_general_ci
|
|
|
| recogida_recogido |
varchar(20)
|
utf8_general_ci
|
|
|
| recogida_motivonorecogido |
longtext
|
utf8_general_ci
|
|
|
| recogida_direccionenvio |
longtext
|
utf8_general_ci
|
|
|
| recogida_coddireccion |
varchar(11)
|
utf8_general_ci
|
|
|
| recogida_transporte |
varchar(20)
|
utf8_general_ci
|
|
|
| recogida_cobrarportes |
varchar(2)
|
utf8_general_ci
|
|
|
| recogida_importeportes |
decimal(10,2)
|
|
|
|
| recogida_abonarlevante |
varchar(2)
|
utf8_general_ci
|
|
|
| reembolsolevante |
decimal(10,2)
|
|
|
|
| recogida_fechaabonolevante |
date
|
|
|
|
| recogida_albaranabonolevante |
varchar(25)
|
utf8_general_ci
|
|
|
| recogida_facturaabonolevante |
varchar(25)
|
utf8_general_ci
|
|
|
| recogida_motivonoabonolevante |
longtext
|
utf8_general_ci
|
|
|
| fecharecepcion |
date
|
|
|
|
| imagenalmacen |
varchar(100)
|
utf8_general_ci
|
|
|
| imagenalmacen2 |
varchar(150)
|
utf8_general_ci
|
|
|
| observacionesalmacen |
longtext
|
utf8_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| create_user |
int(11)
|
|
|
|
| update_at |
datetime
|
|
|
|
| update_user |
int(11)
|
|
|
|
| blocker |
int(11)
|
|
|
|
| responsable |
varchar(100)
|
utf8_general_ci
|
|
|
| market |
varchar(25)
|
utf8_general_ci
|
|
|
