PeopleSoft 9
Asset Management

Table Name AMDPCOMP_RQST

Table Description
AMDPCOMP_RQST
Columns
Name Datatype Is PK Is FK
OPRID char(30) Yes No
RUN_CNTL_ID char(30) Yes No
RUN_ID char(25) No No
BUSINESS_UNIT char(5) No No
BOOK char(10) No No
PROFILE_ID char(10) No No
ASSET_ID_FROM char(12) No No
ASSET_ID_TO char(12) No No
LIFE_SELECTION smallint No No
METHOD_SELECTION char(2) No No
FROM_FISCAL_YEAR smallint No No
DATE_FROM PSDATE No No
DATE_TO PSDATE No No
FROM_PERIOD smallint No No
THRU_FISCAL_YEAR smallint No No
THRU_PERIOD smallint No No
CONVENTION char(2) No No
TAG_NUMBER_FROM char(12) No No
TAG_NUMBER_TO char(12) No No
LIFE smallint No No
DEPR_PERCENT decimal(9,8) No No
DB_PERCENT decimal(15,14) No No
METHOD char(2) No No
DEPR_SCHED_CD char(10) No No
UD_METHOD_ID char(5) No No
LIFE_END_DT PSDATE No No
DEPR_LOW_LIMIT decimal(26,3) No No
DEPR_AVG_OPTION char(1) No No
UOP_ID char(10) No No
CALCULATION_TYPE char(1) No No
RESET_CALC_TYPE_PB char(1) No No
RESET_AVG_OPTN_PB char(1) No No
PERIOD_DEPR_SW char(1) No No
DEPR_PASS_LIFE_SW char(1) No No
DEPR_LIMIT_PCT decimal(5,2) No No
MULTI_SHIFT_CODE char(6) No No
LOW_VALUE_SW char(1) No No
DEPR_LIMIT_CD char(10) No No
TRANSACTION_DT PSDATE No No
ACCOUNTING_DT PSDATE No No
PROCESSING_SEQ int No No
DELETE_STG char(1) No No
Index
Name Type Unique Member
PS_AMDPCOMP_RQST PK Yes
Member(s) of "PS_AMDPCOMP_RQST" Index
OPRID
RUN_CNTL_ID

Published December 16, 2006