Reply To: sql table info needed

[Rohithzr]

list of my status variable: should help

0: paid amount
3: deleted amount [i dont really want to delete the payment do i]
5: pending amount [the amount he had to pay but he did not]
6: advance deposit [will use this to cover next months payment]
9: balance cleared [once the balance is cleared i store a clearing date]
10: advance cleared [once an advance amount is used to clear it gets cleared with a clearing Date]