[Home] [Help] [Dependency Information]
Object Name: | BIM_R_FUND_WEEKLY_FACTS# |
---|---|
Object Type: | VIEW |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FUND_TRANSACTION_ID | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
FUND_ID | NUMBER | Yes | ||
PARENT_FUND_ID | NUMBER | |||
FUND_NUMBER | VARCHAR2 | (30) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
START_PERIOD | VARCHAR2 | (30) | ||
END_PERIOD | VARCHAR2 | (30) | ||
SET_OF_BOOKS_ID | NUMBER | |||
FUND_TYPE | VARCHAR2 | (30) | ||
REGION | VARCHAR2 | (30) | ||
COUNTRY | VARCHAR2 | (30) | ||
CATEGORY_ID | NUMBER | |||
STATUS | VARCHAR2 | (30) | ||
ORIGINAL_BUDGET | NUMBER | |||
TRANSFER_IN | NUMBER | |||
TRANSFER_OUT | NUMBER | |||
HOLDBACK_AMT | NUMBER | |||
CURRENCY_CODE_FC | VARCHAR2 | (15) | ||
DELETE_FLAG | VARCHAR2 | (1) | ||
TRANSACTION_CREATE_DATE | DATE | Yes | ||
LOAD_DATE | DATE | |||
ORG_ID | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | |||
FIS_MONTH | VARCHAR2 | (30) | ||
FIS_QTR | VARCHAR2 | (30) | ||
FIS_YEAR | VARCHAR2 | (30) | ||
BUSINESS_UNIT_ID | NUMBER |
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#;
|
|
|