# Generated by Django 3.2.6 on 2021-08-23 23:56 import Main.models from django.db import migrations, models import django.db.models.deletion class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='Cajas', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('nombre', models.CharField(max_length=100, verbose_name='Nombre Caja')), ('estado', models.BooleanField(default=True, verbose_name='Estado Caja:')), ('horaIngreso', models.CharField(max_length=20, null=True, verbose_name='hora Ingreso')), ], options={ 'verbose_name': 'Caja', 'verbose_name_plural': 'Cajas', 'ordering': ['id'], }, ), migrations.CreateModel( name='Cliente', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id')), ('dni', models.CharField(blank=True, max_length=11, null=True, verbose_name='DNI:')), ('nombre', models.CharField(blank=True, max_length=100, null=True, verbose_name='Nombres:')), ('Apellido_paterno', models.CharField(blank=True, max_length=200, null=True, verbose_name=' Apellido Paterno:')), ('Apellido_materno', models.CharField(blank=True, max_length=200, null=True, verbose_name='Apellido Materno:')), ('telefono', models.CharField(blank=True, max_length=15, null=True, verbose_name='Teléfono:')), ('direccion', models.CharField(blank=True, max_length=100, null=True, verbose_name='Dirección:')), ('fecha_nacimiento', models.DateField(blank=True, null=True, verbose_name='Cumpleaños:')), ('email', models.CharField(max_length=250, null=True, verbose_name='e-mail:')), ('drem', models.CharField(blank=True, max_length=100, null=True, verbose_name='DREM:')), ('estado', models.BooleanField(default=True, verbose_name='Estado:')), ('tipo_persona', models.CharField(blank=True, max_length=10, null=True, verbose_name='Tipo Persona:')), ('transferencias', models.CharField(blank=True, max_length=2, null=True, verbose_name='Transferencia:')), ('cuentas', models.CharField(blank=True, max_length=2, null=True, verbose_name='Cuentas:')), ('dolar', models.CharField(blank=True, max_length=2, null=True, verbose_name='Dolar:')), ('otros', models.CharField(blank=True, max_length=2, null=True, verbose_name='Otros:')), ('tablaRelacional', models.CharField(blank=True, max_length=30, null=True, verbose_name='Tabla Relacional:')), ('verificado', models.BooleanField(default=False, verbose_name='Verificado:')), ('idCaja', models.IntegerField(default=0, verbose_name='id Caja:')), ('operaciones_caja', models.CharField(blank=True, max_length=100, null=True, verbose_name='operaciones caja:')), ], options={ 'verbose_name': 'Cliente', 'verbose_name_plural': 'Clientes', 'ordering': ['id'], }, ), migrations.CreateModel( name='ConceptoEgreso', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID:')), ('concepto', models.CharField(max_length=250, null=True, verbose_name='concepto:')), ('estado', models.BooleanField(default=True, verbose_name='estado')), ], options={ 'verbose_name': 'Concepto Egreso', 'verbose_name_plural': 'Conceptos Egreso', 'ordering': ['id'], }, ), migrations.CreateModel( name='ConceptoEgresoM', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID:')), ('concepto', models.CharField(max_length=250, null=True, verbose_name='concepto:')), ('estado', models.BooleanField(default=True, verbose_name='estado')), ], options={ 'verbose_name': 'Concepto Egreso', 'verbose_name_plural': 'Conceptos Egreso', 'ordering': ['id'], }, ), migrations.CreateModel( name='conf_liquid_Cajas', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('aux1', models.CharField(blank=True, max_length=25, null=True, verbose_name='aux1')), ('aux2', models.CharField(blank=True, max_length=25, null=True, verbose_name='aux2')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id:')), ], options={ 'verbose_name': 'Configuracion arqueo caja', 'verbose_name_plural': 'Configuraciones de arqueo de cajas', 'ordering': ['id'], }, ), migrations.CreateModel( name='Configuracion_monto_bancos', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('montomin', models.DecimalField(decimal_places=2, max_digits=15)), ('montomax', models.DecimalField(decimal_places=2, max_digits=15)), ('banco_nacion', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ('otros_bancos', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ('continental', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ('bcp', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ], options={ 'verbose_name': 'Configuracion Monto Banco', 'verbose_name_plural': 'Configuraciones Montos Banco', 'ordering': ['id'], }, ), migrations.CreateModel( name='Gerente', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('dni', models.CharField(blank=True, max_length=8, null=True, verbose_name='DNI:')), ('nombre', models.CharField(blank=True, max_length=100, null=True, verbose_name='Nombres:')), ('Apellido_paterno', models.CharField(blank=True, max_length=200, null=True, verbose_name='Apellido Paterno:')), ('Apellido_materno', models.CharField(blank=True, max_length=200, null=True, verbose_name='Apellido Materno:')), ('telefono', models.CharField(blank=True, max_length=15, null=True, verbose_name='Teléfono:')), ('direccion', models.CharField(blank=True, max_length=100, null=True, verbose_name='Dirección:')), ('fecha_nacimiento', models.DateField(null=True, verbose_name='Cumpleaños:')), ('email', models.CharField(max_length=250, null=True, verbose_name='e-mail:')), ('fecha_creacion', models.DateTimeField(auto_now=True, verbose_name='Creacion:')), ('observacion', models.CharField(max_length=100, null=True, verbose_name='Observacion:')), ('estado', models.CharField(max_length=12, verbose_name='Estado:')), ('usuario', models.CharField(max_length=50, verbose_name='Usuario:')), ('password', models.CharField(max_length=50, verbose_name='Password:')), ], options={ 'verbose_name': 'Gerente', 'verbose_name_plural': 'Gerentes', 'ordering': ['id'], }, ), migrations.CreateModel( name='Mensajeria_sms', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('id_transaccion', models.CharField(max_length=15, null=True, verbose_name='id Transaccion:')), ('nro_envio', models.IntegerField(null=True, verbose_name='Nro Envio:')), ('tipo', models.CharField(max_length=15, null=True, verbose_name='tipo:')), ('texto', models.CharField(max_length=300, null=True, verbose_name='texto:')), ('tabla', models.CharField(max_length=50, null=True, verbose_name='tabla:')), ('celular', models.CharField(blank=True, max_length=15, null=True, verbose_name='cel')), ('estado', models.CharField(blank=True, max_length=20, null=True, verbose_name='estado')), ('fecha_op', models.DateField(null=True, verbose_name='Fecha Operacion:')), ('aux1', models.CharField(blank=True, max_length=20, null=True, verbose_name='aux1:')), ], options={ 'verbose_name': 'Mensaje SMS', 'verbose_name_plural': 'Mensajes SMS', 'ordering': ['id'], }, ), migrations.CreateModel( name='Mensajeria_sms_global', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('id_transaccion', models.CharField(max_length=15, null=True, verbose_name='id Transaccion:')), ('nro_envio', models.IntegerField(null=True, verbose_name='Nro Envio:')), ('tipo', models.CharField(max_length=15, null=True, verbose_name='tipo:')), ('texto', models.CharField(max_length=300, null=True, verbose_name='texto:')), ('tabla', models.CharField(max_length=50, null=True, verbose_name='tabla:')), ('celular', models.CharField(blank=True, max_length=15, null=True, verbose_name='cel')), ('estado', models.CharField(blank=True, max_length=20, null=True, verbose_name='estado')), ('fecha_op', models.DateField(null=True, verbose_name='Fecha Operacion:')), ('aux1', models.CharField(blank=True, max_length=20, null=True, verbose_name='aux1:')), ], options={ 'verbose_name': 'Mensaje SMS Global', 'verbose_name_plural': 'Mensajes SMS Global', 'ordering': ['id'], }, ), migrations.CreateModel( name='Notificacion', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('descripcion', models.CharField(max_length=100, verbose_name='Nombre Caja')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha actualizacion:')), ('usuario', models.CharField(max_length=25, verbose_name='Usuario')), ('permisos', models.CharField(max_length=20, verbose_name='Permisos')), ('estado', models.CharField(blank=True, max_length=20, null=True, verbose_name='estado')), ('archivo', models.FileField(upload_to=Main.models.get_upload_file_name)), ], options={ 'verbose_name': 'Notificacion', 'verbose_name_plural': 'Notificaciones', 'ordering': ['id'], }, ), migrations.CreateModel( name='Oficina', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('nombre_oficina', models.CharField(max_length=250, verbose_name='Nombre Oficina:')), ('ciudad', models.CharField(max_length=20, verbose_name='Ciudad:')), ('provincia', models.CharField(max_length=25, null=True, verbose_name='Provincia:')), ('distrito', models.CharField(max_length=25, null=True, verbose_name='Distrito:')), ('direccion', models.CharField(max_length=250, null=True, verbose_name='Dirección:')), ('descripcion', models.CharField(max_length=250, null=True, verbose_name='Descripción:')), ('observaciones', models.CharField(max_length=200, null=True, verbose_name='Observacion:')), ('estado_oficina', models.BooleanField(default=True, verbose_name='Estado')), ('categoria_oficina', models.CharField(max_length=20, null=True, verbose_name='Categoria')), ], options={ 'verbose_name': 'Oficina', 'verbose_name_plural': 'Oficinas', 'ordering': ['id'], }, ), migrations.CreateModel( name='Personal', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('dni', models.CharField(blank=True, max_length=8, null=True, verbose_name='DNI:')), ('nombre', models.CharField(blank=True, max_length=100, null=True, verbose_name='Nombres:')), ('Apellido_paterno', models.CharField(blank=True, max_length=200, null=True, verbose_name='Apellido Paterno:')), ('Apellido_materno', models.CharField(blank=True, max_length=200, null=True, verbose_name='Apellido Materno:')), ('telefono', models.CharField(blank=True, max_length=15, null=True, verbose_name='Teléfono:')), ('direccion', models.CharField(blank=True, max_length=100, null=True, verbose_name='Dirección:')), ('fecha_nacimiento', models.DateField(null=True, verbose_name='Cumpleaños:')), ('email', models.CharField(max_length=250, null=True, verbose_name='e-mail:')), ('cargo', models.CharField(max_length=20, null=True, verbose_name='Cargo:')), ('sueldo', models.DecimalField(decimal_places=2, default=0, max_digits=15, verbose_name='sueldo:')), ('fecha_contratacion', models.DateField(null=True, verbose_name='Contratacion:')), ('observacion', models.CharField(max_length=100, null=True, verbose_name='Observacion:')), ('estado', models.BooleanField(default=True, verbose_name='Estado:')), ('usuario', models.CharField(max_length=50, null=True, verbose_name='Usuario:')), ('password', models.CharField(max_length=50, null=True, verbose_name='Password:')), ], options={ 'verbose_name': 'Personal', 'verbose_name_plural': 'Personales', 'ordering': ['id'], }, ), migrations.CreateModel( name='TConfiguracionSistema', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id')), ('tipoSistema', models.CharField(blank=True, max_length=20, null=True, verbose_name='Tipo:')), ('cajaDolar', models.CharField(blank=True, max_length=10, null=True, verbose_name='CajaDolar:')), ('nroDecimales', models.IntegerField(blank=True, null=True, verbose_name='Nro Decimales:')), ('conf1', models.CharField(max_length=60, verbose_name='conf1:')), ('conf2', models.CharField(max_length=15, verbose_name='conf2:')), ('conf3', models.CharField(blank=True, max_length=3, null=True, verbose_name='conf3:')), ('compra_tactil', models.CharField(blank=True, max_length=3, null=True, verbose_name='compra tactil:')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id Caja:')), ('id_oficina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.oficina', verbose_name='Id Oficina:')), ], options={ 'verbose_name': 'Configuracion de sistema', 'verbose_name_plural': 'Configuraciones de sistema', 'ordering': ['id'], }, ), migrations.CreateModel( name='Solicitud_aut_comision', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('id_st', models.CharField(max_length=20, null=True, verbose_name='Id ST')), ('codigo_aut', models.CharField(max_length=10, null=True, verbose_name='Codigo:')), ('estado', models.CharField(max_length=20, verbose_name='Estado')), ('usuario_autorizador', models.CharField(max_length=20, null=True, verbose_name='Autorizacor')), ('id_usuario_aut', models.IntegerField(null=True, verbose_name='Id User Aut:')), ('fecha_aut', models.DateTimeField(null=True, verbose_name='Fecha Aut:')), ('fecha_desbloqueo', models.DateTimeField(null=True, verbose_name='Fecha Desbloqueo:')), ('fecha_creacion_st', models.DateTimeField(null=True, verbose_name='Fecha Creacion ST:')), ('id_oficina_des', models.CharField(max_length=10, null=True, verbose_name='Id Oficina Destino:')), ('obs', models.CharField(max_length=100, null=True, verbose_name='Obs:')), ('aux1', models.CharField(max_length=20, verbose_name='aux1:')), ('id_caja_solicitante', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id Caja:')), ('id_user_solicitante', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.personal', verbose_name='ID Personal')), ], options={ 'verbose_name': 'Solicitud de Aut Comi Trans', 'verbose_name_plural': 'Solicitudes de Autrizacion Comi Trans', 'ordering': ['id'], }, ), migrations.CreateModel( name='SesionesAbiertas', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('dispositivo', models.CharField(blank=True, max_length=150, null=True, verbose_name='Dispositivo:')), ('navegador', models.CharField(blank=True, max_length=150, null=True, verbose_name='Navegador:')), ('so', models.CharField(blank=True, max_length=100, null=True, verbose_name='Sistema Operativo:')), ('ipLocal', models.CharField(blank=True, max_length=20, null=True, verbose_name='IP:')), ('locacion', models.CharField(blank=True, max_length=250, null=True, verbose_name='Locación:')), ('fecha_sesion', models.DateTimeField(auto_now=True, verbose_name='Fecha Sesión:')), ('id_usuario', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.personal', verbose_name='Id:')), ], options={ 'verbose_name': 'Sesión Abierta', 'verbose_name_plural': 'Sesiones Abiertas', 'ordering': ['id'], }, ), migrations.CreateModel( name='saldo_sistema', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('saldo_soles', models.DecimalField(decimal_places=3, max_digits=15)), ('saldo_dolares', models.DecimalField(decimal_places=3, max_digits=15)), ('saldo_material', models.DecimalField(decimal_places=3, max_digits=15)), ('fechaActual', models.DateField(null=True, verbose_name='Fecha Actual:')), ('aux1', models.CharField(blank=True, max_length=20, null=True, verbose_name='aux1:')), ('aux2', models.CharField(blank=True, max_length=30, null=True, verbose_name='aux2:')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id:')), ], options={ 'verbose_name': 'Saldo Sistema', 'verbose_name_plural': 'Saldos Sistema', 'ordering': ['id'], }, ), migrations.CreateModel( name='ReinicioNroReciboCaja', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('u_nroRE', models.IntegerField(verbose_name='Nro Recibo Egreso:')), ('u_nroRI', models.IntegerField(verbose_name='Nro Recibo Ingreso:')), ('u_nroREM', models.IntegerField(verbose_name='Nro Recibo Egreso Material:')), ('u_nroRIM', models.IntegerField(verbose_name='Nro Recibo Ingreso Material:')), ('u_nroST', models.IntegerField(verbose_name='Nro Recibo Transferencia:')), ('u_nroPT', models.IntegerField(verbose_name='Nro Recibo Pago Transferencia:')), ('u_nroSI', models.IntegerField(verbose_name='Nro Recibo Intercambio:')), ('u_nroPI', models.IntegerField(verbose_name='Nro Recibo Pago Intercambio:')), ('aux1', models.CharField(blank=True, max_length=20, null=True, verbose_name='aux1:')), ('aux2', models.CharField(blank=True, max_length=30, null=True, verbose_name='aux2:')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id Caja:')), ('id_oficina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.oficina', verbose_name='Id Oficina:')), ], options={ 'verbose_name': 'Reinicio Número de Recibo Caja', 'verbose_name_plural': 'Reinicio Números de Recibos Cajas', 'ordering': ['id'], }, ), migrations.AddField( model_name='oficina', name='id_usuario', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.personal', verbose_name='Id:'), ), migrations.CreateModel( name='NroReciboCaja', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id')), ('nroRE', models.IntegerField(verbose_name='Nro Recibo Egreso:')), ('nroRI', models.IntegerField(verbose_name='Nro Recibo Ingreso:')), ('nroST', models.IntegerField(verbose_name='Nro Recibo Transferencia:')), ('nroPT', models.IntegerField(verbose_name='Nro Recibo Pago Transferencia:')), ('nroSI', models.IntegerField(verbose_name='Nro Recibo Intercambio:')), ('nroPI', models.IntegerField(verbose_name='Nro Recibo Pago Intercambio:')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id Caja:')), ('id_oficina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.oficina', verbose_name='Id Oficina:')), ], options={ 'verbose_name': 'Número de Recibo Caja', 'verbose_name_plural': 'Números de Recibos Cajas', 'ordering': ['id'], }, ), migrations.CreateModel( name='Log_EstadoCaja', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('descripcion', models.CharField(max_length=200, verbose_name='Descripción')), ('id_estadoCaja', models.CharField(max_length=20, null=True, verbose_name='id Estado Caja')), ('estado', models.CharField(max_length=30, verbose_name='Estado')), ('observaciones', models.CharField(max_length=200, null=True, verbose_name='Observaciones')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id:')), ], options={ 'verbose_name': 'Log estado de caja', 'verbose_name_plural': 'Logs estado de cajas', 'ordering': ['id'], }, ), migrations.CreateModel( name='HoraIngresoPersonal', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('fecha_ingreso', models.CharField(max_length=50, verbose_name='Fecha ingreso')), ('horaMora', models.CharField(max_length=20, verbose_name='Hora mora')), ('bloqueado', models.CharField(max_length=2, verbose_name='Bloqueo')), ('id_usuario', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.personal', verbose_name='Id:')), ], options={ 'verbose_name': 'Hora Ingreso', 'verbose_name_plural': 'Horas de Ingresos', 'ordering': ['id'], }, ), migrations.CreateModel( name='Gerente_conf', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Creacion:')), ('subGerente', models.CharField(blank=True, max_length=10, null=True, verbose_name='SubGerente')), ('observacion', models.CharField(max_length=100, null=True, verbose_name='Observacion:')), ('estado', models.CharField(max_length=12, verbose_name='Estado:')), ('telefono', models.CharField(blank=True, max_length=15, null=True, verbose_name='Teléfono:')), ('sueldo', models.DecimalField(decimal_places=2, default=0, max_digits=15, verbose_name='sueldo:')), ('aux1', models.CharField(blank=True, max_length=25, null=True, verbose_name='aux1')), ('aux2', models.CharField(blank=True, max_length=25, null=True, verbose_name='aux2')), ('id_gerente', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.gerente', verbose_name='Id:')), ], options={ 'verbose_name': 'Gerente configuracion', 'verbose_name_plural': 'Gerentes configuraciones', 'ordering': ['id'], }, ), migrations.AddField( model_name='gerente', name='id_usuario', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.personal', verbose_name='Id:'), ), migrations.CreateModel( name='Foto', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('estado', models.BooleanField(default=False, verbose_name='Estado:')), ('descripcion', models.CharField(max_length=50, null=True, verbose_name='Descripcion:')), ('titulo', models.CharField(max_length=50, null=True, verbose_name='Titulo:')), ('foto', models.FileField(upload_to=Main.models.get_upload_file_name)), ('id_usuario', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.personal', verbose_name='Id:')), ], options={ 'verbose_name': 'Foto', 'verbose_name_plural': 'Fotos', 'ordering': ['id'], }, ), migrations.CreateModel( name='EstadoValido_Caja', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('debe_soles', models.DecimalField(decimal_places=3, max_digits=15)), ('debe_dolares', models.DecimalField(decimal_places=3, max_digits=15)), ('haber_soles', models.DecimalField(decimal_places=3, max_digits=15)), ('haber_dolares', models.DecimalField(decimal_places=3, max_digits=15)), ('saldoI_soles', models.DecimalField(decimal_places=3, max_digits=15)), ('saldoI_dolares', models.DecimalField(decimal_places=3, max_digits=15)), ('saldo_soles', models.DecimalField(decimal_places=3, max_digits=15)), ('saldo_dolares', models.DecimalField(decimal_places=3, max_digits=15)), ('saldoCierre_soles', models.DecimalField(decimal_places=3, max_digits=15)), ('saldoCierre_dolares', models.DecimalField(decimal_places=3, max_digits=15)), ('estado', models.CharField(blank=True, max_length=20, null=True, verbose_name='estado:')), ('fechaDesde', models.DateField(null=True, verbose_name='Fecha desde:')), ('fechaHasta', models.DateField(null=True, verbose_name='Fecha hasta:')), ('aux1', models.CharField(blank=True, max_length=20, null=True, verbose_name='aux1:')), ('aux2', models.CharField(blank=True, max_length=30, null=True, verbose_name='aux2:')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id:')), ], options={ 'verbose_name': 'Estado Calido Cierre', 'verbose_name_plural': 'Estados Validos Cierre', 'ordering': ['id'], }, ), migrations.CreateModel( name='ConfiguracionExtra_caja', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('Prj_comicion_queda', models.DecimalField(decimal_places=2, max_digits=15, null=True, verbose_name='porcentaje:')), ('cierreObligatorio', models.CharField(blank=True, max_length=25, null=True, verbose_name='Cierre Obligatorio')), ('monto_tope', models.DecimalField(decimal_places=2, max_digits=15, verbose_name='Monto Tope:')), ('comision_minima', models.DecimalField(decimal_places=2, max_digits=15, null=True, verbose_name='Monto Pagado:')), ('otros_conceptos_minimo', models.DecimalField(decimal_places=2, max_digits=15, null=True, verbose_name='Monto Pagado:')), ('extorno_total', models.CharField(blank=True, max_length=25, null=True, verbose_name='Extorno Total')), ('ver_saldo', models.CharField(blank=True, max_length=25, null=True, verbose_name='Ver Saldo')), ('aux1', models.CharField(blank=True, max_length=25, null=True, verbose_name='ver saldo de oficinas')), ('aux2', models.CharField(blank=True, max_length=25, null=True, verbose_name='regiro en pt')), ('aux3', models.CharField(blank=True, max_length=25, null=True, verbose_name='egresar')), ('aux4', models.CharField(blank=True, max_length=25, null=True, verbose_name='autorizacion sobregiro')), ('aux5', models.CharField(blank=True, max_length=2, null=True, verbose_name='globales')), ('aux6', models.CharField(blank=True, max_length=2, null=True, verbose_name='autorizacion versaldos alternas')), ('aux7', models.CharField(blank=True, max_length=2, null=True, verbose_name='egreso subgerencia')), ('aux8', models.CharField(blank=True, max_length=2, null=True, verbose_name='pt sin validar dni')), ('cambioO', models.DecimalField(decimal_places=2, default=1, max_digits=15)), ('aux9', models.CharField(blank=True, max_length=2, null=True, verbose_name='filtarar todo desde reinicio de recibos')), ('aux10', models.CharField(blank=True, max_length=2, null=True, verbose_name='egreso en pt')), ('aux11', models.CharField(blank=True, max_length=2, null=True, verbose_name='ver intercambios recibidos')), ('monto_tope_st', models.DecimalField(decimal_places=2, default=0, max_digits=15)), ('egreso_hab', models.CharField(blank=True, max_length=2, null=True, verbose_name='Egreso Habilitaciones')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id:')), ('id_oficina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.oficina', verbose_name='Id:')), ], options={ 'verbose_name': 'config Caja', 'verbose_name_plural': 'config Caja', 'ordering': ['id'], }, ), migrations.CreateModel( name='Configuracion_comision_intercambio', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('montomin', models.DecimalField(decimal_places=2, max_digits=15)), ('montomax', models.DecimalField(decimal_places=2, max_digits=15)), ('comision', models.DecimalField(decimal_places=6, max_digits=15)), ('obs', models.CharField(blank=True, max_length=100, null=True, verbose_name='Observaciones')), ('auz1', models.CharField(blank=True, max_length=20, null=True, verbose_name='Aux1')), ('tipo', models.CharField(blank=True, max_length=20, null=True, verbose_name='tipo Config')), ('base_ori', models.CharField(blank=True, max_length=10, null=True, verbose_name='Base Origen')), ('base_des', models.CharField(blank=True, max_length=10, null=True, verbose_name='Base Destino')), ('id_caja', models.IntegerField(default=0)), ('id_config', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.configuracionextra_caja', verbose_name='Id:')), ('id_oficina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.oficina', verbose_name='Id:')), ], options={ 'verbose_name': 'Configuracion Comisiones Intercambio', 'verbose_name_plural': 'Configuraciones Comisiones Intercambio', 'ordering': ['id'], }, ), migrations.CreateModel( name='Configuracion_comision', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('montomin', models.DecimalField(decimal_places=2, max_digits=15)), ('montomax', models.DecimalField(decimal_places=2, max_digits=15)), ('comision', models.DecimalField(decimal_places=6, max_digits=15)), ('obs', models.CharField(blank=True, max_length=100, null=True, verbose_name='Observaciones')), ('auz1', models.CharField(blank=True, max_length=20, null=True, verbose_name='Aux1')), ('tipo', models.CharField(blank=True, max_length=20, null=True, verbose_name='tipo Config')), ('base_ori', models.CharField(blank=True, max_length=10, null=True, verbose_name='Base Origen')), ('base_des', models.CharField(blank=True, max_length=10, null=True, verbose_name='Base Destino')), ('id_caja', models.IntegerField(default=0)), ('banco_nacion', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ('otros_bancos', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ('continental', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ('bcp', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ('banco_nacion_de', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ('continental_de', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ('bcp_de', models.DecimalField(decimal_places=6, default=0, max_digits=15)), ('id_config', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.configuracionextra_caja', verbose_name='Id:')), ('id_oficina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.oficina', verbose_name='Id:')), ], options={ 'verbose_name': 'Configuracion Comisiones', 'verbose_name_plural': 'Configuraciones Comisiones', 'ordering': ['id'], }, ), migrations.CreateModel( name='conf_prj_arqueo', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('tipo_caja', models.CharField(max_length=2, verbose_name='Tipo de caja')), ('prj_caja', models.DecimalField(decimal_places=2, default=0, max_digits=15, verbose_name='porcentaje caja:')), ('prj_oficina_central', models.DecimalField(decimal_places=2, default=0, max_digits=15, verbose_name='porcentaje central:')), ('prj_otra_oficina', models.DecimalField(decimal_places=2, default=0, max_digits=15, verbose_name='porcentaje otra oficina:')), ('aux1', models.CharField(blank=True, max_length=25, null=True, verbose_name='aux1')), ('aux2', models.CharField(blank=True, max_length=25, null=True, verbose_name='aux2')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id:')), ('id_conf', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.conf_liquid_cajas', verbose_name='Id:')), ], options={ 'verbose_name': 'Configuracion arqueo caja', 'verbose_name_plural': 'Configuraciones de arqueo de cajas', 'ordering': ['id'], }, ), migrations.CreateModel( name='conf_permisos_Cajas', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('Trans_global', models.CharField(max_length=2, verbose_name='Transferencia Global')), ('Nrodias', models.IntegerField(null=True, verbose_name='Nro dias:')), ('aux1', models.CharField(blank=True, max_length=25, null=True, verbose_name='llave de transaccion')), ('aux2', models.CharField(blank=True, max_length=25, null=True, verbose_name='autorizacion retiro trans')), ('aux3', models.CharField(blank=True, max_length=25, null=True, verbose_name='autorizar permiso para autorizar retiro')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id:')), ], options={ 'verbose_name': 'Configuracion permiso caja', 'verbose_name_plural': 'Configuraciones permisos cajas', 'ordering': ['id'], }, ), migrations.CreateModel( name='conf_oficinas_para_TransGlobal', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('aux1', models.CharField(blank=True, max_length=25, null=True, verbose_name='aux1')), ('aux2', models.CharField(blank=True, max_length=25, null=True, verbose_name='aux2')), ('id_conf', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.conf_permisos_cajas', verbose_name='Id:')), ('id_oficina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.oficina', verbose_name='Id:')), ], options={ 'verbose_name': 'Oficina Transferencia Global', 'verbose_name_plural': 'oficinas Transferecnias Globales', 'ordering': ['id'], }, ), migrations.CreateModel( name='Codigo_desbloqueo_sistema', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('codigo_aut', models.CharField(max_length=10, null=True, verbose_name='Codigo:')), ('estado', models.CharField(max_length=20, verbose_name='Estado')), ('usuario_autorizador', models.CharField(max_length=20, null=True, verbose_name='Autorizacor')), ('id_usuario_aut', models.IntegerField(null=True, verbose_name='Id User Aut:')), ('fecha_aut', models.DateTimeField(null=True, verbose_name='Fecha Aut:')), ('fecha_desbloqueo', models.DateTimeField(null=True, verbose_name='Fecha Desbloqueo:')), ('obs', models.CharField(max_length=100, null=True, verbose_name='Obs:')), ('aux1', models.DecimalField(decimal_places=2, max_digits=15, null=True)), ('aux2', models.CharField(max_length=20, verbose_name='aux2:')), ('id_caja_solicitante', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id Caja:')), ('id_user_solicitante', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.personal', verbose_name='ID Personal')), ], options={ 'verbose_name': 'Codigo de Tardanza', 'verbose_name_plural': 'Codigos de Tardanzas', 'ordering': ['id'], }, ), migrations.AddField( model_name='cajas', name='id_oficina', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.oficina', verbose_name='Id:'), ), migrations.AddField( model_name='cajas', name='id_usuario', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.personal', verbose_name='Id:'), ), migrations.CreateModel( name='caja_independiente', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Fecha:')), ('independiente', models.CharField(max_length=20, verbose_name='Independiente')), ('aux1', models.CharField(blank=True, max_length=20, null=True, verbose_name='aux1:')), ('aux2', models.CharField(blank=True, max_length=30, null=True, verbose_name='aux2:')), ('id_caja', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.cajas', verbose_name='Id:')), ], options={ 'verbose_name': 'Caja Independiente', 'verbose_name_plural': 'Cajas Independientes', 'ordering': ['id'], }, ), migrations.CreateModel( name='Base_Ext', fields=[ ('id', models.AutoField(primary_key=True, serialize=False, verbose_name='Id:')), ('fecha', models.DateTimeField(auto_now=True, verbose_name='Creacion:')), ('nombre_base', models.CharField(max_length=250, verbose_name='Nombre Base:')), ('ciudad', models.CharField(max_length=20, null=True, verbose_name='Ciudad:')), ('direccion', models.CharField(max_length=250, null=True, verbose_name='Dirección:')), ('descripcion', models.CharField(max_length=250, null=True, verbose_name='Descripción:')), ('observaciones', models.CharField(max_length=200, null=True, verbose_name='Observacion:')), ('estado_base', models.BooleanField(default=True, verbose_name='Estado')), ('aux1', models.CharField(max_length=60, null=True, verbose_name='axu1:')), ('aux2', models.CharField(max_length=15, null=True, verbose_name='aux2:')), ('id_confSis', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Main.tconfiguracionsistema', verbose_name='Id:')), ], options={ 'verbose_name': 'Base', 'verbose_name_plural': 'Bases', 'ordering': ['id'], }, ), ]