DynDeveloper.com

DynDeveloper.com

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

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..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?

* 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 = GL10001.BACHNUMB
JRNENTRYint Journal En...(more) Join Now
GP 9
SQNCLINEnumeric(19,5) Sequence L...(more) Join Now
GP 9
ACTINDXint Account In...(more) Join Now
GP 9
join GL00100 on GL00100.ACTINDX = GL10001.ACTINDX
XCHGRATEnumeric(19,7) Exchange R...(more) Join Now
GP 9
DSCRIPTNchar(31) Descriptio...(more) Join Now
GP 9
GLLINMSGbinary(4) GL LINE Me...(more) Join Now
GP 9
GLLINMS2binary(4) GL LINE Me...(more) Join Now
GP 9
CURRNIDXsmallint Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = GL10001.CURRNIDX
GLLINVALbinary(4) GL Line Va...(more) Join Now
GP 9
ACCTTYPEsmallint Account Ty...(more) Join Now
GP 9
FXDORVARsmallint Fixed Or V...(more) Join Now
GP 9
BALFRCLCsmallint Balance fo...(more) Join Now
GP 9
PSTNGTYPsmallint Posting Ty...(more) Join Now
GP 9
DECPLACSsmallint Decimal Pl...(more) Join Now
GP 9
ORCTRNUMchar(21) Originatin...(more) Join Now
GP 9
ORDOCNUMchar(21) Originatin...(more) Join Now
GP 9
ORMSTRIDchar(31) Originatin...(more) Join Now
GP 9
ORMSTRNMchar(65) Originatin...(more) Join Now
GP 9
ORTRXTYPsmallint Originatin...(more) Join Now
GP 9
OrigSeqNumint Originatin...(more) Join Now
GP 9
ORTRXDESCchar(31) Originatin...(more) Join Now
GP 9
DTA_GL_Statussmallint DTA GL Sta...(more) Join Now
GP 9
INTERIDchar(5) Intercompa...(more) Join Now
GP 9
RATETPIDchar(15) Rate Type ...(more) Join Now
GP 9
EXGTBLIDchar(15) Exchange T...(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
CRDTAMNTnumeric(19,5) Credit Amo...(more) Join Now
GP 9
DEBITAMTnumeric(19,5) Debit Amou...(more) Join Now
GP 9
ORCRDAMTnumeric(19,5) Originatin...(more) Join Now
GP 9
ORDBTAMTnumeric(19,5) Originatin...(more) Join Now
GP 9
DENXRATEnumeric(19,7) Denominati...(more) Join Now
GP 9
MCTRXSTTsmallint MC Transac...(more) Join Now
GP 9
LNESTATsmallint Line Statu...(more) Join Now
GP 9
CorrespondingUnitchar(5) Correspond...(more) Join Now
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9