DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..Budget Transaction Work)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
BCHSOURCchar(15) Batch Sour...(more) Join Now
GP 2010
BACHNUMBchar(15) Batch Numb...(more) Join Now
GP 2010
join SY00500 on SY00500.BACHNUMB = GL12000.BACHNUMB
JRNENTRYint Journal En...(more) Join Now
GP 2010
BUDGETIDchar(15) Budget ID ...(more) Join Now
GP 2010
REFRENCEchar(31) Reference:...(more) Join Now
GP 2010
TRXDATEdatetime TRX Date: ...(more) Join Now
GP 2010
PSTGSTUSsmallint Posting St...(more) Join Now
GP 2010
LASTUSERchar(15) Last User:...(more) Join Now
GP 2010
LSTDTEDTdatetime Last Date ...(more) Join Now
GP 2010
USWHPSTDchar(15) User Who P...(more) Join Now
GP 2010
SOURCDOCchar(11) Join Now
GP 2010
TRXSORCEchar(13) Transactio...(more) Join Now
GP 2010
ERRSTATEint Error Stat...(more) Join Now
GP 2010
GLHDRVALbinary(4) GL Header ...(more) Join Now
GP 2010
GLHDRMSGbinary(4) GL HDR Mes...(more) Join Now
GP 2010
GLHDRMS2binary(4) GL HDR Mes...(more) Join Now
GP 2010
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 2010
join SY03900 on SY03900.NOTEINDX = GL12000.NOTEINDX
DEX_ROW_TSdatetime Time Stamp...(more) Join Now
GP 2010
DEX_ROW_IDint Unique aut...(more) Join Now
GP 2010