[Home] [Help] [Dependency Information]
Object Name: | FEM_BALANCES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
FEM_BALANCES_V shows balance data for use in reporting
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATASET_CODE | NUMBER | Yes | Foreign key to the Dataset dimension | |
CAL_PERIOD_ID | NUMBER | Yes | Foreign key to the Calendar Period dimension | |
CREATION_ROW_SEQUENCE | NUMBER | Yes | Surrogate key used for Visual Trace. For each combination of Created By Object_ID, Dataset_Code and Cal_Period_ID, you may have one ore more CREATION_ROW_SEQUENCE values. | |
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) | Yes | Currency Code |
CURRENCY_TYPE_CODE | VARCHAR2 | (30) | Yes | Identifies the row as an ENTERED row or a TRANSLATED row. |
ACTIVITY_ID | NUMBER | Foreign key to the Activity dimension | ||
COST_OBJECT_ID | NUMBER | Foreign key to the Cost Object dimension | ||
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 | ||
TASK_ID | NUMBER | Foreign key to the Task 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 | |
CREATED_BY_OBJECT_ID | NUMBER | (9) | Yes | Identifies the business rule that created the data |
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 |
XTD_BALANCE_E | NUMBER | Period-to-Date end or average balance in the entered currency. | ||
XTD_BALANCE_F | NUMBER | Period-to-Date end or average balance in the functional currency for the current set of books. | ||
YTD_BALANCE_E | NUMBER | Year-to-Date end or average balance as of end date for period denoted by CAL_PERIOD_ID, in the entered currency. | ||
YTD_BALANCE_F | NUMBER | Year-to-Date end or average balance as of end date for period denoted by CAL_PERIOD_ID, in the functional currency for the current set of books. | ||
QTD_BALANCE_E | NUMBER | Quarter-to-Date end or average balance as of end date for period denoted by CAL_PERIOD_ID, in the entered currency. | ||
QTD_BALANCE_F | NUMBER | Quarter-to-Date end or average balance as of end date for period denoted by CAL_PERIOD_ID, in the functional currency for the current set of books. | ||
PTD_DEBIT_BALANCE_E | NUMBER | Debit Amount in the entered currency. Only used by GCSII and GL Integration. | ||
PTD_CREDIT_BALANCE_E | NUMBER | Credit Amount in the entered currency. Only used by GCSII and GL Integration. | ||
YTD_DEBIT_BALANCE_E | NUMBER | Year to Date credit amount in the entered currency. Only used by GCSII and GL Integration. | ||
YTD_CREDIT_BALANCE_E | NUMBER | Year to Date credit amount in the entered currency. Only used by GCSII and GL Integration. | ||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | Identifies the Functional Currency for the given Ledger | |
CALENDAR_ID | NUMBER | (5) | Identifies the Calendar for the given Ledger | |
COMPANY_COST_CENTER_ORG_VS_ID | NUMBER | Identifies the Value Set applicable for the Company Cost Center Organization dimension for the given Ledger | ||
FINANCIAL_ELEM_VS_ID | NUMBER | Identifies the Value Set applicable for the Financial Element dimension for the given Ledger | ||
PRODUCT_VS_ID | NUMBER | Identifies the Value Set applicable for the Product dimension for the given Ledger | ||
NATURAL_ACCOUNT_VS_ID | NUMBER | Identifies the Value Set applicable for the Natural Account dimension for the given Ledger | ||
CHANNEL_VS_ID | NUMBER | Identifies the Value Set applicable for the Channel dimension for the given Ledger | ||
LINE_ITEM_VS_ID | NUMBER | Identifies the Value Set applicable for the Line Item dimension for the given Ledger | ||
PROJECT_VS_ID | NUMBER | Identifies the Value Set applicable for the Project dimension for the given Ledger | ||
CUSTOMER_VS_ID | NUMBER | Identifies the Value Set applicable for the Customer dimension for the given Ledger | ||
ENTITY_VS_ID | NUMBER | Identifies the Value Set applicable for the Entity dimension for the given Ledger | ||
TASK_VS_ID | NUMBER | Identifies the Value Set applicable for the Task dimension for the given Ledger | ||
USER_DIM1_VS_ID | NUMBER | Identifies the Value Set applicable for the User Dimension01 dimension for the given Ledger | ||
USER_DIM2_VS_ID | NUMBER | Identifies the Value Set applicable for the User Dimension02 dimension for the given Ledger | ||
USER_DIM3_VS_ID | NUMBER | Identifies the Value Set applicable for the User Dimension03 dimension for the given Ledger | ||
USER_DIM4_VS_ID | NUMBER | Identifies the Value Set applicable for the User Dimension04 dimension for the given Ledger | ||
USER_DIM5_VS_ID | NUMBER | Identifies the Value Set applicable for the User Dimension05 dimension for the given Ledger | ||
USER_DIM6_VS_ID | NUMBER | Identifies the Value Set applicable for the User Dimension06 dimension for the given Ledger | ||
USER_DIM7_VS_ID | NUMBER | Identifies the Value Set applicable for the User Dimension07 dimension for the given Ledger | ||
USER_DIM8_VS_ID | NUMBER | Identifies the Value Set applicable for the User Dimension08 dimension for the given Ledger | ||
USER_DIM9_VS_ID | NUMBER | Identifies the Value Set applicable for the User Dimension09 dimension for the given Ledger | ||
USER_DIM10_VS_ID | NUMBER | Identifies the Value Set applicable for the User Dimension10 dimension for the given Ledger |
Cut, paste (and edit) the following text to query this object:
SELECT DATASET_CODE
, CAL_PERIOD_ID
, CREATION_ROW_SEQUENCE
, SOURCE_SYSTEM_CODE
, LEDGER_ID
, COMPANY_COST_CENTER_ORG_ID
, CURRENCY_CODE
, CURRENCY_TYPE_CODE
, ACTIVITY_ID
, COST_OBJECT_ID
, FINANCIAL_ELEM_ID
, PRODUCT_ID
, NATURAL_ACCOUNT_ID
, CHANNEL_ID
, LINE_ITEM_ID
, PROJECT_ID
, CUSTOMER_ID
, ENTITY_ID
, INTERCOMPANY_ID
, TASK_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
, CREATED_BY_OBJECT_ID
, LAST_UPDATED_BY_REQUEST_ID
, LAST_UPDATED_BY_OBJECT_ID
, XTD_BALANCE_E
, XTD_BALANCE_F
, YTD_BALANCE_E
, YTD_BALANCE_F
, QTD_BALANCE_E
, QTD_BALANCE_F
, PTD_DEBIT_BALANCE_E
, PTD_CREDIT_BALANCE_E
, YTD_DEBIT_BALANCE_E
, YTD_CREDIT_BALANCE_E
, FUNCTIONAL_CURRENCY_CODE
, CALENDAR_ID
, COMPANY_COST_CENTER_ORG_VS_ID
, FINANCIAL_ELEM_VS_ID
, PRODUCT_VS_ID
, NATURAL_ACCOUNT_VS_ID
, CHANNEL_VS_ID
, LINE_ITEM_VS_ID
, PROJECT_VS_ID
, CUSTOMER_VS_ID
, ENTITY_VS_ID
, TASK_VS_ID
, USER_DIM1_VS_ID
, USER_DIM2_VS_ID
, USER_DIM3_VS_ID
, USER_DIM4_VS_ID
, USER_DIM5_VS_ID
, USER_DIM6_VS_ID
, USER_DIM7_VS_ID
, USER_DIM8_VS_ID
, USER_DIM9_VS_ID
, USER_DIM10_VS_ID
FROM APPS.FEM_BALANCES_V;
|
|
|