from django.db import models

# Create your models here.


class tm_claim_table(models.Model): 
    company_id          = models.IntegerField(default=0,null=True)
    supplier_id         = models.IntegerField(default=0,null=True)
    branch_id           = models.IntegerField(default=0,null=True)
    current_fy          = models.IntegerField(default=0,null=True)
    date                = models.DateField(null=True, blank=True)
    time                = models.TimeField(null=True, blank=True)
    from_date           = models.DateField(null=True, blank=True)
    to_date             = models.DateField(null=True, blank=True)
    debit_note_no       = models.CharField(max_length=50,null=True)
    debit_note_date     = models.DateField(null=True, blank=True)
    claim_no            = models.CharField(max_length=50,null=True)
    scheme_type         = models.CharField(max_length=50,null=True)
    total_amount        = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    debit_amount        = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    balance             = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    remarks             = models.CharField(max_length=150,null=True)
    employee_id         = models.IntegerField(default=0,null=True)
    is_active           = models.IntegerField(default=1,null=True)
    status              = models.IntegerField(default=1,null=True)
    created_on          = models.DateTimeField(null=True)
    updated_on          = models.DateTimeField(null=True)
    created_by          = models.IntegerField(null=True)
    updated_by          = models.IntegerField(null=True)
    class Meta:
        db_table="tm_claim"

    


class tx_claim_table(models.Model): 
    company_id          = models.IntegerField(default=0,null=True)
    supplier_id         = models.IntegerField(default=0,null=True)
    branch_id           = models.IntegerField(default=0,null=True)
    current_fy          = models.IntegerField(default=0,null=True)
    tm_claim_id         = models.IntegerField(default=0,null=True)
    sales_id            = models.IntegerField(default=0,null=True)
    source_id           = models.IntegerField(default=0,null=True)
    supply_branch_id    = models.IntegerField(default=0,null=True)
    inv_no              = models.CharField(max_length=50,null=True)
    inv_date            = models.DateField(null=True, blank=True)
    scheme_type         = models.CharField(max_length=50,null=True)
    ean                  = models.CharField(max_length=50,null=True)
    amount              = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    is_active           = models.IntegerField(default=1,null=True)
    status              = models.IntegerField(default=1,null=True)
    created_on          = models.DateTimeField(null=True)
    updated_on          = models.DateTimeField(null=True)
    created_by          = models.IntegerField(null=True)
    updated_by          = models.IntegerField(null=True)
    class Meta:
        db_table="tx_claim"




class tm_collection_table(models.Model): 
    company_id          = models.IntegerField(default=0,null=True)
    branch_id           = models.IntegerField(default=0,null=True)
    finance_id          = models.IntegerField(default=0,null=True)
    bank_id             = models.IntegerField(default=0,null=True)
    current_fy          = models.IntegerField(default=0,null=True)
    f_type              = models.CharField(max_length=50,null=True)
    collection_no       = models.CharField(max_length=50,null=True)
    date                = models.DateField(null=True, blank=True)
    time                = models.TimeField(null=True, blank=True)
    from_date           = models.DateField(null=True, blank=True)
    to_date             = models.DateField(null=True, blank=True)
    receipt_no          = models.CharField(max_length=50,null=True)
    receipt_date        = models.DateField(null=True, blank=True)
    total_amount        = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    receipt             = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    remarks             = models.CharField(max_length=150,null=True)
    is_active           = models.IntegerField(default=1,null=True)
    status              = models.IntegerField(default=1,null=True)
    created_on          = models.DateTimeField(null=True)
    updated_on          = models.DateTimeField(null=True)
    created_by          = models.IntegerField(null=True)
    employee_id         = models.IntegerField(null=True)
    updated_by          = models.IntegerField(null=True)
    class Meta:
        db_table="tm_collection"

    


class tx_collection_table(models.Model): 
    company_id          = models.IntegerField(default=0,null=True)
    branch_id           = models.IntegerField(default=0,null=True)
    current_fy          = models.IntegerField(default=0,null=True)
    supply_branch_id    = models.IntegerField(default=0,null=True)
    tm_collection_id    = models.IntegerField(default=0,null=True)
    transaction_id      = models.IntegerField(default=0,null=True)
    sales_id            = models.IntegerField(default=0,null=True)
    inv_no              = models.CharField(max_length=50,null=True)
    inv_date            = models.DateField(null=True, blank=True)
    f_type              = models.CharField(max_length=50,null=True)
    row_type            = models.CharField(max_length=50,null=True)
    finance_id          = models.IntegerField(default=1,null=True)
    amount              = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    is_active           = models.IntegerField(default=1,null=True)
    status              = models.IntegerField(default=1,null=True)
    created_on          = models.DateTimeField(null=True)
    updated_on          = models.DateTimeField(null=True)
    created_by          = models.IntegerField(null=True)
    updated_by          = models.IntegerField(null=True)
    class Meta:
        db_table="tx_collection"




class tm_upgrade_table(models.Model): 
    company_id          = models.IntegerField(default=0,null=True)
    branch_id           = models.IntegerField(default=0,null=True)
    current_fy          = models.IntegerField(default=0,null=True)
    upgrade_no          = models.CharField(max_length=50,null=True)
    imei_no             = models.CharField(max_length=50,null=True)
    supply_branch_id    = models.IntegerField(default=0,null=True)
    date                = models.DateField(null=True, blank=True)
    time                = models.TimeField(null=True, blank=True)
    sales_id            = models.IntegerField(default=0,null=True)
    tx_sales_id         = models.IntegerField(default=0,null=True)
    subcategory_id      = models.IntegerField(default=0,null=True)
    brand_id            = models.IntegerField(default=0,null=True)
    model_id            = models.IntegerField(default=0,null=True)
    variant_id          = models.IntegerField(default=0,null=True)
    color_id            = models.IntegerField(default=0,null=True)
    debit_note_no       = models.CharField(max_length=50,null=True)
    debit_note_date     = models.DateField(null=True, blank=True)
    total_amount        = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    debit_amount        = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    balance             = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    remarks             = models.CharField(max_length=150,null=True)    
    employee_id         = models.IntegerField(default=0,null=True)
    is_active           = models.IntegerField(default=1,null=True)
    status              = models.IntegerField(default=1,null=True)
    created_on          = models.DateTimeField(null=True)
    updated_on          = models.DateTimeField(null=True)
    created_by          = models.IntegerField(null=True)
    updated_by          = models.IntegerField(null=True)
    class Meta:
        db_table="tm_upgrade"