DFW_SF_ERN_CST(SQL View) |
Index Back |
|---|
| SELECT DISTINCT BUSINESS_UNIT , PRODUCTION_ID , OP_SEQUENCE , CONVERSION_TYPE , CONVERSION_AMT , RATE_AMOUNT , RATE_TYPE , OP_TIME_RATE , COST_ELEMENT , REVALUE_FLAG FROM PS_SF_EARNCONCOST |
| # | 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_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Conversion Type
1100=Lab Setup 1200=Lab Fixed 1300=Labor Run 1400=Lab PostPr 1500=Mach Setup 1600=Mach Fixed 1700=Mach Run 1800=MC PostPrd 2100=Ovhd 1 2200=Ovhd 2 2300=Ovhd 3 2400=Ovhd 4 |
| 5 | CONVERSION_AMT | Signed Number(12,4) | DECIMAL(10,4) NOT NULL | Conversion Amount |
| 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 |
| 8 | OP_TIME_RATE | Number(9,2) | DECIMAL(8,2) NOT NULL | Operation Time/Rate |
| 9 | COST_ELEMENT |
Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 10 | REVALUE_FLAG |
Character(1) | VARCHAR2(1) NOT NULL |
Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.
Y/N Table Edit Default Value: N |