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

TABLE: BIM.BIM_R_FUND_DAILY_FACTS

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


This table keeps 90 dyas of fund facts


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_FUND_DAILY_FACTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUND_TRANSACTION_ID
BIM_R_FUND_DAILY_FACTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_CREATE_DATE
ColumnFUND_ID
Columns
Name Datatype Length Mandatory Comments
FUND_TRANSACTION_ID NUMBER
Yes unique identifier
CREATION_DATE DATE
Yes standard who column
CREATED_BY NUMBER
Yes standard who column
LAST_UPDATE_DATE DATE
Yes standard who column
LAST_UPDATED_BY NUMBER
Yes standard who column
LAST_UPDATE_LOGIN NUMBER
Yes standard who column
FUND_ID NUMBER
Yes id for fund
PARENT_FUND_ID NUMBER

parent fund id for fund
FUND_NUMBER VARCHAR2 (30)
fund number for fund
START_DATE DATE

fund start date
END_DATE DATE

fund end date
START_PERIOD VARCHAR2 (30)
fund start period
END_PERIOD VARCHAR2 (30)
fund end period
SET_OF_BOOKS_ID NUMBER

set of books id for fund
FUND_TYPE VARCHAR2 (30)
fund type for fund
REGION VARCHAR2 (30)
region where fund is issued
COUNTRY VARCHAR2 (30)
country where fund is issued
CATEGORY_ID NUMBER

fund category id
STATUS VARCHAR2 (30)
fund status
ORIGINAL_BUDGET NUMBER

original budget for fund
TRANSFER_IN NUMBER

amount of fund transfer in
TRANSFER_OUT NUMBER

amount fo fund transfer out
HOLDBACK_AMT NUMBER

amount of fund hold back
CURRENCY_CODE_FC VARCHAR2 (15)
currecency code
DELETE_FLAG VARCHAR2 (1)
delete flag are used when records need to be deleted
TRANSACTION_CREATE_DATE DATE
Yes Creation date of the transaction.
LOAD_DATE DATE

This column provides the week end date of the transaction create date.
ORG_ID NUMBER

organization id
SECURITY_GROUP_ID NUMBER

This column is used in hosted environments
FIS_MONTH VARCHAR2 (30)
Fiscal period month
FIS_QTR VARCHAR2 (30)
Fiscal period quarter
FIS_YEAR VARCHAR2 (30)
Fiscal period year
BUSINESS_UNIT_ID NUMBER

business_unit_id
Query Text

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


SELECT FUND_TRANSACTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FUND_ID
,      PARENT_FUND_ID
,      FUND_NUMBER
,      START_DATE
,      END_DATE
,      START_PERIOD
,      END_PERIOD
,      SET_OF_BOOKS_ID
,      FUND_TYPE
,      REGION
,      COUNTRY
,      CATEGORY_ID
,      STATUS
,      ORIGINAL_BUDGET
,      TRANSFER_IN
,      TRANSFER_OUT
,      HOLDBACK_AMT
,      CURRENCY_CODE_FC
,      DELETE_FLAG
,      TRANSACTION_CREATE_DATE
,      LOAD_DATE
,      ORG_ID
,      SECURITY_GROUP_ID
,      FIS_MONTH
,      FIS_QTR
,      FIS_YEAR
,      BUSINESS_UNIT_ID
FROM BIM.BIM_R_FUND_DAILY_FACTS;

Dependencies

[top of page]

BIM.BIM_R_FUND_DAILY_FACTS does not reference any database object

BIM.BIM_R_FUND_DAILY_FACTS is referenced by following:

SchemaAPPS
SynonymBIM_R_FUND_DAILY_FACTS