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 LK tables LK000103
You are currently viewing the COMPANY database.
Change

COMPANY..LK000103 Table Definition

(COMPANY..Trx Matching Link Line History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
LK_Link_No int
0

LineNumber smallint
0
Field Type...(more) Join Now SVC10301.LineNumber
JRNENTRY int
0
Journal En...(more) Join Now DTA10100.JRNENTRY
ACTINDX int
0
Account In...(more) Join Now UPR00100.ACTINDX
join ... more text available
SEQNUMBR int
0
Sequence N...(more) Join Now DTA10200.SEQNUMBR
TRXAMNT numeric(19,5)
0.00
TrxAmount Amount of the transaction ME123504.TRXAMNT
ACTNUMBR_1 char(5)
''
Account Nu...(more) Join Now GL00105.ACTNUMBR_1
ACTNUMBR_2 char(5)
''
Account Nu...(more) Join Now GL00105.ACTNUMBR_2
ACTNUMBR_3 char(5)
''
Account Nu...(more) Join Now GL00105.ACTNUMBR_3
ACTNUMBR_4 char(5)
''
Account Nu...(more) Join Now GL00105.ACTNUMBR_4
ACTNUMBR_5 char(5)
''
Account Nu...(more) Join Now GL00105.ACTNUMBR_5
ACTNUMBR_6 char
''

OPENYEAR smallint
0
Open Year:...(more) Join Now GL10000.OPENYEAR
ACTNUMBR_7 char
''

CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
ACTNUMBR_8 char
''

RCTRXSEQ numeric(19,5)
0.00
Recurring ...(more) Join Now GL10000.RCTRXSEQ
TRXDATE datetime
'1/1/1900'
TrxDate Transaction Date used when the transaction was posted CM20502.TRXDATE
ACTNUMBR_9 char
''

ACTNUMBR_10 char
''

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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3