# Generated by Django 2.0.2 on 2018-07-25 23:32

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('cadastro', '0003_auto_20180507_1734'),
    ]

    operations = [
        migrations.CreateModel(
            name='Fiscal',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('mes', models.IntegerField(choices=[(1, '01'), (2, '02'), (3, '03'), (4, '04'), (5, '05'), (6, '06'), (7, '07'), (8, '08'), (9, '09'), (10, '11'), (12, '12')], verbose_name='Mês')),
                ('ano', models.IntegerField(choices=[(1, '2018'), (2, '2019'), (3, '2020'), (4, '2021'), (5, '2022')], verbose_name='Ano')),
                ('planilha', models.FileField(max_length=200, upload_to='uploads/%d/%m/%Y/')),
                ('data_envio', models.DateTimeField(auto_now_add=True)),
                ('empresa', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cadastro.Empresa')),
            ],
        ),
        migrations.CreateModel(
            name='Nota',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('numero_nota', models.PositiveIntegerField(verbose_name='Número_nota')),
                ('dt_Escritur', models.DateField(verbose_name='Dt. Escrituração')),
                ('serie', models.CharField(max_length=3, verbose_name='Série')),
                ('cfop', models.IntegerField(verbose_name='CFOP')),
                ('cnpj', models.CharField(max_length=14, verbose_name='CNPJ/CPF')),
                ('uf', models.CharField(max_length=2, verbose_name='UF')),
                ('especie', models.CharField(max_length=2, verbose_name='Espécie')),
                ('desd', models.CharField(max_length=2, verbose_name='desd.')),
                ('codigo_Produto', models.CharField(max_length=2, verbose_name='Cod. Produto')),
                ('numero_Item', models.CharField(max_length=2, verbose_name='Num. Item')),
                ('ncm', models.CharField(max_length=2, verbose_name='NCM')),
                ('cst', models.CharField(max_length=2, verbose_name='CST')),
                ('quantidade', models.DecimalField(decimal_places=4, max_digits=14, verbose_name='Quantidade')),
                ('preco_un', models.DecimalField(decimal_places=6, max_digits=14, verbose_name='Preco_un')),
                ('desconto', models.DecimalField(decimal_places=2, max_digits=14, verbose_name='Vl. Desconto')),
                ('valor_liquido', models.DecimalField(decimal_places=2, max_digits=14, verbose_name='Vl. Liquido')),
                ('despesas', models.DecimalField(decimal_places=2, max_digits=14, verbose_name='Vl. Despesas')),
                ('codigo_ctb', models.CharField(max_length=5, verbose_name='Cod. CTB')),
                ('frete', models.DecimalField(decimal_places=2, max_digits=14, verbose_name='Vl. Frete')),
                ('seguro', models.DecimalField(decimal_places=2, max_digits=14, verbose_name='Vl. Seguro')),
                ('numero_di', models.CharField(max_length=10, verbose_name='Num DI')),
                ('data_di', models.DateField(verbose_name='Data_DI')),
                ('di_simplificadora', models.CharField(max_length=3, verbose_name='DI Simplificadora')),
                ('mov_fisica', models.CharField(max_length=3, verbose_name='Mov. Física')),
                ('cst_pis', models.CharField(max_length=2, verbose_name='CST_PIS')),
                ('cst_cofins', models.CharField(max_length=2, verbose_name='CST_COFINS')),
                ('natureza_receita', models.CharField(max_length=3, verbose_name='Nat. Receita')),
                ('cod_contr_social', models.CharField(max_length=1, verbose_name='Cod. Contr Social')),
                ('ind_tipo_cred_soc', models.CharField(max_length=1, verbose_name='Ind. Tipo Cred.')),
                ('codigo_bc_credito', models.CharField(max_length=1, verbose_name='Cod. BC Crédito')),
                ('nat_frete', models.CharField(max_length=2, verbose_name='Nat. Frete')),
                ('valor_receita', models.DecimalField(decimal_places=2, max_digits=14, verbose_name='Vl. Receita')),
                ('valor_pis', models.DecimalField(decimal_places=2, max_digits=14, verbose_name='Vl. Pis')),
                ('valor_cofins', models.DecimalField(decimal_places=2, max_digits=14, verbose_name='Vl. Cofins')),
                ('valor_bc_pis_cofins', models.DecimalField(decimal_places=2, max_digits=14, verbose_name='Vl. BC Pis_Cofins')),
                ('aliquota_pis', models.DecimalField(decimal_places=2, max_digits=5, verbose_name='Alíquota Pis')),
                ('aliquota_cofins', models.DecimalField(decimal_places=2, max_digits=5, verbose_name='Alíquota Cofins')),
                ('valor_bc_qtde', models.DecimalField(decimal_places=2, max_digits=14)),
                ('aliq_pis_vlr', models.DecimalField(decimal_places=2, max_digits=5)),
                ('aliq_cofins_vlr', models.DecimalField(decimal_places=2, max_digits=5)),
                ('pis_pago', models.DecimalField(decimal_places=2, max_digits=14)),
                ('cofins_pago', models.DecimalField(decimal_places=2, max_digits=14)),
                ('drawback', models.CharField(max_length=3)),
                ('bc_difal', models.DecimalField(decimal_places=2, max_digits=14)),
                ('aliquota_fcp', models.DecimalField(decimal_places=2, max_digits=5)),
                ('aliquota_interna_uf_destino', models.DecimalField(decimal_places=2, max_digits=5)),
                ('aliquota_interestadual', models.DecimalField(decimal_places=2, max_digits=5)),
                ('partilha_uf_destino_perc', models.DecimalField(decimal_places=2, max_digits=5)),
                ('icms_fcp_uf_destino', models.DecimalField(decimal_places=2, max_digits=14)),
                ('icms_uf_destino', models.DecimalField(decimal_places=2, max_digits=14)),
                ('icms_uf_origem', models.DecimalField(decimal_places=2, max_digits=14)),
                ('bc_icms', models.DecimalField(decimal_places=2, max_digits=14)),
                ('aliquota_icms', models.DecimalField(decimal_places=2, max_digits=5)),
                ('valor_icms', models.DecimalField(decimal_places=2, max_digits=14)),
                ('isentas_icms', models.DecimalField(decimal_places=2, max_digits=14)),
                ('outras_icms', models.DecimalField(decimal_places=2, max_digits=14)),
                ('icms_desonerado', models.DecimalField(decimal_places=2, max_digits=14)),
                ('bc_subst_tribut', models.DecimalField(decimal_places=2, max_digits=14)),
                ('aliq_sub_trib', models.DecimalField(decimal_places=2, max_digits=5)),
                ('icms_subst_tribut', models.DecimalField(decimal_places=2, max_digits=14)),
                ('cest', models.CharField(max_length=8)),
                ('cst_ipi', models.CharField(max_length=2)),
                ('bc_ipi', models.DecimalField(decimal_places=2, max_digits=14)),
                ('aliquota_ipi', models.DecimalField(decimal_places=2, max_digits=5)),
                ('valor_ipi', models.DecimalField(decimal_places=2, max_digits=14)),
                ('isentas_ipi', models.DecimalField(decimal_places=2, max_digits=14)),
                ('outras_ipi', models.DecimalField(decimal_places=2, max_digits=14)),
                ('ipi_nao_creditado', models.DecimalField(decimal_places=2, max_digits=14)),
                ('ipi_creditado_50', models.DecimalField(decimal_places=2, max_digits=14)),
                ('empresa', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cadastro.Empresa')),
            ],
        ),
    ]
