DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Module List > Module GL tables > GL10000

DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and 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?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
BACHNUMBchar(15) Batch Numb...(more) Join Now
GP 9
join SY00500 on SY00500.BACHNUMB = GL10000.BACHNUMB
BCHSOURCchar(15) Batch Sour...(more) Join Now
GP 9
JRNENTRYint Journal En...(more) Join Now
GP 9
RCTRXSEQnumeric(19,5) Recurring ...(more) Join Now
GP 9
SOURCDOCchar(11) Join Now
GP 9
REFRENCEchar(31) Reference:...(more) Join Now
GP 9
TRXDATEdatetime TRX Date: ...(more) Join Now
GP 9
RVRSNGDTdatetime Reversing ...(more) Join Now
GP 9
RCRNGTRXtinyint Recurring ...(more) Join Now
GP 9
BALFRCLCsmallint Balance Fo...(more) Join Now
GP 9
PSTGSTUSsmallint Posting St...(more) Join Now
GP 9
LASTUSERchar(15) Last User:...(more) Join Now
GP 9
LSTDTEDTdatetime Last Date ...(more) Join Now
GP 9
USWHPSTDchar(15) User Who P...(more) Join Now
GP 9
TRXTYPEsmallint Transactio...(more) Join Now
GP 9
SQNCLINEnumeric(19,5) Sequence L...(more) Join Now
GP 9
GLHDRMSGbinary(4) GL HDR Mes...(more) Join Now
GP 9
GLHDRMS2binary(4) GL HDR Mes...(more) Join Now
GP 9
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
RVTRXSRCchar(13) Reversing ...(more) Join Now
GP 9
SERIESsmallint Series
Join Now

GP 9
ORPSTDDTdatetime Originatio...(more) Join Now
GP 9
ORTRXSRCchar(13) Originatin...(more) Join Now
GP 9
OrigDTASeriessmallint Originatin...(more) Join Now
GP 9
DTAControlNumchar(21) DTA Contro...(more) Join Now
GP 9
DTATRXTypesmallint DTA TRX Ty...(more) Join Now
GP 9
DTA_Indexnumeric(19,5) DTA Index:...(more) Join Now
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now CM20000
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = GL10000.CURNCYID
CURRNIDXsmallint Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = GL10000.CURRNIDX
RATETPIDchar(15) Rate Type ...(more) Join Now
GP 9
EXGTBLIDchar(15) Exchange T...(more) Join Now
GP 9
XCHGRATEnumeric(19,7) Exchange R...(more) Join Now
GP 9
EXCHDATEdatetime Exchange D...(more) Join Now
GP 9
TIME1datetime Time: The ...(more) Join Now
GP 9
RTCLCMTDsmallint Rate Calcu...(more) Join Now
GP 9
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = GL10000.NOTEINDX
GLHDRVALbinary(4) GL Header ...(more) Join Now
GP 9
PERIODIDsmallint Period ID:...(more) Join Now
GP 9
OPENYEARsmallint Open Year:...(more) Join Now
GP 9
CLOSEDYRsmallint Closed Yea...(more) Join Now
GP 9
HISTRXtinyint History TR...(more) Join Now
GP 9
REVPRDIDsmallint Reversing ...(more) Join Now
GP 9
REVYEARsmallint Reversing ...(more) Join Now
GP 9
REVCLYRsmallint Reversing ...(more) Join Now
GP 9
REVHISTtinyint Reversing ...(more) Join Now
GP 9
ERRSTATEint Error Stat...(more) Join Now
GP 9
ICTRXtinyint IC TRX: T...(more) Join Now
GP 9
ORCOMIDchar(5) Originatin...(more) Join Now
GP 9
ORIGINJEint Originatin...(more) Join Now
GP 9
ICDISTStinyint ICDists: T...(more) Join Now
GP 9
PRNTSTUSsmallint Printing S...(more) Join Now
GP 9
DENXRATEnumeric(19,7) Denominati...(more) Join Now
GP 9
MCTRXSTTsmallint MC Transac...(more) Join Now
GP 9
DOCDATEdatetime Document D...(more) Join Now
GP 9
Tax_Datedatetime Tax Date: ...(more) Join Now
GP 9
VOIDEDtinyint Voided: ...(more) Join Now
GP 9
Original_JEint Original J...(more) Join Now
GP 9
Original_JE_Yearsmallint Original J...(more) Join Now
GP 9
Original_JE_Seq_Numnumeric(19,5) Original J...(more) Join Now
GP 9
Correcting_Trx_Typesmallint Correcting...(more) Join Now
GP 9
Ledger_IDsmallint Ledger ID:...(more) Join Now
GP 2010
Adjustment_Transactiontinyint Adjustment...(more) Join Now
GP 2010
DEX_ROW_TSdatetime Time Stamp...(more) Join Now
GP 10
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9