Prepare Trail Balancen -Django

The project is Django - Python

Models:

Transaction Header

Transaction Detail

AccountMaster

Filter: User

class FinTransHeader([login to view URL]):

user = [login to view URL](User, null=True, blank=True, on_delete=models.SET_NULL)

fh_type = [login to view URL](max_length=200)

fh_code = [login to view URL](max_length=200)

fh_no = [login to view URL](blank=False,null=False)

fh_dt = [login to view URL]()

fh_detail=[login to view URL](max_length=200,blank=True,null=True)

fh_cust_code = [login to view URL](max_length=200,blank=True,null=True)

fh_user_code =[login to view URL](max_length=200,blank=True,null=True)

fh_ref=[login to view URL](max_length=200,default='nil',blank=True,null=True)

fh_status=[login to view URL](max_length=1,default=0)

fh_post_status = [login to view URL](default=False)

fh_prt_status=[login to view URL](default=False)

def __str__(self):

"""String for representing the Model object."""

return str(self.fh_no)

# return self.fh_no

class FinTransDetail([login to view URL]):

user = [login to view URL](User, null=True, blank=True, on_delete=models.SET_NULL)

fd_no = [login to view URL](FinTransHeader, on_delete=[login to view URL],default=1)

# fd_acct = [login to view URL](AccountMaster, to_field='AcctCode', on_delete=[login to view URL],default=1)

fd_acct = [login to view URL](decimal_places=0, max_digits=6)

fd_debit = [login to view URL](max_digits=12, decimal_places=2, default=0, null=False)

fd_credit = [login to view URL](max_digits=12, decimal_places=2, default=0, null=False)

fd_detail = [login to view URL](max_length=200, null=True, blank=True)

fd_tax = [login to view URL](max_digits=12, decimal_places=2, default=0, null=False)

fd_posting = [login to view URL](default=False, blank=True, null=True)

def __str__(self):

return str(self.fd_debit)

(can recommend to change the releationship between models eg foreign key)

class AccountMaster([login to view URL]):

"""Model representing a book (but not a specific copy of a book)."""

user = [login to view URL](User, null=True, blank=True, on_delete=models.SET_NULL)

AcctLevel = [login to view URL](max_length=100,default='0',null=False)

AcctCode =[login to view URL]( decimal_places=0, max_digits=6)

AcctName = [login to view URL](max_length=50)

AcctDesc = [login to view URL](max_length=100)

# AcctType = [login to view URL](AcctType,on_delete=[login to view URL],null=True,blank=True)

AcctType = [login to view URL](max_length=20,choices=ACCTTYPE_CHOICES,null=False, blank=False,default="A")

AcctGrp = [login to view URL](max_length=20, choices=ACCTGRP_CHOICES, null = False, blank = False, default = "G")

# AcctReport1 = [login to view URL]('self', on_delete=[login to view URL], null=True, blank=True,required=False)

AcctReport1 = [login to view URL]( decimal_places=0, max_digits=6,default=0,null=True, blank=True)

# AcctReport1 = [login to view URL](max_digits=6, decimal_places=0, default=0, blank=True)

AcctReport2 = [login to view URL](max_digits=6, decimal_places=0, default=0, blank=True)

AcctPosting = [login to view URL](default=False, blank=True)

AcctFreeze= [login to view URL](default=False, blank=True)

AcctBal = [login to view URL](max_digits=12, decimal_places=2, default=0, null=False)

AcctDefault= [login to view URL](default=False, blank=True)

class Meta:

ordering = ["AcctCode"]

def __str__(self):

"""String for representing the Model object."""

# return [login to view URL](AcctCode)+"-"+[login to view URL]

return str([login to view URL])

Needs to prepare trai lbalance with

Account Level 1 -Total

Account level 2 - Total

Account Level 3 - total

(more details on chats)

Python Django Programvaruarkitektur JavaScript

Projekt-id: #36144025

About the project