Transaction_tax_detail

Columns

Name	Type	Length	Precision	Scale	References	In	Description
account_id	NUMBER		39	0	account_id	Accounts	Account ID
amount	NUMBER		20	2			Amount
amount_foreign	NUMBER		20	2			Amount in foreign currency
amount_net	NUMBER		23	5			Net amount
calculation_comment	VARCHAR2	65534					Calculation Comment
tax_basis_amount	NUMBER		39	0			Tax basis amount
tax_item_id	NUMBER		39	0	item_id item_id	Items Tax_items	Tax item ID
tax_rate	NUMBER		21	11			Tax rate
tax_type	VARCHAR2	5					Tax type
transaction_id	NUMBER		39	0	transaction_id	Transaction_lines	Transaction ID
transaction_line_id	NUMBER		39	0	transaction_line_id	Transaction_lines	Transaction line ID

Primary key (Composite)

PK Column Name
transaction_id
transaction_line_id
tax_item_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
transaction_tax_detail_accounts_fk	account_id	Accounts	account_id	1
transaction_tax_detail_items_fk	tax_item_id	Items	item_id	1
transaction_tax_detail_tax_items_fk	tax_item_id	Tax_items	item_id	1
transaction_tax_detail_transaction_lines_fk	transaction_id	Transaction_lines	transaction_id	1
transaction_tax_detail_transaction_lines_fk	transaction_line_id	Transaction_lines	transaction_line_id	2

This table is included in the following domains

Domains
General_accounting

Domain diagrams