DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..Account Transaction History)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
HSTYEARsmallint B3930000.HSTYEAR
GP 9
JRNENTRYint Journal En...(more) Join Now DTA10100.JRNENTRY
GP 9
RCTRXSEQnumeric(19,5) Recurring ...(more) Join Now GL10000.RCTRXSEQ
GP 9
SOURCDOCchar(11) Join Now
GP 9
REFRENCEchar(31) Reference:...(more) Join Now POP30300.REFRENCE
GP 9
DSCRIPTNchar(31) Descriptio...(more) Join Now CM20300.DSCRIPTN
GP 9
TRXDATEdatetime TrxDate Transaction Date used when the transaction was posted PAM30502.TRXDATE
GP 9
ACTINDXint Account In...(more) Join Now
GP 9
join GL00100 on GL00100.ACTINDX = GL30000.ACTINDX
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
POLLDTRXtinyint
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
ORGNTSRCchar(15) Originatin...(more) Join Now GL20000.ORGNTSRC
GP 9
ORGNATYPsmallint Originatin...(more) Join Now GL20000.ORGNATYP
GP 9
QKOFSETsmallint Quick Off ...(more) Join Now GL20000.QKOFSET
GP 9
SERIESsmallint Series
Join Now

GP 9
ORTRXTYPsmallint Originatin...(more) Join Now GL10001.ORTRXTYP
GP 9
ORCTRNUMchar(21) Originatin...(more) Join Now GL10001.ORCTRNUM
GP 9
ORMSTRIDchar(31) Originatin...(more) Join Now GL10001.ORMSTRID
GP 9
ORMSTRNMchar(65) Originatin...(more) Join Now GL10001.ORMSTRNM
GP 9
ORDOCNUMchar(21) Originatin...(more) Join Now GL10001.ORDOCNUM
GP 9
ORPSTDDTdatetime Note Index...(more) Join Now GL10000.ORPSTDDT
GP 9
ORTRXSRCchar(13) Originatin...(more) Join Now
GP 9
OrigDTASeriessmallint Period ID:...(more) Join Now GL10000.OrigDTASeries
GP 9
OrigSeqNumint Originatin...(more) Join Now GL10001.OrigSeqNum
GP 9
SEQNUMBRint Sequence N...(more) Join Now DTA10200.SEQNUMBR
GP 9
DTA_GL_Statussmallint DTA GL Sta...(more) Join Now GL10001.DTA_GL_Status
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 = GL30000.CURNCYID
CURRNIDXsmallint Currency I...(more) Join Now CM20200.CURRNIDX
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = GL30000.CURRNIDX
RATETPIDchar(15) A valid Ra...(more) Join Now
GP 9
EXGTBLIDchar(15) Exchange T...(more) Join Now CM20200.EXGTBLID
GP 9
XCHGRATEnumeric(19,7) Exchange R...(more) Join Now CM20200.XCHGRATE
GP 9
EXCHDATEdatetime Exchange D...(more) Join Now CM20200.EXCHDATE
GP 9
TIME1datetime Time see ...(more) Join Now CM20200.TIME1
GP 9
RTCLCMTDsmallint Rate Calcu...(more) Join Now CM20200.RTCLCMTD
GP 9
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = GL30000.NOTEINDX
ICTRXtinyint IC TRX: Im...(more) Join Now PM10000.ICTRX
GP 9
ORCOMIDchar(5) Originatin...(more) Join Now GL10000.ORCOMID
GP 9
ORIGINJEint Originatin...(more) Join Now GL10000.ORIGINJE
GP 9
PERIODIDsmallint Period ID:...(more) Join Now
GP 9
CRDTAMNTnumeric(19,5) Credit Amo...(more) Join Now GL10001.CRDTAMNT
GP 9
DEBITAMTnumeric(19,5) Debit Amou...(more) Join Now GL10001.DEBITAMT
GP 9
ORCRDAMTnumeric(19,5) Originatin...(more) Join Now GL10001.ORCRDAMT
GP 9
ORDBTAMTnumeric(19,5) Originatin...(more) Join Now GL10001.ORDBTAMT
GP 9
DOCDATEdatetime The date a...(more) Join Now
GP 9
PSTGNMBRint
GP 9
PPSGNMBRint
GP 9
DENXRATEnumeric(19,7) Denominati...(more) Join Now CM20200.DENXRATE
GP 9
MCTRXSTTsmallint MC Transac...(more) Join Now CM20200.MCTRXSTT
GP 9
CorrespondingUnitchar(5) Correspond...(more) Join Now GL10001.CorrespondingUnit
GP 9
VOIDEDtinyint Voided TRU...(more) Join Now CM20100.VOIDED
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 GL10000.Original_JE
GP 9
Original_JE_Seq_Numnumeric(19,5) Original J...(more) Join Now
GP 9
Original_JE_Yearsmallint Original J...(more) Join Now GL10000.Original_JE_Year
GP 9
Ledger_IDsmallint Ledger ID:...(more) Join Now GL10000.Ledger_ID
GP 2010
Adjustment_Transactiontinyint Adjustment...(more) Join Now GL10000.Adjustment_Transaction
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