SF_CONV_COST_VW(SQL View) |
Index Back |
|---|---|
OpList Hours View |
| SELECT A.BUSINESS_UNIT ,A.PRODUCTION_ID ,A.OP_SEQUENCE ,A.CONVERSION_CODE ,A.TIME_TYPE ,C.COST_ELEMENT ,A.CE_TOTAL_HOURS ,C.RATE_AMOUNT ,C.RATE_TYPE ,A.AOQ ,%Round((%DecMult(%round(%DecMult(A.CE_TOTAL_HOURS, C.RATE_AMOUNT),15), D.CE_RATE_HR)+%Round(%DecMult(C.RATE_AMOUNT, D.CE_RATE_UN),15)),15) FROM PS_SF_OP_HRS_VW2 A , PS_CE_FRZCONRATES C , PS_CE_HR_CONV D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.CONVERSION_CODE = C.CONVERSION_CODE AND A.TIME_TYPE = C.CONRATE_TYPE AND D.CE_SOURCE = 'RATES' AND C.RATE_TYPE = D.RATE_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 3 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 4 | CONVERSION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Conversion Code |
| 5 | TIME_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Time / Resource Type
0100=Planning Labor Setup 0200=Planning Labor Fixed Run 0300=Planning Labor Run 0400=Planning Labor Post Prod 0500=Planning Machine Setup 0600=Planning Machine Fixed Run 0700=Planning Machine Run 0800=Planning Machine Post Prod 1100=Costing Labor Setup 1200=Costing Labor Fixed Run 1300=Costing Labor Run 1400=Costing Labor Post Prod 1500=Costing Machine Setup 1600=Costing Machine Fixed Run 1700=Costing Machine Run 1800=Costing Machine Post Prod 2000=Queue Time 3000=Intransit Time |
| 6 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 7 | CE_TOTAL_HOURS | Signed Number(33,15) | DECIMAL(31,15) NOT NULL | Total Hours |
| 8 | RATE_AMOUNT | Number(11,4) | DECIMAL(10,4) NOT NULL | Rate Amount |
| 9 | RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly UN=Per Unit |
| 10 | AOQ | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Average Order Qty |
| 11 | CE_EXTENDED_COST | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Extended Cost |