AM_MULTSEL_RQST (SQL Table)	Index Back
AM Multi-Select Request For use by components like WorkCenter to store the Assets that wer e selected to be processed in batch.

AM_MULTSEL_RQST

(SQL Table)

AM Multi-Select Request

For use by components like WorkCenter to store the Assets that wer e selected to be processed in batch.

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

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID

3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_AM_NONVW

5 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

6 ASSET_ID_FROM Character(12) VARCHAR2(12) NOT NULL From Asset ID

7 ASSET_ID_TO Character(12) VARCHAR2(12) NOT NULL Asset ID to

8 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID

9 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

10 DTTM_STAMP_SEC 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: PRCSRUNCNTL.OPRID
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Default Value: PRCSRUNCNTL.RUN_CNTL_ID
3	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AM_NONVW
5	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
6	ASSET_ID_FROM	Character(12)	VARCHAR2(12) NOT NULL	From Asset ID
7	ASSET_ID_TO	Character(12)	VARCHAR2(12) NOT NULL	Asset ID to
8	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
9	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
10	DTTM_STAMP_SEC	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.