fx_transaction
| # | trans_number | userid | debit_amount | credit_amount | trans_type | total_amt | trans_date | closing_balance | description |
|---|---|---|---|---|---|---|---|---|---|
| 1 | @random_num | intUserID | dblDebitAmount | dblCreditAmount | intTransType | dbltotal_amt | @Now | dblClosingBalance | strDescription |
| 2 | @random_num | intUserID | dblDebitAmount | dblCreditAmount | intTransType | dbltotal_amt | strDate | dblClosingBalance | strDescription |
| 3 | @random_num | intUserID | dblDebitAmount | dblCreditAmount | intTransType | dbltotal_amt | @Now | dblClosingBalance | strDescription |