| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FAS001 |
Character(5) |
VARCHAR2(5) NOT NULL |
FAS Number
|
| 2 |
FAS002 |
Character(1) |
VARCHAR2(1) NOT NULL |
Active/Inactive (I/A)
|
| 3 |
FAS003 |
Character(1) |
VARCHAR2(1) NOT NULL |
Class Code
|
| 4 |
FAS004 |
Character(1) |
VARCHAR2(1) NOT NULL |
Property Type
|
| 5 |
FAS005 |
Character(25) |
VARCHAR2(25) NOT NULL |
Asset Description
|
| 6 |
FAS006 |
Character(6) |
VARCHAR2(6) NOT NULL |
Location
|
| 7 |
FAS007 |
Character(20) |
VARCHAR2(20) NOT NULL |
Custodian
|
| 8 |
FAS008 |
Character(6) |
VARCHAR2(6) NOT NULL |
Acquisition Date (MMDDYY)
|
| 9 |
FAS009 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
At-Risk Basis
|
| 10 |
FAS010 |
Character(1) |
VARCHAR2(1) NOT NULL |
ITC Option
|
| 11 |
FAS011 |
Number(3,0) |
SMALLINT NOT NULL |
ITC Percentage
|
| 12 |
FAS012 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
ITC Amount
|
| 13 |
FAS013 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
ITC Basis Reduction Amount
|
| 14 |
FAS014 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
ITC Recapture Amount
|
| 15 |
FAS015 |
Character(12) |
VARCHAR2(12) NOT NULL |
Purchase Order Number
|
| 16 |
FAS016 |
Character(25) |
VARCHAR2(25) NOT NULL |
Supplier/Manufacturer
|
| 17 |
FAS017 |
Character(20) |
VARCHAR2(20) NOT NULL |
Manufacturer Serial Number
|
| 18 |
FAS018 |
Character(6) |
VARCHAR2(6) NOT NULL |
Warranty Date (MMDDYY)
|
| 19 |
FAS019 |
Character(6) |
VARCHAR2(6) NOT NULL |
Disposal Date (MMDDYY)
|
| 20 |
FAS020 |
Character(1) |
VARCHAR2(1) NOT NULL |
Disposal Method
|
| 21 |
FAS021 |
Character(10) |
VARCHAR2(10) NOT NULL |
General Ledger Code
|
| 22 |
FAS022 |
Character(10) |
VARCHAR2(10) NOT NULL |
Co. Asset Number (Dept ID)
|
| 23 |
FAS023 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Disposal Price
|
| 24 |
FAS024 |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax-free Disposal (Y/N)
|
| 25 |
FAS025 |
Character(1) |
VARCHAR2(1) NOT NULL |
Depr Adjustment Needed Bk 1-3
|
| 26 |
FAS026 |
Character(1) |
VARCHAR2(1) NOT NULL |
Depr Adjustment Needed Bk 4-5
|
| 27 |
FAS027 |
Character(3) |
VARCHAR2(3) NOT NULL |
Remaining Life Switch Bk 1-3
|
| 28 |
FAS028 |
Character(2) |
VARCHAR2(2) NOT NULL |
Remaining Life Switch Bk 4-5
|
| 29 |
FAS029 |
Character(2) |
VARCHAR2(2) NOT NULL |
Blank #1
|
| 30 |
FAS030 |
Character(8) |
VARCHAR2(8) NOT NULL |
Class Life
|
| 31 |
FAS031 |
Character(3) |
VARCHAR2(3) NOT NULL |
Blank #3
|
| 32 |
FAS032 |
Character(10) |
VARCHAR2(10) NOT NULL |
Blank #4
|
| 33 |
FAS033 |
Character(1) |
VARCHAR2(1) NOT NULL |
Mid-Quarter Flag (M/N)
|
| 34 |
FAS034 |
Number(3,0) |
SMALLINT NOT NULL |
Depreciation Version Number
|
| 35 |
FAS035 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Acquisition Value
|
| 36 |
FAS036 |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Method
|
| 37 |
FAS037 |
Number(3,0) |
SMALLINT NOT NULL |
Declining Balance Percentage
|
| 38 |
FAS038 |
Character(1) |
VARCHAR2(1) NOT NULL |
20% Bonus (Y/N)
|
| 39 |
FAS039 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Salvage Value
|
| 40 |
FAS040 |
Character(2) |
VARCHAR2(2) NOT NULL |
Estimated Life Years
|
| 41 |
FAS041 |
Character(2) |
VARCHAR2(2) NOT NULL |
Estimated Life Months
|
| 42 |
FAS042 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Depreciation This Run
|
| 43 |
FAS043 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current YTD Depreciation
|
| 44 |
FAS044 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Total Accum Depreciation
|
| 45 |
FAS045 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Prior Total Accum Depreciation
|
| 46 |
FAS046 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Depreciation Adjustment Amount
|
| 47 |
FAS047 |
Character(6) |
VARCHAR2(6) NOT NULL |
Adjustment Date (MMYY)
|
| 48 |
FAS048 |
Character(6) |
VARCHAR2(6) NOT NULL |
Last Depreciation Date (MMYY)
|
| 49 |
FAS049 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Gain or Loss Amount
|
| 50 |
FAS050 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Wrkg Tot Unrec Shrt-Yr Depr
|
| 51 |
FAS051 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Wrkg Curr Unrec Shrt-Yr Depr
|
| 52 |
FAS052 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Acquisition Value
|
| 53 |
FAS053 |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Method
|
| 54 |
FAS054 |
Number(3,0) |
SMALLINT NOT NULL |
Declining Balance Percentage
|
| 55 |
FAS055 |
Character(1) |
VARCHAR2(1) NOT NULL |
20% Bonus
|
| 56 |
FAS056 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Salvage Value/Section 179 Exp
|
| 57 |
FAS057 |
Character(2) |
VARCHAR2(2) NOT NULL |
Estimated Life Years
|
| 58 |
FAS058 |
Character(2) |
VARCHAR2(2) NOT NULL |
Estimated Life Months
|
| 59 |
FAS059 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Depreciation This Run
|
| 60 |
FAS060 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current YTD Depreciation
|
| 61 |
FAS061 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Total Accum Depreciation
|
| 62 |
FAS062 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Prior Total Accum Depreciation
|
| 63 |
FAS063 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Depreciation Adjustment Amount
|
| 64 |
FAS064 |
Character(6) |
VARCHAR2(6) NOT NULL |
Adjustment Date (MMYY)
|
| 65 |
FAS065 |
Character(6) |
VARCHAR2(6) NOT NULL |
Last Depreciation Date (MMYY)
|
| 66 |
FAS066 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Gain or Loss Amount
|
| 67 |
FAS067 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Wrkg Tot Unrecvrd Shrt-Yr Depr
|
| 68 |
FAS068 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Wrkg Cur Unrecvrd Shrt-Yr Depr
|
| 69 |
FAS069 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Acquisition Value
|
| 70 |
FAS070 |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Method
|
| 71 |
FAS071 |
Number(3,0) |
SMALLINT NOT NULL |
Declining Balance Percentage
|
| 72 |
FAS072 |
Character(1) |
VARCHAR2(1) NOT NULL |
20% Bonus
|
| 73 |
FAS073 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Salvage Value/Section 179 Exp
|
| 74 |
FAS074 |
Character(2) |
VARCHAR2(2) NOT NULL |
Estimated Life Years
|
| 75 |
FAS075 |
Character(2) |
VARCHAR2(2) NOT NULL |
Estimated Life Months
|
| 76 |
FAS076 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Depreciation This Run
|
| 77 |
FAS077 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current YTD Depreciation
|
| 78 |
FAS078 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Total Accumulated Depreciation
|
| 79 |
FAS079 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Prior Total Accum Depreciation
|
| 80 |
FAS080 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Depreciation Adjustment Amount
|
| 81 |
FAS081 |
Character(6) |
VARCHAR2(6) NOT NULL |
Adjustment Date (MMYY)
|
| 82 |
FAS082 |
Character(6) |
VARCHAR2(6) NOT NULL |
Last Depreciation Date (MMYY)
|
| 83 |
FAS083 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Gain or Loss Amount
|
| 84 |
FAS084 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Wrkg Tot Unrecvrd Shrt-Yr Depr
|
| 85 |
FAS085 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Wrkg Cur Unrecvrd Shrt-Yr Depr
|
| 86 |
FAS086 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Acquisition Value
|
| 87 |
FAS087 |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Method
|
| 88 |
FAS088 |
Number(3,0) |
SMALLINT NOT NULL |
Declining Balance Percentage
|
| 89 |
FAS089 |
Character(1) |
VARCHAR2(1) NOT NULL |
20% Bonus
|
| 90 |
FAS090 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Salvage Value/Section 179 Exp
|
| 91 |
FAS091 |
Character(2) |
VARCHAR2(2) NOT NULL |
Estimated Life Years
|
| 92 |
FAS092 |
Character(2) |
VARCHAR2(2) NOT NULL |
Estimated Life Months
|
| 93 |
FAS093 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Depreciation This Run
|
| 94 |
FAS094 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current YTD Depreciation
|
| 95 |
FAS095 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Total Accumulated Depreciation
|
| 96 |
FAS096 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Prior Total Accum Depreciation
|
| 97 |
FAS097 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Depreciation Adjustment Amount
|
| 98 |
FAS098 |
Character(6) |
VARCHAR2(6) NOT NULL |
Adjustment Date (MMYY)
|
| 99 |
FAS099 |
Character(6) |
VARCHAR2(6) NOT NULL |
Last Depreciation Date (MMYY)
|
| 100 |
FAS100 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Gain or Loss Amount
|
| 101 |
FAS101 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Wrkg Tot Unrecvrd Shrt-Yr Depr
|
| 102 |
FAS102 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Wrkg Cur Unrecvrd Shrt-Yr Depr
|
| 103 |
FAS103 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Acquisition Value
|
| 104 |
FAS104 |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Method
|
| 105 |
FAS105 |
Number(3,0) |
SMALLINT NOT NULL |
Declining Balance Percentage
|
| 106 |
FAS106 |
Character(1) |
VARCHAR2(1) NOT NULL |
20% Bonus
|
| 107 |
FAS107 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Salvage Value/Section 179 Exp
|
| 108 |
FAS108 |
Character(2) |
VARCHAR2(2) NOT NULL |
Estimated Life Years
|
| 109 |
FAS109 |
Character(2) |
VARCHAR2(2) NOT NULL |
Estimated Life Months
|
| 110 |
FAS110 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Depreciation This Run
|
| 111 |
FAS111 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current YTD Depreciation
|
| 112 |
FAS112 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Total Accumulated Depreciation
|
| 113 |
FAS113 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Prior Total Accum Depreciation
|
| 114 |
FAS114 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Depreciation Adjustment Amount
|
| 115 |
FAS115 |
Character(6) |
VARCHAR2(6) NOT NULL |
Adjustment Date (MMYY)
|
| 116 |
FAS116 |
Character(6) |
VARCHAR2(6) NOT NULL |
Last Depreciation Date (MMYY)
|
| 117 |
FAS117 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Gain or Loss Amount
|
| 118 |
FAS118 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Wrkg Tot Unrecvrd Shrt-Yr Depr
|
| 119 |
FAS119 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Wrkg Cur Unrecvrd Shrt-Yr Depr
|