| id |
int(11)
|
|
|
|
| DniCliente |
int(11)
|
|
|
|
| ClienteNombre_c |
varchar(50)
|
utf8_general_ci
|
|
|
| Partida |
varchar(50)
|
utf8_general_ci
|
|
|
| Codigo |
int(11)
|
|
|
|
| ClienteDireccion |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteLocalidad |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteCP |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteProvincia |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteTel |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteObservaciones |
longtext
|
utf8_general_ci
|
|
|
| ClienteNacionalidad |
varchar(50)
|
utf8_general_ci
|
|
|
| ClientePropietario |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteOcupacion |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteAnt |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteEmpresa |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteTel_Emp |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteDir_Emp |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteNom_Conyuge |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteDni_Conyuge |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteTel_Conyugue |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteOcupa_Conyu |
varchar(50)
|
utf8_general_ci
|
|
|
| Fecha |
datetime
|
|
|
|
| Fecha_S |
datetime
|
|
|
|
| Solicitud |
varchar(50)
|
utf8_general_ci
|
|
|
| Cantidad |
int(11)
|
|
|
|
| Nombre |
varchar(50)
|
utf8_general_ci
|
|
|
| Vendedor |
varchar(50)
|
utf8_general_ci
|
|
|
| Importe_Tot |
decimal(19,4)
|
|
|
|
| AnticipoPagado |
decimal(19,4)
|
|
|
|
| Cuota |
decimal(19,4)
|
|
|
|
| 1_Pago |
decimal(19,4)
|
|
|
|
| Saldo |
decimal(19,4)
|
|
|
|
| Vto_Cred |
varchar(50)
|
utf8_general_ci
|
|
|
| Nº Remito |
varchar(50)
|
utf8_general_ci
|
|
|
| Fech_Remito |
datetime
|
|
|
|
| RemitoImpreso |
int(11)
|
|
|
|
| Estado |
varchar(50)
|
utf8_general_ci
|
|
|
| ValorCuota |
int(11)
|
|
|
|
| Can_Cuotas |
int(11)
|
|
|
|
| ValorCuotaS |
decimal(19,4)
|
|
|
|
| Can_CuotasS |
int(11)
|
|
|
|
| Cliente Tipo |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteNumCliente |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteCte |
varchar(50)
|
utf8_general_ci
|
|
|
| ClienteDni |
int(11)
|
|
|
|
| ClienteIngreso |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteTipo |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteDni |
int(11)
|
|
|
|
| GaranteNombre |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteDireccion |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteTel |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteCte |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteLocalidad |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteNacionalidad |
varchar(50)
|
utf8_general_ci
|
|
|
| GarantePropietario |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteOcupacion |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteEmpresa |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteAnt |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteDir_Emp |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteTel_Emp |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteNom_Conyuge |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteDni_Conyuge |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteNumCliente |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteOcupa_Conyu |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteTel_Conyugue |
varchar(50)
|
utf8_general_ci
|
|
|
| GaranteObservaciones |
longtext
|
utf8_general_ci
|
|
|
| GaranteIngreso |
varchar(50)
|
utf8_general_ci
|
|
|
| Usuario |
varchar(20)
|
utf8_general_ci
|
|
|
| Observ |
text
|
utf8_general_ci
|
|
|