cofre_transactions

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

Date and time when the saving was responded by the payment gateway.

dt_retrieve

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.