RETIREMENT

(SQL Table)
Index Back

Asset Retirement

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUS_AM_NONVW

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

Prompt Table: SP_BOOK_NONVW

4 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %date

5 RETIREMENT_DT Date(10) DATE Projected Retirement Date
6 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention

Prompt Table: CONV_BOOK_VW

7 END_DEPR_DT Date(10) DATE End Depreciation Date
8 DISPOSAL_CODE Character(1) VARCHAR2(1) NOT NULL Retirement Type
A=Abandonment
C=Cannibalize for Other Assets
D=Disappeared Assets
E=Expensed
F=Disposal Due to Theft
I=Returned to Inventory
L=Like Kind Exchange
M=Missing Asset
N=Donated to External Group
O=ARO Settlement
R=Scrapped Assets
S=Retirement by Sale
T=Traded In for another Asset
V=Auto-Retire Fully Depr Assets
Y=Casualty Loss

Default Value: S

9 RETIREMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Retirement Type
E=Extraordinary
O=Ordinary Retirement

Default Value: O

10 RETIREMENT_STATUS Character(1) VARCHAR2(1) NOT NULL Retirement Status
C=Depreciation Calculated
N=New Retirement
P=Posted to General Ledger
R=Reinstated Retirement
U=No Retirements Exist

Default Value: U

11 VOLUNTARY Character(1) VARCHAR2(1) NOT NULL Voluntary Conversion
I=Involuntary
V=Voluntary Conversion

Default Value: V

12 TRADE_IN_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Trade In Asset

Prompt Table: ASSET

13 TRADE_IN_DTTM_STMP DateTime(26) TIMESTAMP Trade In DateTime Stamp
14 TRADE_IN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Trade In Amount
15 TXN_TRADE_IN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Trade In Amount
16 GROUPID_ONE_MANY Character(12) VARCHAR2(12) NOT NULL One to Many ID
17 LIKE_EXCH_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Like Exch Asset
18 LIKE_KIND_DATESTMP DateTime(26) TIMESTAMP Like Kind datetimestmp
19 LIKE_KIND_BASIS Signed Number(28,3) DECIMAL(26,3) NOT NULL Like Kind Exch Basis
20 NON_LIKE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Non Like Kind Asset
21 NON_LKE_DTTM_STAMP DateTime(26) TIMESTAMP Non Like Dttm Stmp
22 NON_LIKE_BASIS Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Like Kind Asset Basis
23 REFERENCE Character(30) VARCHAR2(30) NOT NULL Field to show when a variable is a reference variable.
24 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
25 RETIREMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Amount
26 TXN_PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Proceeds
27 PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Proceeds
28 TXN_REMOVAL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Removal Cost
29 REMOVAL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Removal Cost
30 TXN_CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Transaction Currency Display

Prompt Table: CURR_TXN_VW2

31 RATE_DIV_2 Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
32 RATE_MULT_2 Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
33 RETIREMENT_RSV Signed Number(28,3) DECIMAL(26,3) NOT NULL Accum Depr
34 GAIN_LOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Gain/Loss
35 BASIS_RED_RECAP Signed Number(28,3) DECIMAL(26,3) NOT NULL Basis Reduction Recapture
36 LEASE_REM_PAYMNTS Signed Number(28,3) DECIMAL(26,3) NOT NULL Lease Remaining Payments
37 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Prompt Table: CURR_TXN_VW

38 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

Default Value: BU_BOOK_VW2.CURRENCY_CD

39 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
40 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
41 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
42 RT_EFFDT Date(10) DATE The effective date for a given item of market rate data.
43 INCL_NON_CAP_COST Character(1) VARCHAR2(1) NOT NULL Include Non Capitalized Cost

Y/N Table Edit

Default Value: N

44 ORIGINAL_COST_FLG Character(1) VARCHAR2(1) NOT NULL Use Original Cost

Y/N Table Edit

Default Value: N

45 RECALC_COST_W_INDX Character(1) VARCHAR2(1) NOT NULL Recalc Cost Using Index

Y/N Table Edit

Default Value: N

46 TRAN_EXCLUDE_CODE Character(2) VARCHAR2(2) NOT NULL Basis Reduction Code

Prompt Table: TRAN_EXCLUD_VW

47 TRAN_EXCLUDE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Exclude Trans Type Amount
48 RETIREMENT_PCT Signed Number(20,12) DECIMAL(18,12) NOT NULL Retirement PCT
49 RET_NON_CAP_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Retired non-capitalized amount
50 INDEX_NAME Character(20) VARCHAR2(20) NOT NULL Index Name

Prompt Table: AM_INDEX_TBL

51 INDEX_DETAIL_NAME Character(35) VARCHAR2(35) NOT NULL SubIndex Name

Prompt Table: AM_INDEX_DETAIL

52 INDEX_REVALUE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Indexed Revalue Amount
53 FULLY_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Retire As Fully Depreciated SW
F=Fully Depr with Future Expense
N=Calculate Gain/Loss
Y=Fully Depr no Future Expense
54 REDUCED_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Reduced Cost Basis
55 CAPITAL_G_L Signed Number(28,3) DECIMAL(26,3) NOT NULL Capital Gains and Loss
56 RET_NON_CAP_AMT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Capitalized CGT Amount
57 IN_SERVICE_PDS Number(9,2) DECIMAL(8,2) NOT NULL # of periods in service
58 RETIREMENT_RSV_SL Signed Number(17,2) DECIMAL(15,2) NOT NULL Reserve Retired SL
59 RECOG_GAIN_LOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Ret. Recognized Gain/Loss
60 TXN_CASH Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Cash
61 CASH Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Received/Paid
62 TXN_TRADE_IN_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Trade-In Value
63 TRADE_IN_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Trade In value
64 TXN_NON_LIKE_KIND Signed Number(28,3) DECIMAL(26,3) NOT NULL FMV Non Like-Kind
65 NON_LIKE_KIND Signed Number(28,3) DECIMAL(26,3) NOT NULL FMV Non Like Kind Property
66 TXN_LIAB_ASSUMED Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Liability Assumed
67 LIABILITY_ASSUMED Signed Number(28,3) DECIMAL(26,3) NOT NULL Liabilities Assumed
68 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
69 DEPR_YTD Signed Number(28,3) DECIMAL(26,3) NOT NULL Year to Date Depreciation
70 ACCUM_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Accumulated Depreciation
71 DEPR_BAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Accumulated Depreciation
72 AUTO_RETIRED_SW Character(1) VARCHAR2(1) NOT NULL Auto-Retired Fully Depreciated

Y/N Table Edit

Default Value: N

73 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: BI_BILL_TO_VW

74 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: CUST_ADDRBLL_VW

75 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: BI_SHIP_TO_VW

76 SHIP_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Ship To Address Sequence Num

Prompt Table: CUST_ADDRSHP_VW

77 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: BI_SOLD_TO_VW

78 SOLD_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Sold To Address Sequence Num

Prompt Table: CUST_ADDRSLD_VW

79 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location

Prompt Table: LOCATION_VW

80 AM_CREATE_BILL Character(1) VARCHAR2(1) NOT NULL Create Bill

Y/N Table Edit

Default Value: N

81 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
82 PROCEEDS_BSE_DIFF Signed Number(28,3) DECIMAL(26,3) NOT NULL Proceeds Base Difference
83 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254