PeopleSoft 9
Asset Management

Table Name RETIREMENT_NF

Table Description
RETIREMENT_NF
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes No
DTTM_STAMP PSDATETIME Yes No
RETIREMENT_DT PSDATE No No
TRANS_DT PSDATE No No
CONVENTION char(2) No No
END_DEPR_DT PSDATE No No
DISPOSAL_CODE char(1) No No
RETIREMENT_TYPE char(1) No No
RETIREMENT_STATUS char(1) No No
VOLUNTARY char(1) No No
TRADE_IN_ASSET_ID char(12) No No
TRADE_IN_DTTM_STMP PSDATETIME No No
TRADE_IN_AMT decimal(26,3) No No
REFERENCE char(30) No No
QUANTITY decimal(15,4) No No
RETIREMENT_AMT decimal(26,3) No No
PROCEEDS decimal(26,3) No No
REMOVAL_COST decimal(26,3) No No
RETIREMENT_RSV decimal(26,3) No No
GAIN_LOSS decimal(26,3) No No
BASIS_RED_RECAP decimal(26,3) No No
LEASE_REM_PAYMNTS decimal(26,3) No No
FROM_CUR char(3) No No
INCL_NON_CAP_COST char(1) No No
ORIGINAL_COST_FLG char(1) No No
RECALC_COST_W_INDX char(1) No No
TRAN_EXCLUDE_CODE char(2) No No
TRAN_EXCLUDE_AMT decimal(26,3) No No
RETIREMENT_PCT decimal(18,12) No No
RET_NON_CAP_AMT decimal(26,3) No No
INDEX_NAME char(20) No No
INDEX_DETAIL_NAME char(35) No No
INDEX_REVALUE_AMT decimal(26,3) No No
FULLY_DEPR_SW char(1) No No
REDUCED_COST decimal(26,3) No No
CAPITAL_G_L decimal(26,3) No No
RET_NON_CAP_AMT2 decimal(26,3) No No
Index
Name Type Unique Member
PS_RETIREMENT_NF PK Yes
Member(s) of "PS_RETIREMENT_NF" Index
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP

Published December 16, 2006