# Generated by Django 2.0 on 2018-12-19 18:49

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


class Migration(migrations.Migration):

    dependencies = [
        ('home', '0053_auto_20181220_0031'),
    ]

    operations = [
        migrations.CreateModel(
            name='InventorySn',
            fields=[
                ('sn', models.IntegerField(primary_key=True, serialize=False)),
            ],
        ),
        migrations.CreateModel(
            name='PrePayments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('dueDate', models.DateField(blank=True, null=True)),
                ('advance', models.FloatField()),
                ('lcNumberValue', models.CharField(max_length=255)),
                ('lcIssuingBank', models.CharField(max_length=255)),
                ('advanceFromBuyers', models.FloatField()),
                ('advanceToSellers', models.FloatField()),
                ('receivedDate', models.CharField(max_length=255)),
                ('paidDate', models.CharField(max_length=255)),
                ('lcExpiryDate', models.CharField(max_length=255)),
            ],
        ),
        migrations.CreateModel(
            name='Products',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255)),
                ('balanceqty', models.FloatField()),
                ('inventoryvalue', models.FloatField()),
            ],
        ),
        migrations.CreateModel(
            name='SaveInventory',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sn', models.IntegerField()),
                ('entrydate', models.CharField(max_length=255)),
                ('godowndate', models.CharField(max_length=255)),
                ('trn', models.CharField(max_length=255)),
                ('product', models.CharField(max_length=255)),
                ('trd', models.CharField(max_length=255)),
                ('supplier', models.CharField(max_length=255)),
                ('qtyin', models.FloatField()),
                ('qtyout', models.FloatField()),
                ('incoterm', models.CharField(max_length=255)),
                ('expense', models.FloatField()),
                ('net', models.FloatField()),
                ('oldbalqtyvalue', models.FloatField()),
                ('balanceqty', models.FloatField()),
                ('unit', models.CharField(max_length=255)),
                ('godownlocation', models.CharField(max_length=255)),
                ('oldinventoryvalue', models.FloatField()),
                ('inventoryvalue', models.FloatField()),
            ],
        ),
        migrations.CreateModel(
            name='SnCount',
            fields=[
                ('sn', models.IntegerField(primary_key=True, serialize=False)),
            ],
        ),
        migrations.CreateModel(
            name='SnStock',
            fields=[
                ('sn', models.IntegerField(primary_key=True, serialize=False)),
            ],
        ),
        migrations.CreateModel(
            name='StockJournal',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sn', models.IntegerField()),
                ('stockno', models.IntegerField()),
                ('stockdate', models.CharField(max_length=255)),
                ('c_product1', models.CharField(max_length=255)),
                ('c_qty1', models.CharField(max_length=25)),
                ('c_unit1', models.CharField(max_length=25)),
                ('c_altqty1', models.CharField(max_length=25)),
                ('c_altunit1', models.CharField(max_length=25)),
                ('c_product2', models.CharField(max_length=255)),
                ('c_qty2', models.CharField(max_length=25)),
                ('c_unit2', models.CharField(max_length=25)),
                ('c_altqty2', models.CharField(max_length=25)),
                ('c_altunit2', models.CharField(max_length=25)),
                ('c_product3', models.CharField(max_length=255)),
                ('c_qty3', models.CharField(max_length=25)),
                ('c_unit3', models.CharField(max_length=25)),
                ('c_altqty3', models.CharField(max_length=25)),
                ('c_altunit3', models.CharField(max_length=25)),
                ('p_product', models.CharField(max_length=255)),
                ('p_qty', models.CharField(max_length=25)),
                ('p_unit', models.CharField(max_length=25)),
                ('p_altqty', models.CharField(max_length=25)),
                ('p_altunit', models.CharField(max_length=25)),
                ('warehouse', models.CharField(max_length=255)),
                ('purpose', models.CharField(max_length=255)),
            ],
        ),
        migrations.CreateModel(
            name='StockNo',
            fields=[
                ('number', models.IntegerField(primary_key=True, serialize=False)),
            ],
        ),
        migrations.CreateModel(
            name='TradeApproval',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sn', models.IntegerField()),
                ('company', models.CharField(max_length=255)),
                ('trd', models.DateField(blank=True, null=True)),
                ('trn', models.CharField(max_length=255)),
                ('types', models.CharField(max_length=255)),
                ('product', models.CharField(max_length=255)),
                ('origin', models.CharField(max_length=255)),
                ('client', models.CharField(max_length=255)),
                ('address', models.CharField(max_length=255)),
                ('tad', models.DateField(blank=True, null=True)),
                ('trade_status', models.CharField(max_length=255)),
                ('tcq', models.CharField(max_length=255)),
                ('contractUnit', models.CharField(max_length=255)),
                ('tolerance', models.CharField(max_length=255)),
                ('packing', models.CharField(max_length=255)),
                ('tuq', models.CharField(max_length=255)),
                ('tuqUnit', models.CharField(max_length=255)),
                ('contractBalanceQty', models.CharField(max_length=255)),
                ('contractBalanceUnit', models.CharField(max_length=255)),
                ('ratePMT', models.CharField(max_length=255)),
                ('commissionAgent', models.CharField(max_length=255)),
                ('commissionRate', models.CharField(max_length=255)),
                ('logisticProvider', models.CharField(max_length=255)),
                ('estimatedLogisticsCost', models.CharField(max_length=255)),
                ('paymentTerm', models.CharField(max_length=255)),
                ('incoterm', models.CharField(max_length=255)),
                ('pol', models.CharField(max_length=255)),
                ('pod', models.CharField(max_length=255)),
                ('etd', models.DateField(blank=True, null=True)),
                ('eta', models.DateField(blank=True, null=True)),
                ('remarks', models.CharField(max_length=255)),
                ('po_number', models.CharField(max_length=255)),
                ('po_date', models.DateField(blank=True, null=True)),
                ('so_number', models.CharField(max_length=255)),
                ('so_date', models.DateField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='TradeRefNo',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('kp', models.IntegerField()),
                ('ks', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='ApprovedBy',
            fields=[
                ('trn', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='home.TradeApproval')),
                ('manager1', models.CharField(max_length=255)),
                ('manager2', models.CharField(max_length=255)),
                ('approve1', models.BooleanField()),
                ('approve2', models.BooleanField()),
                ('approve1date', models.CharField(max_length=255)),
                ('approve2date', models.CharField(max_length=255)),
            ],
        ),
        migrations.CreateModel(
            name='Disputes',
            fields=[
                ('trn', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='home.TradeApproval')),
                ('s_dispute', models.CharField(max_length=255)),
                ('p_dispute', models.CharField(max_length=255)),
                ('s_remark', models.CharField(max_length=255)),
                ('p_remark', models.CharField(max_length=255)),
            ],
        ),
        migrations.CreateModel(
            name='ExtraCost',
            fields=[
                ('trn', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='home.TradeApproval')),
                ('bankCharges', models.FloatField()),
                ('billFee', models.FloatField()),
                ('billCollectionCharges', models.FloatField()),
                ('otherCharges', models.FloatField()),
            ],
        ),
        migrations.CreateModel(
            name='PaymentAndFinance',
            fields=[
                ('trn', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='home.TradeApproval')),
                ('balancePaymentFromBuyer', models.FloatField()),
                ('balancePaymentToSupplier', models.FloatField()),
                ('dueDate', models.CharField(max_length=255)),
                ('paymentReceived', models.FloatField()),
                ('paymentSent', models.FloatField()),
                ('paymentDate', models.CharField(max_length=255)),
                ('balanceDue', models.FloatField()),
                ('paymentMode', models.CharField(max_length=255)),
                ('paymentStatus', models.CharField(max_length=255)),
                ('logisticsPaymentDue', models.FloatField()),
                ('logisticsCommisionDueDate', models.CharField(max_length=255)),
                ('agentCommissionPaid', models.FloatField()),
            ],
        ),
        migrations.CreateModel(
            name='PL',
            fields=[
                ('trn', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='home.TradeApproval')),
                ('s_purchaseTotalCost', models.FloatField()),
                ('p_purchaseTotalCost', models.FloatField()),
                ('totalRevenueFromSales', models.FloatField()),
                ('grossProfit', models.FloatField()),
                ('profitPerDrum', models.FloatField()),
            ],
        ),
        migrations.CreateModel(
            name='SalesAndPurchase',
            fields=[
                ('trn', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='home.TradeApproval')),
                ('invoiceDate', models.CharField(max_length=255)),
                ('invoiceNumber', models.CharField(max_length=255)),
                ('invoiceAmount', models.FloatField()),
                ('commissionAgent', models.CharField(max_length=255)),
                ('commissionAmount', models.FloatField()),
                ('packingListDetails', models.CharField(max_length=255)),
                ('billNumber', models.CharField(max_length=255)),
                ('billQty', models.FloatField()),
                ('billDate', models.CharField(max_length=255)),
                ('logisticAgent', models.CharField(max_length=255)),
                ('logisticCost', models.FloatField()),
                ('liner', models.CharField(max_length=255)),
                ('eta', models.CharField(max_length=255)),
                ('etd', models.CharField(max_length=255)),
                ('shipmentStatus', models.CharField(max_length=255)),
            ],
        ),
        migrations.AddField(
            model_name='prepayments',
            name='trn',
            field=models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='home.TradeApproval'),
        ),
    ]
