[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BIM_I_BUDGET_FACTS |
|---|---|
| Object Type: | TABLE |
| Owner: | BIM |
| Subobject Name: | |
| Status: | VALID |
This table provides daily facts summary information for Marketing Management DBI Budget Reports.
| 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 | ||
| ORIGINAL_BUDGET_S | NUMBER | For secondary currency | ||
| TRANSFER_IN | NUMBER | Transfer IN | ||
| TRANSFER_IN_S | NUMBER | For secondary currency | ||
| TRANSFER_OUT | NUMBER | Transfer Out | ||
| TRANSFER_OUT_S | NUMBER | For secondary currency | ||
| HOLDBACK_AMT | NUMBER | Holdback Amount | ||
| HOLDBACK_AMT_S | NUMBER | For secondary currency | ||
| PLANNED | NUMBER | Planned | ||
| PLANNED_S | NUMBER | For secondary currency | ||
| COMMITTED | NUMBER | Committed | ||
| COMMITTED_S | NUMBER | For secondary currency | ||
| UTILIZED | NUMBER | Utilized | ||
| UTILIZED_S | NUMBER | For secondary currency | ||
| ACCRUAL | NUMBER | Accural | ||
| ACCRUAL_S | NUMBER | For secondary currency | ||
| PAID | NUMBER | Paid | ||
| PAID_S | NUMBER | For secondary currency | ||
| FROM_CURRENCY | VARCHAR2 | (30) | From Currency | |
| CONVERSION_RATE | NUMBER | Conversion Rate | ||
| CONVERSION_RATE_S | NUMBER | For secondary currency | ||
| 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 |
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
, ORIGINAL_BUDGET_S
, TRANSFER_IN
, TRANSFER_IN_S
, TRANSFER_OUT
, TRANSFER_OUT_S
, HOLDBACK_AMT
, HOLDBACK_AMT_S
, PLANNED
, PLANNED_S
, COMMITTED
, COMMITTED_S
, UTILIZED
, UTILIZED_S
, ACCRUAL
, ACCRUAL_S
, PAID
, PAID_S
, FROM_CURRENCY
, CONVERSION_RATE
, CONVERSION_RATE_S
, CURRENCY_CODE_FC
, ORG_ID
, SECURITY_GROUP_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM BIM.BIM_I_BUDGET_FACTS;
BIM.BIM_I_BUDGET_FACTS does not reference any database object
BIM.BIM_I_BUDGET_FACTS is referenced by following:
APPS
BIM_I_BGT_CAB_MV
BIM_I_BGT_FCT_MV
BIM_I_BUDGET_FACTS
|
|
|
|