CE_FRZCNRT_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for CE_FRZCONRATES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 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 |
| 8 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |