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

COMPANY..FA00800 Table Definition

(COMPANY..Asset Transfer Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TRANSFERINDX int
0

TRANSFEREVENT int
0

ASSETINDEX int
0

ASSETID char(15)
''

XFRDATESTAMP datetime
'1/1/1900'

XFRTIMESTAMP datetime
'1/1/1900'

TRANSFERSEQ smallint
0

TRANSFERDATE datetime
'1/1/1900'

FROMASSETINDX int
0

FROMASSETID char(15)
''

FROMSTRUC char(31)
''

FROMLOC char(15)
''

From_Physical_LocationID char(15)
''

From_Master_Asset_ID char(19)
''

FROMDEPREXPACCTINDX int
0

FROMDEPRRESVACCTINDX int
0

FROMPRYRDEPRACCTINDX int
0

FROMASSETCOSTACCTINDX int
0

FROMPROCEEDSACCTINDX int
0

FROMRECGAINLOSSACCTINDX int
0

FROMNONRECGAINLOSSACCTINDX int
0

FROMCLEARACCTINDX int
0

PARTIALQTY int
0

PARTIALCOST numeric(19,5)
0.00

PARTIALPCT smallint
0

TOASSETINDX int
0

TOASSETID char(15)
''

TOSTRUC char(31)
''

TOLOC char(15)
''

To_Physical_Location_ID char(15)
''

To_Master_Asset_ID char(19)
''

TODEPREXPACCTINDX int
0

TODEPRRESVACCTINDX int
0

TOPRYRDEPRACCTINDX int
0

TOASSETCOSTACCTINDX int
0

TOPROCEEDSACCTINDX int
0

TORECGAINLOSSACCTINDX int
0

TONONRECGAINLOSSACCTINDX int
0

TOCLEARACCTINDX int
0

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
LASTMNTDDATE datetime
'1/1/1900'

LASTMNTDTIME datetime
'1/1/1900'

LASTMNTDUSERID char(15)
''

RETIREEVENT int
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
ALIAS smallint
0

DSTCOMID char
''

TOCLASSID char
''

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