# 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. Field `id` returned by the API.	https://www.saltedge.com/api/v5/transactions?connection\_id={connection.id}&account\_id={account.id}
saltedge\_amount	Decimal	The amount of the transaction. Field `amount` returned by the API.	https://www.saltedge.com/api/v5/transactions?connection\_id={connection.id}&account\_id={account.id}
amount\_saved	Decimal	The amount saved (AS): AS = saltedge\_amount \* percentage. 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 4 – Sent to payment gateway, but waiting response 5 – Not approved by payment gateway 6 – Retrieve asked by the user 7 – Retrieve processed
saltedge\_made\_on	Datetime	The date when the transaction was made. Field `made_on` returned by the API.	https://www.saltedge.com/api/v5/transactions?connection\_id={connection.id}&account\_id={account.id}
dt\_saving	Datetime	Date and time when the saving was responded by the payment gateway.
dt\_retrieve	Datetime	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.