ARM_BALANCES
This table stores the Source and Sub-system balances that are shown in the Reconciliation Balances list.
Details
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
ARM_BALANCES_PK |
PERIOD_ID, PROFILE_ID, BALANCE_TYPE, BUCKET_ID, CURRENCY, LOCATION_ID |
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
PROFILE_ID |
VARCHAR2 |
1000 |
No |
The profile segment ID (it is from ARM_RECONCILIATIONS.RECONCILIATION_ACCOUNT_ID) |
||
|
PERIOD_ID |
NUMBER |
18 |
0 |
No |
The ARM period ID. |
|
|
BUCKET_ID |
NUMBER |
18 |
0 |
No |
ID of the currency bucket |
|
|
BALANCE_TYPE |
NUMBER |
1 |
0 |
No |
The ARM balance type (1=Source system or 2=Sub-system) |
|
|
LOCATION_ID |
NUMBER |
10 |
0 |
No |
The location ID in Data Management. |
|
|
CURRENCY |
VARCHAR2 |
80 |
No |
The currency key such as USD, CAD, or Yen. |
||
|
AMOUNT |
NUMBER |
38 |
12 |
No |
The component account's aggregated balance. |
|
|
UPDATED_FLAG |
VARCHAR2 |
1 |
Yes |
Update flag: U-update, I-insert, N-none |
||
|
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_UPDATED_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. |
|||
|
SOURCE_LABEL |
VARCHAR2 |
300 |
Yes |
|||
|
FROM_FLAG |
VARCHAR2 |
1 |
Yes |
Where transaction came from: M=Manually entered by user, I=Imported from Recon Action dialog,P=Imported with Pre-mapped account ID, F=FDMEE data load. |
||
|
FUNCTIONAL_RATE |
NUMBER |
Yes |
The functional rate |
|||
|
REPORTING_RATE |
NUMBER |
Yes |
The reporting rate |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
|
ARM_BALANCES_TOTAL_U1 |
UNIQUE |
PROFILE_ID, PERIOD_ID |
|
ARM_BALANCES_N1 |
NONUNIQUE |
BUCKET_ID, CURRENCY |
|
ARM_BALANCES_N2 |
NONUNIQUE |
PERIOD_ID |
|
ARM_BALANCES_N3 |
NONUNIQUE |
PERIOD_ID, PROFILE_ID, BUCKET_ID |
|
ARM_BALANCES_N4 |
NONUNIQUE |
PERIOD_ID, PROFILE_ID, BALANCE_TYPE, BUCKET_ID |