ARM_AMORTIZATIONS

This table stores the amortization information for transactions.

Details

Object type: TABLE

Primary Key

Name	Columns
ARM_AMORTIZATIONS_PK	TRANSACTION_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
TRANSACTION_ID	NUMBER		18	0	No	Foreign key to ARM_TRANSACTIONS
METHOD	VARCHAR2	1			No	A=Actual, S=Straight-line or C=custom
START_PERIOD	NUMBER		18	0	Yes	Starting period for Straight-line or Custom
NUM_PERIODS	NUMBER				Yes	Number of periods for the amortization
ORIGINAL_AMOUNT_BUCKET1	NUMBER		29	12	Yes	Original amount entered by the user in bucket 1
ORIGINAL_AMOUNT_BUCKET2	NUMBER		29	12	Yes	Original amount entered by the user in bucket 2
ORIGINAL_AMOUNT_BUCKET3	NUMBER		29	12	Yes	Original amount entered by the user in bucket 3
START_DATE	DATE				Yes	Start date used for the Actual method
END_DATE	DATE				Yes	End date used for the Actual method
HALF_MONTH_CONVENTION	VARCHAR2	1			No	Y for using half-month convention
OBJECT_VERSION_NUMBER	NUMBER		9	0	No	Used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATE_LOGIN	NUMBER				Yes	Who column. Stores the login/session ID of the user who last updated this row.
LAST_UPDATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who last updated this row.
LAST_UPDATE_DATE	DATE				No	Who column. Stores the date when this row was last updated.
CREATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who created this row.
CREATION_DATE	DATE				No	Who column. Stores the date when this row was created in the database.

Indexes

Index	Uniqueness	Columns
ARM_AMORTIZATIONS_PK	UNIQUE	TRANSACTION_ID