Guest User

Untitled

a guest
Nov 13th, 2018
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. fees_id, interest, amount, total_amount, status_id, is_recurring recurring_status from_date to_date payment_id
  2. F001 1.50 1000 1015 1 N NULL 2018-11-01 2018-11-01 1
  3. F002 2.00 2000 1020 1 Y COMPLETE 2018-11-01 2018-11-20 2
  4.  
  5. id, amount, payment_date, txn_id, bnk_name, txn_status, pay_mode, dd_no, dd_date, chk_no, chk_date
  6. 1 1015 2018-11-11 TXN0001 SBI 1 1 NULL NULL NULL NULL
  7. 2 1020 2018-11-20 NULL NULL NULL 3 DNO001 2018-11-19 NULL NULL
  8.  
  9. id name display
  10. 1 ONLINE Y
  11. 2 CASH Y
  12. 3 DRAFT Y
  13. 4 CHECK Y
  14.  
  15. id status display
  16. 1 PAID Y
  17. 2 UNPAID Y
Add Comment
Please, Sign In to add comment