CE_CONOH_RT_TMP(SQL Table) |
Index Back |
|---|---|
Conversion Ovhd Rate Temp10/09/99 lee - this record is used as temp record for ce_conoh_rate; it must be identical to it. I added activity id because the record ce_conoh_rate had it added, due to the abm overhead cost interface. |
| # | 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_BUMGOP_NONVW |
| 2 | CE_COST_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Cost Type
Prompt Table: CE_TYPE |
| 3 | COST_VERSION |
Character(10) | VARCHAR2(10) NOT NULL |
Cost Version
Prompt Table: CE_VERSION |
| 4 | OVHD_RATE_CODE |
Character(4) | VARCHAR2(4) NOT NULL |
Conversion Ovhd Rate Code
Prompt Table: CE_CONOH_CODE |
| 5 | OVERHEAD_RATE | Number(11,4) | DECIMAL(10,4) NOT NULL | Conversion Overhead Rate |
| 6 | OVERHEAD_PERCENT | Number(5,1) | DECIMAL(4,1) NOT NULL | Conversion Overhead % |
| 7 | OH_RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Conversion Ovhd Rate Type
%L=% of Labor Amt %M=% of Mach Amt PL=Amt Per Labor Hr PM=Amt Per Mach Hr PU=Per Unit Amt Default Value: PU |
| 8 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CE_ELEMENT2_VW |
| 9 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |