PeopleSoft 9
Asset Management

Table Name AMOPNTRNS_RQST

Table Description
AMOPNTRNS_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
PROCESS_STATUS char(1) No No
TRANS_DATE PSDATE No No
ACCOUNTING_DT PSDATE 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
METHOD char(2) No No
ASSET_TYPE_OPTION char(1) No No
CONVENTION char(2) No No
Index
Name Type Unique Member
PS_AMOPNTRNS_RQST PK Yes
Member(s) of "PS_AMOPNTRNS_RQST" Index
OPRID
RUN_CNTL_ID
REQUEST_ID

Published December 16, 2006