WM_QWO_FILTER(SQL Table) |
Index Back |
|---|---|
Fluid Quick Work Order filterFluid Quick Work Order filter |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW |
| 3 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table: WM_WOA_WOID |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL |
Description of length 254
Default Value: WM_WO_HDR.DESCR254 |
| 5 | SHOP | Character(16) | VARCHAR2(16) NOT NULL |
Shop Tag
Prompt Table: WM_WOA_SHOPID |
| 6 | PRIORITY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table: WM_PRIORITY |
| 7 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Group
Default Value: OPR_DEF_TBL_WM.SRVC_GRP_ID Prompt Table: WM_SRVC_GRP_BU |
| 8 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table: WM_WO_TYPE |
| 9 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table: WM_STATUS_HDR |
| 10 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 11 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: BUS_UNIT_AM_VW |
| 12 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: WM_ASSET_VWA |
| 13 | ASSET_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Asset Location |
| 14 | AREA_ID | Character(10) | VARCHAR2(10) NOT NULL | Area ID |
| 15 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL |
Tag Number
Prompt Table: WM_TAG_DVW |
| 16 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL |
Serial ID
Prompt Table: WM_SERIAL_DVW |