Targets: Entry

This is the list of all the fields you can use in the SELECT … clause and the FROM … clause of a BQL query.

For available functions and aggregates to use with these columns, see BQL Functions by Category.

• id: (str) Unique id of a directive.

• type: (str) The data type of the directive. Currently, beanquery only can list the directives of type ‘transaction’.

• filename: (str) The filename where the directive was parsed from or created.

• lineno: (int) The line number from the file the directive was parsed from.

• date: (date) The date of the directive.

• year: (int) The year of the date year of the directive.

• month: (int) The year of the date month of the directive.

• day: (int) The year of the date day of the directive.

• flag: (str) The flag the transaction.

• payee: (str) The payee of the transaction.

• narration: (str) The narration of the transaction.

• description: (str) A combination of the payee + narration of the transaction, if present.

• tags: (set) The set of tags (#abc) of the transaction.

• links: (set) The set of links (^abc) of the transaction.

• meta: (dict) The metadata of the transaction.

• accounts: (set[str]) The set of accounts of the transaction.