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

Expense_amortization
Invoice_with_amortization