BUSINESS_UNITPrompt Table: WM_SRVC_GRP
Prompt Table: WM_SHOP_BU_VW
Prompt Table: WM_WO_IN_BU_VW
1=Tag Number
2=Serial ID
3=Vehicle ID Number
4=Asset ID
5=Do not display asset fields
WM_WO_BU_VW(SQL View) |
Index Back |
|---|---|
Work Order Business Unit ViewWork Order Business Unit view to publish business unit data to mobile devices. |
| SELECT A.BUSINESS_UNIT , B.DESCR , A.SRVC_GRP_ID , A.SHOP_ID , A.BUSINESS_UNIT_IN , A.ASSET_FIELD , A.BUSINESS_UNIT_PC FROM PS_BUS_UNIT_TBL_WM A , PS_BUS_UNIT_TBL_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Group
Prompt Table: WM_SRVC_GRP |
| 4 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table: WM_SHOP_BU_VW |
| 5 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL |
Inventory Unit
Prompt Table: WM_WO_IN_BU_VW |
| 6 | ASSET_FIELD | Character(1) | VARCHAR2(1) NOT NULL |
Field to use for Asset lookup on Work Request
1=Tag Number 2=Serial ID 3=Vehicle ID Number 4=Asset ID 5=Do not display asset fields |
| 7 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |