| Name | Description | Type | Additional information |
|---|---|---|---|
| t_account_number |
Transaction Account Number |
string |
None. |
| t_trans_number |
Unique transaction number for bank transaction |
string |
None. |
| t_location |
Branch/Location where the transaction took place |
string |
None. |
| transaction_description |
Description of the transaction |
string |
None. |
| t_date |
Date and time of the transaction |
date |
None. |
| t_teller |
Who conducted the transaction |
string |
None. |
| t_authorized |
Who authorized the transaction |
string |
None. |
| t_late_deposit |
Late deposit indicator 1 for late deposit otherwise 0 |
string |
None. |
| t_date_posting |
Date of posting (if different from date of transaction) |
date |
None. |
| t_value_date |
Transaction Value Date and Time |
date |
None. |
| t_transmode_code |
How the transaction was conducted A-In-branch/Office, B-ATM, C-Electronic transaction |
string |
None. |
| t_amount_local |
The value of the transaction in local currency |
decimal number |
None. |
| t_source_client_type |
Specifies where the money came from. varchar(1) [0,1] : 0 = Not My Client, 1 = My Client |
string |
None. |
| t_source_type |
Specifies the source of the money either account, person or entity |
string |
None. |
| t_source_funds_code | string |
None. |
|
| t_source_currency_code |
Local Currency code Varchar(3) e.g NGN |
string |
None. |
| t_source_foreign_amount |
If the transaction is conducted in foreign currency, then specify the foreign currency details. |
decimal number |
None. |
| t_source_exchange_rate |
Exchange rate which has been used for transaction |
decimal number |
None. |
| t_source_country |
The country the source of money come from |
string |
None. |
| t_source_institution_code |
Institution Code |
string |
None. |
| t_source_institution_name |
Source Institution Name |
string |
None. |
| t_source_account_number |
The Source Account Number |
string |
None. |
| t_source_account_name |
The source account name |
string |
None. |
| t_source_person_first_name |
First name of the source person |
string |
None. |
| t_source_person_last_name |
Last name of the source person |
string |
None. |
| t_source_entity_name |
Name of source entity |
string |
None. |
| t_dest_client_type |
Specifies where the money go to varchar(1) [0,1] : 0 = Not My Client, 1 = My Client |
string |
None. |
| t_dest_type |
Specifies where the money goes to, either account, person or entity |
string |
None. |
| t_dest_funds_code | string |
None. |
|
| t_dest_currency_code |
Local Currency code varchar(3) e.g NGN |
string |
None. |
| t_dest_foreign_amount |
If the transaction is conducted in foreign currency, then specify the foreign currency details. |
decimal number |
None. |
| t_dest_exchange_rate |
Exchange rate which has been used for transaction |
decimal number |
None. |
| t_dest_country |
The country the money goes to |
string |
None. |
| t_dest_institution_code |
Destination Institution Code |
string |
None. |
| t_dest_institution_name |
Destination Institution |
string |
None. |
| t_dest_account_number |
The destiantion account number |
string |
None. |
| t_dest_account_name |
The destination account name |
string |
None. |
| t_dest_person_first_name |
First name of the destination person |
string |
None. |
| t_dest_person_last_name |
Last name of the the destination person |
string |
None. |
| t_dest_entity_name |
Name of destination entity |
string |
None. |
| Tran_Type |
Transaction Type NEFT INWARD, NIPS INWARD e.t.c.. |
string |
None. |