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
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Module List > Module GL tables > GL10001
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change

COMPANY..GL10001 Table Definition

(COMPANY..Transaction Amounts Work)

Physical Name: GL10001
Display Name: Transaction Amounts Work

This table contains line information for transactions entered in transaction entry windows in General
Ledger.

Required fields:
Batch Number
Journal Entry
Sequence Line
Account Index
Debit Amount
Credit Amount

Optional:
Originating Credit Amount
Originating Debit Amount
Denomination Exchange Rate - Required for Euro Triangulation.
MC Transaction State - Required for Euro Triangulation. 


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
JRNENTRY int
0
Journal En...(more) Join Now
SQNCLINE numeric(19,5)
0.00
Sequence L...(more) Join Now
ACTINDX int
0
Account In...(more) Join Now
join ... more text available
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now
DSCRIPTN char(31)
''
Descriptio...(more) Join Now
GLLINMSG binary(4)
0
GL LINE Me...(more) Join Now
GLLINMS2 binary(4)
0
GL LINE Me...(more) Join Now
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
GLLINVAL binary(4)
0
GL Line Va...(more) Join Now
ACCTTYPE smallint
0
Account Ty...(more) Join Now
FXDORVAR smallint
0
Fixed Or V...(more) Join Now
BALFRCLC smallint
0
Balance fo...(more) Join Now
PSTNGTYP smallint
0
Posting Ty...(more) Join Now
DECPLACS smallint
0
Decimal Pl...(more) Join Now
ORCTRNUM char(21)
''
Originatin...(more) Join Now
ORDOCNUM char(21)
''
Originatin...(more) Join Now
ORMSTRID char(31)
''
Originatin...(more) Join Now
ORMSTRNM char(65)
''
Originatin...(more) Join Now
ORTRXTYP smallint
0
Originatin...(more) Join Now
OrigSeqNum int
0
Originatin...(more) Join Now
ORTRXDESC char(31)
''
Originatin...(more) Join Now
DTA_GL_Status smallint
0
DTA GL Sta...(more) Join Now
INTERID char(5)
''
Intercompa...(more) Join Now
RATETPID char(15)
''
Rate Type ...(more) Join Now
EXGTBLID char(15)
''
Exchange T...(more) Join Now
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now
TIME1 datetime
'1/1/1900'
Time: The ...(more) Join Now
RTCLCMTD smallint
0
Rate Calcu...(more) Join Now
CRDTAMNT numeric(19,5)
0.00
Credit Amo...(more) Join Now
DEBITAMT numeric(19,5)
0.00
Debit Amou...(more) Join Now
ORCRDAMT numeric(19,5)
0.00
Originatin...(more) Join Now
ORDBTAMT numeric(19,5)
0.00
Originatin...(more) Join Now
DENXRATE numeric(19,7)
0.00
Denominati...(more) Join Now
MCTRXSTT smallint
0
MC Transac...(more) Join Now
LNESTAT smallint
0
Line Statu...(more) Join Now
CorrespondingUnit char(5)
''
Correspond...(more) Join Now
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