DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..Quick Journal Work)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
BSNSFMIDchar(15) B3940400.BSNSFMID
GP 9
JRNENTRYint Journal En...(more) Join Now DTA10100.JRNENTRY
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now CM20000
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = GL10100.CURNCYID
OFFINDXint
GP 9
TRXDATEdatetime TrxDate Transaction Date used when the transaction was posted PAM30502.TRXDATE
GP 9
TRXBALNCnumeric(19,5)
GP 9
PSTGSTUSsmallint Posting St...(more) Join Now RM10301.PSTGSTUS
GP 9
LASTUSERchar(15) Last User:...(more) Join Now GL10000.LASTUSER
GP 9
LSTDTEDTdatetime Last Date ...(more) Join Now GL10000.LSTDTEDT
GP 9
USWHPSTDchar(15) User Who P...(more) Join Now GL10000.USWHPSTD
GP 9
PSTDAMNTnumeric(19,5) Field Type...(more) Join Now SVC00604.PSTDAMNT
GP 9
REFRENCEchar(31) Reference:...(more) Join Now POP30300.REFRENCE
GP 9
SOURCDOCchar(11) Join Now
GP 9
SQNCLINEnumeric(19,5) Sequence L...(more) Join Now GL10000.SQNCLINE
GP 9
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
GLHDRMSGbinary(4) GL HDR Mes...(more) Join Now GL10000.GLHDRMSG
GP 9
GLHDRMS2binary(4) GL HDR Mes...(more) Join Now GL10000.GLHDRMS2
GP 9
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = GL10100.NOTEINDX
GLHDRVALbinary(4) GL Header ...(more) Join Now GL10000.GLHDRVAL
GP 9
PERIODIDsmallint Period ID:...(more) Join Now
GP 9
OPENYEARsmallint Open Year:...(more) Join Now GL10000.OPENYEAR
GP 9
CLOSEDYRsmallint Closed Yea...(more) Join Now GL10000.CLOSEDYR
GP 9
ERRSTATEint Error Stat...(more) Join Now SY00500.ERRSTATE
GP 9
HISTRXtinyint History TR...(more) Join Now GL10000.HISTRX
GP 9
OFFACTYPsmallint
GP 9
OFFBLCLCsmallint
GP 9
OFFXVARsmallint
GP 9
OFFPSTYPsmallint
GP 9
DOCDATEdatetime The date a...(more) Join Now
GP 9
VOIDEDtinyint Voided TRU...(more) Join Now CM20100.VOIDED
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9