| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FAS_1001 |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Sys Number
|
| 2 |
FAS_1002 |
Character(12) |
VARCHAR2(12) NOT NULL |
Company Asset Number
|
| 3 |
FAS_1003 |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Code or Current Statu
|
| 4 |
FAS_1004 |
Character(1) |
VARCHAR2(1) NOT NULL |
Property Type
|
| 5 |
FAS_1005 |
Character(2) |
VARCHAR2(2) NOT NULL |
Class
|
| 6 |
FAS_1006 |
Character(4) |
VARCHAR2(4) NOT NULL |
Class life in years and months
|
| 7 |
FAS_1007 |
Character(1) |
VARCHAR2(1) NOT NULL |
ITC option
|
| 8 |
FAS_1008 |
Number(6,4) |
DECIMAL(5,4) NOT NULL |
ITC Percent
|
| 9 |
FAS_1009 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
ITC Amount
|
| 10 |
FAS_1010 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
ITC Reduction Amount
|
| 11 |
FAS_1011 |
Character(64) |
VARCHAR2(64) NOT NULL |
Asset Description
|
| 12 |
FAS_1012 |
Character(1) |
VARCHAR2(1) NOT NULL |
Creation Code
|
| 13 |
FAS_1013 |
Number(1,0) |
SMALLINT NOT NULL |
FAS Asset (Y=1/N=0)
|
| 14 |
FAS_1014 |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Original Asset Sys Number
|
| 15 |
FAS_1015 |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Created Asset #1 SYS Number
|
| 16 |
FAS_1016 |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Created Asset #2 SYS Number
|
| 17 |
FAS_1017 |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Created Asset #3 SYS Number
|
| 18 |
FAS_1018 |
Character(6) |
VARCHAR2(6) NOT NULL |
Disposal Date MMDDYY
|
| 19 |
FAS_1019 |
Character(1) |
VARCHAR2(1) NOT NULL |
Disposal Method
|
| 20 |
FAS_1020 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Cash Proceeds
|
| 21 |
FAS_1021 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Noncash Proceeds
|
| 22 |
FAS_1022 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Expenses of Sale
|
| 23 |
FAS_1023 |
Number(1,0) |
SMALLINT NOT NULL |
Partial Disposition (Y=1/N=0)
|
| 24 |
FAS_1024 |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Disposal Amount
|
| 25 |
FAS_1025 |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Percentage Disposed Of
|
| 26 |
FAS_1026 |
Character(6) |
VARCHAR2(6) NOT NULL |
Transfer In Date MMDDYY
|
| 27 |
FAS_1027 |
Character(6) |
VARCHAR2(6) NOT NULL |
Transfer Out Date MMDDYY
|
| 28 |
FAS_1028 |
Character(6) |
VARCHAR2(6) NOT NULL |
Effective Xfer Out Date MMDDYY
|
| 29 |
FAS_1029 |
Character(6) |
VARCHAR2(6) NOT NULL |
Effective XFer In Date MMDDYY
|
| 30 |
FAS_1030 |
Number(1,0) |
SMALLINT NOT NULL |
Xfer within Company (Y=1/N=0)
|
| 31 |
FAS_1031 |
Number(1,0) |
SMALLINT NOT NULL |
Allocate on Xfer Dt (Y=1/N=0)
|
| 32 |
FAS_1032 |
Number(1,0) |
SMALLINT NOT NULL |
Partial Xfer (Y=1/N=0)
|
| 33 |
FAS_1033 |
Number(1,0) |
SMALLINT NOT NULL |
XFer with Disposal (Y=1/N=0)
|
| 34 |
FAS_1034 |
Number(1,0) |
SMALLINT NOT NULL |
Change Asset (Y=1/N=0)
|
| 35 |
FAS_1035 |
Character(8) |
VARCHAR2(8) NOT NULL |
Destination Company
|
| 36 |
FAS_1036 |
Character(8) |
VARCHAR2(8) NOT NULL |
Original Company
|
| 37 |
FAS_1037 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Amount Transferred
|
| 38 |
FAS_1038 |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Percentage Transferred
|
| 39 |
FAS_1039 |
Number(1,0) |
SMALLINT NOT NULL |
Acquired Value Book Number
|