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


TABLE: GL.GL_IEA_INTERFACE

Object Details
Object Name: GL_IEA_INTERFACE
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_IEA_INTERFACE
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_IEA_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
ColumnTRANSACTION_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER (15) Yes Interface group defining column
TRANSACTION_TYPE_ID NUMBER (15) Yes Transaction type defining column
TRANSACTION_STATUS_CODE VARCHAR2 (1) Yes Transaction status
CURRENCY_CODE VARCHAR2 (15) Yes Transaction currency
GL_DATE DATE
Yes Accounting date for the transaction
SENDER_SUBSIDIARY_ID NUMBER (15) Yes Sending subsidiary defining column
RECEIVER_SUBSIDIARY_ID NUMBER (15) Yes Receiving subsidiary defining column
LINE_TYPE VARCHAR2 (1) Yes Line type defining column (clearing or distribution)
TRANSACTION_NUMBER VARCHAR2 (20)
Transaction number
DESCRIPTION VARCHAR2 (240)
Intercompany transaction description
NOTE VARCHAR2 (2000)
Intercompany transaction note
SENDER_CODE_COMBINATION_ID NUMBER (15)
Sending subsidiary key flexfield defining column
RECEIVER_CODE_COMBINATION_ID NUMBER (15)
Receiving subsidiary key flexfield defining column
SENDER_SEGMENT1 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT2 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT3 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT4 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT5 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT6 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT7 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT8 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT9 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT10 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT11 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT12 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT13 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT14 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT15 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT16 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT17 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT18 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT19 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT20 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT21 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT22 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT23 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT24 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT25 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT26 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT27 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT28 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT29 VARCHAR2 (25)
Sending subsidiary key flexfield segment
SENDER_SEGMENT30 VARCHAR2 (25)
Sending subsidiary key flexfield segment
RECEIVER_SEGMENT1 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT2 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT3 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT4 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT5 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT6 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT7 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT8 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT9 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT10 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT11 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT12 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT13 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT14 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT15 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT16 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT17 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT18 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT19 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT20 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT21 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT22 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT23 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT24 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT25 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT26 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT27 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT28 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT29 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
RECEIVER_SEGMENT30 VARCHAR2 (25)
Receiving subsidiary key flexfield segment
LINE_DEBIT NUMBER

Transaction line debit amount
LINE_CREDIT NUMBER

Transaction line credit amount
LAST_MODIFIED_BY NUMBER (15)
Defining column for user who last modified the row
LAST_MODIFICATION_DATE DATE

Last modified date
SENDER_CHART_OF_ACCOUNTS_ID NUMBER (15)
Sending subsidiary Key flexfield structure defining column
RECEIVER_CHART_OF_ACCOUNTS_ID NUMBER (15)
Receiving subsidiary key flexfield structure defining column
REQUEST_ID NUMBER (15)
Concurrent program request ID
COMPLETION_STATUS_CODE VARCHAR2 (1000)
Status of row at completion
Query Text

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


SELECT GROUP_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_STATUS_CODE
,      CURRENCY_CODE
,      GL_DATE
,      SENDER_SUBSIDIARY_ID
,      RECEIVER_SUBSIDIARY_ID
,      LINE_TYPE
,      TRANSACTION_NUMBER
,      DESCRIPTION
,      NOTE
,      SENDER_CODE_COMBINATION_ID
,      RECEIVER_CODE_COMBINATION_ID
,      SENDER_SEGMENT1
,      SENDER_SEGMENT2
,      SENDER_SEGMENT3
,      SENDER_SEGMENT4
,      SENDER_SEGMENT5
,      SENDER_SEGMENT6
,      SENDER_SEGMENT7
,      SENDER_SEGMENT8
,      SENDER_SEGMENT9
,      SENDER_SEGMENT10
,      SENDER_SEGMENT11
,      SENDER_SEGMENT12
,      SENDER_SEGMENT13
,      SENDER_SEGMENT14
,      SENDER_SEGMENT15
,      SENDER_SEGMENT16
,      SENDER_SEGMENT17
,      SENDER_SEGMENT18
,      SENDER_SEGMENT19
,      SENDER_SEGMENT20
,      SENDER_SEGMENT21
,      SENDER_SEGMENT22
,      SENDER_SEGMENT23
,      SENDER_SEGMENT24
,      SENDER_SEGMENT25
,      SENDER_SEGMENT26
,      SENDER_SEGMENT27
,      SENDER_SEGMENT28
,      SENDER_SEGMENT29
,      SENDER_SEGMENT30
,      RECEIVER_SEGMENT1
,      RECEIVER_SEGMENT2
,      RECEIVER_SEGMENT3
,      RECEIVER_SEGMENT4
,      RECEIVER_SEGMENT5
,      RECEIVER_SEGMENT6
,      RECEIVER_SEGMENT7
,      RECEIVER_SEGMENT8
,      RECEIVER_SEGMENT9
,      RECEIVER_SEGMENT10
,      RECEIVER_SEGMENT11
,      RECEIVER_SEGMENT12
,      RECEIVER_SEGMENT13
,      RECEIVER_SEGMENT14
,      RECEIVER_SEGMENT15
,      RECEIVER_SEGMENT16
,      RECEIVER_SEGMENT17
,      RECEIVER_SEGMENT18
,      RECEIVER_SEGMENT19
,      RECEIVER_SEGMENT20
,      RECEIVER_SEGMENT21
,      RECEIVER_SEGMENT22
,      RECEIVER_SEGMENT23
,      RECEIVER_SEGMENT24
,      RECEIVER_SEGMENT25
,      RECEIVER_SEGMENT26
,      RECEIVER_SEGMENT27
,      RECEIVER_SEGMENT28
,      RECEIVER_SEGMENT29
,      RECEIVER_SEGMENT30
,      LINE_DEBIT
,      LINE_CREDIT
,      LAST_MODIFIED_BY
,      LAST_MODIFICATION_DATE
,      SENDER_CHART_OF_ACCOUNTS_ID
,      RECEIVER_CHART_OF_ACCOUNTS_ID
,      REQUEST_ID
,      COMPLETION_STATUS_CODE
FROM GL.GL_IEA_INTERFACE;

Dependencies

[top of page]

GL.GL_IEA_INTERFACE does not reference any database object

GL.GL_IEA_INTERFACE is referenced by following:

SchemaGL
ViewGL_IEA_INTERFACE#