[Home] [Help] [Dependency Information]
Object Name: | FEM_DATA4 |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Enterprise Performance Foundation Generic
Fact Data Table4
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATED_BY_OBJECT_ID | NUMBER | (9) | Yes | Identifies the business rule that created the data |
DATASET_CODE | NUMBER | Yes | Foreign key to the Dataset dimension | |
CAL_PERIOD_ID | NUMBER | Yes | Foreign key to the Calendar Period dimension | |
SOURCE_SYSTEM_CODE | NUMBER | Yes | Foreign key to the Source System dimension | |
LEDGER_ID | NUMBER | Yes | Foreign key to the Ledger dimension | |
COMPANY_COST_CENTER_ORG_ID | NUMBER | Foreign key to the Company Cost Center Organization dimension | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
FINANCIAL_ELEM_ID | NUMBER | Foreign key to the Financial Element dimension | ||
PRODUCT_ID | NUMBER | Foreign key to the Product dimension | ||
NATURAL_ACCOUNT_ID | NUMBER | Foreign key to the Natural Account dimension | ||
CHANNEL_ID | NUMBER | Foreign key to the Channel dimension | ||
LINE_ITEM_ID | NUMBER | Foreign key to the Line Item dimension | ||
PROJECT_ID | NUMBER | Foreign key to the Project dimension | ||
CUSTOMER_ID | NUMBER | Customer dimension member identifier | ||
ENTITY_ID | NUMBER | Foeign key to the Entity dimension | ||
INTERCOMPANY_ID | NUMBER | Foreign key to the Intercompany dimension | ||
USER_DIM1_ID | NUMBER | Foreign key to User Dimension1 | ||
USER_DIM2_ID | NUMBER | Foreign key to User Dimension2 | ||
USER_DIM3_ID | NUMBER | Foreign key to User Dimension3 | ||
USER_DIM4_ID | NUMBER | Foreign key to User Dimension4 | ||
USER_DIM5_ID | NUMBER | Foreign key to User Dimension5 | ||
USER_DIM6_ID | NUMBER | Foreign key to User Dimension6 | ||
USER_DIM7_ID | NUMBER | Foreign key to User Dimension7 | ||
USER_DIM8_ID | NUMBER | Foreign key to User Dimension8 | ||
USER_DIM9_ID | NUMBER | Foreign key to User Dimension9 | ||
USER_DIM10_ID | NUMBER | Foreign key to User Dimension10 | ||
CREATED_BY_REQUEST_ID | NUMBER | Yes | Created by Request | |
LAST_UPDATED_BY_REQUEST_ID | NUMBER | Yes | Identifies the Request that last updated the data | |
LAST_UPDATED_BY_OBJECT_ID | NUMBER | (9) | Yes | Identifies the business rule that last updated the data |
NUMERIC_MEASURE | NUMBER | Generic column for numeric data | ||
ALPHANUMERIC_MEASURE | VARCHAR2 | (4000) | Generic column for alphanumeric data | |
DATE_MEASURE | DATE | Generic column for date data | ||
GEOGRAPHY_ID | NUMBER | Foreign key to the Geography dimension | ||
TASK_ID | NUMBER | Foreign key to the Task dimension |
Cut, paste (and edit) the following text to query this object:
SELECT CREATED_BY_OBJECT_ID
, DATASET_CODE
, CAL_PERIOD_ID
, SOURCE_SYSTEM_CODE
, LEDGER_ID
, COMPANY_COST_CENTER_ORG_ID
, CURRENCY_CODE
, FINANCIAL_ELEM_ID
, PRODUCT_ID
, NATURAL_ACCOUNT_ID
, CHANNEL_ID
, LINE_ITEM_ID
, PROJECT_ID
, CUSTOMER_ID
, ENTITY_ID
, INTERCOMPANY_ID
, USER_DIM1_ID
, USER_DIM2_ID
, USER_DIM3_ID
, USER_DIM4_ID
, USER_DIM5_ID
, USER_DIM6_ID
, USER_DIM7_ID
, USER_DIM8_ID
, USER_DIM9_ID
, USER_DIM10_ID
, CREATED_BY_REQUEST_ID
, LAST_UPDATED_BY_REQUEST_ID
, LAST_UPDATED_BY_OBJECT_ID
, NUMERIC_MEASURE
, ALPHANUMERIC_MEASURE
, DATE_MEASURE
, GEOGRAPHY_ID
, TASK_ID
FROM FEM.FEM_DATA4;
FEM.FEM_DATA4 does not reference any database object
FEM.FEM_DATA4 is referenced by following:
|
|
|