id | int(11) |
|
|
|
counter_code | varchar(6) |
|
|
|
counter_des | varchar(50) |
|
|
|
open_cnt_date | date |
|
|
|
recpt_date | date |
|
|
|
pay_recpt_no | varchar(20) |
|
|
|
payment_mode | varchar(20) |
|
|
|
ipno | varchar(20) |
|
|
|
name | varchar(45) |
|
|
|
acount_no | varchar(30) |
|
|
|
remarks | varchar(100) |
|
|
|
pay_receipt_ind | varchar(20) |
|
|
|
amount | double(15,2) |
|
|
|
created_date | timestamp |
|
|
CURRENT_TIMESTAMP
|
created_by | varchar(20) |
|
|
|
modified_date | datetime |
|
|
0000-00-00 00:00:00.000000
|
modified_by | varchar(20) |
|
|
|
rest_amt | double(10,2) |
|
|
|
rev_status | tinyint(1) |
|
|
0
|
locationname | varchar(20) |
|
|
|