# Generated by Django 4.1 on 2024-12-11 16:43 import datetime from django.conf import settings from django.db import migrations, models import django.db.models.deletion import django.utils.timezone class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='CabezeraImpresion', fields=[ ('cli_direccion', models.CharField(blank=True, max_length=255)), ('cli_nombre', models.CharField(blank=True, max_length=255)), ('cli_ruc', models.CharField(blank=True, max_length=20)), ('fac_banco', models.CharField(blank=True, max_length=255)), ('fac_direccion', models.CharField(blank=True, max_length=255)), ('fac_efectivo', models.CharField(blank=True, max_length=255)), ('fac_empresa', models.CharField(blank=True, max_length=255)), ('fac_fecha', models.CharField(blank=True, max_length=100)), ('fac_hora', models.CharField(blank=True, max_length=100)), ('fac_igvt', models.CharField(blank=True, max_length=255)), ('fac_ruc', models.CharField(blank=True, max_length=20)), ('fac_tarjeta', models.CharField(blank=True, max_length=255)), ('fac_total', models.CharField(blank=True, max_length=255)), ('fac_valorvta', models.CharField(blank=True, max_length=255)), ('idfactura', models.CharField(max_length=255, primary_key=True, serialize=False)), ('numero', models.CharField(blank=True, max_length=255)), ('serie', models.CharField(blank=True, max_length=255)), ('fac_personal', models.CharField(blank=True, max_length=255)), ('fac_exonerado', models.CharField(blank=True, max_length=255)), ('fac_inafecto', models.CharField(blank=True, max_length=255)), ], options={ 'managed': False, }, ), migrations.CreateModel( name='DetalleImpresion', fields=[ ('idfactura', models.CharField(max_length=255, primary_key=True, serialize=False)), ('det_cantidad', models.CharField(blank=True, max_length=255, null=True)), ('det_descripcion', models.CharField(blank=True, max_length=255, null=True)), ('det_impneto', models.CharField(blank=True, max_length=255, null=True)), ('det_preuni', models.CharField(blank=True, max_length=255, null=True)), ('det_moneda', models.CharField(blank=True, max_length=255, null=True)), ('det_unidad', models.CharField(blank=True, max_length=255, null=True)), ], options={ 'managed': False, }, ), migrations.CreateModel( name='Ajuste', fields=[ ('idajuste', models.AutoField(primary_key=True, serialize=False)), ('serie', models.CharField(blank=True, max_length=4, null=True)), ('numero', models.CharField(blank=True, max_length=8, null=True)), ('fecha', models.DateField(blank=True, null=True)), ('motivo', models.CharField(blank=True, max_length=4, null=True)), ('referencia', models.CharField(blank=True, max_length=40, null=True)), ('estado', models.CharField(blank=True, max_length=3, null=True)), ('moneda', models.CharField(blank=True, max_length=3, null=True)), ('tcambio', models.DecimalField(blank=True, decimal_places=3, max_digits=8, null=True)), ('tipo_ope', models.CharField(blank=True, max_length=2, null=True)), ('idsucur2', models.CharField(blank=True, max_length=5, null=True)), ('total', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('personalc_id', models.CharField(blank=True, max_length=5, null=True)), ('personalm_id', models.CharField(blank=True, max_length=5, null=True)), ('dtmodificacion', models.DateTimeField(auto_now=True, null=True)), ], options={ 'db_table': 'ajuste', }, ), migrations.CreateModel( name='Articulos', fields=[ ('idproduct', models.AutoField(primary_key=True, serialize=False)), ('codigo', models.CharField(max_length=30)), ('nombre', models.CharField(max_length=100)), ('modelo', models.CharField(blank=True, max_length=50, null=True)), ('marca', models.CharField(blank=True, max_length=25, null=True)), ('idprovee', models.CharField(blank=True, max_length=7, null=True)), ('codpro', models.CharField(blank=True, max_length=30, null=True)), ('pais', models.CharField(blank=True, max_length=20, null=True)), ('stockmini', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('stockmax', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('valvta', models.DecimalField(blank=True, decimal_places=6, max_digits=10, null=True)), ('moneda', models.CharField(blank=True, max_length=3, null=True)), ('tipo', models.CharField(default='ART', max_length=3)), ('moncosto', models.CharField(blank=True, max_length=3, null=True)), ('igv', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('costopro', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('ultcosto', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=10, null=True)), ('utilipor', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('tcambio', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('igvt', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('total', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('pesouni', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('stockmin', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('color', models.CharField(blank=True, max_length=20, null=True)), ('flete', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('otrocosto', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('tipo_exis', models.CharField(max_length=2)), ('otros', models.TextField(blank=True, null=True)), ('saldo00001', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=12)), ('saldo00002', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=12)), ('personalc_id', models.CharField(blank=True, max_length=5, null=True)), ('personalm_id', models.CharField(blank=True, max_length=5, null=True)), ('dtmodificacion', models.DateTimeField(auto_now=True, null=True)), ('s_image', models.BinaryField(blank=True, null=True)), ('n_image', models.BinaryField(blank=True, null=True)), ('codsunat', models.CharField(blank=True, max_length=20, null=True)), ('afectoigv', models.CharField(max_length=2)), ('codigo_fe', models.CharField(blank=True, max_length=20, null=True)), ('impto_cbp', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'articulos', }, ), migrations.CreateModel( name='BajaDocumento', fields=[ ('idb', models.AutoField(primary_key=True, serialize=False)), ('fechagen', models.DateField(blank=True, null=True)), ('fechacom', models.DateField(blank=True, null=True)), ('tipodoc', models.CharField(blank=True, max_length=2, null=True)), ('numerodoc', models.CharField(blank=True, max_length=13, null=True)), ('descrip', models.CharField(blank=True, max_length=100, null=True)), ('correlat', models.DecimalField(decimal_places=0, default=0, max_digits=3)), ('respuesta', models.TextField(blank=True, null=True)), ('serie', models.CharField(blank=True, max_length=4, null=True)), ('idfactura', models.IntegerField(blank=True, null=True)), ('texto', models.TextField(blank=True, null=True)), ], options={ 'db_table': 'bajadocumento', }, ), migrations.CreateModel( name='Banco', fields=[ ('cod_banco', models.CharField(max_length=3, primary_key=True, serialize=False)), ('nombre', models.CharField(max_length=35)), ], options={ 'db_table': 'banco_list', }, ), migrations.CreateModel( name='Catalogo03', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('codigo', models.CharField(blank=True, max_length=3, null=True)), ('original', models.CharField(blank=True, max_length=80, null=True)), ('descripcion', models.CharField(blank=True, max_length=80, null=True)), ], options={ 'db_table': 'catalogo03', }, ), migrations.CreateModel( name='Catalogo07', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('codigo', models.CharField(blank=True, max_length=2, null=True)), ('descrip', models.CharField(blank=True, max_length=133, null=True)), ], options={ 'db_table': 'catalogo07', }, ), migrations.CreateModel( name='Catalogo10', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('codigo', models.CharField(blank=True, max_length=3, null=True)), ('descripcion', models.CharField(blank=True, max_length=100, null=True)), ], options={ 'db_table': 'catalogo10', }, ), migrations.CreateModel( name='Catalogo17', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('codigo', models.CharField(blank=True, max_length=4, null=True)), ('descripcion', models.CharField(blank=True, max_length=100, null=True)), ], options={ 'db_table': 'catalogo17', }, ), migrations.CreateModel( name='Catalogo54', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('codigo', models.CharField(blank=True, max_length=3, null=True)), ('nombre', models.CharField(blank=True, max_length=100, null=True)), ('porcien', models.DecimalField(blank=True, decimal_places=2, max_digits=14, null=True)), ], options={ 'db_table': 'catalogo54', }, ), migrations.CreateModel( name='CatalogProduct', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('nombre', models.CharField(blank=True, max_length=150, null=True)), ('codigo', models.CharField(blank=True, max_length=20, null=True)), ], options={ 'db_table': 'caltlog_prod', }, ), migrations.CreateModel( name='Chofer', fields=[ ('idchofer', models.AutoField(primary_key=True, serialize=False)), ('nombre', models.CharField(max_length=100)), ('dni', models.CharField(max_length=8)), ('licencia', models.CharField(max_length=15)), ('tipo_doc', models.CharField(max_length=2)), ('apellidos', models.CharField(blank=True, max_length=100, null=True)), ('email', models.CharField(blank=True, max_length=150, null=True)), ], options={ 'db_table': 'choferes', }, ), migrations.CreateModel( name='Clientes', fields=[ ('idcliente1', models.CharField(blank=True, max_length=10, null=True)), ('apellidos', models.CharField(blank=True, max_length=100, null=True)), ('nombre', models.CharField(blank=True, max_length=150, null=True)), ('direccion', models.CharField(blank=True, max_length=100, null=True)), ('ruc', models.CharField(blank=True, max_length=11, null=True)), ('telefono', models.CharField(blank=True, max_length=40, null=True)), ('fax', models.CharField(blank=True, max_length=15, null=True)), ('distrito', models.CharField(blank=True, max_length=20, null=True)), ('region', models.CharField(blank=True, max_length=30, null=True)), ('pais', models.CharField(blank=True, max_length=30, null=True)), ('ctacli', models.CharField(blank=True, max_length=10, null=True)), ('email', models.CharField(blank=True, max_length=100, null=True)), ('email1', models.CharField(blank=True, max_length=100, null=True)), ('email2', models.CharField(blank=True, max_length=100, null=True)), ('documento', models.CharField(blank=True, max_length=16, null=True, unique=True)), ('actividad', models.CharField(blank=True, max_length=40, null=True)), ('notas', models.CharField(blank=True, max_length=40, null=True)), ('contacto', models.CharField(blank=True, max_length=40, null=True)), ('fecha_crea', models.DateField(blank=True, null=True)), ('idvende', models.CharField(blank=True, max_length=5, null=True)), ('creditomax', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('saldo_sol', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('idcliente', models.AutoField(primary_key=True, serialize=False)), ('tipodocide', models.CharField(blank=True, max_length=1, null=True)), ('personalc_id', models.CharField(blank=True, max_length=5, null=True)), ('personalm_id', models.CharField(blank=True, max_length=5, null=True)), ('dtmodificacion', models.DateTimeField(auto_now=True, null=True)), ('tip_iden', models.CharField(blank=True, max_length=1, null=True)), ('ubigeo', models.CharField(blank=True, max_length=6, null=True)), ('nomubigeo', models.CharField(blank=True, max_length=50, null=True)), ], options={ 'db_table': 'clientes', }, ), migrations.CreateModel( name='Compras', fields=[ ('idcompra1', models.CharField(blank=True, max_length=10, null=True)), ('documento', models.CharField(blank=True, max_length=4, null=True)), ('serie', models.CharField(blank=True, max_length=4, null=True)), ('numero', models.CharField(blank=True, max_length=8, null=True)), ('serdoc', models.CharField(blank=True, max_length=4, null=True)), ('numdoc', models.CharField(blank=True, max_length=8, null=True)), ('fecemi', models.DateField(blank=True, null=True)), ('fectra', models.DateField(blank=True, null=True)), ('fecven', models.DateField(blank=True, null=True)), ('feccan', models.DateField(blank=True, null=True)), ('estado', models.CharField(blank=True, max_length=3, null=True)), ('valorcom', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=11, null=True)), ('total', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=12, null=True)), ('igv', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=11, null=True)), ('tcambio', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=9, null=True)), ('moneda', models.CharField(blank=True, max_length=3, null=True)), ('pago', models.CharField(blank=True, max_length=3, null=True)), ('impbruto', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=10, null=True)), ('impren', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=10, null=True)), ('impes', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=10, null=True)), ('impneto', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=10, null=True)), ('mercad', models.CharField(blank=True, max_length=10, null=True)), ('referencia', models.CharField(blank=True, max_length=50, null=True)), ('transporte', models.CharField(blank=True, max_length=50, null=True)), ('transruc', models.CharField(blank=True, max_length=11, null=True)), ('fletefec', models.DateField(blank=True, null=True)), ('fletedoc', models.CharField(blank=True, max_length=4, null=True)), ('fletenum', models.CharField(blank=True, max_length=7, null=True)), ('fechaest', models.DateField(blank=True, null=True)), ('documest', models.CharField(blank=True, max_length=30, null=True)), ('motivo', models.CharField(blank=True, max_length=4, null=True)), ('reffecha', models.DateField(blank=True, null=True)), ('idorden', models.CharField(blank=True, max_length=9, null=True)), ('ordser', models.CharField(blank=True, max_length=3, null=True)), ('ordnum', models.CharField(blank=True, max_length=7, null=True)), ('afectoigv', models.CharField(blank=True, max_length=2, null=True)), ('documeng', models.CharField(blank=True, max_length=4, null=True)), ('serieg', models.CharField(blank=True, max_length=3, null=True)), ('numerog', models.CharField(blank=True, max_length=8, null=True)), ('observa', models.CharField(blank=True, max_length=50, null=True)), ('trp_valvta', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('trp_igv', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('fleteser', models.CharField(blank=True, max_length=4, null=True)), ('peso_total', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('costo_kilo', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('tipo_ope', models.CharField(blank=True, max_length=2, null=True)), ('fvcto', models.DateField(blank=True, null=True)), ('pedido_ser', models.CharField(blank=True, max_length=4, null=True)), ('pedido_num', models.CharField(blank=True, max_length=17, null=True)), ('mon_flete', models.CharField(blank=True, max_length=3, null=True)), ('cambioflet', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=9, null=True)), ('idcompra', models.AutoField(primary_key=True, serialize=False)), ('ncrdoc', models.CharField(blank=True, max_length=4, null=True)), ('ncrser', models.CharField(blank=True, max_length=3, null=True)), ('ncrnum', models.CharField(blank=True, max_length=8, null=True)), ('ncrfecha', models.DateField(blank=True, null=True)), ('ncrvalvta', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=12, null=True)), ('ncrigvt', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=12, null=True)), ('ncrtotal', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=12, null=True)), ('personalc_id', models.CharField(blank=True, max_length=5, null=True)), ('personalm_id', models.CharField(blank=True, max_length=5, null=True)), ('dtmodificacion', models.DateTimeField(auto_now=True, null=True)), ('percepcion', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('tasapercepcion', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('totalper', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('fec_depos', models.DateField(blank=True, null=True)), ('ciu_depos', models.CharField(blank=True, max_length=20, null=True)), ('tarjeta', models.CharField(blank=True, max_length=2, null=True)), ('voucher', models.CharField(blank=True, max_length=20, null=True)), ('tarjetachq', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('banco', models.CharField(blank=True, max_length=35, null=True)), ('cod_banco', models.CharField(blank=True, max_length=2, null=True)), ('porrenta', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('apagar', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('renta', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('nogravado', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=12, null=True)), ], options={ 'db_table': 'compras', }, ), migrations.CreateModel( name='Cotizacion', fields=[ ('atencion', models.CharField(blank=True, max_length=100, null=True)), ('validezdia', models.IntegerField(blank=True, null=True)), ('validezfec', models.DateField(blank=True, default=datetime.date.today, null=True)), ('entrega', models.CharField(blank=True, max_length=100, null=True)), ('nota', models.CharField(blank=True, max_length=100, null=True)), ('serie', models.CharField(blank=True, max_length=4, null=True)), ('numero', models.CharField(blank=True, max_length=8, null=True)), ('fecha', models.DateField(blank=True, default=datetime.date.today, null=True)), ('moneda', models.CharField(blank=True, max_length=3, null=True)), ('tcambio', models.DecimalField(blank=True, decimal_places=3, max_digits=7, null=True)), ('idvende', models.IntegerField(blank=True, null=True)), ('documen', models.CharField(blank=True, max_length=3, null=True)), ('clasepago', models.CharField(blank=True, max_length=3, null=True)), ('estado', models.CharField(blank=True, max_length=3, null=True)), ('descuadi', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('igv', models.DecimalField(blank=True, decimal_places=2, max_digits=7, null=True)), ('valorvta', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('igvt', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('total', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('impriglo', models.CharField(blank=True, max_length=1, null=True)), ('referencia', models.CharField(blank=True, max_length=40, null=True)), ('guia', models.CharField(blank=True, max_length=1, null=True)), ('apellidos', models.CharField(blank=True, max_length=100, null=True)), ('cdoc', models.CharField(blank=True, max_length=3, null=True)), ('cserie', models.CharField(blank=True, max_length=4, null=True)), ('cnumero', models.CharField(blank=True, max_length=8, null=True)), ('diasletras', models.DecimalField(blank=True, decimal_places=0, max_digits=3, null=True)), ('gastosfin', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('fvcto', models.DateField(blank=True, null=True)), ('hora', models.DateTimeField(blank=True, default=django.utils.timezone.now, null=True)), ('totalfactu', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('pedido', models.CharField(blank=True, max_length=20, null=True)), ('despacho', models.CharField(blank=True, max_length=10, null=True)), ('recibido', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('vuelto', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('direccion', models.CharField(blank=True, max_length=100, null=True)), ('banco', models.CharField(blank=True, max_length=35, null=True)), ('motivo', models.CharField(blank=True, max_length=4, null=True)), ('cfecha', models.DateField(blank=True, null=True)), ('cod_banco', models.CharField(blank=True, max_length=3, null=True)), ('autori_maq', models.CharField(blank=True, max_length=20, null=True)), ('cod_ope', models.CharField(blank=True, max_length=3, null=True)), ('impnogrv', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('idcotiza', models.AutoField(primary_key=True, serialize=False)), ('tipo_ope', models.CharField(blank=True, max_length=2, null=True)), ('fec_depos', models.DateField(blank=True, null=True)), ('ciu_depos', models.CharField(blank=True, max_length=20, null=True)), ('turno', models.CharField(blank=True, max_length=2, null=True)), ('totaldscto', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('tipoopera', models.CharField(blank=True, max_length=2, null=True)), ('impinafec', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('isct', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('cod_nota', models.CharField(blank=True, max_length=2, null=True)), ('motivonota', models.CharField(blank=True, max_length=100, null=True)), ('ciendscto', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('totgratui', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('ruc', models.CharField(blank=True, max_length=15, null=True)), ('tip_iden', models.CharField(blank=True, max_length=1, null=True)), ('texto', models.TextField(blank=True, null=True)), ('saldo', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=14, null=True)), ], options={ 'db_table': 'cotizacion', }, ), migrations.CreateModel( name='Detajuste', fields=[ ('cantidad', models.DecimalField(decimal_places=3, max_digits=15)), ('valunit', models.DecimalField(decimal_places=6, max_digits=12)), ('inven', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('inven_sald', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('item', models.DecimalField(decimal_places=0, max_digits=4)), ('texto', models.CharField(blank=True, max_length=50, null=True)), ('id_det', models.AutoField(primary_key=True, serialize=False)), ('total', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('personalc_id', models.CharField(blank=True, max_length=5, null=True)), ('personalm_id', models.CharField(blank=True, max_length=5, null=True)), ('dtmodificacion', models.DateTimeField(auto_now=True, null=True)), ], options={ 'db_table': 'detajuste', }, ), migrations.CreateModel( name='DetCajaIng', fields=[ ('iddet', models.AutoField(primary_key=True, serialize=False)), ('tipodoc', models.CharField(default=1, max_length=2)), ('apagar', models.DecimalField(blank=True, decimal_places=2, max_digits=14)), ('saldo', models.DecimalField(blank=True, decimal_places=2, max_digits=14)), ('nue_saldo', models.DecimalField(decimal_places=2, max_digits=14)), ], options={ 'db_table': 'detcajaing', }, ), migrations.CreateModel( name='Detcompra', fields=[ ('precio', models.DecimalField(blank=True, decimal_places=9, default=0, max_digits=14, null=True)), ('cantidad', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=9, null=True)), ('dcto1', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=6, null=True)), ('dcto2', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=6, null=True)), ('neto', models.DecimalField(blank=True, decimal_places=6, default=0, max_digits=10, null=True)), ('igv', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=7, null=True)), ('subtotal1', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('subtotal2', models.DecimalField(blank=True, decimal_places=3, default=0, max_digits=10, null=True)), ('atendida', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=8, null=True)), ('desped', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=7, null=True)), ('flete', models.DecimalField(blank=True, decimal_places=6, default=0, max_digits=14, null=True)), ('otros', models.DecimalField(blank=True, decimal_places=6, default=0, max_digits=14, null=True)), ('precioreal', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('canti_oc', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('saldo_oc', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('item', models.DecimalField(blank=True, decimal_places=0, default=0, max_digits=4, null=True)), ('igv_unit', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('afectoigv', models.CharField(blank=True, max_length=10, null=True)), ('serieoc', models.CharField(blank=True, max_length=3, null=True)), ('numerooc', models.CharField(blank=True, max_length=7, null=True)), ('idorden', models.CharField(blank=True, max_length=9, null=True)), ('texto', models.CharField(blank=True, max_length=50, null=True)), ('preciobrut', models.DecimalField(blank=True, decimal_places=6, default=0, max_digits=14, null=True)), ('id_det', models.AutoField(primary_key=True, serialize=False)), ('flet_subt', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('fl_sub_uni', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10, null=True)), ('notacredito', models.DecimalField(blank=True, decimal_places=6, default=0, max_digits=14, null=True)), ('personalc_id', models.CharField(blank=True, max_length=5, null=True)), ('personalm_id', models.CharField(blank=True, max_length=5, null=True)), ('dtmodificacion', models.DateTimeField(auto_now=True, null=True)), ], options={ 'db_table': 'detcompra', }, ), migrations.CreateModel( name='DetCotiza', fields=[ ('item', models.IntegerField(blank=True, null=True)), ('cantidad', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('valorunit', models.DecimalField(blank=True, decimal_places=8, max_digits=17, null=True)), ('descuento', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('igv', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)), ('descrip', models.CharField(blank=True, max_length=150, null=True)), ('impneto', models.DecimalField(blank=True, decimal_places=7, max_digits=17, null=True)), ('preuni', models.DecimalField(blank=True, decimal_places=6, max_digits=15, null=True)), ('unidad', models.CharField(blank=True, max_length=10, null=True)), ('unico', models.CharField(blank=True, max_length=3, null=True)), ('id_det', models.AutoField(primary_key=True, serialize=False)), ('totdscto', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('igvi', models.DecimalField(blank=True, decimal_places=8, max_digits=17, null=True)), ('afectoigv', models.CharField(blank=True, max_length=2, null=True)), ('montoisc', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('valgratui', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('impnetoct', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('dcto_valor', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('anticipodt', models.CharField(blank=True, max_length=10, null=True)), ('serie_docant', models.CharField(blank=True, max_length=4, null=True)), ('numerodocant', models.CharField(blank=True, max_length=8, null=True)), ], options={ 'db_table': 'detcotiza', }, ), migrations.CreateModel( name='Detfactu', fields=[ ('item', models.IntegerField(blank=True, null=True)), ('cantidad', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('valorunit', models.DecimalField(blank=True, decimal_places=8, max_digits=17, null=True)), ('descuento', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('igv', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)), ('descrip', models.CharField(blank=True, max_length=150, null=True)), ('impneto', models.DecimalField(blank=True, decimal_places=7, max_digits=17, null=True)), ('preuni', models.DecimalField(blank=True, decimal_places=6, max_digits=15, null=True)), ('unidad', models.CharField(blank=True, max_length=10, null=True)), ('unico', models.CharField(blank=True, max_length=3, null=True)), ('id_det', models.AutoField(primary_key=True, serialize=False)), ('totdscto', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('igvi', models.DecimalField(blank=True, decimal_places=8, max_digits=17, null=True)), ('afectoigv', models.CharField(blank=True, max_length=2, null=True)), ('montoisc', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('valgratui', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('impnetoct', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('dcto_valor', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('impto_cbp', models.IntegerField(blank=True, null=True)), ('icbp', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=12)), ('anticipodt', models.CharField(blank=True, max_length=10, null=True)), ('serie_docant', models.CharField(blank=True, max_length=4, null=True)), ('numerodocant', models.CharField(blank=True, max_length=8, null=True)), ], options={ 'db_table': 'detfactu', }, ), migrations.CreateModel( name='Detguia', fields=[ ('cantidad', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('descuen', models.DecimalField(blank=True, decimal_places=1, max_digits=2, null=True)), ('precio', models.DecimalField(blank=True, decimal_places=3, max_digits=8, null=True)), ('facturado', models.DecimalField(blank=True, decimal_places=2, max_digits=8, null=True)), ('texto', models.CharField(blank=True, max_length=100, null=True)), ('saldo', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('total', models.DecimalField(blank=True, decimal_places=3, max_digits=10, null=True)), ('igv', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)), ('pesototal', models.CharField(blank=True, max_length=10, null=True)), ('pesouni', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('unidad', models.CharField(blank=True, max_length=10, null=True)), ('item', models.DecimalField(blank=True, decimal_places=0, max_digits=4, null=True)), ('idfactura', models.IntegerField()), ('id_det', models.AutoField(primary_key=True, serialize=False)), ('personalc_id', models.CharField(blank=True, max_length=5, null=True)), ('personalm_id', models.CharField(blank=True, max_length=5, null=True)), ('dtmodificacion', models.DateTimeField(auto_now=True, null=True)), ], options={ 'db_table': 'detguia', }, ), migrations.CreateModel( name='DocCredito', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('estado', models.CharField(blank=True, default='EMI', max_length=3, null=True)), ('nrocuota', models.IntegerField(blank=True, null=True)), ('fechapgo', models.DateField(blank=True, null=True)), ('total', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ], options={ 'db_table': 'doc_credito', }, ), migrations.CreateModel( name='Docrelaci', fields=[ ('serie', models.CharField(blank=True, max_length=4, null=True)), ('numero', models.CharField(blank=True, max_length=27, null=True)), ('indicador', models.CharField(blank=True, max_length=1, null=True)), ('tipdocrela', models.CharField(blank=True, max_length=2, null=True)), ('tipdocemi', models.CharField(blank=True, max_length=1, null=True)), ('numemi', models.CharField(blank=True, max_length=12, null=True)), ('monto', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('iddocr', models.AutoField(primary_key=True, serialize=False)), ], options={ 'db_table': 'docrelaci', }, ), migrations.CreateModel( name='Empresa', fields=[ ('idempresa', models.AutoField(primary_key=True, serialize=False)), ('razonsocial', models.CharField(blank=True, max_length=100, null=True)), ('ruc', models.CharField(blank=True, max_length=11, null=True)), ('direccion', models.CharField(blank=True, max_length=150, null=True)), ('nombrecomercial', models.CharField(blank=True, max_length=100, null=True)), ('distrito', models.CharField(blank=True, max_length=50, null=True)), ('ciudad', models.CharField(blank=True, max_length=30, null=True)), ('telefono', models.CharField(blank=True, max_length=15, null=True)), ('fax', models.CharField(blank=True, max_length=15, null=True)), ('email', models.CharField(blank=True, max_length=50, null=True)), ('logotipo', models.CharField(blank=True, max_length=150, null=True)), ('dominio', models.CharField(blank=True, max_length=100, null=True)), ('codigofis', models.CharField(blank=True, max_length=3, null=True)), ('codigoubigeo', models.CharField(blank=True, max_length=6, null=True)), ('resolucion', models.CharField(blank=True, max_length=100, null=True)), ('current_sucursal_dir', models.CharField(blank=True, max_length=300, null=True)), ('dtr_bconac', models.CharField(blank=True, max_length=50, null=True)), ('logo', models.ImageField(blank=True, upload_to='logos/')), ('logo2', models.ImageField(blank=True, upload_to='logos/')), ('logo3', models.ImageField(blank=True, upload_to='logos/')), ('observacion', models.CharField(blank=True, max_length=100, null=True)), ('refran', models.CharField(blank=True, max_length=100, null=True)), ('banco', models.CharField(blank=True, max_length=100, null=True)), ('cuenta', models.CharField(blank=True, max_length=20, null=True)), ('cci', models.CharField(blank=True, max_length=30, null=True)), ], options={ 'db_table': 'empresa', }, ), migrations.CreateModel( name='Factura', fields=[ ('serie', models.CharField(blank=True, max_length=4, null=True)), ('numero', models.CharField(blank=True, max_length=8, null=True)), ('fecha', models.DateField(blank=True, default=datetime.date.today, null=True)), ('moneda', models.CharField(blank=True, max_length=3, null=True)), ('tcambio', models.DecimalField(blank=True, decimal_places=3, max_digits=7, null=True)), ('idvende', models.IntegerField(blank=True, null=True)), ('documen', models.CharField(blank=True, max_length=3, null=True)), ('clasepago', models.CharField(blank=True, max_length=3, null=True)), ('estado', models.CharField(blank=True, max_length=3, null=True)), ('descuadi', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('igv', models.DecimalField(blank=True, decimal_places=2, max_digits=7, null=True)), ('valorvta', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('igvt', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('total', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('impriglo', models.CharField(blank=True, max_length=1, null=True)), ('referencia', models.CharField(blank=True, max_length=40, null=True)), ('guia', models.CharField(blank=True, max_length=1, null=True)), ('apellidos', models.CharField(blank=True, max_length=100, null=True)), ('cdoc', models.CharField(blank=True, max_length=3, null=True)), ('cserie', models.CharField(blank=True, max_length=4, null=True)), ('cnumero', models.CharField(blank=True, max_length=8, null=True)), ('diasletras', models.DecimalField(blank=True, decimal_places=0, max_digits=3, null=True)), ('gastosfin', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('fvcto', models.DateField(blank=True, null=True)), ('hora', models.DateTimeField(blank=True, default=django.utils.timezone.now, null=True)), ('retporcien', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('tot_reten', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('totalfactu', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('pedido', models.CharField(blank=True, max_length=20, null=True)), ('despacho', models.CharField(blank=True, max_length=10, null=True)), ('recibido', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('vuelto', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('direccion', models.CharField(blank=True, max_length=100, null=True)), ('efectivo', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('tarjeta', models.CharField(blank=True, max_length=2, null=True)), ('tarjetachq', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=10)), ('voucher', models.CharField(blank=True, max_length=25, null=True)), ('banco', models.CharField(blank=True, max_length=35, null=True)), ('motivo', models.CharField(blank=True, max_length=4, null=True)), ('cfecha', models.DateField(blank=True, null=True)), ('cod_banco', models.CharField(blank=True, max_length=3, null=True)), ('autori_maq', models.CharField(blank=True, max_length=20, null=True)), ('cod_ope', models.CharField(blank=True, max_length=3, null=True)), ('impnogrv', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('idfactura', models.AutoField(primary_key=True, serialize=False)), ('tipo_ope', models.CharField(blank=True, max_length=2, null=True)), ('fec_depos', models.DateField(blank=True, null=True)), ('ciu_depos', models.CharField(blank=True, max_length=20, null=True)), ('turno', models.CharField(blank=True, max_length=2, null=True)), ('totaldscto', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('tipoopera', models.CharField(blank=True, max_length=2, null=True)), ('impinafec', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('isct', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('cod_nota', models.CharField(blank=True, max_length=2, null=True)), ('motivonota', models.CharField(blank=True, max_length=100, null=True)), ('ciendscto', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('totgratui', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('ruc', models.CharField(blank=True, max_length=15, null=True)), ('tip_iden', models.CharField(blank=True, max_length=1, null=True)), ('respuesta', models.TextField(blank=True, null=True)), ('texto', models.TextField(blank=True, null=True)), ('tot_icbp', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('dtr_cod_bien', models.CharField(blank=True, max_length=3, null=True)), ('dtr_porcien', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('dtr_monto', models.DecimalField(blank=True, decimal_places=2, max_digits=14, null=True)), ('dtr_mediopago', models.CharField(blank=True, max_length=3, null=True)), ('dtr_bconac', models.CharField(blank=True, max_length=20, null=True)), ('saldo', models.DecimalField(blank=True, decimal_places=2, default=0, max_digits=14, null=True)), ], options={ 'db_table': 'factura', }, ), migrations.CreateModel( name='GuiaCompra', fields=[ ('tipoguia', models.IntegerField(blank=True)), ('numero', models.CharField(max_length=8)), ('serie', models.CharField(max_length=4)), ('fecha', models.DateField()), ('importe', models.DecimalField(decimal_places=2, default=0, max_digits=12)), ('idcompra', models.IntegerField(default=0)), ('id', models.AutoField(primary_key=True, serialize=False)), ], options={ 'db_table': 'guiacompra', }, ), migrations.CreateModel( name='GuiaMotivo', fields=[ ('abrevia', models.CharField(max_length=4)), ('descrip', models.CharField(max_length=80)), ('id', models.AutoField(primary_key=True, serialize=False)), ('codigo', models.CharField(max_length=2)), ], options={ 'db_table': 'guiamot', }, ), migrations.CreateModel( name='Guiarem', fields=[ ('idguiar1', models.CharField(blank=True, max_length=10, null=True)), ('serie', models.CharField(blank=True, max_length=4, null=True)), ('numero', models.CharField(blank=True, max_length=8, null=True)), ('fecha', models.DateField(blank=True, null=True)), ('idvende', models.CharField(blank=True, max_length=5, null=True)), ('dirpartida', models.CharField(blank=True, max_length=50, null=True)), ('motivo', models.CharField(blank=True, max_length=4, null=True)), ('fectras', models.DateField(blank=True, null=True)), ('estado', models.CharField(blank=True, max_length=3, null=True)), ('serfac', models.CharField(blank=True, max_length=4, null=True)), ('sernum', models.CharField(blank=True, max_length=8, null=True)), ('igv', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)), ('tcambio', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)), ('dirptopar', models.CharField(blank=True, max_length=80, null=True)), ('dscto2', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)), ('fecfac', models.DateField(blank=True, null=True)), ('tipodoc', models.CharField(blank=True, max_length=2, null=True)), ('documen', models.CharField(blank=True, max_length=3, null=True)), ('material', models.CharField(blank=True, max_length=70, null=True)), ('costomin', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('moneda', models.CharField(blank=True, max_length=3, null=True)), ('pago', models.CharField(blank=True, max_length=3, null=True)), ('pidfactura', models.IntegerField(blank=True, null=True)), ('tra_confve', models.CharField(blank=True, max_length=15, null=True)), ('otromotivo', models.CharField(blank=True, max_length=30, null=True)), ('tra_pla', models.CharField(blank=True, max_length=40, null=True)), ('tra_cer', models.CharField(blank=True, max_length=30, null=True)), ('tra_lic', models.CharField(blank=True, max_length=15, null=True)), ('zona_field', models.CharField(blank=True, db_column='zona_', max_length=20, null=True)), ('dpto_field', models.CharField(blank=True, db_column='dpto_', max_length=20, null=True)), ('provin_field', models.CharField(blank=True, db_column='provin_', max_length=20, null=True)), ('chofer', models.CharField(blank=True, max_length=30, null=True)), ('dirllegada', models.CharField(blank=True, max_length=80, null=True)), ('choferdni', models.CharField(blank=True, max_length=12, null=True)), ('apellidos', models.CharField(blank=True, max_length=50, null=True)), ('tipo_ope', models.CharField(blank=True, max_length=2, null=True)), ('idsucur2', models.CharField(blank=True, max_length=5, null=True)), ('docum', models.CharField(blank=True, max_length=3, null=True)), ('idguiar', models.AutoField(primary_key=True, serialize=False)), ('zona_p', models.CharField(blank=True, max_length=20, null=True)), ('provin_p', models.CharField(blank=True, max_length=20, null=True)), ('dpto_p', models.CharField(blank=True, max_length=20, null=True)), ('razsoc_d', models.CharField(blank=True, max_length=50, null=True)), ('ruc_d', models.CharField(blank=True, max_length=11, null=True)), ('razsoc_c', models.CharField(blank=True, max_length=50, null=True)), ('ruc_c', models.CharField(blank=True, max_length=11, null=True)), ('pedidosap', models.CharField(blank=True, max_length=10, null=True)), ('personalc_id', models.CharField(blank=True, max_length=5, null=True)), ('personalm_id', models.CharField(blank=True, max_length=5, null=True)), ('dtmodificacion', models.DateTimeField(auto_now=True, null=True)), ('dni_d', models.CharField(blank=True, max_length=8, null=True)), ('unidad', models.CharField(blank=True, max_length=10, null=True)), ('cond_nombre', models.CharField(blank=True, max_length=100, null=True)), ('cond_apellido', models.CharField(blank=True, max_length=100, null=True)), ('licencia', models.CharField(blank=True, max_length=10, null=True)), ('cod_est_pto_par', models.CharField(blank=True, max_length=4, null=True)), ('cod_est_pto_lle', models.CharField(blank=True, max_length=4, null=True)), ('enlace_qr', models.TextField(blank=True, null=True)), ('enlace_xml', models.TextField(blank=True, null=True)), ('enlace_cdr', models.TextField(blank=True, null=True)), ('enlace_pdf', models.TextField(blank=True, null=True)), ('observa', models.CharField(blank=True, max_length=200, null=True)), ('ptopt_ubig', models.CharField(blank=True, max_length=6, null=True)), ('ptollg_ubig', models.CharField(blank=True, max_length=6, null=True)), ('ubigeopart', models.CharField(blank=True, max_length=100, null=True)), ('ubigeolleg', models.CharField(blank=True, max_length=100, null=True)), ('respuesta', models.TextField(blank=True, null=True)), ('text', models.TextField(blank=True, null=True)), ('pesobruto', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)), ('num_bulto', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('tipo_trans', models.CharField(blank=True, max_length=2, null=True)), ('conduct_nr', models.CharField(blank=True, max_length=11, null=True)), ('conduct_td', models.CharField(blank=True, max_length=11, null=True)), ('destinatario_denom', models.CharField(blank=True, max_length=150, null=True)), ('destinatario_tipo', models.CharField(blank=True, max_length=2, null=True)), ('destinatario_numero', models.CharField(blank=True, max_length=20, null=True)), ], options={ 'db_table': 'guiarem', }, ), migrations.CreateModel( name='Ingreso', fields=[ ('idingreso', models.AutoField(primary_key=True, serialize=False)), ('concepto', models.CharField(max_length=50)), ('total', models.DecimalField(decimal_places=2, max_digits=12)), ('fecha', models.DateField(blank=True, null=True)), ('hora', models.TimeField(blank=True, null=True)), ('estado', models.CharField(max_length=10)), ('moneda', models.CharField(blank=True, max_length=3, null=True)), ('tcambio', models.DecimalField(blank=True, decimal_places=3, max_digits=13, null=True)), ('cod_banco', models.CharField(blank=True, max_length=2, null=True)), ('voucher', models.CharField(blank=True, max_length=15, null=True)), ('importe', models.DecimalField(decimal_places=2, default=0, max_digits=14)), ('formapago', models.CharField(blank=True, max_length=4, null=True)), ], options={ 'db_table': 'ingreso', }, ), migrations.CreateModel( name='Lineas', fields=[ ('idclase', models.AutoField(primary_key=True, serialize=False)), ('nombre', models.CharField(blank=True, max_length=72, null=True)), ], options={ 'db_table': 'lineas', }, ), migrations.CreateModel( name='Monedas', fields=[ ('idmoneda', models.AutoField(primary_key=True, serialize=False)), ('simbolo', models.CharField(blank=True, max_length=3, null=True)), ('nombre', models.CharField(blank=True, max_length=30, null=True)), ('bandera', models.CharField(blank=True, max_length=100, null=True)), ('codigo', models.CharField(blank=True, max_length=3, null=True)), ], options={ 'db_table': 'monedas', }, ), migrations.CreateModel( name='Motivo', fields=[ ('idmotivo', models.AutoField(primary_key=True, serialize=False)), ('nombre', models.CharField(blank=True, max_length=55, null=True)), ('abrevia', models.CharField(blank=True, max_length=4, null=True)), ('clase', models.CharField(blank=True, max_length=3, null=True)), ], options={ 'db_table': 'motivo', }, ), migrations.CreateModel( name='Numero', fields=[ ('serie', models.CharField(max_length=4)), ('clasedoc', models.CharField(max_length=3)), ('ultimo', models.DecimalField(decimal_places=0, max_digits=8)), ('idnumero', models.AutoField(primary_key=True, serialize=False)), ], options={ 'db_table': 'numero', }, ), migrations.CreateModel( name='OtrasTasas', fields=[ ('idtasa', models.CharField(max_length=5, primary_key=True, serialize=False)), ('nombre', models.CharField(blank=True, max_length=30)), ('abrevia', models.CharField(blank=True, max_length=5)), ('porcien', models.DecimalField(blank=True, decimal_places=2, max_digits=8)), ], options={ 'db_table': 'otrastasas', }, ), migrations.CreateModel( name='Proveedor', fields=[ ('idprovee', models.AutoField(primary_key=True, serialize=False)), ('razonsocial', models.CharField(max_length=100)), ('direccion', models.CharField(blank=True, max_length=100, null=True)), ('ruc', models.CharField(max_length=11, unique=True)), ('telefono', models.CharField(blank=True, max_length=40, null=True)), ('contacto', models.CharField(blank=True, max_length=35, null=True)), ('nota', models.CharField(blank=True, max_length=30, null=True)), ('cuenta', models.CharField(blank=True, max_length=6, null=True)), ('email', models.CharField(blank=True, max_length=100, null=True)), ('actividad', models.CharField(blank=True, max_length=100, null=True)), ('distrito', models.CharField(blank=True, max_length=30, null=True)), ('dtmodificacion', models.DateTimeField(auto_now=True, null=True)), ('tip_iden', models.CharField(blank=True, max_length=1, null=True)), ('codubigeo', models.CharField(blank=True, max_length=6, null=True)), ], options={ 'db_table': 'proveedor', }, ), migrations.CreateModel( name='TarjetaCre', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('codigo', models.CharField(max_length=2)), ('nombre', models.CharField(max_length=60)), ('porcien', models.DecimalField(decimal_places=2, max_digits=4)), ], options={ 'db_table': 'tarjetacre', }, ), migrations.CreateModel( name='Tbl1_tipoope', fields=[ ('idtb', models.CharField(blank=True, max_length=2, primary_key=True, serialize=False)), ('nombre', models.CharField(blank=True, max_length=101, null=True)), ('codigo', models.CharField(blank=True, max_length=3, null=True)), ], options={ 'db_table': 'Tbl1_tipoope', }, ), migrations.CreateModel( name='Tbl2Tipdoc', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nombre', models.CharField(blank=True, max_length=50, null=True)), ('codigo', models.CharField(blank=True, max_length=2, null=True)), ], options={ 'db_table': 'tbl2_tipdoc', }, ), migrations.CreateModel( name='Tip_exitbl05', fields=[ ('descripcion', models.CharField(blank=True, max_length=50, null=True)), ('cod', models.CharField(blank=True, max_length=2, primary_key=True, serialize=False)), ], options={ 'db_table': 'tip_exitbl05', }, ), migrations.CreateModel( name='Tip_opetbl12', fields=[ ('cod', models.CharField(blank=True, max_length=2, primary_key=True, serialize=False)), ('descripcion', models.CharField(blank=True, max_length=50, null=True)), ], options={ 'db_table': 'tip_opetbl12', }, ), migrations.CreateModel( name='Transporte', fields=[ ('idtransporte', models.AutoField(primary_key=True, serialize=False)), ('razonsocial', models.CharField(max_length=60)), ('ruc', models.CharField(max_length=11)), ('direccion', models.CharField(max_length=150)), ('ciudad', models.CharField(blank=True, max_length=30, null=True)), ('provincia', models.CharField(max_length=50)), ('codpostal', models.CharField(blank=True, max_length=15, null=True)), ('region', models.CharField(max_length=50)), ('email', models.CharField(blank=True, max_length=150, null=True)), ('telefono', models.CharField(max_length=15)), ('fax', models.CharField(blank=True, max_length=15, null=True)), ('nacion', models.CharField(max_length=1)), ('nota', models.CharField(blank=True, max_length=50, null=True)), ('tipo_doc', models.CharField(max_length=2)), ], options={ 'db_table': 'transportes', }, ), migrations.CreateModel( name='Ubigeo', fields=[ ('id_ubi', models.CharField(max_length=100, primary_key=True, serialize=False)), ('descrip_ubigeo', models.CharField(blank=True, max_length=100, null=True)), ('id_prov', models.CharField(max_length=2)), ('descrip_prov', models.CharField(blank=True, max_length=100, null=True)), ('id_dep', models.CharField(max_length=2)), ('descrip_dep', models.CharField(max_length=100)), ], options={ 'db_table': 'ubigeo_peru', }, ), migrations.CreateModel( name='Unidades', fields=[ ('unidad', models.CharField(max_length=10, unique=True)), ('idunidad', models.AutoField(primary_key=True, serialize=False)), ('equivale', models.DecimalField(blank=True, decimal_places=5, max_digits=10, null=True)), ('codigo', models.CharField(blank=True, max_length=20, null=True)), ], options={ 'db_table': 'unidades', }, ), migrations.CreateModel( name='Vehiculo', fields=[ ('idvehiculo', models.AutoField(primary_key=True, serialize=False)), ('placa', models.CharField(max_length=50)), ('certifica', models.CharField(max_length=30)), ('confvehi', models.CharField(max_length=15)), ('color', models.CharField(blank=True, max_length=50, null=True)), ('anio', models.CharField(max_length=4)), ], options={ 'db_table': 'vehiculo', }, ), migrations.CreateModel( name='Zonas', fields=[ ('idzona', models.CharField(max_length=2, primary_key=True, serialize=False)), ('descripcion', models.CharField(blank=True, max_length=25, null=True)), ('otro', models.CharField(blank=True, max_length=15, null=True)), ], options={ 'db_table': 'zonas', }, ), migrations.CreateModel( name='Sucursal', fields=[ ('idsucursal', models.AutoField(primary_key=True, serialize=False)), ('nombre', models.CharField(blank=True, max_length=20, null=True)), ('direccion', models.CharField(blank=True, max_length=70, null=True)), ('region', models.CharField(blank=True, max_length=30, null=True)), ('telefono', models.CharField(blank=True, max_length=15, null=True)), ('fax', models.CharField(blank=True, max_length=15, null=True)), ('email', models.CharField(blank=True, max_length=40, null=True)), ('token', models.CharField(blank=True, max_length=200, null=True)), ('ruta', models.CharField(blank=True, max_length=200, null=True)), ('notas', models.CharField(blank=True, max_length=20, null=True)), ('tam_boleta', models.CharField(blank=True, max_length=8, null=True)), ('tam_factura', models.CharField(blank=True, max_length=8, null=True)), ('tam_pedido', models.CharField(blank=True, max_length=8, null=True)), ('empresa', models.ForeignKey(default=1, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.empresa')), ], options={ 'db_table': 'sucursal', }, ), migrations.CreateModel( name='Subclase', fields=[ ('idsubcla', models.AutoField(primary_key=True, serialize=False)), ('nombre', models.CharField(max_length=72)), ('inventario', models.CharField(blank=True, max_length=1, null=True)), ('idclase', models.ForeignKey(db_column='idclase', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.lineas')), ], options={ 'db_table': 'subclase', }, ), migrations.CreateModel( name='Ssgrupo', fields=[ ('idgrupo', models.AutoField(primary_key=True, serialize=False)), ('nombre', models.CharField(blank=True, max_length=80, null=True)), ('inventario', models.CharField(blank=True, max_length=1, null=True)), ('idclase', models.ForeignKey(db_column='idclase', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.subclase')), ], options={ 'db_table': 'ssgrupo', }, ), migrations.CreateModel( name='Precios', fields=[ ('igv', models.DecimalField(decimal_places=2, default=18.0, max_digits=8)), ('valvta', models.DecimalField(decimal_places=6, default=1.0, max_digits=15)), ('impuesto', models.DecimalField(decimal_places=6, max_digits=10)), ('preventa', models.DecimalField(decimal_places=6, default=1.0, max_digits=12)), ('idzona', models.CharField(default='1', max_length=2)), ('personalc_id', models.CharField(blank=True, max_length=5, null=True)), ('personalm_id', models.CharField(blank=True, max_length=5, null=True)), ('dtmodificacion', models.DateTimeField(auto_now=True, null=True)), ('codbar', models.CharField(blank=True, max_length=20, null=True)), ('idprecio', models.AutoField(primary_key=True, serialize=False)), ('idproduct', models.ForeignKey(db_column='idproduct', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.articulos')), ('moneda', models.ForeignKey(db_column='moneda', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.monedas')), ('unidad', models.ForeignKey(db_column='unidad', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.unidades')), ], options={ 'db_table': 'precios', }, ), migrations.CreateModel( name='Personal', fields=[ ('idpersonal', models.AutoField(primary_key=True, serialize=False)), ('nombre', models.CharField(blank=True, max_length=40, null=True)), ('direccion', models.CharField(blank=True, max_length=40, null=True)), ('tipodocumento', models.CharField(blank=True, max_length=1, null=True)), ('documento', models.CharField(blank=True, max_length=20, null=True)), ('fecha_ingreso', models.DateField(blank=True, default=django.utils.timezone.now, null=True)), ('notas', models.CharField(blank=True, max_length=50, null=True)), ('cargo', models.CharField(blank=True, max_length=3, null=True)), ('celular', models.CharField(blank=True, max_length=15, null=True)), ('activo', models.CharField(blank=True, default='1', max_length=1, null=True)), ('idsucursal', models.ForeignKey(blank=True, default=1, null=True, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.sucursal')), ('idusuario', models.OneToOneField(default=1, on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'personal', }, ), migrations.AddConstraint( model_name='numero', constraint=models.UniqueConstraint(fields=('serie', 'clasedoc'), name='numero_idx'), ), migrations.AddField( model_name='ingreso', name='idcliente', field=models.ForeignKey(db_column='idcliente', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.clientes'), ), migrations.AddField( model_name='ingreso', name='idsucursal', field=models.ForeignKey(db_column='idsucursal', default=1, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.sucursal'), ), migrations.AddField( model_name='guiarem', name='idcliente', field=models.ForeignKey(db_column='idcliente', null=True, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.clientes'), ), migrations.AddField( model_name='guiarem', name='idsucursal', field=models.ForeignKey(db_column='idsucursal', null=True, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.sucursal'), ), migrations.AddField( model_name='guiarem', name='idtrans', field=models.ForeignKey(db_column='idtrans', null=True, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.transporte'), ), migrations.AddField( model_name='factura', name='idcliente', field=models.ForeignKey(blank=True, db_column='idcliente', null=True, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.clientes'), ), migrations.AddField( model_name='factura', name='idsucursal', field=models.ForeignKey(db_column='idsucursal', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.sucursal'), ), migrations.AddField( model_name='docrelaci', name='idfactura', field=models.ForeignKey(blank=True, db_column='idfactura', null=True, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.factura'), ), migrations.AddField( model_name='doccredito', name='idfactura', field=models.ForeignKey(blank=True, db_column='idfactura', null=True, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.factura'), ), migrations.AddField( model_name='detguia', name='idguiar', field=models.ForeignKey(blank=True, db_column='idguiar', null=True, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.guiarem'), ), migrations.AddField( model_name='detguia', name='idproduct', field=models.ForeignKey(blank=True, db_column='idproduct', null=True, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.articulos'), ), migrations.AddField( model_name='detfactu', name='idfactura', field=models.ForeignKey(db_column='idfactura', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.factura'), ), migrations.AddField( model_name='detfactu', name='idproduct', field=models.ForeignKey(db_column='idproduct', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.articulos'), ), migrations.AddField( model_name='detcotiza', name='idcotiza', field=models.ForeignKey(db_column='idfactura', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.factura'), ), migrations.AddField( model_name='detcotiza', name='idproduct', field=models.ForeignKey(db_column='idproduct', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.articulos'), ), migrations.AddField( model_name='detcompra', name='idcompra', field=models.ForeignKey(db_column='idcompra', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.compras'), ), migrations.AddField( model_name='detcompra', name='idproduct', field=models.ForeignKey(db_column='idproduct', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.articulos'), ), migrations.AddField( model_name='detcajaing', name='idfactura', field=models.ForeignKey(db_column='idfactura', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.factura'), ), migrations.AddField( model_name='detcajaing', name='idingreso', field=models.ForeignKey(db_column='idingreso', on_delete=django.db.models.deletion.CASCADE, to='app_venin_web_new1.ingreso'), ), migrations.AddField( model_name='detajuste', name='idajuste', field=models.ForeignKey(db_column='idajuste', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.ajuste'), ), migrations.AddField( model_name='detajuste', name='idproduct', field=models.ForeignKey(db_column='idproduct', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.articulos'), ), migrations.AddField( model_name='cotizacion', name='idcliente', field=models.ForeignKey(blank=True, db_column='idcliente', null=True, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.clientes'), ), migrations.AddField( model_name='cotizacion', name='idsucursal', field=models.ForeignKey(db_column='idsucursal', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.sucursal'), ), migrations.AddField( model_name='compras', name='idprovee', field=models.ForeignKey(db_column='idprovee', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.proveedor'), ), migrations.AddField( model_name='compras', name='idsucursal', field=models.ForeignKey(db_column='idsucursal', default=1, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.sucursal'), ), migrations.AddField( model_name='chofer', name='idvehiculo', field=models.ForeignKey(db_column='idvehiculo', on_delete=django.db.models.deletion.CASCADE, to='app_venin_web_new1.vehiculo'), ), migrations.AddConstraint( model_name='banco', constraint=models.UniqueConstraint(fields=('cod_banco',), name='banco_list_pkey'), ), migrations.AddField( model_name='articulos', name='clase3', field=models.ForeignKey(db_column='idgrupo', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.ssgrupo'), ), migrations.AddField( model_name='articulos', name='idclase', field=models.ForeignKey(db_column='idclase', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.lineas'), ), migrations.AddField( model_name='articulos', name='idsubcla', field=models.ForeignKey(db_column='idsubcla', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.subclase'), ), migrations.AddField( model_name='articulos', name='unidad', field=models.ForeignKey(db_column='unidad', on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.unidades'), ), migrations.AddField( model_name='ajuste', name='idsucursal', field=models.ForeignKey(db_column='idsucursal', default=1, on_delete=django.db.models.deletion.PROTECT, to='app_venin_web_new1.sucursal'), ), ]