from django.db import models

# Create your models here.

class slab_letter_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    current_fy          = models.IntegerField(null=True)
    from_date           = models.DateField(null=True)
    to_date             = models.DateField(null=True)
    date                = models.DateField(null=True)
    time                = models.TimeField(null=True)
    supplier_id         = models.IntegerField(null=True)
    subcategory_id      = models.IntegerField(null=True)
    brand_id            = models.IntegerField(null=True)
    slab_no             = models.CharField(max_length=50)
    month               = models.CharField(max_length=50)
    year                = models.IntegerField(null=True)
    remarks             = models.CharField(max_length=150)
    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)
    employee_id         = models.IntegerField(null=True)
    class Meta:
        db_table="tm_slab_letter"



class tx_slab_letter_table(models.Model):    
    branch_id           = models.IntegerField(null=True)
    tm_slab_id          = models.IntegerField(null=True)
    current_fy          = models.IntegerField(null=True)
    supplier_id         = models.IntegerField(null=True)
    subcategory_id      = models.IntegerField(null=True)
    brand_id            = models.IntegerField(null=True)
    model_id            = models.IntegerField(null=True)
    variant_id          = models.IntegerField(null=True)
    from_qty            = models.IntegerField(null=True)
    to_qty              = models.IntegerField(null=True)
    amount              = models.DecimalField(max_digits=10, decimal_places=2, 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="tx_slab_letter"




class slab_sales_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    current_fy          = models.IntegerField(null=True)
    slab_id             = models.IntegerField(null=True)
    supply_branch_id    = models.IntegerField(null=True)
    supplier_id         = models.IntegerField(null=True)
    subcategory_id      = models.IntegerField(null=True)
    brand_id            = models.IntegerField(null=True)
    from_date           = models.DateField(null=True)
    to_date             = models.DateField(null=True)
    date                = models.DateField(null=True)
    time                = models.TimeField(null=True)
    slab_no             = models.CharField(max_length=50)
    credit_note         = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    claim_status        = models.CharField(max_length=50, default='pending')
    claim_amount        = models.DecimalField(max_digits=10, decimal_places=2, null=True, default=0.00)
    month               = models.CharField(max_length=50)
    year                = models.IntegerField(null=True)
    remarks             = models.CharField(max_length=150)
    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)
    employee_id         = models.IntegerField(null=True)
    class Meta:
        db_table="tm_slab_sales"



class tx_slab_sales_table(models.Model):    
    branch_id           = models.IntegerField(null=True)
    supplier_id         = models.IntegerField(null=True)
    supply_branch_id    = models.IntegerField(null=True)
    tm_slab_id          = models.IntegerField(null=True)
    slab_letter_id      = models.IntegerField(null=True)
    current_fy          = models.IntegerField(null=True)
    supplier_id         = models.IntegerField(null=True)
    subcategory_id      = models.IntegerField(null=True)
    brand_id            = models.IntegerField(null=True)
    model_id            = models.IntegerField(null=True)
    variant_id          = models.IntegerField(null=True)
    sales_qty           = models.IntegerField(null=True)
    slab_amount         = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    total_amount        = models.DecimalField(max_digits=10, decimal_places=2, 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="tx_slab_sales"