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 *