DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..Year-to-Date Transaction Open)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
OPENYEARsmallint Open Year:...(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
DSCRIPTNchar(31) Descriptio...(more) Join Now
GP 9
TRXDATEdatetime TRX Date: ...(more) Join Now
GP 9
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
ACTINDXint Account In...(more) Join Now
GP 9
join GL00100 on GL00100.ACTINDX = GL20000.ACTINDX
POLLDTRXtinyint
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
ORGNTSRCchar(15) Originatin...(more) Join Now
GP 9
ORGNATYPsmallint Originatin...(more) Join Now
GP 9
QKOFSETsmallint Quick Off ...(more) Join Now
GP 9
SERIESsmallint Series
Join Now

GP 9
ORTRXTYPsmallint Originatin...(more) Join Now
GP 9
ORCTRNUMchar(21) Originatin...(more) Join Now
GP 9
ORMSTRIDchar(31) Originatin...(more) Join Now
GP 9
ORMSTRNMchar(65) Originatin...(more) Join Now
GP 9
ORDOCNUMchar(21) Originatin...(more) 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
OrigSeqNumint Originatin...(more) Join Now
GP 9
SEQNUMBRint Sequence L...(more) Join Now
GP 9
DTA_GL_Statussmallint DTA GL Sta...(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 = GL20000.CURNCYID
CURRNIDXsmallint Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = GL20000.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 = GL20000.NOTEINDX
ICTRXtinyint IC TRX: T...(more) Join Now
GP 9
ORCOMIDchar(5) Originatin...(more) Join Now
GP 9
ORIGINJEint Originati...(more) Join Now
GP 9
PERIODIDsmallint Period ID:...(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
DOCDATEdatetime Document D...(more) Join Now
GP 9
PSTGNMBRint
GP 9
PPSGNMBRint
GP 9
DENXRATEnumeric(19,7) Denominati...(more) Join Now
GP 9
MCTRXSTTsmallint MC Transac...(more) Join Now
GP 9
CorrespondingUnitchar(5) Correspond...(more) Join Now
GP 9
VOIDEDtinyint Voided: ...(more) Join Now
GP 9
Back_Out_JEint
GP 9
Back_Out_JE_Yearsmallint
GP 9
Correcting_JEint
GP 9
Correcting_JE_Yearsmallint
GP 9
Original_JEint Original J...(more) Join Now
GP 9
Original_JE_Seq_Numnumeric(19,5) Original J...(more) Join Now
GP 9
Original_JE_Yearsmallint Original J...(more) Join Now
GP 9
Ledger_IDsmallint Ledger ID:...(more) Join Now
GP 2010
Adjustment_Transactiontinyint Adjustment...(more) Join Now
GP 2010
APRVLUSERIDchar Approval U...(more) Join Now SOP30100.APRVLUSERID
GP 2013
DEX_ROW_TSdatetime Time Stamp...(more) Join Now
GP 10
APPRVLDTdatetime Approval D...(more) Join Now SOP30100.APPRVLDT
GP 2013
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9