CE_CONRATE_TMP(SQL Table) |
Index Back |
|---|---|
Conversion Rates Temp |
| # | 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 | CE_COST_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Cost Type
Prompt Table: CE_TYPE |
| 3 | COST_VERSION |
Character(10) | VARCHAR2(10) NOT NULL |
Cost Version
Prompt Table: CE_VERSION |
| 4 | CONVERSION_CODE |
Character(4) | VARCHAR2(4) NOT NULL |
Conversion Code
Prompt Table: CE_CONCODE |
| 5 | 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 |
| 6 | RATE_AMOUNT | Number(11,4) | DECIMAL(10,4) NOT NULL | Rate Amount |
| 7 | RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly UN=Per Unit Default Value: HR |
| 8 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CE_ELEMENT1_VW |