| ASSETINDEX |
int
0
|
Asset Inde...(more) Join Now
|
|
FA001... more text available
|
| BOOKINDX |
int
0
|
span style...(more) Join Now
|
|
|
| PLINSERVDATE |
datetime
'1/1/1900'
|
span style...(more) Join Now
|
|
|
| DELETEDATE |
datetime
'1/1/1900'
|
span style...(more) Join Now
|
|
|
| DEPRBEGDATE |
datetime
'1/1/1900'
|
span style...(more) Join Now
|
|
|
| FULLYDEPRFLAG |
char(1)
''
|
span style...(more) Join Now
|
|
|
| FULLYDEPRDATE |
datetime
'1/1/1900'
|
span style...(more) Join Now
|
|
|
| ORIGINALLIFEYEARS |
smallint
0
|
span style...(more) Join Now
|
|
|
| ORIGINALLIFEDAYS |
smallint
0
|
span style...(more) Join Now
|
|
|
| REMAININGLIFEYEARS |
smallint
0
|
span style...(more) Join Now
|
|
|
| REMAININGLIFEDAYS |
smallint
0
|
span style...(more) Join Now
|
|
|
| DEPRTODATE |
datetime
'1/1/1900'
|
span style...(more) Join Now
|
|
|
| LASTRECALCDATE |
datetime
'1/1/1900'
|
span style...(more) Join Now
|
|
|
| LASTRECALCDATEFISYR |
smallint
0
|
span style...(more) Join Now
|
|
|
| BEGINYEARCOST |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| BAGINSALVAGE |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| BEGINRESERVE |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| COSTBASIS |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| SALVAGEVALUE |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| DEPRECIATIONMETHOD |
smallint
0
|
table> ...(more) Join Now
|
|
|
| AVERAGINGCONV |
smallint
0
|
1 – ...(more) Join Now
|
|
|
| SWITCHOVER |
smallint
0
|
span style...(more) Join Now
|
|
|
| SWITCHFM1METHOD |
smallint
0
|
span style...(more) Join Now
|
|
|
| SWITCHFM1AMOUNT |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| SWITCHFM1DATE |
datetime
'1/1/1900'
|
span style...(more) Join Now
|
|
|
| DLYDEPRRATE |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| PERDEPRRATE |
numeric(19,5)
0.00
|
table clas...(more) Join Now
|
|
|
| YRLYDEPRRATE |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| SAVEDLYDEPRRATE |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| SAVEPERDEPRRATE |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| SAVEYRLYDEPRRATE |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| AMORTIZATIONCODE |
smallint
0
|
span style...(more) Join Now
|
|
|
| AMORTIZATIONAMOUNT |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| CURRUNDEPRAMT |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| PREVRUNDEPRAMT |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| YTDDEPRAMT |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| LTDDEPRAMT |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| NETBOOKVALUE |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| LUXAUTOIND |
smallint
0
|
span style...(more) Join Now
|
|
|
| PRORATEDRETDATE |
datetime
'1/1/1900'
|
span style...(more) Join Now
|
|
|
| DEPRTODATEBFRET |
datetime
'1/1/1900'
|
span style...(more) Join Now
|
|
|
| RECGAINLOSS |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| NONRECGAINLOSS |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| STLINEDEPRATRET |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| COSTBFRETORDEL |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| Initial_Allowance_Perc |
smallint
0
|
span style...(more) Join Now
|
|
|
| Initial_Allowance_Amount |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| SPECDEPRALLOW |
smallint
0
|
span style...(more) Join Now
|
|
|
| SPECDEPRALLOWPCT |
smallint
0
|
span style...(more) Join Now
|
|
|
| SPECDEPRALLOWAMT |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
join ... more text available
|
| DATEADDED |
datetime
'1/1/1900'
|
Date Added...(more) Join Now
|
|
|
| LASTMNTDDATE |
datetime
'1/1/1900'
|
Last Maint...(more) Join Now
|
|
|
| LASTMNTDTIME |
datetime
'1/1/1900'
|
Last Maint...(more) Join Now
|
|
|
| LASTMNTDUSERID |
char(15)
''
|
Last Maint...(more) Join Now
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
| LUXVANTRUCK |
tinyint
0
|
Luxury Van...(more) Join Now
|
|
|
| LUXELAUTO |
tinyint
0
|
Luxury Ele...(more) Join Now
|
|
|