[Home] [Help] [Dependency Information]
Object Name: | IGI_MPP_SUBLEDGER |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_MPP_SUBLEDGER |
Subobject Name: | |
Status: | VALID |
IGI_MPP_SUBLEDGER contains accounting entries related to Multi-Period Posting which are then transferred to General Ledger.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGI_MPP_SUBLEDGER_I1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INVOICE_ID
DISTRIBUTION_LINE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Yes | Unique identifier for invoice |
DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Yes | Invoice distribution line number |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
SUBLEDGER_ENTRY_ID | NUMBER | Yes | Sequence number | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code |
ACTUAL_FLAG | VARCHAR2 | (1) | Yes | Indicates whether amount to be transferred to General Ledger is an A (Actual) or E (Encumbrance) amount. Currently only Actual amounts are supported. |
JE_SOURCE_NAME | VARCHAR2 | (25) | Yes | Multi-Period Posting journal source |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Yes | Multi-Period Posting journal category |
SET_OF_BOOKS_ID | NUMBER | Yes | Set of Books identifier | |
GL_DATE | DATE | Yes | General Ledger date | |
EXPENSE_RECOGNIZED_FLAG | VARCHAR2 | (1) | Indicates whether expense recognition routine has marked this entry | |
GL_POSTED_FLAG | VARCHAR2 | (1) | Indicates if posting to General Ledger has occurred | |
CODE_COMBINATION_ID | NUMBER | Accounting code | ||
ACCOUNTED_DR | NUMBER | Debit account for functional currency | ||
ACCOUNTED_CR | NUMBER | Credit account for functional currency | ||
ENTERED_DR | NUMBER | Debit account for transactional currency | ||
ENTERED_CR | NUMBER | Credit account for transactional currency | ||
CURRENCY_CONVERSION_DATE | DATE | Date of currency conversion when exchange occurs from transactional currency to functional currency | ||
USER_CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Type of currency conversion when exchange occurs from transactional currency to functional currency. User, Company, or Spot. | |
CURRENCY_CONVERSION_RATE | NUMBER | Rate of currency conversion when exchange occurs from transactional currency to functional currency | ||
PERIOD_NAME | VARCHAR2 | (15) | Accounting period name | |
CHART_OF_ACCOUNTS_ID | NUMBER | Identifier for chart of accounts | ||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | Currency code for functional currency | |
DATE_CREATED_IN_GL | DATE | Creation date in General Ledger. Not currently used. | ||
JE_BATCH_NAME | VARCHAR2 | (100) | Journal batch name for General Ledger. Not currently used. | |
JE_BATCH_DESCRIPTION | VARCHAR2 | (100) | Detailed description of journal batch name for General Ledger. Not currently used. | |
JE_HEADER_NAME | VARCHAR2 | (100) | Journal header name for General Ledger. Not currently used. | |
JE_LINE_DESCRIPTION | VARCHAR2 | (100) | Detailed description for journal line in General Ledger. Not currently used. | |
REVERSE_JOURNAL_FLAG | VARCHAR2 | (1) | Indicates if reversal process has occurred. Not currently used. | |
REVERSAL_PERIOD_NAME | VARCHAR2 | (15) | Accounting period involved in the reversal process. Not currently used. | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | General Ledger transaction code. Not currently used. | |
REFERENCE1 | VARCHAR2 | (240) | Reference information about Multi-Period Posting distribution line numbers. | |
REFERENCE2 | VARCHAR2 | (240) | Reference information about Multi-Period Posting distribution line numbers. Not currently used. | |
REFERENCE3 | VARCHAR2 | (240) | Reference information about Multi-Period Posting distribution line numbers. Not currently used. |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, DISTRIBUTION_LINE_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SUBLEDGER_ENTRY_ID
, CURRENCY_CODE
, ACTUAL_FLAG
, JE_SOURCE_NAME
, JE_CATEGORY_NAME
, SET_OF_BOOKS_ID
, GL_DATE
, EXPENSE_RECOGNIZED_FLAG
, GL_POSTED_FLAG
, CODE_COMBINATION_ID
, ACCOUNTED_DR
, ACCOUNTED_CR
, ENTERED_DR
, ENTERED_CR
, CURRENCY_CONVERSION_DATE
, USER_CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, PERIOD_NAME
, CHART_OF_ACCOUNTS_ID
, FUNCTIONAL_CURRENCY_CODE
, DATE_CREATED_IN_GL
, JE_BATCH_NAME
, JE_BATCH_DESCRIPTION
, JE_HEADER_NAME
, JE_LINE_DESCRIPTION
, REVERSE_JOURNAL_FLAG
, REVERSAL_PERIOD_NAME
, USSGL_TRANSACTION_CODE
, REFERENCE1
, REFERENCE2
, REFERENCE3
FROM IGI.IGI_MPP_SUBLEDGER;
IGI.IGI_MPP_SUBLEDGER does not reference any database object
IGI.IGI_MPP_SUBLEDGER is referenced by following:
|
|
|