PeopleSoft 9
Asset Management

Table Name AMAEDIST_RQST

Table Description
AMAEDIST_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
PROCESS_INSTANCE decimal(10) No No
PROCESS_ORIG char(1) No No
DTTM_STAMP_SEC PSDATETIME No No
PARALLEL_SW char(1) No No
PROCESSING_SEQ int No No
OPEN_TRANS_FLAG char(1) No No
OPEN_TRANS_ID decimal(10) No No
TO_OPEN_TRANS_ID decimal(10) No No
BUSINESS_UNIT char(5) No No
BOOK char(10) No No
ASSET_ID_FROM char(12) No No
ASSET_ID_TO char(12) No No
BASE_CURRENCY char(3) No No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
RT_TYPE char(5) No No
RATE_EFFDT PSDATE No No
COST_SUM_SW char(1) No No
Index
Name Type Unique Member
PS_AMAEDIST_RQST PK Yes
Member(s) of "PS_AMAEDIST_RQST" Index
OPRID
RUN_CNTL_ID
REQUEST_ID

Published December 16, 2006