CM_PRDCOST_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for CM_PRODCOST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MST_ITM_PRPT_VW |
| 4 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 5 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CM_ELEMENT |
| 7 | TL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | This Level Cost |
| 8 | LL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Lower Level Cost |
| 9 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 10 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |