| banktransid | bigint(20) |
|
|
|
| VPrefix | varchar(25) |
|
|
|
| type | smallint(6) |
|
|
0
|
| ledger_id | int(11) |
|
|
|
| client_id | int(11) |
|
|
|
| sub_ledger_id | int(11) |
|
|
|
| branch_name | varchar(255) |
|
|
|
| cheque_no | varchar(255) |
|
|
|
| narration | varchar(255) |
|
|
|
| transno | bigint(20) |
|
|
0
|
| bankact | int(11) |
|
|
0
|
| ref | varchar(50) |
|
|
|
| amountcleared | double |
|
|
0
|
| exrate | double |
|
|
1
|
| functionalexrate | double |
|
|
1
|
| transdate | date |
|
|
0000-00-00
|
| banktranstype | varchar(30) |
|
|
|
| amount | double |
|
|
0
|
| currcode | char(3) |
|
|
|
