DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3