bank_accounts
NEW
In short
Bank accounts connected to Pennylane. This table includes basic account information, balances and data synchronization status.
Available Columns
id
bigint
Unique identifier of the bank account.
company_id
bigint
Unique ID of the company on Pennylane, referring to companies.id.
company_name
character varying
Name of the company on Pennylane.
establishment_id
bigint
Unique ID of banking establishment holding the account.
establishment_name
character varying
Name of the banking establishment holding the account.
name
character varying
Name of the bank account on Pennylane.
accounting_plan_item_id
bigint
Unique identifier of the bookkeeping account associated with the bank account.
accounting_plan_item_number
character varying
Bookkeeping account number associated with the bank account (starting with 512).
Examples: "5121008", "512000002"
accounting_plan_item_label
character varying
Label of the bookkeeping account associated with the bank account.
Examples: "Banque Nationale de Paris", "CREDIT AGRICOLE"
currency
character varying
Currency of the bank account.
Examples: "EUR", "USD"
is_visible
boolean
This flag indicates if the bank account is marked as visible in the Pennylane interface.
is_synchronized
boolean
This flag indicates if the bank account is set to be synchronized automatically with Pennylane.
balance
double precision
Current balance of the bank account, as provided by the bank.
last_sync_success
boolean
This flag indicates if the last synchronization of the bank account was successful. The value can be NULL in case the bank account has never been synchronized.
last_sync_at
timestamp without time zone
Date and time of the last synchronization of the bank account in Pennylane. This value can be NULL in case the bank account has never been synchronized.
created_at
timestamp without time zone
Date and time of the creation of the bank account in Pennylane.
updated_at
timestamp without time zone
Date and time of the last update of the bank account in Pennylane.