from django.db import models

class voucher_table(models.Model): 
    company_id      = models.IntegerField(default=0,null=True)
    date            = models.DateField(null=True)
    current_fy      = models.IntegerField(null=True)
    voucher_type    = models.CharField(max_length=30)
    voucher_no      = models.CharField(max_length=10)
    num_series      = models.CharField(max_length=10)
    branch_id       = models.IntegerField(default=0,null=True)
    supply_branch_id= models.IntegerField(default=0,null=True)
    time            = models.TimeField(null=True)
    bank_id         = models.IntegerField(default=0,null=True)
    finance_id      = models.IntegerField(default=0,null=True)
    card_id         = models.IntegerField(default=0,null=True)
    supplier_id     = models.IntegerField(default=0,null=True)
    customer_id     = models.IntegerField(default=0,null=True)
    payable_amount  = models.FloatField(null=True)
    receivable_amount = models.FloatField(null=True)
    advance_amount  = models.FloatField(null=True)
    outstanding     = models.FloatField(null=True)
    remarks         = models.CharField(max_length=100)
    payment_mode    = models.CharField(max_length=30)
    payment_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_voucher"