[Home] [Help] [Dependency Information]
Object Name: | BIM_R_FUND_DIMSUM |
---|---|
Object Type: | TABLE |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
This table is used for creating Fund level Materialized view
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATION_DATE | DATE | Standard who column | ||
CREATED_BY | NUMBER | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | DATE | Standard who column | ||
LAST_UPDATE_LOGIN | DATE | Standard who column | ||
FUND_ID | NUMBER | Fund Identifier | ||
FUND_NAME | VARCHAR2 | (240) | Fund Name | |
PARENT_FUND_ID | NUMBER | Parent of the default fund | ||
FUND_NUMBER | VARCHAR2 | (30) | Fund Number | |
START_DATE | DATE | Start date of the fund | ||
END_DATE | DATE | ENd Date of the fund | ||
START_PERIOD | VARCHAR2 | (30) | Start period of the Fund | |
END_PERIOD | VARCHAR2 | (30) | End period of the fund | |
FUND_TYPE | VARCHAR2 | (30) | Type of the fund | |
AREA1_CODE | VARCHAR2 | (30) | Region of the fund | |
AREA2_CODE | VARCHAR2 | (30) | Regions Next Level | |
COUNTRY_CODE | VARCHAR2 | (30) | Country Code of the fund | |
CATEGORY_ID | NUMBER | Category of the fund | ||
STATUS | VARCHAR2 | (30) | Status of the fund | |
MONTH | VARCHAR2 | (30) | Month in which we are interested | |
QTR | VARCHAR2 | (30) | Quarter in which we are interested | |
YEAR | VARCHAR2 | (30) | Year in which we are interested | |
AGGREGATE_BY | VARCHAR2 | (9) | Aggregate type of the period | |
ORIGINAL_BUDGET | NUMBER | Original Budget | ||
HOLDBACK_AMT | NUMBER | Hold back amount of the fund | ||
CURRENCY_CODE_FC | VARCHAR2 | (15) | Functional Currency code of the Fund | |
TOTAL_BUDGET | NUMBER | Total Budget amount | ||
AVAILABLE_BUDGET | NUMBER | Available Budget | ||
BALANCE | NUMBER | Balance Budget | ||
PRE_BALANCE | NUMBER | Balance in the previous period | ||
COMMITTED | NUMBER | Committed Amount | ||
PRE_COMMITTED | NUMBER | Committed in the previous period | ||
UTILIZED | NUMBER | Utilized amount | ||
PRE_UTILIZED | NUMBER | Utilized in the previous period | ||
DISPLAY_TYPE | VARCHAR2 | (7) | Display type by the period (Aggregate Increment can have 5 display types - daily, weekly, monthly, quarterly,yearly) | |
BUSINESS_UNIT_ID | NUMBER | business unit it of fund | ||
PLANNED | NUMBER | planned amount | ||
PAID | NUMBER | paid amount |
Cut, paste (and edit) the following text to query this object:
SELECT CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, FUND_ID
, FUND_NAME
, PARENT_FUND_ID
, FUND_NUMBER
, START_DATE
, END_DATE
, START_PERIOD
, END_PERIOD
, FUND_TYPE
, AREA1_CODE
, AREA2_CODE
, COUNTRY_CODE
, CATEGORY_ID
, STATUS
, MONTH
, QTR
, YEAR
, AGGREGATE_BY
, ORIGINAL_BUDGET
, HOLDBACK_AMT
, CURRENCY_CODE_FC
, TOTAL_BUDGET
, AVAILABLE_BUDGET
, BALANCE
, PRE_BALANCE
, COMMITTED
, PRE_COMMITTED
, UTILIZED
, PRE_UTILIZED
, DISPLAY_TYPE
, BUSINESS_UNIT_ID
, PLANNED
, PAID
FROM BIM.BIM_R_FUND_DIMSUM;
BIM.BIM_R_FUND_DIMSUM does not reference any database object
BIM.BIM_R_FUND_DIMSUM is referenced by following:
|
|
|