PeopleSoft 9
Asset Management

Table Name AMDPREPT_RQST

Table Description
AMDPREPT_RQST
Columns
Name Datatype Is PK Is FK
OPRID char(30) Yes No
RUN_CNTL_ID char(30) Yes No
REQUEST_ID char(10) Yes No
PROCESS_FREQUENCY char(1) No No
PARALLEL_SW char(1) No No
PROCESSING_SEQ int No No
USE_OPEN_TRANS_SW char(1) No No
KEEP_ENTRIES char(1) No No
PROCESS_STATUS char(1) No No
FISCAL_YEAR_FROM smallint No No
FISCAL_YEAR_TO smallint No No
BUSINESS_UNIT char(5) No No
BOOK char(10) No No
FROM_ASSET_ID char(12) No No
TO_ASSET_ID char(12) No No
UPDATE_STATISTICS char(1) No No
CUR_ACTIVITY_SW char(1) No No
Index
Name Type Unique Member
PS_AMDPREPT_RQST PK Yes
Member(s) of "PS_AMDPREPT_RQST" Index
OPRID
RUN_CNTL_ID
REQUEST_ID

Published December 16, 2006