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 :doc:`functions_index`. * **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])