[Home] [Help] [Dependency Information]
Object Name: | BIM_I_BUDGET_FACTS_STG |
---|---|
Object Type: | TABLE |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
Staging table for Budget Facts
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FUND_ID | NUMBER | Fund ID | ||
PARENT_FUND_ID | NUMBER | Parent Fund ID | ||
FUND_NUMBER | VARCHAR2 | (30) | Fund Number | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
START_PERIOD | VARCHAR2 | (30) | Start Date | |
END_PERIOD | VARCHAR2 | (30) | End Period | |
SET_OF_BOOKS_ID | NUMBER | Set of Books ID | ||
FUND_TYPE | VARCHAR2 | (30) | Fund Type | |
REGION | VARCHAR2 | (30) | Region | |
COUNTRY | VARCHAR2 | (30) | Country | |
CATEGORY_ID | NUMBER | Category ID | ||
STATUS | VARCHAR2 | (30) | Status | |
BUSINESS_UNIT_ID | NUMBER | Business unit ID | ||
DELETE_FLAG | VARCHAR2 | (1) | Delete Flag | |
METRIC_TYPE | VARCHAR2 | (30) | Metric Type | |
TRANSACTION_CREATE_DATE | DATE | Transaction Create Date | ||
ORIGINAL_BUDGET | NUMBER | Orginal Budget | ||
TRANSFER_IN | NUMBER | Transfer IN | ||
TRANSFER_OUT | NUMBER | Transfer Out | ||
HOLDBACK_AMT | NUMBER | Holdback Amount | ||
PLANNED | NUMBER | Planned | ||
COMMITTED | NUMBER | Committed | ||
UTILIZED | NUMBER | Utilized | ||
ACCRUAL | NUMBER | Accrual | ||
PAID | NUMBER | Paid | ||
FROM_CURRENCY | VARCHAR2 | (30) | From Currency | |
CONVERSION_RATE | NUMBER | Conversion Rate | ||
CURRENCY_CODE_FC | VARCHAR2 | (15) | Currency Code | |
ORG_ID | NUMBER | ORG ID | ||
SECURITY_GROUP_ID | NUMBER | Security Group ID | ||
CREATION_DATE | DATE | Who Column | ||
CREATED_BY | NUMBER | Who Column | ||
LAST_UPDATE_DATE | DATE | Who Column | ||
LAST_UPDATED_BY | NUMBER | Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | Who Column | ||
ORIGINAL_BUDGET_S | NUMBER | For secondary currency | ||
TRANSFER_IN_S | NUMBER | For secondary currency | ||
TRANSFER_OUT_S | NUMBER | For secondary currency | ||
HOLDBACK_AMT_S | NUMBER | For secondary currency | ||
PLANNED_S | NUMBER | For secondary currency | ||
COMMITTED_S | NUMBER | For secondary currency | ||
UTILIZED_S | NUMBER | For secondary currency | ||
ACCRUAL_S | NUMBER | For secondary currency | ||
PAID_S | NUMBER | For secondary currency | ||
CONVERSION_RATE_S | NUMBER | For secondary currency |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, BUSINESS_UNIT_ID
, DELETE_FLAG
, METRIC_TYPE
, TRANSACTION_CREATE_DATE
, ORIGINAL_BUDGET
, TRANSFER_IN
, TRANSFER_OUT
, HOLDBACK_AMT
, PLANNED
, COMMITTED
, UTILIZED
, ACCRUAL
, PAID
, FROM_CURRENCY
, CONVERSION_RATE
, CURRENCY_CODE_FC
, ORG_ID
, SECURITY_GROUP_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ORIGINAL_BUDGET_S
, TRANSFER_IN_S
, TRANSFER_OUT_S
, HOLDBACK_AMT_S
, PLANNED_S
, COMMITTED_S
, UTILIZED_S
, ACCRUAL_S
, PAID_S
, CONVERSION_RATE_S
FROM BIM.BIM_I_BUDGET_FACTS_STG;
BIM.BIM_I_BUDGET_FACTS_STG does not reference any database object
BIM.BIM_I_BUDGET_FACTS_STG is referenced by following:
|
|
|