Amortization_sched_lines

Columns

Name	Type	Length	Precision	Scale	References	In	Description
account_id	NUMBER		39	0	account_id	Accounts	Account ID
accounting_period_id	NUMBER		39	0	accounting_period_id	Accounting_periods	Accounting period ID
amount	VARCHAR2	42					Amount
is_recognized	VARCHAR2	3					Whether the amount is recognized
journal_id	NUMBER		39	0	transaction_id	Transactions	Journal ID
schedule_id	NUMBER		39	0	schedule_id	Amortization_schedules	Amortization schedule ID

Primary key (Composite)

PK Column Name
schedule_id
journal_id
account_id
accounting_period_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
amortization_sched_lines_accounting_periods_fk	accounting_period_id	Accounting_periods	accounting_period_id	1
amortization_sched_lines_accounts_fk	account_id	Accounts	account_id	1
amortization_sched_lines_amortization_schedules_fk	schedule_id	Amortization_schedules	schedule_id	1
amortization_sched_lines_transactions_fk	journal_id	Transactions	transaction_id	1

This table is included in the following domains

Domains
Expense_amortization
Invoice_with_amortization

Domain diagrams