bank_transactions

NEW

In short

Bank transactions accessible on pennylane. This table includes basic transaction information, such as the amount, execution date, transaction state.

This table is suited for incremental ingestion with an ETL tool. For standard data analysis, use schema pennylane.

Available Columns

id

bigint

Unique identifier of the transaction.

execution_date

date

Execution date of the transaction.

company_id

bigint

Unique ID of the company on Pennylane, referring to companies.id.

thirdparty_name

character varying

A thirdparty represents a supplier or a customer of the company managed on Pennylane. Third parties can be both legal entities or individuals. The thirdparty_name is the name of the third party on Pennylane.

thirdparty_id

bigint

A thirdparty represents a supplier or a customer of the company managed on Pennylane. Third parties can be both legal entities or individuals. The thirdparty_id is the unique identifier of the third party on Pennylane, and refers to suppliers.id or customers.id depending on the type of third party.

If the bookkeeping entry is associated with a third party, thirdparty_id is its ID.
Otherwise, thirdparty_id is inherited from the document associated with the bookkeeping entry in case of 4xx (invoices) and 5xx (bank transactions) accounts.

label

character varying

Label of the transaction, as provided by the bank.

amount_eur

numeric

Amount of the transaction in EUR.

outstanding_balance

numeric

Current amount yet to be paid for the invoice linked with this transaction.

currency

character varying

Currency of the transaction.

currency_amount

numeric

Amount of the transaction in the currency of the transaction.

source

character varying

Source of the transaction.
Examples: "Fintecture", "Connectors", "Bridge", "Stripe"

is_potential_duplicate

boolean

This flag indicates if a transaction was detected as being a potential duplicate, I.E it has the same amount, same account and execution date as another transaction. In the transactions view, they are outlined when filtering on "duplicates".

sftp_ebics_files_filename

character varying

Filename of the SFTP EBICS file. Applicable only to transactions extracted from EBICS connectors.

sftp_ebics_files_created_at

timestamp without time zone

Creation date of the SFTP EBICS file.

accountants_view_status

character varying

Status of the transactions as visible in the accountants' view. Warning the status may not be the same on the SME side. Status are the following:
- "Waiting details"
- "Pre-processed"
- "To be processed"
- "Processed"
- "Deleted"

proof_status

character varying

Proof status of the transaction. Depends on whether a proof is required for the transaction, marked as lost, and on the number of supporting documents attached Status are the following:
- "available"
- "missing" (Proof not marked as lost or optional)
- "optional"
- "lost"

synchronized_at

timestamp without time zone

Date and time when the bank transaction was last synchronised with Pennylane's application.

deleted_at

timestamp without time zone

Date and time when the bank transaction was deleted. If the transaction is not deleted, the value is NULL.