WM_CINQ_WO (SQL Table)	Index Back
Work Order Cost Search Cost Inquiry

WM_CINQ_WO

(SQL Table)

Work Order Cost Search

Cost Inquiry

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEARCH_ID Character(10) VARCHAR2(10) NOT NULL Search ID

2 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
Prompt Table: PSOPRDEFN

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT
Prompt Table: SP_BU_WM_NONVW

5 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
Prompt Table: WM_CINQ_WO_VW

6 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type
Prompt Table: WM_WO_TYPE
Set Control Field: BUSINESS_UNIT_WO

7 BUSINESS_UNIT_WR Character(5) VARCHAR2(5) NOT NULL Work Request Business Unit
Prompt Table: BUS_UNIT_TBL_WR

8 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID
Prompt Table: WM_CINQ_WR_VW

9 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
Prompt Table: WM_CINQ_SHOP_VW

10 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: LOCATION_TBL
Set Control Field: BUSINESS_UNIT_WO

11 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

12 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: WM_CINQ_PROJ_VW

13 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
Prompt Table: SP_BU_AM_NONVW

14 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
Prompt Table: WM_ASSET_VWA

15 SRCH_OPR_1 Character(2) VARCHAR2(2) NOT NULL Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals
Default Value: =

16 SRCH_OPR_2 Character(2) VARCHAR2(2) NOT NULL Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals
Default Value: =

17 SRCH_OPR_3 Character(2) VARCHAR2(2) NOT NULL Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals
Default Value: =

18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEARCH_ID	Character(10)	VARCHAR2(10) NOT NULL	Search ID
2	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID Prompt Table: PSOPRDEFN
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW
5	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Prompt Table: WM_CINQ_WO_VW
6	WO_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Work Order Type Prompt Table: WM_WO_TYPE Set Control Field: BUSINESS_UNIT_WO
7	BUSINESS_UNIT_WR	Character(5)	VARCHAR2(5) NOT NULL	Work Request Business Unit Prompt Table: BUS_UNIT_TBL_WR
8	WR_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Request ID Prompt Table: WM_CINQ_WR_VW
9	SHOP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shop Identification Prompt Table: WM_CINQ_SHOP_VW
10	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL Set Control Field: BUSINESS_UNIT_WO
11	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
12	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: WM_CINQ_PROJ_VW
13	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Prompt Table: SP_BU_AM_NONVW
14	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification Prompt Table: WM_ASSET_VWA
15	SRCH_OPR_1	Character(2)	VARCHAR2(2) NOT NULL	Field search operator <=Less than <==Less than or equals ==Equals >=Greater than >==Greater than or equals Default Value: =
16	SRCH_OPR_2	Character(2)	VARCHAR2(2) NOT NULL	Field search operator <=Less than <==Less than or equals ==Equals >=Greater than >==Greater than or equals Default Value: =
17	SRCH_OPR_3	Character(2)	VARCHAR2(2) NOT NULL	Field search operator <=Less than <==Less than or equals ==Equals >=Greater than >==Greater than or equals Default Value: =
18	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.