[Home] [Help] [Dependency Information]
Object Name: | IPA_INTEREST_BATCHES |
---|---|
Object Type: | TABLE |
Owner: | IPA |
FND Design Data: | IPA.IPA_INTEREST_BATCHES |
Subobject Name: | |
Status: | VALID |
Table to store Capitalized Interest Batch Information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IPA_INTEREST_BATCHES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | INTEREST_BATCH_ID |
IPA_INTEREST_BATCHES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
GL_PERIOD
PROJECT_ID EXPENDITURE_ITEM_ID |
IPA_INTEREST_BATCHES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXPENDITURE_ITEM_ID |
IPA_INTEREST_BATCHES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTEREST_BATCH_ID | NUMBER | (15) | Yes | System generated ID |
INTEREST_APPLIED | NUMBER | (15) | Actual Interest applied | |
GL_PERIOD | VARCHAR2 | (15) | GL Period in which the Interest applied | |
PERIOD_BEGIN_DATE | DATE | GL Period begin date | ||
PERIOD_END_DATE | DATE | GL Period end date | ||
EXPENDITURE_ITEM_DATE | DATE | Date with which the interest lines are created | ||
EXPENDITURE_TASK_ID | NUMBER | (15) | Task on which interest line is created | |
STATUS | VARCHAR2 | (20) | Status- REVALIDATE - Interest lines not created in PA due to error SUCCEDED - Interest line successfully interfaced to PA | |
EXPENDITURE_ITEM_ID | NUMBER | (15) | Expenditure Item Id when expenditure item is created. | |
RATE_TYPE | VARCHAR2 | (30) | Rate type used - Not used | |
REVERSAL_DATE | DATE | Date of reversal of interest if reversed | ||
PROJECT_ID | NUMBER | (15) | Project id | |
BATCH_ID | NUMBER | (15) | Yes | Capitalized interest run identification number. |
Cut, paste (and edit) the following text to query this object:
SELECT INTEREST_BATCH_ID
, INTEREST_APPLIED
, GL_PERIOD
, PERIOD_BEGIN_DATE
, PERIOD_END_DATE
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_TASK_ID
, STATUS
, EXPENDITURE_ITEM_ID
, RATE_TYPE
, REVERSAL_DATE
, PROJECT_ID
, BATCH_ID
FROM IPA.IPA_INTEREST_BATCHES;
IPA.IPA_INTEREST_BATCHES does not reference any database object
IPA.IPA_INTEREST_BATCHES is referenced by following:
|
|
|