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 |