DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..General Ledger Report Options)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
IFFILXSTsmallint B3900297.IFFILXST
GP 9
FILEXPNMchar(255) XXUF0100.FILEXPNM
GP 9
EXPTTYPEsmallint PAM70103.EXPTTYPE
GP 9
ASKECHTMtinyint
GP 9
PRNTOFILtinyint
GP 9
PRTOPRTRtinyint SY01400.PRTOPRTR
GP 9
PRTOSCRNtinyint SY01400.PRTOSCRN
GP 9
PRNTTYPEsmallint
GP 9
RPTGRINDsmallint B3970500.RPTGRIND
GP 9
RTPACHINsmallint B3970500.RTPACHIN
GP 9
RTGRSBINnumeric(19,5) UPR70501.RTGRSBIN
GP 9
REPORTIDsmallint
GP 9
FINRPTNMchar(31) PP000060.FINRPTNM
GP 9
STGENINT1smallint
GP 9
ENDGENINT1smallint
GP 9
STGENINT2smallint
GP 9
ENDGENINT2smallint
GP 9
STRTNGDTdatetime
GP 9
ENDINGDTdatetime
GP 9
STTCATEGsmallint
GP 9
STTUDEF1char(21) CN40500.STTUDEF1
GP 9
ENUSRDF1char(21) CN40500.ENUSRDF1
GP 9
ENDCATEGsmallint
GP 9
STTCATNMchar(41)
GP 9
ENDCATNMchar(41)
GP 9
STRTJRNLint
GP 9
ENDJRNALint
GP 9
STRXSRCchar(13)
GP 9
ENTRXSRCchar(13)
GP 9
STRTCMTRXNUMchar(21)
GP 9
ENDCMTRXNUMchar(21)
GP 9
SSRCEDOCchar(11)
GP 9
ENDSRCDCchar(11)
GP 9
STTACDSCchar(51)
GP 9
ENDACDSCchar(51)
GP 9
STBDBSIDchar(15)
GP 9
ENBDBSIDchar(15)
GP 9
STBDBSDSchar(31)
GP 9
ENBDBSDSchar(31)
GP 9
STCHBKIDchar(15)
GP 9
ENCHBKIDchar(15)
GP 9
STRTDSCRchar(51)
GP 9
ENDDESCRchar(51)
GP 9
STTSEGIDchar(11) PP000060.STTSEGID
GP 9
ENDSEGIDchar(11) PP000060.ENDSEGID
GP 9
STCTRNUMchar(21)
GP 9
ENCNTNUMchar(21)
GP 9
STDOCNUMchar(21) RVPS0132.STDOCNUM
GP 9
ENDOCNUMchar(21) RVPS0132.ENDOCNUM
GP 9
STMASTIDchar(21)
GP 9
ENMASTIDchar(21)
GP 9
STMASTNMchar(31)
GP 9
ENMASTNMchar(31)
GP 9
SORTBYsmallint PAM00100.SORTBY
GP 9
CBINACTStinyint
GP 9
PSTNGACTsmallint
GP 9
UNITACCTsmallint
GP 9
RPRTSHOWsmallint
GP 9
PRRPTFORsmallint
GP 9
PRVYRCMBchar(5) PP000060.PRVYRCMB
GP 9
RPTDETALsmallint
GP 9
INDIVDUL_1tinyint
GP 9
INDIVDUL_2tinyint
GP 9
INDIVDUL_3tinyint
GP 9
INDIVDUL_4tinyint
GP 9
INDIVDUL_5tinyint
GP 9
INDIVDUL_6tinyint
GP 9
INDIVDUL_7tinyint
GP 9
INDIVDUL_8tinyint
GP 9
INDIVDUL_9tinyint
GP 9
INDIVDUL_10tinyint
GP 9
INDIVDUL_11tinyint
GP 9
INDIVDUL_12tinyint
GP 9
INDIVDUL_13tinyint
GP 9
INDIVDUL_14tinyint
GP 9
INDIVDUL_15tinyint
GP 9
INDIVDUL_16tinyint
GP 9
INDIVDUL_17tinyint
GP 9
INDIVDUL_18tinyint
GP 9
INDIVDUL_19tinyint
GP 9
INDIVDUL_20tinyint
GP 9
INDIVDUL_21tinyint
GP 9
INDIVDUL_22tinyint
GP 9
INDIVDUL_23tinyint
GP 9
INDIVDUL_24tinyint
GP 9
INDIVDUL_25tinyint
GP 9
INDIVDUL_26tinyint
GP 9
INDIVDUL_27tinyint
GP 9
INDIVDUL_28tinyint
GP 9
INDIVDUL_29tinyint
GP 9
INDIVDUL_30tinyint
GP 9
INDIVDUL_31tinyint
GP 9
INDIVDUL_32tinyint
GP 9
INDIVDUL_33tinyint
GP 9
INDIVDUL_34tinyint
GP 9
INDIVDUL_35tinyint
GP 9
INDIVDUL_36tinyint
GP 9
INDIVDUL_37tinyint
GP 9
INDIVDUL_38tinyint
GP 9
INDIVDUL_39tinyint
GP 9
INDIVDUL_40tinyint
GP 9
INDIVDUL_41tinyint
GP 9
PRNTDSCRsmallint
GP 9
PRZROBALtinyint
GP 9
CLCRATIOsmallint
GP 9
INCLGNDStinyint
GP 9
GLSTTKDTsmallint
GP 9
GLENTKDTsmallint
GP 9
PRUNTACTtinyint
GP 9
STACCNUM_1char(5)
GP 9
STACCNUM_2char(5)
GP 9
STACCNUM_3char(5)
GP 9
STACCNUM_4char(5)
GP 9
STACCNUM_5char(5)
GP 9
STACCNUM_6char
GP 2010
EDGACNUM_1char(5)
GP 9
EDGACNUM_2char(5)
GP 9
STACCNUM_7char
GP 2010
STACCNUM_8char
GP 2010
EDGACNUM_3char(5)
GP 9
EDGACNUM_4char(5)
GP 9
STACCNUM_9char
GP 2010
STACCNUM_10char
GP 2010
EDGACNUM_5char(5)
GP 9
SEGSRTBYsmallint
GP 9
RANGEBYsmallint
GP 9
ACCLSTATsmallint
GP 9
USEACCELtinyint
GP 9
CBZBNAtinyint
GP 9
Accounts_Includedsmallint
GP 9
EDGACNUM_6char
GP 2010
EDGACNUM_7char
GP 2010
Start_Position_Stringchar(89) PP000060.Start_Position_String
GP 9
EDGACNUM_8char
GP 2010
End_Position_Stringchar(89) PP000060.End_Position_String
GP 9
EDGACNUM_9char
GP 2010
RPTXRATEnumeric(19,7) Reporting ...(more) Join Now MC40000.RPTXRATE
GP 9
RPRTCLMDsmallint Reporting ...(more) Join Now MC40000.RPRTCLMD
GP 9
EDGACNUM_10char
GP 2010
PRTCURINsmallint
GP 9
Checkbook_Datedatetime
GP 9
End_Monthsmallint
GP 9
Start_Monthsmallint
GP 9
YEAR1smallint Year fisca...(more) Join Now
GP 9
INCMCINFtinyint
GP 9
STCURRIDchar(15)
GP 9
ENDCURIDchar(15)
GP 9
Include_Voided_Trxtinyint
GP 9
UseLedgersForAcctBalancebinary(4)
GP 2010
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9