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

Domains
Expense_amortization
Invoice_with_amortization

Domain diagrams