PeopleSoft 9
Asset Management

Table Name AMREVAL_RQST

Table Description
AMREVAL_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
IMPAIR_FREQUENCY CHAR(1) No No
PROCESS_STATUS char(1) No No
BUSINESS_UNIT char(5) No No
BOOK char(10) No No
ASSET_FLAG char(1) No No
ASSET_ID_FROM char(12) No No
ASSET_ID_TO char(12) No No
OPERATING_UNIT char(8) No No
PRODUCT char(6) No No
FUND_CODE char(5) No No
CLASS_FLD char(5) No No
PROGRAM_CODE char(5) No No
BUDGET_REF char(8) No No
AFFILIATE char(5) No No
AFFILIATE_INTRA1 char(10) No No
AFFILIATE_INTRA2 char(10) No No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
PROJECT_ID char(15) No No
DEPTID char(10) No No
CATEGORY char(5) No No
COST_TYPE char(1) No No
TRANS_DT PSDATE No No
ACCOUNTING_DT PSDATE No No
PERCENT_PNL decimal(9,6) No No
AMOUNT decimal(26,3) No No
CURRENCY_CD char(3) No No
INCLUDE_CUR_PD_DPR char(1) No No
IMP_COMMENT_PB CHAR(1) No No
REVALUE_METHOD CHAR(1) No No
REVALUE_METHOD_1 CHAR(1) No No
REVALUE_METHOD_3 CHAR(1) No No
FMV_PERCENT DECIMAL(9,6) No No
NBV_PERCENT DECIMAL(9,6) No No
CONVENTION CHAR(2) No No
EXC_AST_IMP_DT_AFT PSDATE No No
COPY_TO_OTH_BK CHAR(1) No No
USE_FMV CHAR(1) No No
PROFILE_ID CHAR(10) No No
LOCATION CHAR(10) No No
REVAL_COST_TYPE CHAR(1) No No
ASSET_CLASS CHAR(10) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_AMREVAL_RQST PK Yes
Member(s) of "PS_AMREVAL_RQST" Index
OPRID
RUN_CNTL_ID
REQUEST_ID

Published December 16, 2006