LM_ADHCCOST_LVW (SQL View)	Index Back
Activity Adhoc Cost VW Display all user entered ad-hoc costs associated with an activity.

LM_ADHCCOST_LVW

(SQL View)

Activity Adhoc Cost VW

Display all user entered ad-hoc costs associated with an activity.

SELECT LM_ACT_ID ,LM_COST_ID ,LANGUAGE_CD ,LM_COST_DESCR FROM PS_LM_ACTCOST_LANG

Related Language Record for LM_ADHC_COST_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

2 LM_COST_ID Number(4,0) SMALLINT NOT NULL Cost ID

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 LM_COST_DESCR Character(100) VARCHAR2(100) NOT NULL Cost Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
2	LM_COST_ID	Number(4,0)	SMALLINT NOT NULL	Cost ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LM_COST_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Cost Description