#	Column Name	Nullable	Data Type	Max Length	Description
1	transaction_detail_id		bigint	0
2	transaction_master_id		bigint	0
3	value_date		date	0
4	tran_type		transaction_type	0
5	account_id		bigint	0	Foreign key to the table core.accounts.
6	statement_reference		text	0
7	cash_repository_id		integer	0
8	currency_code		character varying	12	Foreign key to the table core.currencies.
9	amount_in_currency		money_strict	0
10	local_currency_code		character varying	12
11	er		decimal_strict	0
12	amount_in_local_currency		money_strict	0
13	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
14	audit_ts		timestamp with time zone	0	Contains the date and timestamp of the last insert or update action.

Foreign Keys

#	Column Name	Key Name	References
2	transaction_master_id	transaction_details_transaction_master_id_fkey	transactions.transaction_master.transaction_master_id
5	account_id	transaction_details_account_id_fkey	core.accounts.account_id
7	cash_repository_id	transaction_details_cash_repository_id_fkey	office.cash_repositories.cash_repository_id
8	currency_code	transaction_details_currency_code_fkey	core.currencies.currency_code
10	local_currency_code	transaction_details_local_currency_code_fkey	core.currencies.currency_code
13	audit_user_id	transaction_details_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
transaction_details_pkey	postgres	btree	transaction_detail_id

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	transaction_detail_id	nextval('transactions.transaction_details_transaction_detail_id_seq'::regclass)
14	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description
transactions.restrict_delete_trigger	transactions.restrict_delete_trigger	DELETE	BEFORE		0	ROW
transactions.check_cash_balance_trigger	transactions.check_cash_balance_trigger	UPDATE	BEFORE		0	ROW
transactions.check_cash_balance_trigger	transactions.check_cash_balance_trigger	INSERT	BEFORE		0	ROW