tx

Represents a financial transaction on an account.

Column name Description Data type
tx Primary key. integer
company Reference to company.

Reference to currency.

smallint
tx_detail If the transaction is itemised, this will refer to the header record of the tx items. If it is not itemised this value will be null.

Reference to tx_detail.

integer *
account Reference to account. integer
tx_type Reference to tx_type. smallint
tx_number A public unique number identifying this transaction. text
ledger_date   date
ledger_time   timestamp with time zone *
currency Reference to currency. character varying (3) *
amount   numeric
tax_amount   numeric
unallocated_amount The amount of this transaction that has not been balanced by another transaction. numeric
creating_operator Reference to operator. integer
creation_time   timestamp with time zone *
comments   text *
reporting_account If the transaction is not itemised, this is the reporting account that should be used. Otherwise use the reporting account from tx_item.

Reference to reporting_account.

integer *
payment_plan Reference to payment_plan. integer *
tx_disposition Reference to tx_disposition. integer *
referenced_tx If this transaction refers to another, for example it is a reversal of another, then the other transaction is listed here.

Reference to tx.

integer *