[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_XFR_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | GL |
| FND Design Data: |  SQLGL.GL_XFR_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
This table is a custom version of the gl_interface table for use by the balance transfer.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_XFR_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 SYSTEM_ID
GROUP_ID
ROW_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| STATUS | VARCHAR2 | (450) | Yes | Status |
| LEDGER_ID | NUMBER | (15) | Ledger defining column | |
| ACCOUNTING_DATE | DATE | Yes | Effective date of the transaction | |
| CURRENCY_CODE | VARCHAR2 | (135) | Yes | Currency |
| DATE_CREATED | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| ACTUAL_FLAG | VARCHAR2 | (9) | Yes | Balance type (actual, budget, or encumbrance) |
| USER_JE_CATEGORY_NAME | VARCHAR2 | (225) | Yes | Journal entry category user defined name |
| USER_JE_SOURCE_NAME | VARCHAR2 | (225) | Yes | Journal entry source user defined name |
| CURRENCY_CONVERSION_DATE | DATE | Date of exchange rate | ||
| ENCUMBRANCE_TYPE_ID | NUMBER | Encumbrance type defining column | ||
| BUDGET_VERSION_ID | NUMBER | Budget version defining column | ||
| USER_CURRENCY_CONVERSION_TYPE | VARCHAR2 | (270) | Type of exchange rate | |
| CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
| SEGMENT1 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT2 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT6 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT7 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT8 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT9 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT10 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT11 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT12 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT13 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT14 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT15 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT16 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT17 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT18 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT19 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT20 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT21 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT22 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT23 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT24 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT25 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT26 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT27 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT28 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT29 | VARCHAR2 | (225) | Key flexfield segment | |
| SEGMENT30 | VARCHAR2 | (225) | Key flexfield segment | |
| ENTERED_DR | NUMBER | Transaction debit amount, entered currency | ||
| ENTERED_CR | NUMBER | Transaction credit amount, entered currency | ||
| ACCOUNTED_DR | NUMBER | Transaction debit amount, base currency | ||
| ACCOUNTED_CR | NUMBER | Transaction debit amount, base currency | ||
| TRANSACTION_DATE | DATE | Date of transaction | ||
| REFERENCE1 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE2 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE3 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE4 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE5 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE6 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE7 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE8 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE9 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE10 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE11 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE12 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE13 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE14 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE15 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE16 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE17 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE18 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE19 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE20 | VARCHAR2 | (900) | Journal Import reference column | |
| REFERENCE21 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE22 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE23 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE24 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE25 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE26 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE27 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE28 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE29 | VARCHAR2 | (2160) | Journal Import reference column | |
| REFERENCE30 | VARCHAR2 | (2160) | Journal Import reference column | |
| JE_BATCH_ID | NUMBER | (15) | Journal entry batch defining column | |
| PERIOD_NAME | VARCHAR2 | (135) | Accounting period | |
| JE_HEADER_ID | NUMBER | (15) | Journal entry header defining column | |
| JE_LINE_NUM | NUMBER | (15) | Journal entry line number | |
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Key flexfield structure defining column | |
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (135) | Ledger base currency | |
| CODE_COMBINATION_ID | NUMBER | (15) | Key flexfield combination defining column | |
| DATE_CREATED_IN_GL | DATE | Date Journal Import created batch | ||
| WARNING_CODE | VARCHAR2 | (36) | Not currently used | |
| STATUS_DESCRIPTION | VARCHAR2 | (2160) | Journal import status description | |
| STAT_AMOUNT | NUMBER | Statistical amount | ||
| GROUP_ID | NUMBER | (15) | Yes | Interface group defining column |
| REQUEST_ID | NUMBER | (15) | Concurrent program request id | |
| SUBLEDGER_DOC_SEQUENCE_ID | NUMBER | Sequential numbering sequence defining column | ||
| SUBLEDGER_DOC_SEQUENCE_VALUE | NUMBER | Sequential numbering sequence value | ||
| ATTRIBUTE1 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (1350) | Descriptive flexfield segment | |
| CONTEXT | VARCHAR2 | (1350) | Descriptive flexfield context column | |
| CONTEXT2 | VARCHAR2 | (1350) | Descriptive flexfield context column | |
| INVOICE_DATE | DATE | Value added tax descriptive flexfield column | ||
| TAX_CODE | VARCHAR2 | (135) | Value added tax descriptive flexfield column | |
| INVOICE_IDENTIFIER | VARCHAR2 | (180) | Value added tax descriptive flexfield column | |
| INVOICE_AMOUNT | NUMBER | Value added tax descriptive flexfield column | ||
| CONTEXT3 | VARCHAR2 | (1350) | Descriptive flexfield context column | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (270) | Government transaction code | |
| DESCR_FLEX_ERROR_MESSAGE | VARCHAR2 | (2160) | Descriptive flexfield error message | |
| JGZZ_RECON_REF | VARCHAR2 | (2160) | Global reconciliation reference | |
| AVERAGE_JOURNAL_FLAG | VARCHAR2 | (9) | Average Journal Flag | |
| ORIGINATING_BAL_SEG_VALUE | VARCHAR2 | (225) | Source Balancing Segment Value | |
| GL_SL_LINK_ID | NUMBER | Link to associated subledger data | ||
| GL_SL_LINK_TABLE | VARCHAR2 | (270) | Table containing associated subledger data | |
| REFERENCE_DATE | DATE | Reference Date | ||
| SET_OF_BOOKS_ID | NUMBER | (15) | Ledger defining column | |
| BALANCING_SEGMENT_VALUE | VARCHAR2 | (225) | Balancing segment value | |
| MANAGEMENT_SEGMENT_VALUE | VARCHAR2 | (225) | Management segment value | |
| FUNDS_RESERVED_FLAG | VARCHAR2 | (9) | Reserved for Oracle internal use | |
| CODE_COMBINATION_ID_INTERIM | NUMBER | (15) | Interim Code Combination Id | |
| CURRENCY_CONV_DATE_INTER | DATE | Interim Currency Conversion Date | ||
| CURRENCY_CONV_TYPE_INTER | VARCHAR2 | (270) | Interim Currency Conversion Type | |
| CURRENCY_CONV_RATE_INTER | NUMBER | (15) | Interim Currency Conversion Rate | |
| ROW_NUMBER | NUMBER | (15) | Yes | Row number. Used to make a unique index |
| SYSTEM_ID | NUMBER | (15) | Yes | System that the data came from |
| GL_INTERFACE_ID | NUMBER | (15) | Interface Id |
Cut, paste (and edit) the following text to query this object:
SELECT STATUS
, LEDGER_ID
, ACCOUNTING_DATE
, CURRENCY_CODE
, DATE_CREATED
, CREATED_BY
, ACTUAL_FLAG
, USER_JE_CATEGORY_NAME
, USER_JE_SOURCE_NAME
, CURRENCY_CONVERSION_DATE
, ENCUMBRANCE_TYPE_ID
, BUDGET_VERSION_ID
, USER_CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, TRANSACTION_DATE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, REFERENCE11
, REFERENCE12
, REFERENCE13
, REFERENCE14
, REFERENCE15
, REFERENCE16
, REFERENCE17
, REFERENCE18
, REFERENCE19
, REFERENCE20
, REFERENCE21
, REFERENCE22
, REFERENCE23
, REFERENCE24
, REFERENCE25
, REFERENCE26
, REFERENCE27
, REFERENCE28
, REFERENCE29
, REFERENCE30
, JE_BATCH_ID
, PERIOD_NAME
, JE_HEADER_ID
, JE_LINE_NUM
, CHART_OF_ACCOUNTS_ID
, FUNCTIONAL_CURRENCY_CODE
, CODE_COMBINATION_ID
, DATE_CREATED_IN_GL
, WARNING_CODE
, STATUS_DESCRIPTION
, STAT_AMOUNT
, GROUP_ID
, REQUEST_ID
, SUBLEDGER_DOC_SEQUENCE_ID
, SUBLEDGER_DOC_SEQUENCE_VALUE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CONTEXT
, CONTEXT2
, INVOICE_DATE
, TAX_CODE
, INVOICE_IDENTIFIER
, INVOICE_AMOUNT
, CONTEXT3
, USSGL_TRANSACTION_CODE
, DESCR_FLEX_ERROR_MESSAGE
, JGZZ_RECON_REF
, AVERAGE_JOURNAL_FLAG
, ORIGINATING_BAL_SEG_VALUE
, GL_SL_LINK_ID
, GL_SL_LINK_TABLE
, REFERENCE_DATE
, SET_OF_BOOKS_ID
, BALANCING_SEGMENT_VALUE
, MANAGEMENT_SEGMENT_VALUE
, FUNDS_RESERVED_FLAG
, CODE_COMBINATION_ID_INTERIM
, CURRENCY_CONV_DATE_INTER
, CURRENCY_CONV_TYPE_INTER
, CURRENCY_CONV_RATE_INTER
, ROW_NUMBER
, SYSTEM_ID
, GL_INTERFACE_ID
FROM GL.GL_XFR_INTERFACE;
GL.GL_XFR_INTERFACE does not reference any database object
GL.GL_XFR_INTERFACE is referenced by following:
GL
GL_XFR_INTERFACE#
|
|
|
|