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 |