PeopleSoft 9
Asset Management

Table Name AMPARCHDIU_RQST

Table Description
AMPARCHDIU_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
BUSINESS_UNIT char(5) No No
ASSET_ID char(12) No No
NEW_BUSINESS_UNIT char(5) No No
PROFILE_ID char(10) No No
CONVENTION char(2) No No
TRANS_DT PSDATE No No
ACCOUNTING_DT PSDATE No No
TRANS_CODE char(5) No No
NUM_CHILD_ASSETS int No No
INCL_PARENT_ASSET char(1) No No
WHERE_CLAUSE_LONG TEXT No No
Index
Name Type Unique Member
PS_AMPARCHDIU_RQST PK Yes
Member(s) of "PS_AMPARCHDIU_RQST" Index
OPRID
RUN_CNTL_ID
REQUEST_ID

Published December 16, 2006