[Home] [Help] [Dependency Information]
Object Name: | IGW_REPORT_BUDGET_BASE_RATE |
---|---|
Object Type: | TABLE |
Owner: | IGW |
FND Design Data: | IGW.IGW_REPORT_BUDGET_BASE_RATE |
Subobject Name: | |
Status: | VALID |
IGW_REPORT_BUDGET_BASE_RATE stores base amounts or direct costs for all budget periods in the proposal.
This is a processing table used in printing proposals.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGW_REPORT_BUDG_BASE_RATE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROPOSAL_ID
VERSION_ID BUDGET_PERIOD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPOSAL_ID | NUMBER | (15) | Yes | Proposal identifier |
VERSION_ID | NUMBER | (15) | Yes | Budget version identifier |
BUDGET_PERIOD_ID | NUMBER | (15) | Yes | Budget period identifier |
BASE_AMOUNT | NUMBER | Base amount for buget period on which indirect cost is applied | ||
RATE_APPLIED | NUMBER | Overhead rate that is applied on the base amount | ||
TOTAL_INDIRECT_COST | NUMBER | (17) | Total indirect cost calculation based on base amount and applicable rate | |
START_DATE | DATE | Start date of budget period | ||
END_DATE | DATE | End date of budget period | ||
FISCAL_YEAR | NUMBER | (4) | Fiscal year on which the base rate is calculated | |
PROPOSAL_FORM_NUMBER | VARCHAR2 | (30) | Proposal form number or EDI transaction set number. Examples are PHS 398 and 194TS. |
Cut, paste (and edit) the following text to query this object:
SELECT PROPOSAL_ID
, VERSION_ID
, BUDGET_PERIOD_ID
, BASE_AMOUNT
, RATE_APPLIED
, TOTAL_INDIRECT_COST
, START_DATE
, END_DATE
, FISCAL_YEAR
, PROPOSAL_FORM_NUMBER
FROM IGW.IGW_REPORT_BUDGET_BASE_RATE;
IGW.IGW_REPORT_BUDGET_BASE_RATE does not reference any database object
IGW.IGW_REPORT_BUDGET_BASE_RATE is referenced by following:
|
|
|