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 > GL10000
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..GL10000 Table Definition

(COMPANY..Transaction Work)

Physical Name: GL10000
Display Name: Transaction Work

This table contains transaction header information for transactions entered in transaction and clearing entry windows in General Ledger. Line detail is stored in the GL_TRX_LINE_WORK table for transactions and the GL_TRX_Clearing_WORK table for clearing transactions.

Required fields:
Batch Number
Batch Source
Journal Entry
Source Document
Reference
TRX Date
Reversing Date
Balance For Calculation
Posting Status
Transaction Type
Series
Ledger ID

Optional:
Denomination Exchange Rate - Required for Euro Triangulation.
MC Transaction State - Required for Euro Triangulation.
Document Date

Comments:
The following fields are assigned values only for specific transaction types:
Reversing Date: reversing transactions only
Balance For Calculation: clearing transactions only

The following fields are used to store transaction information when posting transactions from subsidiary modules to General Ledger:
DTA Control Number
DTA TRX Type
DTA Index 
Originating Posted Date
Originating TRX Source

 


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
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
JRNENTRY int
0
Journal En...(more) Join Now
RCTRXSEQ numeric(19,5)
0.00
Recurring ...(more) Join Now
SOURCDOC char(11)
''
span style...(more) Join Now
REFRENCE char(31)
''
Reference:...(more) Join Now
TRXDATE datetime
'1/1/1900'
TRX Date: ...(more) Join Now
RVRSNGDT datetime
'1/1/1900'
Reversing ...(more) Join Now
RCRNGTRX tinyint
0
Recurring ...(more) Join Now
BALFRCLC smallint
0
Balance Fo...(more) Join Now
PSTGSTUS smallint
0
Posting St...(more) Join Now
LASTUSER char(15)
''
Last User:...(more) Join Now
LSTDTEDT datetime
'1/1/1900'
Last Date ...(more) Join Now
USWHPSTD char(15)
''
User Who P...(more) Join Now
TRXTYPE smallint
0
Transactio...(more) Join Now
SQNCLINE numeric(19,5)
0.00
Sequence L...(more) Join Now
GLHDRMSG binary(4)
0
GL HDR Mes...(more) Join Now
GLHDRMS2 binary(4)
0
GL HDR Mes...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
RVTRXSRC char(13)
''
Reversing ...(more) Join Now
SERIES smallint
0
Seriesbr /...(more) Join Now
ORPSTDDT datetime
'1/1/1900'
Originatio...(more) Join Now
ORTRXSRC char(13)
0
Originatin...(more) Join Now
OrigDTASeries smallint
0
Originatin...(more) Join Now
DTAControlNum char(21)
''
DTA Contro...(more) Join Now
DTATRXType smallint
0
DTA TRX Ty...(more) Join Now
DTA_Index numeric(19,5)
0.00
DTA Index:...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now CM20000
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
RATETPID char(15)
''
Rate Type ...(more) Join Now
EXGTBLID char(15)
''
Exchange T...(more) Join Now
XCHGRATE numeric(19,7)
0.00
Exchange R...(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
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
GLHDRVAL binary(4)
0
GL Header ...(more) Join Now
PERIODID smallint
0
Period ID:...(more) Join Now
OPENYEAR smallint
0
Open Year:...(more) Join Now
CLOSEDYR smallint
0
Closed Yea...(more) Join Now
HISTRX tinyint
0
History TR...(more) Join Now
REVPRDID smallint
0
Reversing ...(more) Join Now
REVYEAR smallint
0
Reversing ...(more) Join Now
REVCLYR smallint
0
Reversing ...(more) Join Now
REVHIST tinyint
0
Reversing ...(more) Join Now
ERRSTATE int
0
Error Stat...(more) Join Now
ICTRX tinyint
0
IC TRX: T...(more) Join Now
ORCOMID char(5)
''
Originatin...(more) Join Now
ORIGINJE int
0
Originatin...(more) Join Now
ICDISTS tinyint
0
ICDists: T...(more) Join Now
PRNTSTUS smallint
0
Printing S...(more) Join Now
DENXRATE numeric(19,7)
0.00
Denominati...(more) Join Now
MCTRXSTT smallint
0
MC Transac...(more) Join Now
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now
VOIDED tinyint
0
Voided: ...(more) Join Now
Original_JE int
0
Original J...(more) Join Now
Original_JE_Year smallint
0
Original J...(more) Join Now
Original_JE_Seq_Num numeric(19,5)
0.00
Original J...(more) Join Now
Correcting_Trx_Type smallint
0
Correcting...(more) Join Now
Ledger_ID smallint
0
Ledger ID:...(more) Join Now
Adjustment_Transaction tinyint
0
Adjustment...(more) Join Now
DEX_ROW_TS datetime
(getutcdate())
Time Stamp...(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