CE_FRZCONRATES(SQL Table) |
Index Back |
|---|---|
Frozen Conversion 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 | CONVERSION_CODE |
Character(4) | VARCHAR2(4) NOT NULL |
Conversion Code
Prompt Table: CE_CONCODE |
| 3 | 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 |
| 4 | RATE_AMOUNT | Number(11,4) | DECIMAL(10,4) NOT NULL | Rate Amount |
| 5 | RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly UN=Per Unit Default Value: HR |
| 6 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CE_ELEMENT1_VW |