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 |