tx_aged

A description of the age of a (debit) transaction with respect to being fully balanced by a credit transaction.

Column name	Description	Data type
ledger_date		date
reporting_date	Primary key.	date
due_date		date *
allocated_date		date *
age_in_periods		integer *
tx	Primary key. Reference to `tx`.	integer
company	Reference to `company`. Reference to `currency`.	smallint
tx_detail	Reference to `tx_detail`.	integer *
account	Reference to `account`.	integer
tx_type	Reference to `tx_type`.	smallint
tx_number		text
ledge_time		timestamp with time zone *
currency	Reference to `currency`.	character varying (3) *
amount		numeric
tax_amount		numeric
unallocated_amount		numeric *
creating_operator	Reference to `operator`.	integer
creation_time		timestamp with time zone *
comments		text *
reporting_account	Reference to `reporting_account`.	integer *
payment_plan	Reference to `payment_plan`.	integer *
tx_disposition	Reference to `tx_disposition`.	integer *
referenced_tx	Reference to `tx`.	integer *