PeopleSoft 9
Asset Management

Table Name RETIREMENT

Table Description
RETIREMENT
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
DTTM_STAMP PSDATETIME Yes No
RETIREMENT_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
TXN_TRADE_IN_AMT decimal(26,3) No No
GROUPID_ONE_MANY char(12) No No
LIKE_EXCH_ASSET_ID char(12) No No
LIKE_KIND_DATESTMP PSDATETIME No No
LIKE_KIND_BASIS decimal(26,3) No No
NON_LIKE_ASSET_ID char(12) No No
NON_LKE_DTTM_STAMP PSDATETIME No No
NON_LIKE_BASIS decimal(15,2) No No
REFERENCE char(30) No No
QUANTITY decimal(15,4) No No
RETIREMENT_AMT decimal(26,3) No No
TXN_PROCEEDS decimal(26,3) No No
PROCEEDS decimal(26,3) No No
TXN_REMOVAL_COST decimal(26,3) No No
REMOVAL_COST decimal(26,3) No No
TXN_CURRENCY_CD2 char(3) No No
RATE_DIV_2 decimal(15,8) No No
RATE_MULT_2 decimal(15,8) 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
TXN_CURRENCY_CD char(3) No No
FROM_CUR char(3) No No
RATE_DIV decimal(15,8) No No
RATE_MULT decimal(15,8) No No
RT_TYPE char(5) No No
RT_EFFDT PSDATE 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 Yes
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
IN_SERVICE_PDS decimal(8,2) No No
RETIREMENT_RSV_SL decimal(15,2) No No
RECOG_GAIN_LOSS decimal(26,3) No No
TXN_CASH decimal(26,3) No No
CASH decimal(26,3) No No
TXN_TRADE_IN_VALUE decimal(26,3) No No
TRADE_IN_VALUE decimal(26,3) No No
TXN_NON_LIKE_KIND decimal(26,3) No No
NON_LIKE_KIND decimal(26,3) No No
TXN_LIAB_ASSUMED decimal(26,3) No No
LIABILITY_ASSUMED decimal(26,3) No No
ACCOUNTING_DT PSDATE No No
DEPR_YTD decimal(26,3) No No
ACCUM_DEPR decimal(26,3) No No
DEPR_BAL decimal(26,3) No No
AUTO_RETIRED_SW char(1) No No
BILL_TO_CUST_ID char(15) No No
ADDRESS_SEQ_NUM INT No No
SHIP_TO_CUST_ID char(15) No No
SHIP_TO_ADDR_NUM INT No No
SOLD_TO_CUST_ID char(15) No No
SOLD_TO_ADDR_NUM INT No No
SHIP_FROM_LOC char(10) No No
AM_CREATE_BILL char(1) No No
CUSTOMER_SETID char(5) No No
PROCEEDS_BSE_DIFF decimal(26,3) No No
DESCR254 char(254) No No
Index
Name Type Unique Member
PS_RETIREMENT PK Yes
PS0RETIREMENT IE1 No
PS1RETIREMENT IE2 No
PS2RETIREMENT IE3 No
PSARETIREMENT IE4 No
Member(s) of "PS_RETIREMENT" Index
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
Member(s) of "PS0RETIREMENT" Index
BILL_TO_CUST_ID
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
Member(s) of "PS1RETIREMENT" Index
SHIP_TO_CUST_ID
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
Member(s) of "PS2RETIREMENT" Index
SOLD_TO_CUST_ID
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
Member(s) of "PSARETIREMENT" Index
ASSET_ID
BUSINESS_UNIT
BOOK

Published December 16, 2006