eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BIM.BIM_R_FUND_WEEKLY_FACTS

Object Details

Object Name:	BIM_R_FUND_WEEKLY_FACTS
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

This table keeps weekly fund facts

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_R_FUND_WEEKLY_FACTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FUND_TRANSACTION_ID
BIM_R_FUND_WEEKLY_FACTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_CREATE_DATE

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			standard who column
FUND_ID	NUMBER		Yes	id for the fund
PARENT_FUND_ID	NUMBER			parent id for fund
FUND_NUMBER	VARCHAR2	(30)		fund number
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)		type for fund
REGION	VARCHAR2	(30)		region where the fund was issued
COUNTRY	VARCHAR2	(30)		country where the fund is issued
CATEGORY_ID	NUMBER			category id for fund
STATUS	VARCHAR2	(30)		fund status
ORIGINAL_BUDGET	NUMBER			amount of original buget for fund
TRANSFER_IN	NUMBER			amount of transfer in for fund
TRANSFER_OUT	NUMBER			fund transfer out
HOLDBACK_AMT	NUMBER			amount fund holdback
CURRENCY_CODE_FC	VARCHAR2	(15)		currency 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			Bussiness Unit Identifier

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_WEEKLY_FACTS;

Dependencies

[top of page]

BIM.BIM_R_FUND_WEEKLY_FACTS does not reference any database object

BIM.BIM_R_FUND_WEEKLY_FACTS is referenced by following:

APPS: BIM_R_FUND_WEEKLY_FACTS