SF_AUTOFRZOH_VW(SQL View) |
Index Back |
|---|---|
Prdn Frozen Conv Ovhd Rates |
| SELECT DISTINCT a.business_unit ,c.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_en_rtg_ops b , ps_sf_prdnid_headr c , PS_BU_ITEMS_INV d WHERE a.business_unit = b.business_unit AND b.business_unit = c.business_unit AND c.business_unit = d.business_unit AND c.inv_item_id = d.inv_item_id AND b.inv_item_id = d.ref_routing_item AND b.rtg_type = c.production_type AND b.rtg_code = c.rtg_code AND b.rtg_state='PR' 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 |