Amortization_schedules
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
amount |
NUMBER |
|
20 |
2 |
|
|
Amount |
initial_amount |
VARCHAR2 |
42 |
|
|
|
|
Initial amount |
is_template |
VARCHAR2 |
1 |
|
|
|
|
Is template |
name |
VARCHAR2 |
40 |
|
|
|
|
Schedule name |
period_offset |
NUMBER |
|
10 |
0 |
|
|
Period offset |
residual |
VARCHAR2 |
42 |
|
|
|
|
Residual |
schedule_id |
NUMBER |
|
39 |
0 |
|
|
Amortization schedule ID |
schedule_method |
VARCHAR2 |
56 |
|
|
|
|
Method |
schedule_number |
VARCHAR2 |
99 |
|
|
|
|
Amortization schedule number |
schedule_type |
VARCHAR2 |
8 |
|
|
|
|
Type |
start_offset |
NUMBER |
|
39 |
0 |
|
|
Start offset |
term_source |
VARCHAR2 |
16 |
|
|
|
|
Term source |
Primary key
PK Column Name |
schedule_id |
Foreign keys referencing this table
FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
Amortization_sched_lines_amortization_schedules_fk |
schedule_id |
Amortization_sched_lines |
schedule_id |
1 |
This table is included in the following domains
Domain diagrams
Expense_amortization
Invoice_with_amortization