ARM_SUMMARY_AMOUNTS

This table is no longer used. See ARM_BALANCE_TOTALS instead.

This table stores the display values for various balance and transaction summaries. Needed for performance reasons.

Details

Object type: TABLE

Primary Key

Name	Columns
ARM_SUMMARY_AMOUNTS_PK	SUMMARY_AMOUNT_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
SUMMARY_AMOUNT_ID	NUMBER		18	0	No	Primary Key
RECONCILIATION_ACCOUNT_ID	VARCHAR2	4000			No	The Account ID
PERIOD_ID	NUMBER		18	0	No	The Period ID
BUCKET_ID	NUMBER		18	0	No	The Bucket ID
SUMMARY_TYPE	VARCHAR2	4			No	Types: BSRC=Balance Source System, BSUB=Balance Sub System, SRC=Adjustment to Source System, SUB=Adjustment to Sub System, BEX=Balance Explanation
AMOUNTS	VARCHAR2	4000			Yes	The amounts broken up by currencies.
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_SUMMARY_AMOUNTS_N1	NONUNIQUE	PERIOD_ID
ARM_SUMMARY_AMOUNTS_PK	UNIQUE	SUMMARY_AMOUNT_ID
ARM_SUMMARY_AMOUNTS_U1	UNIQUE	PERIOD_ID, RECONCILIATION_ACCOUNT_ID, BUCKET_ID, SUMMARY_TYPE