EN_RTG_CST_INQ2(SQL Table) |
Index Back |
|---|---|
Conversion Costsfrom ce_rtg_hrs_vw2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | CE_COST_CAT | Character(3) | VARCHAR2(3) NOT NULL |
Costing Catagory
ADD=Mat Add'l Cost CNV=Direct Conversion Costs LAN=Landed Costs MAT=Materials Catagory OVH=Conversion Overhead |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 6 | RTG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown |
| 7 | RTG_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing |
| 8 | CONVERSION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Conversion Code |
| 9 | OVHD_RATE_CODE | Character(4) | VARCHAR2(4) NOT NULL | Conversion Ovhd Rate Code |
| 10 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 11 | 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 |
| 12 | CE_COST_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Cost Type |
| 13 | COST_VERSION | Character(10) | VARCHAR2(10) NOT NULL | Cost Version |
| 14 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 15 | CE_TOTAL_HOURS | Signed Number(33,15) | DECIMAL(31,15) NOT NULL | Total Hours |
| 16 | RATE_AMOUNT | Number(11,4) | DECIMAL(10,4) NOT NULL | Rate Amount |
| 17 | RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly UN=Per Unit |
| 18 | AOQ | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Average Order Qty |
| 19 | OH_RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Conversion Ovhd Rate Type
%L=% of Labor Amt %M=% of Mach Amt PL=Amt Per Labor Hr PM=Amt Per Mach Hr PU=Per Unit Amt |
| 20 | OVERHEAD_RATE | Number(11,4) | DECIMAL(10,4) NOT NULL | Conversion Overhead Rate |
| 21 | OVERHEAD_PERCENT | Number(5,1) | DECIMAL(4,1) NOT NULL | Conversion Overhead % |
| 22 | CE_EXTENDED_COST | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Extended Cost |
| 23 | CE_EXTENDED_COST4 | Signed Number(21,4) | DECIMAL(19,4) NOT NULL | Extended Cost |
| 24 | YLD_EXTENDED_COST | Signed Number(21,4) | DECIMAL(19,4) NOT NULL | Extended Cost with Yield |
| 25 | YLD_EXTENDED_COST2 | Signed Number(21,4) | DECIMAL(19,4) NOT NULL | Extended Cost with yield |