Module List > Module FA tables FA00200
You are currently viewing the COMPANY database.
Change

COMPANY..FA00200 Table Definition

(COMPANY..Asset Book Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3