WM_WO_TOOLS_VW(SQL View) |
Index Back |
|---|---|
Work Task Tools SchedulesWork Task Tools Schedules |
| SELECT BUSINESS_UNIT ,WO_ID ,WO_TASK_ID ,RES_LN_NBR ,ASSET_TYPE ,ASSET_SUBTYPE ,BUSINESS_UNIT_AM ,ASSET_ID ,ACTL_DURATION ,ACTL_USAGE ,ACTL_COST_TLS ,CURRENCY_CD ,TOOL_BILL_RATE_ACT ,TOOL_COST_RATE_ACT ,TOOL_UOM FROM PS_WM_WO_SCHED_TLS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 4 | RES_LN_NBR |
Number(5,0) | INTEGER NOT NULL |
Resource Line No.
Default Value: WM_WO_TSK.LAST_SCHEDLN_TLS |
| 5 | ASSET_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Asset Type
010=IT Hardware 020=IT Software 040=Equipment 050=Property 060=Fleet 070=Machinery 080=Furniture 090=Facility 100=Intangible 200=Asset Retirement Obligations 999=Other |
| 6 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL |
Asset Subtype
Prompt Table: AM_SUBTYPE |
| 7 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 8 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: %EDITTABLE4 |
| 9 | ACTL_DURATION | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Actual Duration |
| 10 | ACTL_USAGE | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Actual Usage |
| 11 | ACTL_COST_TLS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Actual Tools Cost |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY |
| 13 | TOOL_BILL_RATE_ACT | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
| 14 | TOOL_COST_RATE_ACT | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
| 15 | TOOL_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Tools Unit of Measure
Prompt Table: UNITS_TBL |