WM_COST_GRP (SQL Table)	Index Back
Cost Inquiry Asset Temporary

WM_COST_GRP

(SQL Table)

Cost Inquiry Asset Temporary

# 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: WM_COST_SRCH.OPRID

2 WM_ASSET_GRP Character(10) VARCHAR2(10) NOT NULL Asset Cost Group
Default Value: WM_COST_SRCH.WM_ASSET_GRP

3 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AM_NONVW

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

5 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.
Default Value: %Datetime

6 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: WM_COST_SRCH.OPRID
2	WM_ASSET_GRP	Character(10)	VARCHAR2(10) NOT NULL	Asset Cost Group Default Value: WM_COST_SRCH.WM_ASSET_GRP
3	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW
4	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification Prompt Table: WM_ASSET_VWA
5	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. Default Value: %Datetime
6	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.