[Home] [Help] [Dependency Information]
Object Name: | IGI_IAC_ADJUSTMENTS |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_IAC_ADJUSTMENTS |
Subobject Name: | |
Status: | VALID |
IGI_IAC_ADJUSTMENTS holds the accounting information. Driver table for creating Journals
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGI_ADJUSTMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ADJUSTMENT_ID
DISTRIBUTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADJUSTMENT_ID | NUMBER | (15) | Yes | Foreign key to IGI_IAC_TRANSACTION_HEADERS |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book Identifier |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | Code Combination Identifier |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
DR_CR_FLAG | VARCHAR2 | (3) | Yes | Debit Credit Flag |
AMOUNT | NUMBER | Yes | Amount impacted | |
ADJUSTMENT_TYPE | VARCHAR2 | (15) | Yes | Account Type Impacted |
TRANSFER_TO_GL_FLAG | VARCHAR2 | (1) | Y/N | |
UNITS_ASSIGNED | NUMBER | Units impacted in the transactions | ||
ASSET_ID | NUMBER | Yes | Asset identifier | |
DISTRIBUTION_ID | NUMBER | Yes | Distribution Identifier | |
PERIOD_COUNTER | NUMBER | Yes | Period Counter | |
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. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
ADJUSTMENT_OFFSET_TYPE | VARCHAR2 | (15) | Offset account entry for the account type | |
REPORT_CCID | NUMBER | Holds the code combination for Reval Reserve or OP Expense for reporting purpose. | ||
EVENT_ID | NUMBER | (15) | event id |
Cut, paste (and edit) the following text to query this object:
SELECT ADJUSTMENT_ID
, BOOK_TYPE_CODE
, CODE_COMBINATION_ID
, SET_OF_BOOKS_ID
, DR_CR_FLAG
, AMOUNT
, ADJUSTMENT_TYPE
, TRANSFER_TO_GL_FLAG
, UNITS_ASSIGNED
, ASSET_ID
, DISTRIBUTION_ID
, PERIOD_COUNTER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ADJUSTMENT_OFFSET_TYPE
, REPORT_CCID
, EVENT_ID
FROM IGI.IGI_IAC_ADJUSTMENTS;
IGI.IGI_IAC_ADJUSTMENTS does not reference any database object
IGI.IGI_IAC_ADJUSTMENTS is referenced by following:
|
|
|