ARM_BALANCE_TOTALS
This table stores the display values for various balance and transaction summaries and is needed for performance reasons. This table has a one-to-one relationship with ARM_RECONCILIATIONS; there is one row in ARM_BALANCE_TOTALS for each reconciliation. You join to ARM_RECONCILIATIONS using the PROFILE_ID and PERIOD_ID columns.
The ARM_BALANCE_TOTALS table has a column for each balance type/bucket combination, and the column is named with the Balance Type + Bucket ID combination. The bucket IDs are 100001, 100002, and 100003 corresponding to the lowest, middle and highest bucket (Entered, Functional, Reporting). For example, the BSRC10001 column stores the Source System Balance in the lowest (Entered) currency for the reconciliation, and SRC100003 column stores the Adjustments to Source System at the Reporting level for the reconciliation.
Note:
The balance types in ARM_BALANCE_TOTALS match identically to the balance types in the old ARM_SUMMARY_AMOUNTS table.Details
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
ARM_BALANCE_TOTAL_PK |
TOTAL_ID |
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
TOTAL_ID |
NUMBER |
18 |
0 |
No |
Primary Key |
|
|
PROFILE_ID |
VARCHAR2 |
1000 |
No |
The Profile ID |
||
|
PERIOD_ID |
NUMBER |
18 |
0 |
No |
The Period ID |
|
|
BSRC100001 |
VARCHAR2 |
4000 |
Yes |
Source System Balance Entered |
||
|
BSRC100002 |
VARCHAR2 |
4000 |
Yes |
Source System Balance Functional |
||
|
BSRC100003 |
VARCHAR2 |
4000 |
Yes |
Source System Balance Reporting |
||
|
BSUB100001 |
VARCHAR2 |
4000 |
Yes |
Sub System Balance Entered |
||
|
BSUB100002 |
VARCHAR2 |
4000 |
Yes |
Sub System Balance Functional |
||
|
BSUB100003 |
VARCHAR2 |
4000 |
Yes |
Sub System Balance Reporting |
||
|
BEX100001 |
VARCHAR2 |
4000 |
Yes |
Balance Explanations Entered |
||
|
BEX100002 |
VARCHAR2 |
4000 |
Yes |
Balance Explanations Functional |
||
|
BEX100003 |
VARCHAR2 |
4000 |
Yes |
Balance Explanations Reporting |
||
|
SRC100001 |
VARCHAR2 |
4000 |
Yes |
Adjustments to Source Entered |
||
|
SRC100002 |
VARCHAR2 |
4000 |
Yes |
Adjustments to Source Functional |
||
|
SRC100003 |
VARCHAR2 |
4000 |
Yes |
Adjustments to Source Reporting |
||
|
SUB100001 |
VARCHAR2 |
4000 |
Yes |
Adjustments to Sub System Entered |
||
|
SUB100002 |
VARCHAR2 |
4000 |
Yes |
Adjustments to Sub System Functional |
||
|
SUB100003 |
VARCHAR2 |
4000 |
Yes |
Adjustments to Sub System Reporting |
||
|
VEX100001 |
VARCHAR2 |
4000 |
Yes |
Variance Explanations Entered |
||
|
VEX100002 |
VARCHAR2 |
4000 |
Yes |
Variance Explanations Functional |
||
|
VEX100003 |
VARCHAR2 |
4000 |
Yes |
Variance Explanations Reporting |
||
|
TM1100001 |
VARCHAR2 |
4000 |
Yes |
Source System Unmatched Supported Entered |
||
|
TM1100002 |
VARCHAR2 |
4000 |
Yes |
Source System Unmatched Supported Functional |
||
|
TM1100003 |
VARCHAR2 |
4000 |
Yes |
Source System Unmatched Supported Reporting |
||
|
TM2100001 |
VARCHAR2 |
4000 |
Yes |
Source System Unmatched Entered |
||
|
TM2100002 |
VARCHAR2 |
4000 |
Yes |
Source System Unmatched Functional |
||
|
TM2100003 |
VARCHAR2 |
4000 |
Yes |
Source System Unmatched Reporting |
||
|
TM3100001 |
VARCHAR2 |
4000 |
Yes |
Source System Matched In Transit Entered |
||
|
TM3100002 |
VARCHAR2 |
4000 |
Yes |
Source System Matched In Transit Functional |
||
|
TM3100003 |
VARCHAR2 |
4000 |
Yes |
Source System Matched In Transit Reporting |
||
|
TM4100001 |
VARCHAR2 |
4000 |
Yes |
Sub System Unmatched Supported Entered |
||
|
TM4100002 |
VARCHAR2 |
4000 |
Yes |
Sub System Unmatched Supported Functional |
||
|
TM4100003 |
VARCHAR2 |
4000 |
Yes |
Sub System Unmatched Supported Reporting |
||
|
TM5100001 |
VARCHAR2 |
4000 |
Yes |
Sub System Unmatched Entered |
||
|
TM5100002 |
VARCHAR2 |
4000 |
Yes |
Sub System Unmatched Functional |
||
|
TM5100003 |
VARCHAR2 |
4000 |
Yes |
Sub System Unmatched Reporting |
||
|
TM6100001 |
VARCHAR2 |
4000 |
Yes |
Sub System Matched In Transit Entered |
||
|
TM6100002 |
VARCHAR2 |
4000 |
Yes |
Sub System Matched In Transit Functional |
||
|
TM6100003 |
VARCHAR2 |
4000 |
Yes |
Sub System Matched In Transit Reporting |
||
|
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_BALANCE_TOTAL_N1 |
NONUNIQUE |
PROFILE_ID, PERIOD_ID |