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. |