SF_AUTOFRZR_VW(SQL View) |
Index Back |
|---|---|
Prdn Frz Conv Rates Auto Add |
| SELECT DISTINCT a.business_unit , c.production_id , a.conversion_code , a.conrate_type , a.rate_amount , a.rate_type , a.cost_element FROM ps_ce_frzconrates 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.conversion_code = b.conversion_code |
| # | 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: BUS_UNIT_TBL_IN |
| 2 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 3 | CONVERSION_CODE |
Character(4) | VARCHAR2(4) NOT NULL |
Conversion Code
Prompt Table: CE_CONCODE |
| 4 | CONRATE_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Conversion Rate Type
1100=Labor Setup Rate 1200=Labor Fixed Run Rate 1300=Labor Run Rate 1400=Labor Post Prod Rate 1500=Machine Setup Rate 1600=Machine Fixed Run Rate 1700=Machine Run Rate 1800=Machine Post Prod Rate |
| 5 | RATE_AMOUNT | Number(11,4) | DECIMAL(10,4) NOT NULL | Rate Amount |
| 6 | RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly UN=Per Unit Default Value: HR |
| 7 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CE_ELEMENT1_VW |