ARM_BALANCE_DETAIL_SUMMARY (VIEW)
This view stores the Source and Sub-system balances that are shown on the Detail Balances list.
Details
Object type: VIEW
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
BALANCE_ID |
NUMBER |
Yes |
ID of the currency bucket |
|||
|
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 |
15 |
No |
The currency key such as USD, CAD, or Yen. |
||
|
AMOUNT |
NUMBER |
Yes |
The component account's aggregated balance |
|||
|
UD2X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD2 dimension |
||
|
UD3X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD3 dimension |
||
|
UD4X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD4 dimension |
||
|
UD5X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD5 dimension |
||
|
UD6X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD6 dimension |
||
|
UD7X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD7 dimension |
||
|
UD8X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD8 dimension |
||
|
UD9X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD9 dimension |
||
|
UD10X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD10 dimension |
||
|
UD11X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD11 dimension |
||
|
UD12X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD12 dimension |
||
|
UD13X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD13 dimension |
||
|
UD14X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD14 dimension |
||
|
UD15X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD15 dimension |
||
|
UD16X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD16 dimension |
||
|
UD17X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD17 dimension |
||
|
UD18X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD18 dimension |
||
|
UD19X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD19 dimension |
||
|
UD20X |
VARCHAR2 |
300 |
Yes |
Sub-segment value that maps to UD20 dimension |
||
|
CREATION_DATE |
DATE |
Yes |
Who column. Stores the date when this row was created in the database. |
|||
|
LAST_UPDATE_DATE |
DATE |
Yes |
Who column. Stores the date when this row was last updated. |