| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT
Prompt Table:
SP_BU_WM_NONVW
|
| 2 |
WO_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table:
WM_WO_TYPE
|
| 3 |
SRVC_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Group
Prompt Table:
WM_SRVC_GRP_BU
|
| 4 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Default Value: BUS_UNIT_TBL_WM.BUSINESS_UNIT_PC
Prompt Table:
BUS_UNIT_TBL_PC
|
| 5 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDITTABLE
|
| 6 |
INTEGRATION_MODULE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to define integration modules that a product integrates with. This field has translate values.
1=Purchasing/Payables
2=Inventory
3=Expenses
4=Project Costing
|
| 7 |
RSRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor
2=Tools
3=Material
|
| 8 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RES_TYPE
Set Control Field: BUSINESS_UNIT_PC
|
| 9 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
PROJ_CATG_TBL
Set Control Field: BUSINESS_UNIT_PC
|
| 10 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
PROJ_SUBCAT_TBL
Set Control Field: BUSINESS_UNIT_PC
|