DBA Data[Home] [Help] [Dependency Information]

TABLE: BIM.BIM_R_FUND_BALANCE

Object Details
Object Name: BIM_R_FUND_BALANCE
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


This table is used to calculate the balance for each fund.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_FUND_BALANCE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUND_ID
ColumnWEEK_DATE
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE

Standarad who column
CREATED_BY DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LASTE_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
FUND_ID NUMBER
Yes Budget Identifier
WEEK_DATE DATE

start date for each week
CURRENT_AVAILABLE NUMBER

Available amount as of now
PAST_AVAILABLE NUMBER

Available amount as of previous run of the concurrent program
COMMITED NUMBER

Committed amount
COMMITED_SUM NUMBER

Total of comiited amount
CURRENT_BALANCE NUMBER

Current Balance
PAST_BALANCE NUMBER

Balance in the previous period
UTILIZED NUMBER

Utillized amount
FIS_MONTH VARCHAR2 (30)
Fiscal Period Month
FIS_QTR VARCHAR2 (30)
Fiscal Period Quarter
FIS_YEAR VARCHAR2 (30)
Fiscal Period Year
SECURITY_GROUP_ID NUMBER

This column is used in hosted environment
PLANNED NUMBER

planned amount
PAID NUMBER

paid amount
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LASTE_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FUND_ID
,      WEEK_DATE
,      CURRENT_AVAILABLE
,      PAST_AVAILABLE
,      COMMITED
,      COMMITED_SUM
,      CURRENT_BALANCE
,      PAST_BALANCE
,      UTILIZED
,      FIS_MONTH
,      FIS_QTR
,      FIS_YEAR
,      SECURITY_GROUP_ID
,      PLANNED
,      PAID
FROM BIM.BIM_R_FUND_BALANCE;

Dependencies

[top of page]

BIM.BIM_R_FUND_BALANCE does not reference any database object

BIM.BIM_R_FUND_BALANCE is referenced by following:

SchemaBIM
ViewBIM_R_FUND_BALANCE#