ARM_SUMMARY_BALANCES

This table stores the child balance amount information for a summary reconciliation.

Details

Object type: TABLE

Primary Key

Name	Columns
ARM_SUMMARY_BALANCES_PK	RECONCILIATION_ID
ARM_SUMMARY_BALANCES_PK	CHILD_RECON_ACCOUNT_ID
ARM_SUMMARY_BALANCES_PK	BALANCE_TYPE

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
RECONCILIATION_ID	NUMBER		18	0	No	ID of the summary profile/reconciliation
CHILD_RECON_ACCOUNT_ID	VARCHAR2	4000			No	Account ID of the child profile/reconciliation
BALANCE_TYPE	VARCHAR2	4			No	The balance type: BEX SRC=Adjustments to source system, SUB=Adjustments to subsystem, BSRC=Source system balance, BSUB=Subsystem balance.
AMOUNT	NUMBER		29	12	No	The amount
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_SUMMARY_BALANCES_N1	NONUNIQUE	RECONCILIATION_ID, BALANCE_TYPE
ARM_SUMMARY_BALANCES_PK	UNIQUE	RECONCILIATION_ID, CHILD_RECON_ACCOUNT_ID, BALANCE_TYPE