BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
OVHD_RATE_CODEPrompt Table: CE_CONOH_CODE
%L=% of Labor Amt
%M=% of Mach Amt
PL=Amt Per Labor Hr
PM=Amt Per Mach Hr
PU=Per Unit Amt
Prompt Table: CE_ELEMENT2_VW
CE_FRZCON_OH(SQL Table) |
Index Back |
|---|---|
Frozen Conversion Ovhd Rates |
| # | 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 | OVHD_RATE_CODE |
Character(4) | VARCHAR2(4) NOT NULL |
Conversion Ovhd Rate Code
Prompt Table: CE_CONOH_CODE |
| 3 | OVERHEAD_RATE | Number(11,4) | DECIMAL(10,4) NOT NULL | Conversion Overhead Rate |
| 4 | OVERHEAD_PERCENT | Number(5,1) | DECIMAL(4,1) NOT NULL | Conversion Overhead % |
| 5 | 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 |
| 6 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CE_ELEMENT2_VW |