TM_BALANCE_SUMMARY

This table stores the Transaction Matching pre-calculated balance summary for each period.

Details

Object type: TABLE

Primary Key

Name	Columns
TM_BALANCE_SUMMARY_PK	PROFILE_ID
TM_BALANCE_SUMMARY_PK	PERIOD_ID
TM_BALANCE_SUMMARY_PK	BALANCE_TYPE
TM_BALANCE_SUMMARY_PK	BUCKET_ID
TM_BALANCE_SUMMARY_PK	CURRENCY

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
PROFILE_ID	VARCHAR2	4000			No	Account ID of the profile/reconciliation
PERIOD_ID	NUMBER		18	0	No	Period ID
BUCKET_ID	NUMBER		18	0	No	Currency bucket ID
BALANCE_TYPE	NUMBER		1	0	No	Balance Type: 1=Unmatched Total (Source System), 2=Unmatched Supported (Source System),3= In Transit Total (Source System), 4=Unmatched Total (Sub System), 5=Unmatched Supported (Sub System), 6=In Transit Total (Sub System)
CURRENCY	VARCHAR2	80			No	Currency
AMOUNT	NUMBER		29	12	No	Balance Amount
OBJECT_VERSION_NUMBER	NUMBER		9	0	No	Used to implement optimistic locking. This number is incremented every time that 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_UPDATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who last updated this row.
LAST_UPDATE_DATE	TIMESTAMP(6)				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	TIMESTAMP(6)				No	Who column. Stores the date when this row was created in the database.
UPDATED_FLAG	VARCHAR2	1			No	Indicates if the balance was updated. Y = Updated and N = Not Updated. The default setting is Y.

Indexes

Index	Uniqueness	Columns
TM_BALANCE_SUMMARY_N1	NONUNIQUE	PERIOD_ID
TM_BALANCE_SUMMARY_PK	UNIQUE	PROFILE_ID, PERIOD_ID, BALANCE_TYPE, BUCKET_ID, CURRENCY