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

TABLE: IGI.IGI_ARC_DRILL_ITF

Object Details
Object Name: IGI_ARC_DRILL_ITF
Object Type: TABLE
Owner: IGI
Subobject Name:
Status: VALID


IGI_ARC_DRILL_ITF is the RXI interface table for the Cash Basis Drilldown report in Combined Basis Accounting functionality.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGI_ARC_DRILL_ITF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
JOURNAL_LINE_NUMBER NUMBER (15) Yes Line Number of the journal within the batch.
ACCOUNT_CODE VARCHAR2 (929) Yes Concatenated Account Segment values with delimiters.
ACCOUNT_DESC VARCHAR2 (929)
Concatenated Account Segment descriptions with delimiters.
TRX_TYPE_NAME VARCHAR2 (80)
Type of document leading to the current journal line.
TRX_NUMBER VARCHAR2 (30)
Identifying Number of the document leading to the current journal line.
TRX_DATE DATE

Date of the document leading to the current journal line.
THIRD_PARTY_NAME VARCHAR2 (360)
First 50 characters of the customer name related to the document leading to the current journal line.
ACCOUNTED_DR NUMBER

Accounted debit amount related to the document leading to the current journal line.
ACCOUNTED_CR NUMBER

Accounted Credit amount related to the document leading to the current journal line.
CURRENCY_CODE VARCHAR2 (15)
Currency Code of the debit and credit amounts.
ACCT_LINE_TYPE_NAME VARCHAR2 (80)
Type of accounting line related to the current journal.
BANK_ACCOUNT_NAME VARCHAR2 (80)
Name of the Bank Account associated with the journal amounts.
PAYMENT_DEPOSIT_DATE DATE

Payment Deposit Date
APPLIED_TO_TRX_NUMBER VARCHAR2 (20)
Document number to which the current document is applied.
APPLICATION_DATE DATE

Date on which the current document is applied to another document.
REVERSAL_DATE DATE

Date on which current document is reversed.
ACCOUNTING_DATE DATE

Accounting date for the current journal line.
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Functional Currency Code of the debit and credit amounts.
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
Query Text

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


SELECT REQUEST_ID
,      JOURNAL_LINE_NUMBER
,      ACCOUNT_CODE
,      ACCOUNT_DESC
,      TRX_TYPE_NAME
,      TRX_NUMBER
,      TRX_DATE
,      THIRD_PARTY_NAME
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      CURRENCY_CODE
,      ACCT_LINE_TYPE_NAME
,      BANK_ACCOUNT_NAME
,      PAYMENT_DEPOSIT_DATE
,      APPLIED_TO_TRX_NUMBER
,      APPLICATION_DATE
,      REVERSAL_DATE
,      ACCOUNTING_DATE
,      FUNCTIONAL_CURRENCY_CODE
,      ORGANIZATION_NAME
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM IGI.IGI_ARC_DRILL_ITF;

Dependencies

[top of page]

IGI.IGI_ARC_DRILL_ITF does not reference any database object

IGI.IGI_ARC_DRILL_ITF is referenced by following:

SchemaAPPS
SynonymIGI_ARC_DRILL_ITF