DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..Quick Journal Amounts 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
SQNCLINEnumeric(19,5) Sequence L...(more) Join Now GL10000.SQNCLINE
GP 9
ACTINDXint Account In...(more) Join Now
GP 9
join GL00100 on GL00100.ACTINDX = GL10101.ACTINDX
TRXAMNTnumeric(19,5) TrxAmount Amount of the transaction PP50101.TRXAMNT
GP 9
GLLINMSGbinary(4) GL LINE Me...(more) Join Now GL10001.GLLINMSG
GP 9
DSCRIPTNchar(31) Descriptio...(more) Join Now CM20300.DSCRIPTN
GP 9
GLLINVALbinary(4) GL Line Va...(more) Join Now GL10001.GLLINVAL
GP 9
ACCTTYPEsmallint

Account...(more) Join Now

GL00100.ACCTTYPE
GP 9
FXDORVARsmallint

Fixed O...(more) Join Now

GL00100.FXDORVAR
GP 9
BALFRCLCsmallint

Balance...(more) Join Now

GL00100.BALFRCLC
GP 9
PSTNGTYPsmallint

Posting...(more) Join Now

GL00100.PSTNGTYP
GP 9
DECPLACSsmallint Decimal Pl...(more) Join Now GL00100.DECPLACS
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9