SF_FRZCRATES_VW(SQL View) |
Index Back |
|---|---|
Prdn Frozen Conversion Rates |
| select distinct a.business_unit , b.production_id , a.conversion_code , a.conrate_type , a.rate_amount , a.rate_type , a.cost_element from ps_ce_frzconrates a, PS_SF_OP_LIST b where a.business_unit = b.business_unit 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 |