cofre_transactions
Table name: cofre_transactions
Description: Table to store account transactions and savings
|
Field |
Type |
Description |
API |
|
ID |
Integer |
Sequential number of the registry in the table |
|
|
connectionsID |
Integer |
The id of the related connection in table cofre_connections |
|
|
accountsID |
Integer |
The id of the related account in table cofre_accounts |
|
|
saltedge_transaction_id |
String |
The id of the transaction |
https://www.saltedge.com/api/v5/transactions?connection_id={connection.id}&account_id={account.id} |
|
saltedge_amount |
Decimal |
The amount of the transaction |
https://www.saltedge.com/api/v5/transactions?connection_id={connection.id}&account_id={account.id} |
|
amount_saved |
Decimal |
The amount saved (AS): The percentage is defined by the Cofre’s user. |
|
|
status |
Integer |
Status of the transaction selected by the user to calculate a saving for the Cofre platform
Transactions could be: 0 – Selected, but not processed 1 – Saved 2 – Processing 3 – Technical error. Must be analysed 5 – Not approved by payment gateway 6 – Retrieve asked by the user 7 – Retrieve processed |
|
|
dt_saving |
Timestamp |
Date and time when the saving was responded by the payment gateway |
|
|
dt_retrieve |
Timestamp |
Date and time when the user asked a retrieving |
|
|
datainsert |
Timestamp |
Date and time when the registry was inserted in the table |
|
|
dataupdate |
Timestamp |
Date and time of the last update of the registry in the table |
|