BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
INV_ITEM_IDPrompt Table: MST_ITM_PRPT_VW
EFFDTCOST_HST_INV_VW(SQL View) |
Index Back |
|---|---|
Item Inbound Costs - View |
| select distinct business_unit, inv_item_id, staged_date, cost_element, actual_cost from PS_CM_RCV_COST_INV |
| # | 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: MST_ITM_PRPT_VW |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 5 | TL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | This Level Cost |