DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
TranslationCurrencyIDchar
GP 2010
HSTYEARsmallint
GP 2010
JRNENTRYint PAM60601.JRNENTRY
GP 2010
SOURCDOCchar Join Now
GP 2010
REFRENCEchar
GP 2010
TRXDATEdatetime PAM30502.TRXDATE
GP 2010
TRXSORCEchar Transactio...(more) Join Now
GP 2010
ACTINDXint PAM10610.ACTINDX
GP 2010
join GL00100 on GL00100.ACTINDX = GL30001.ACTINDX
SEQNUMBRint Sequence N...(more) Join Now HR2EMP02.SEQNUMBR
GP 2010
PERIODIDsmallint PAM40302.PERIODID
GP 2010
Ledger_IDsmallint
GP 2010
CURNCYIDchar Currency I...(more) Join Now RM20102.CURNCYID
GP 2010
join DYNAMICS..MC40200 on MC40200.CURNCYID = GL30001.CURNCYID
Original_Exchange_Ratenumeric
GP 2010
ORGNTSRCchar
GP 2010
CRDTAMNTnumeric PAM50600.CRDTAMNT
GP 2010
DEBITAMTnumeric PAM50600.DEBITAMT
GP 2010
ORCRDAMTnumeric
GP 2010
ORDBTAMTnumeric
GP 2010
TranslationCreditAmountnumeric
GP 2010
TranslationDebitAmountnumeric
GP 2010
CURRNIDXsmallint Currency I...(more) Join Now RM20102.CURRNIDX
GP 2010
join DYNAMICS..MC40200 on MC40200.CURRNIDX = GL30001.CURRNIDX
DECPLCURsmallint Decimal Pl...(more) Join Now POP10110.DECPLCUR
GP 2010
RATETPIDchar PAM30900.RATETPID
GP 2010
EXGTBLIDchar Exchange T...(more) Join Now MC00100.EXGTBLID
GP 2010
XCHGRATEnumeric Exchange R...(more) Join Now MC00100.XCHGRATE
GP 2010
EXCHDATEdatetime Exchange D...(more) Join Now MC00100.EXCHDATE
GP 2010
TIME1datetime PM20100.TIME1
GP 2010
RTCLCMTDsmallint Rate calcu...(more) Join Now MC40300.RTCLCMTD
GP 2010
DENXRATEnumeric PAM10501.DENXRATE
GP 2010
MCTRXSTTsmallint
GP 2010
CurrencyTranslationTypesmallint
GP 2010
Identity_Columnint
GP 2010
DEX_ROW_IDint MC40200.DEX_ROW_ID
GP 2010