Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: GCS.GCS_BAL_INTERFACE_T

Object Details
Object Name: GCS_BAL_INTERFACE_T
Object Type: TABLE
Owner: GCS
FND Design Data: TableGCS.GCS_BAL_INTERFACE_T
Subobject Name:
Status: VALID


GCS_BAL_INTERFACE_T stores line level information on data that has been or is in the processing of being loaded to FEM_BALANCES.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000399880C00034$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
GCS_BAL_INTERFACE_T_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOAD_ID
Columns
Name Datatype Length Mandatory Comments
LOAD_ID NUMBER (15) Yes Load Identifying Column
CCTR_ORG_DISPLAY_CODE VARCHAR2 (150)
Company Cost Center Org Display Code
FINANCIAL_ELEM_DISPLAY_CODE VARCHAR2 (150)
Financial Element Display Code
PRODUCT_DISPLAY_CODE VARCHAR2 (150)
Product Display Code
NATURAL_ACCOUNT_DISPLAY_CODE VARCHAR2 (150)
Natural Account Display Code
CHANNEL_DISPLAY_CODE VARCHAR2 (150)
Channel Display Code
LINE_ITEM_DISPLAY_CODE VARCHAR2 (150)
Line Item Display Code
PROJECT_DISPLAY_CODE VARCHAR2 (150)
Product Display Code
CUSTOMER_DISPLAY_CODE VARCHAR2 (150)
Customer Display Code
INTERCOMPANY_DISPLAY_CODE VARCHAR2 (150)
Intercompany Display Code
TASK_DISPLAY_CODE VARCHAR2 (150)
Task Display Code
USER_DIM1_DISPLAY_CODE VARCHAR2 (150)
User Dim 1 Display Code
USER_DIM2_DISPLAY_CODE VARCHAR2 (150)
User Dim 2 Display Code
USER_DIM3_DISPLAY_CODE VARCHAR2 (150)
User Dim3 Display Code
USER_DIM4_DISPLAY_CODE VARCHAR2 (150)
User Dim 4 Display Code
USER_DIM5_DISPLAY_CODE VARCHAR2 (150)
User Dim 5 Display Code
USER_DIM6_DISPLAY_CODE VARCHAR2 (150)
User Dim 6 Display Code
USER_DIM7_DISPLAY_CODE VARCHAR2 (150)
User Dim 7 Display Code
USER_DIM8_DISPLAY_CODE VARCHAR2 (150)
User Dim 8 Display Code
USER_DIM9_DISPLAY_CODE VARCHAR2 (150)
User Dim 9 Display Code
USER_DIM10_DISPLAY_CODE VARCHAR2 (150)
User Dim 10 Display Code
PTD_DEBIT_BALANCE_E NUMBER

Period-to-Date Entered Debit Balance
PTD_CREDIT_BALANCE_E NUMBER

Period-to-Date Entered Credit Balance
YTD_DEBIT_BALANCE_E NUMBER

Year-to-Date Entered Debit Balance
YTD_CREDIT_BALANCE_E NUMBER

Year-to-Date Entered Credit Balance
PTD_DEBIT_BALANCE_F NUMBER

Period-to-Date Functional Debit Balance
PTD_CREDIT_BALANCE_F NUMBER

Period-to-Date Functional Credit Balance
YTD_DEBIT_BALANCE_F NUMBER

Year-to-Date Functional Debit Balance
YTD_CREDIT_BALANCE_F NUMBER

Year-to-Date Functional Credit Balance
PTD_BALANCE_E NUMBER

Period-to-Date Entered Balance
PTD_BALANCE_F NUMBER

Period-to-Date Functional Balance
YTD_BALANCE_E NUMBER

Year-to-Date Entered Balance
YTD_BALANCE_F NUMBER

Year-to-Date Functional Balance
ERROR_MESSAGE_CODE CLOB (4000)
Error Message Code
CURRENCY_CODE VARCHAR2 (30)
Currency Code
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Yes Change Indicator Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOAD_ID
,      CCTR_ORG_DISPLAY_CODE
,      FINANCIAL_ELEM_DISPLAY_CODE
,      PRODUCT_DISPLAY_CODE
,      NATURAL_ACCOUNT_DISPLAY_CODE
,      CHANNEL_DISPLAY_CODE
,      LINE_ITEM_DISPLAY_CODE
,      PROJECT_DISPLAY_CODE
,      CUSTOMER_DISPLAY_CODE
,      INTERCOMPANY_DISPLAY_CODE
,      TASK_DISPLAY_CODE
,      USER_DIM1_DISPLAY_CODE
,      USER_DIM2_DISPLAY_CODE
,      USER_DIM3_DISPLAY_CODE
,      USER_DIM4_DISPLAY_CODE
,      USER_DIM5_DISPLAY_CODE
,      USER_DIM6_DISPLAY_CODE
,      USER_DIM7_DISPLAY_CODE
,      USER_DIM8_DISPLAY_CODE
,      USER_DIM9_DISPLAY_CODE
,      USER_DIM10_DISPLAY_CODE
,      PTD_DEBIT_BALANCE_E
,      PTD_CREDIT_BALANCE_E
,      YTD_DEBIT_BALANCE_E
,      YTD_CREDIT_BALANCE_E
,      PTD_DEBIT_BALANCE_F
,      PTD_CREDIT_BALANCE_F
,      YTD_DEBIT_BALANCE_F
,      YTD_CREDIT_BALANCE_F
,      PTD_BALANCE_E
,      PTD_BALANCE_F
,      YTD_BALANCE_E
,      YTD_BALANCE_F
,      ERROR_MESSAGE_CODE
,      CURRENCY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      OBJECT_VERSION_NUMBER
FROM GCS.GCS_BAL_INTERFACE_T;

Dependencies

[top of page]

GCS.GCS_BAL_INTERFACE_T does not reference any database object

GCS.GCS_BAL_INTERFACE_T is referenced by following:

SchemaAPPS
SynonymGCS_BAL_INTERFACE_T