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

COMPANY..FA00801 Table Definition

(COMPANY..Asset Transfer Master WORK)

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)
''

DEX_ROW_ID int
auto number (1,1)
Unique ide...(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