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
Domain diagrams
Expense_amortization
Invoice_with_amortization