Fields: Posting

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

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

  • type: (str)

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

  • 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.

  • filename: (str) The ledger where the posting is defined.

  • lineno: (int) The line number in the ledger file where the posting is defined.

  • location: (str) The filename:lineno location where the posting is defined.

  • flag: (str) The flag of the parent transaction for this posting.

  • payee: (str) The payee of the parent transaction for this posting.

  • narration: (str) The narration of the parent transaction for this posting.

  • description: (str) A combination of the payee + narration for the transaction of this posting.

  • tags: (set) The set of tags of the parent transaction for this posting.

  • links: (set) The set of links of the parent transaction for this posting.

  • posting_flag: (str) The flag of the posting itself.

  • account: (str) The account of the posting.

  • other_accounts: (set) The list of other accounts in the transaction, excluding that of this posting.

  • number: (decimal) The number of units of the posting.

  • currency: (str) The currency of the posting.

  • cost_number: (decimal) The number of cost units of the posting.

  • cost_currency: (str) The cost currency of the posting.

  • cost_date: (date) The cost currency of the posting.

  • cost_label: (str) The cost currency of the posting.

  • position: (position) The position for the posting. These can be summed into inventories.

  • price: (amount) The price attached to the posting.

  • weight: (amount) The computed weight used for this posting.

  • balance: (inventory) The balance for the posting. These can be summed into inventories.

  • meta: (dict)

  • entry: (transaction)

  • accounts: (set[str])