# Generated by Django 3.0.6 on 2021-07-18 09:03

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


class Migration(migrations.Migration):

    dependencies = [
        ('autocount', '0002_auto_20210718_0127'),
    ]

    operations = [
        migrations.CreateModel(
            name='Debtortype',
            fields=[
                ('debtortype', models.CharField(db_column='DebtorType', max_length=20, primary_key=True, serialize=False)),
                ('description', models.CharField(blank=True, db_column='Description', max_length=40, null=True)),
                ('desc2', models.CharField(blank=True, db_column='Desc2', max_length=40, null=True)),
                ('isactive', models.CharField(db_column='IsActive', max_length=1)),
                ('lastupdate', models.IntegerField(db_column='LastUpdate')),
            ],
            options={
                'db_table': 'DebtorType',
            },
        ),
        migrations.CreateModel(
            name='Pricecategory',
            fields=[
                ('pricecategory', models.CharField(db_column='PriceCategory', max_length=12, primary_key=True, serialize=False)),
                ('description', models.CharField(blank=True, db_column='Description', max_length=40, null=True)),
                ('discountpercent', models.DecimalField(blank=True, db_column='DiscountPercent', decimal_places=6, max_digits=18, null=True)),
                ('detaildiscount', models.CharField(blank=True, db_column='DetailDiscount', max_length=20, null=True)),
                ('lastupdate', models.IntegerField(db_column='LastUpdate')),
                ('markupratio', models.DecimalField(blank=True, db_column='MarkupRatio', decimal_places=6, max_digits=18, null=True)),
            ],
            options={
                'db_table': 'PriceCategory',
            },
        ),
        migrations.CreateModel(
            name='Salesagent',
            fields=[
                ('salesagent', models.CharField(db_column='SalesAgent', max_length=12, primary_key=True, serialize=False)),
                ('description', models.CharField(blank=True, db_column='Description', max_length=40, null=True)),
                ('desc2', models.CharField(blank=True, db_column='Desc2', max_length=40, null=True)),
                ('isactive', models.CharField(db_column='IsActive', max_length=1)),
                ('lastupdate', models.IntegerField(db_column='LastUpdate')),
                ('signature', models.BinaryField(blank=True, db_column='Signature', null=True)),
            ],
            options={
                'db_table': 'SalesAgent',
            },
        ),
        migrations.CreateModel(
            name='Terms',
            fields=[
                ('displayterm', models.CharField(db_column='DisplayTerm', max_length=30, primary_key=True, serialize=False)),
                ('terms', models.CharField(blank=True, db_column='Terms', max_length=30, null=True)),
                ('lastupdate', models.IntegerField(db_column='LastUpdate')),
                ('termtype', models.CharField(blank=True, db_column='TermType', max_length=1, null=True)),
                ('termdays', models.IntegerField(blank=True, db_column='TermDays', null=True)),
                ('discountdays', models.IntegerField(blank=True, db_column='DiscountDays', null=True)),
                ('discountpercent', models.DecimalField(blank=True, db_column='DiscountPercent', decimal_places=6, max_digits=18, null=True)),
            ],
            options={
                'db_table': 'Terms',
            },
        ),
        migrations.CreateModel(
            name='Debtor',
            fields=[
                ('accno', models.OneToOneField(db_column='AccNo', on_delete=django.db.models.deletion.DO_NOTHING, primary_key=True, serialize=False, to='autocount.Glmast')),
                ('companyname', models.CharField(blank=True, db_column='CompanyName', max_length=100, null=True)),
                ('desc2', models.CharField(blank=True, db_column='Desc2', max_length=100, null=True)),
                ('registerno', models.CharField(blank=True, db_column='RegisterNo', max_length=25, null=True)),
                ('address1', models.CharField(blank=True, db_column='Address1', max_length=40, null=True)),
                ('address2', models.CharField(blank=True, db_column='Address2', max_length=40, null=True)),
                ('address3', models.CharField(blank=True, db_column='Address3', max_length=40, null=True)),
                ('address4', models.CharField(blank=True, db_column='Address4', max_length=40, null=True)),
                ('postcode', models.CharField(blank=True, db_column='PostCode', max_length=10, null=True)),
                ('deliveraddr1', models.CharField(blank=True, db_column='DeliverAddr1', max_length=40, null=True)),
                ('deliveraddr2', models.CharField(blank=True, db_column='DeliverAddr2', max_length=40, null=True)),
                ('deliveraddr3', models.CharField(blank=True, db_column='DeliverAddr3', max_length=40, null=True)),
                ('deliveraddr4', models.CharField(blank=True, db_column='DeliverAddr4', max_length=40, null=True)),
                ('deliverpostcode', models.CharField(blank=True, db_column='DeliverPostCode', max_length=10, null=True)),
                ('attention', models.CharField(blank=True, db_column='Attention', max_length=40, null=True)),
                ('phone1', models.CharField(blank=True, db_column='Phone1', max_length=25, null=True)),
                ('phone2', models.CharField(blank=True, db_column='Phone2', max_length=25, null=True)),
                ('fax1', models.CharField(blank=True, db_column='Fax1', max_length=25, null=True)),
                ('fax2', models.CharField(blank=True, db_column='Fax2', max_length=25, null=True)),
                ('natureofbusiness', models.CharField(blank=True, db_column='NatureOfBusiness', max_length=40, null=True)),
                ('weburl', models.CharField(blank=True, db_column='WebURL', max_length=80, null=True)),
                ('emailaddress', models.CharField(blank=True, db_column='EmailAddress', max_length=80, null=True)),
                ('creditlimit', models.DecimalField(blank=True, db_column='CreditLimit', decimal_places=2, max_digits=19, null=True)),
                ('agingon', models.CharField(blank=True, db_column='AgingOn', max_length=1, null=True)),
                ('statementtype', models.CharField(blank=True, db_column='StatementType', max_length=1, null=True)),
                ('allowexceedcreditlimit', models.CharField(db_column='AllowExceedCreditLimit', max_length=1)),
                ('note', models.TextField(blank=True, db_column='Note', null=True)),
                ('exemptno', models.CharField(blank=True, db_column='ExemptNo', max_length=60, null=True)),
                ('expirydate', models.DateTimeField(blank=True, db_column='ExpiryDate', null=True)),
                ('discountpercent', models.DecimalField(db_column='DiscountPercent', decimal_places=6, max_digits=18)),
                ('detaildiscount', models.CharField(blank=True, db_column='DetailDiscount', max_length=20, null=True)),
                ('lastmodified', models.DateTimeField(db_column='LastModified')),
                ('createdtimestamp', models.DateTimeField(db_column='CreatedTimeStamp')),
                ('overduelimit', models.DecimalField(blank=True, db_column='OverdueLimit', decimal_places=2, max_digits=19, null=True)),
                ('hasbonuspoint', models.CharField(db_column='HasBonusPoint', max_length=1)),
                ('openingbonuspoint', models.DecimalField(blank=True, db_column='OpeningBonusPoint', decimal_places=2, max_digits=19, null=True)),
                ('qtblockstatus', models.SmallIntegerField(blank=True, db_column='QTBlockStatus', null=True)),
                ('soblockstatus', models.SmallIntegerField(blank=True, db_column='SOBlockStatus', null=True)),
                ('doblockstatus', models.SmallIntegerField(blank=True, db_column='DOBlockStatus', null=True)),
                ('ivblockstatus', models.SmallIntegerField(blank=True, db_column='IVBlockStatus', null=True)),
                ('csblockstatus', models.SmallIntegerField(blank=True, db_column='CSBlockStatus', null=True)),
                ('qtblockmessage', models.CharField(blank=True, db_column='QTBlockMessage', max_length=40, null=True)),
                ('soblockmessage', models.CharField(blank=True, db_column='SOBlockMessage', max_length=40, null=True)),
                ('doblockmessage', models.CharField(blank=True, db_column='DOBlockMessage', max_length=40, null=True)),
                ('ivblockmessage', models.CharField(blank=True, db_column='IVBlockMessage', max_length=40, null=True)),
                ('csblockmessage', models.CharField(blank=True, db_column='CSBlockMessage', max_length=40, null=True)),
                ('externallink', models.TextField(blank=True, db_column='ExternalLink', null=True)),
                ('isgroupcompany', models.CharField(db_column='IsGroupCompany', max_length=1)),
                ('isactive', models.CharField(db_column='IsActive', max_length=1)),
                ('lastupdate', models.IntegerField(db_column='LastUpdate')),
                ('contactinfo', models.TextField(blank=True, db_column='ContactInfo', null=True)),
                ('accountgroup', models.CharField(blank=True, db_column='AccountGroup', max_length=12, null=True)),
                ('markupratio', models.DecimalField(blank=True, db_column='MarkupRatio', decimal_places=6, max_digits=18, null=True)),
                ('taxregisterno', models.CharField(blank=True, db_column='TaxRegisterNo', max_length=20, null=True)),
                ('calcdiscountonunitprice', models.CharField(blank=True, db_column='CalcDiscountOnUnitPrice', max_length=1, null=True)),
                ('gststatusverifieddate', models.DateTimeField(blank=True, db_column='GSTStatusVerifiedDate', null=True)),
                ('inclusivetax', models.CharField(db_column='InclusiveTax', max_length=1)),
                ('roundingmethod', models.IntegerField(db_column='RoundingMethod')),
                ('istaxregistered', models.CharField(blank=True, db_column='IsTaxRegistered', max_length=1, null=True)),
                ('receiptwithholdingtaxcode', models.CharField(blank=True, db_column='ReceiptWithholdingTaxCode', max_length=14, null=True)),
                ('paymentwithholdingtaxcode', models.CharField(blank=True, db_column='PaymentWithholdingTaxCode', max_length=14, null=True)),
                ('servicetaxregisterno', models.CharField(blank=True, db_column='ServiceTaxRegisterNo', max_length=20, null=True)),
                ('selfbilledapprovalno', models.CharField(blank=True, db_column='SelfBilledApprovalNo', max_length=30, null=True)),
                ('areacode', models.ForeignKey(blank=True, db_column='AreaCode', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='autocount.Area')),
                ('createduserid', models.ForeignKey(db_column='CreatedUserID', on_delete=django.db.models.deletion.DO_NOTHING, related_name='createduserid', to='autocount.Users')),
                ('currencycode', models.ForeignKey(db_column='CurrencyCode', on_delete=django.db.models.deletion.DO_NOTHING, to='autocount.Currency')),
                ('debtortype', models.ForeignKey(blank=True, db_column='DebtorType', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='Debtor_debtortype', to='autocount.Debtortype')),
                ('displayterm', models.ForeignKey(db_column='DisplayTerm', on_delete=django.db.models.deletion.DO_NOTHING, to='autocount.Terms')),
                ('lastmodifieduserid', models.ForeignKey(db_column='LastModifiedUserID', on_delete=django.db.models.deletion.DO_NOTHING, related_name='Debtor_LastModifiedUserID', to='autocount.Users')),
                ('pricecategory', models.ForeignKey(blank=True, db_column='PriceCategory', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='Debtor_pricecategory', to='autocount.Pricecategory')),
                ('salesagent', models.ForeignKey(blank=True, db_column='SalesAgent', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='Salesagent', to='autocount.Salesagent')),
                ('taxtype', models.ForeignKey(blank=True, db_column='TaxType', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='Debtor_taxtype', to='autocount.Taxtype')),
            ],
            options={
                'db_table': 'Debtor',
            },
        ),
    ]
