| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FAS_2001 |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
SYS Number
|
| 2 |
FAS_2002 |
Number(1,0) |
SMALLINT NOT NULL |
Book Number
|
| 3 |
FAS_2003 |
Character(6) |
VARCHAR2(6) NOT NULL |
Place In Service Dt MMDDYY
|
| 4 |
FAS_2004 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Acquired Value
|
| 5 |
FAS_2005 |
Character(2) |
VARCHAR2(2) NOT NULL |
Depreciation Method
|
| 6 |
FAS_2006 |
Number(3,0) |
SMALLINT NOT NULL |
Declining Balance Percent
|
| 7 |
FAS_2007 |
Character(4) |
VARCHAR2(4) NOT NULL |
Estimated Life/Yrs and Mos
|
| 8 |
FAS_2008 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Salvage Value
|
| 9 |
FAS_2009 |
Number(1,0) |
SMALLINT NOT NULL |
Bonus (Y=1/N=0)
|
| 10 |
FAS_2010 |
Number(1,0) |
SMALLINT NOT NULL |
Section 179 (Y=1/N=0)
|
| 11 |
FAS_2011 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Bonus Amount
|
| 12 |
FAS_2012 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Section 179 Amount
|
| 13 |
FAS_2013 |
Number(1,0) |
SMALLINT NOT NULL |
100% Business Use (Y=1/N=0)
|
| 14 |
FAS_2014 |
Character(1) |
VARCHAR2(1) NOT NULL |
Remaining Life Switch/MidQrtr
|
| 15 |
FAS_2015 |
Number(1,0) |
SMALLINT NOT NULL |
Bonus Available (Y=1/N=0)
|
| 16 |
FAS_2016 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Year End Prior Depreciation
|
| 17 |
FAS_2017 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Year-end YTD Depreciation
|
| 18 |
FAS_2018 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Year-end Accumulated Depreciat
|
| 19 |
FAS_2019 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Last Run Depreciation
|
| 20 |
FAS_2020 |
Character(4) |
VARCHAR2(4) NOT NULL |
Year-end Depreciation Dt MMYY
|
| 21 |
FAS_2021 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Unrecovered Short Year Total
|
| 22 |
FAS_2022 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Unrecovered Short Year Current
|
| 23 |
FAS_2023 |
Character(1) |
VARCHAR2(1) NOT NULL |
Remaining Life Switch/MidQrtr
|
| 24 |
FAS_2024 |
Number(4,0) |
SMALLINT NOT NULL |
Remaining Life
|
| 25 |
FAS_2025 |
Number(5,0) |
INTEGER NOT NULL |
Months In Run
|
| 26 |
FAS_2026 |
Number(1,0) |
SMALLINT NOT NULL |
Midquarter Convntion (Y=1/N=0)
|
| 27 |
FAS_2027 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Personal Use Amount
|
| 28 |
FAS_2028 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
ITC Recapture Amount
|
| 29 |
FAS_2029 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Section 179 Amount
|
| 30 |
FAS_2030 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Prior Accumulated Depreciation
|
| 31 |
FAS_2031 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Current YTD Depreciation
|
| 32 |
FAS_2032 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Total Accumulated Depreciation
|
| 33 |
FAS_2033 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Current Run Depreciation
|
| 34 |
FAS_2034 |
Character(4) |
VARCHAR2(4) NOT NULL |
Current Through Date MMYY
|
| 35 |
FAS_2035 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Unrecovered Short Year Total
|
| 36 |
FAS_2036 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Unrecovered Short Year Current
|
| 37 |
FAS_2037 |
Character(1) |
VARCHAR2(1) NOT NULL |
Remaining Life Switch/MidQrtr
|
| 38 |
FAS_2038 |
Number(4,0) |
SMALLINT NOT NULL |
Remaining Life
|
| 39 |
FAS_2039 |
Number(5,0) |
INTEGER NOT NULL |
Months In Run
|
| 40 |
FAS_2040 |
Number(1,0) |
SMALLINT NOT NULL |
Midquarter Convntion (Y=1/N=0)
|
| 41 |
FAS_2041 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Personal Use Amount
|
| 42 |
FAS_2042 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
ITC Recapture Amount
|
| 43 |
FAS_2043 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Section 179 Amount
|
| 44 |
FAS_2044 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Unused
|
| 45 |
FAS_2045 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Beginning YTD Depreciation
|
| 46 |
FAS_2046 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Beginning Accumulated Deprecia
|
| 47 |
FAS_2047 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Unused
|
| 48 |
FAS_2048 |
Character(4) |
VARCHAR2(4) NOT NULL |
Beginning Date MMYY
|
| 49 |
FAS_2049 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Unrecovered Short Year Total
|
| 50 |
FAS_2050 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Unrecovered Short Year Current
|
| 51 |
FAS_2051 |
Character(1) |
VARCHAR2(1) NOT NULL |
Remaining Life Switch/MidQrtr
|
| 52 |
FAS_2052 |
Number(4,0) |
SMALLINT NOT NULL |
Remaining Life
|
| 53 |
FAS_2053 |
Number(5,0) |
INTEGER NOT NULL |
Months in Run
|
| 54 |
FAS_2054 |
Number(1,0) |
SMALLINT NOT NULL |
Midquarter Convntion (Y=1/N=0)
|
| 55 |
FAS_2055 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Personal Use Amount
|
| 56 |
FAS_2056 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
ITC Recapture Amount
|
| 57 |
FAS_2057 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Section 179 Amount
|
| 58 |
FAS_2058 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Adjustment Amount
|
| 59 |
FAS_2059 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Gain or Loss Amount
|
| 60 |
FAS_2060 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recognize Gain or Loss
|
| 61 |
FAS_2061 |
Character(4) |
VARCHAR2(4) NOT NULL |
Gain or Loss Deferral Date
|
| 62 |
FAS_2062 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Recognized Gain or Loss Amount
|
| 63 |
FAS_2063 |
Number(1,0) |
SMALLINT NOT NULL |
Adjustment Code
|