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

TABLE: IGI.IGI_AR_JOURNAL_INTERIM

Object Details
Object Name: IGI_AR_JOURNAL_INTERIM
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_AR_JOURNAL_INTERIM
Subobject Name:
Status: VALID


IGI_AR_JOURNAL_INTERIM is an exact copy of AR_JOURNAL_INTERIM_ALL. This is necessary because AR_JOURNAL_INTERIM_ALL is a temporary table where records are deleted by core modules once they've finished, but OPSFI requires this data to create reconciliation reports.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
STATUS VARCHAR2 (50) Yes Journal status
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books identifier
JE_SOURCE_NAME VARCHAR2 (25) Yes Journal source name
JE_CATEGORY_NAME VARCHAR2 (25) Yes Journal category name
ACCOUNTING_DATE DATE
Yes General Ledger accounting date
CURRENCY_CODE VARCHAR2 (15) Yes Application currency code
DATE_CREATED DATE
Yes Invoice creation date
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ACTUAL_FLAG VARCHAR2 (1) Yes Actual flag
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ENCUMBRANCE_TYPE_ID NUMBER

Encumbrance type identifier
BUDGET_VERSION_ID NUMBER (15)
Budget version identifier
CURRENCY_CONVERSION_DATE DATE

Currency conversion date
CURRENCY_CONVERSION_TYPE VARCHAR2 (10)
Currency conversion type
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate
SEGMENT1 VARCHAR2 (25)
Key flexfield segment
SEGMENT2 VARCHAR2 (25)
Key flexfield segment
SEGMENT3 VARCHAR2 (25)
Key flexfield segment
SEGMENT4 VARCHAR2 (25)
Key flexfield segment
SEGMENT5 VARCHAR2 (25)
Key flexfield segment
SEGMENT6 VARCHAR2 (25)
Key flexfield segment
SEGMENT7 VARCHAR2 (25)
Key flexfield segment
SEGMENT9 VARCHAR2 (25)
Key flexfield segment
SEGMENT10 VARCHAR2 (25)
Key flexfield segment
SEGMENT11 VARCHAR2 (25)
Key flexfield segment
SEGMENT12 VARCHAR2 (25)
Key flexfield segment
SEGMENT13 VARCHAR2 (25)
Key flexfield segment
SEGMENT14 VARCHAR2 (25)
Key flexfield segment
SEGMENT15 VARCHAR2 (25)
Key flexfield segment
SEGMENT16 VARCHAR2 (25)
Key flexfield segment
SEGMENT17 VARCHAR2 (25)
Key flexfield segment
SEGMENT18 VARCHAR2 (25)
Key flexfield segment
SEGMENT19 VARCHAR2 (25)
Key flexfield segment
SEGMENT20 VARCHAR2 (25)
Key flexfield segment
SEGMENT21 VARCHAR2 (25)
Account segment
SEGMENT22 VARCHAR2 (25)
Account segment
SEGMENT23 VARCHAR2 (25)
Account segment
SEGMENT24 VARCHAR2 (25)
Account segment
SEGMENT25 VARCHAR2 (25)
Account segment
SEGMENT26 VARCHAR2 (25)
Account segment
SEGMENT27 VARCHAR2 (25)
Account segment
SEGMENT28 VARCHAR2 (25)
Account segment
SEGMENT29 VARCHAR2 (25)
Account segment
SEGMENT30 VARCHAR2 (25)
Account segment
ENTERED_DR NUMBER (22)
Entered debit amount
ENTERED_CR NUMBER (22)
Entered credit amount
ACCOUNTED_DR NUMBER (22)
Accounted debit amount
ACCOUNTED_CR NUMBER (22)
Accounted credit amount
TRANSACTION_DATE DATE

Transaction date
REFERENCE1 VARCHAR2 (100)
Account segment reference
REFERENCE2 VARCHAR2 (100)
Account segment reference
REFERENCE3 VARCHAR2 (100)
Account segment reference
REFERENCE4 VARCHAR2 (100)
Account segment reference
REFERENCE5 VARCHAR2 (100)
Account segment reference
REFERENCE6 VARCHAR2 (100)
Account segment reference
SEGMENT8 VARCHAR2 (25)
Key flexfield segment
REFERENCE7 VARCHAR2 (100)
Account segment reference
REFERENCE8 VARCHAR2 (100)
Account segment reference
REFERENCE9 VARCHAR2 (100)
Account segment reference
REFERENCE10 VARCHAR2 (100)
Account segment reference
REFERENCE11 VARCHAR2 (100)
Account segment reference
REFERENCE12 VARCHAR2 (100)
Account segment reference
REFERENCE13 VARCHAR2 (100)
Account segment reference
REFERENCE14 VARCHAR2 (100)
Account segment reference
REFERENCE15 VARCHAR2 (100)
Account segment reference
REFERENCE16 VARCHAR2 (100)
Account segment reference
REFERENCE17 VARCHAR2 (100)
Account segment reference
REFERENCE18 VARCHAR2 (100)
Account segment reference
REFERENCE19 VARCHAR2 (100)
Account segment reference
REFERENCE20 VARCHAR2 (100)
Account segment reference
REFERENCE21 VARCHAR2 (100)
Account segment reference
REFERENCE22 VARCHAR2 (100)
Account segment reference
REFERENCE23 VARCHAR2 (100)
Account segment reference
REFERENCE24 VARCHAR2 (100)
Account segment reference
REFERENCE25 VARCHAR2 (100)
Account segment reference
REFERENCE26 VARCHAR2 (100)
Account segment reference
REFERENCE27 VARCHAR2 (100)
Account segment reference
REFERENCE28 VARCHAR2 (100)
Account segment reference
REFERENCE29 VARCHAR2 (100)
Account segment reference
REFERENCE30 VARCHAR2 (100)
Account segment reference
INTERFACE_RUN_ID NUMBER (15)
Interface run identifier
JE_BATCH_ID NUMBER (15)
Journal batch identifier
PERIOD_NAME VARCHAR2 (15)
Accounting period name
JE_HEADER_ID NUMBER (15)
Journal header source identifier
JE_LINE_NUM NUMBER (15)
Journal line number
CHART_OF_ACCOUNTS_ID NUMBER (15)
Chart of Accounts identifier
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Functional currency code
CODE_COMBINATION_ID NUMBER (15)
Account Code Combination identifier
DATE_CREATED_IN_GL DATE

General Ledger creation date
WARNING_CODE VARCHAR2 (4)
Warning code
STATUS_DESCRIPTION VARCHAR2 (240)
Status description
STAT_AMOUNT NUMBER (22)
Stated amount
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT STATUS
,      SET_OF_BOOKS_ID
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      ACCOUNTING_DATE
,      CURRENCY_CODE
,      DATE_CREATED
,      CREATED_BY
,      ACTUAL_FLAG
,      REQUEST_ID
,      ENCUMBRANCE_TYPE_ID
,      BUDGET_VERSION_ID
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      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
,      SEGMENT8
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      REFERENCE11
,      REFERENCE12
,      REFERENCE13
,      REFERENCE14
,      REFERENCE15
,      REFERENCE16
,      REFERENCE17
,      REFERENCE18
,      REFERENCE19
,      REFERENCE20
,      REFERENCE21
,      REFERENCE22
,      REFERENCE23
,      REFERENCE24
,      REFERENCE25
,      REFERENCE26
,      REFERENCE27
,      REFERENCE28
,      REFERENCE29
,      REFERENCE30
,      INTERFACE_RUN_ID
,      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
,      ORG_ID
FROM IGI.IGI_AR_JOURNAL_INTERIM;

Dependencies

[top of page]

IGI.IGI_AR_JOURNAL_INTERIM does not reference any database object

IGI.IGI_AR_JOURNAL_INTERIM is referenced by following:

SchemaIGI
ViewIGI_AR_JOURNAL_INTERIM#