[Home] [Help] [Dependency Information]
Object Name: | IGI_RECOVERABLE_LINES_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_RECOVERABLE_LINES_ALL |
Subobject Name: | |
Status: | VALID |
IGI_RECOVERABLE_LINES_ALL contains additional recoverable information for cash basis transaction information for the Gross Based VAT functionality.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Invoice Identifier | |
ACCOUNTING_DATE | DATE | Accounting Date | ||
INVOICE_DATE | DATE | Invoice Date | ||
INV_CURRENCY_CODE | VARCHAR2 | (15) | Invoice Currency Code | |
ACCRUAL_SET_OF_BOOKS_ID | NUMBER | (15) | Set of books id corresponding to the accrual book | |
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). | |
TAX_DISTRIBUTION_ID | NUMBER | (15) | Tax Distribution Identifier | |
TAX_CCID | NUMBER | (15) | Tax Code combination identifier | |
TAX_AMOUNT | NUMBER | Tax amount | ||
ITEM_DISTRIBUTION_ID | NUMBER | (15) | Item distribution identifier | |
ITEM_CCID | NUMBER | (15) | Item Code Combination identifier. | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
CREATED_DATE | DATE | Standard Who Column | ||
ORG_ID | NUMBER | (15) | Organization identifier | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
JE_CREATED_FLAG | VARCHAR2 | (1) | Flag to indicate whether a journal entry has been created in Cash Set of Books. |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, ACCOUNTING_DATE
, INVOICE_DATE
, INV_CURRENCY_CODE
, ACCRUAL_SET_OF_BOOKS_ID
, REQUEST_ID
, TAX_DISTRIBUTION_ID
, TAX_CCID
, TAX_AMOUNT
, ITEM_DISTRIBUTION_ID
, ITEM_CCID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATED_DATE
, ORG_ID
, LAST_UPDATE_LOGIN
, JE_CREATED_FLAG
FROM IGI.IGI_RECOVERABLE_LINES_ALL;
IGI.IGI_RECOVERABLE_LINES_ALL does not reference any database object
IGI.IGI_RECOVERABLE_LINES_ALL is referenced by following:
|
|
|