BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
INV_ITEM_IDPrompt Table: CE_ITEM_OWN_VW
CE_COST_TYPEPrompt Table: CE_TYPE
COST_VERSIONPrompt Table: CE_VERSION
Prompt Table: CE_ELEMENT4_VW
CE_FCST_PUR(SQL Table) |
Index Back |
|---|---|
Forecasted Purchase CostForecasted Purchase Cost 6/17/04 dbe - ICE 729149000 - Change BU prompt table from SP_BUMGOP_NONVW to SP_BUIN_NONVW. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: CE_ITEM_OWN_VW |
| 3 | CE_COST_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Cost Type
Prompt Table: CE_TYPE |
| 4 | COST_VERSION |
Character(10) | VARCHAR2(10) NOT NULL |
Cost Version
Prompt Table: CE_VERSION |
| 5 | COST_AMOUNT | Number(15,4) | DECIMAL(14,4) NOT NULL | Forcasted Purchase Cost |
| 6 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CE_ELEMENT4_VW |