SF_FRZCON_OH_VW(SQL View) |
Index Back |
|---|---|
Prdn Frozen Conv Ovhd Rates |
| select distinct a.business_unit ,b.production_id ,a.ovhd_rate_code ,a.overhead_rate ,a.overhead_percent ,a.oh_rate_type ,a.cost_element from ps_ce_frzcon_oh a, PS_SF_OP_LIST b where a.business_unit = b.business_unit and ((a.ovhd_rate_code = b.con_oh_code_1) or (a.ovhd_rate_code = b.con_oh_code_2) or (a.ovhd_rate_code = b.con_oh_code_3) or (a.ovhd_rate_code = b.con_oh_code_4)) |
| # | 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 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 3 | OVHD_RATE_CODE |
Character(4) | VARCHAR2(4) NOT NULL |
Conversion Ovhd Rate Code
Prompt Table: CE_CONOH_CODE |
| 4 | OVERHEAD_RATE | Number(11,4) | DECIMAL(10,4) NOT NULL | Conversion Overhead Rate |
| 5 | OVERHEAD_PERCENT | Number(5,1) | DECIMAL(4,1) NOT NULL | Conversion Overhead % |
| 6 | 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 |
| 7 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CE_ELEMENT2_VW |