ARM_BALANCE_SUMMARIES (VIEW)

This view stores the Source and Sub-system balances that are shown on the Reconciliation Balances list.

Details

Object type: VIEW

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
PERIOD_ID	NUMBER		18	0	No	The ARM period ID.
PROFILE_ID	VARCHAR2	4000			No	The profile segment ID (it is from ARM_Reconciliations.RECONCILIATION_ACCOUNT_ID)
BALANCE_TYPE	NUMBER		1	0	No	The ARM balance types: 1=Source system or 2=Sub-system)
BUCKET_ID	NUMBER		18	0	No	ID of the currency bucket
CURRENCY	VARCHAR2	80			No	The currency key such as USD, CAD, or Yen.
AMOUNT	NUMBER				Yes	The component account's aggregated balance.
LAST_UPDATE_DATE	DATE				Yes	Who column. Stores the date when this row was last updated.
CREATION_DATE	DATE				Yes	Who column. Stores the date when this row was created in the database.