DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module GL tables GL70500
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?

 Column NameData Type
Default Value		 Source
IFFILXST smallint
0

FILEXPNM char(255)
''

EXPTTYPE smallint
0

ASKECHTM tinyint
0

PRNTOFIL tinyint
0

PRTOPRTR tinyint
0

PRTOSCRN tinyint
0

PRNTTYPE smallint
0

RPTGRIND smallint
0

RTPACHIN smallint
0

RTGRSBIN numeric(19,5)
0.00

REPORTID smallint
0

FINRPTNM char(31)
''

STGENINT1 smallint
0

ENDGENINT1 smallint
0

STGENINT2 smallint
0

ENDGENINT2 smallint
0

STRTNGDT datetime
'1/1/1900'

ENDINGDT datetime
'1/1/1900'

STTCATEG smallint
0

STTUDEF1 char(21)
''

ENUSRDF1 char(21)
''

ENDCATEG smallint
0

STTCATNM char(41)
''

ENDCATNM char(41)
''

STRTJRNL int
0

ENDJRNAL int
0

STRXSRC char(13)
''

ENTRXSRC char(13)
''

STRTCMTRXNUM char(21)
''

ENDCMTRXNUM char(21)
''

SSRCEDOC char(11)
''

ENDSRCDC char(11)
''

STTACDSC char(51)
''

ENDACDSC char(51)
''

STBDBSID char(15)
''

ENBDBSID char(15)
''

STBDBSDS char(31)
''

ENBDBSDS char(31)
''

STCHBKID char(15)
''

ENCHBKID char(15)
''

STRTDSCR char(51)
''

ENDDESCR char(51)
''

STTSEGID char(11)
''

ENDSEGID char(11)
''

STCTRNUM char(21)
''

ENCNTNUM char(21)
''

STDOCNUM char(21)
''

ENDOCNUM char(21)
''

STMASTID char(21)
''

ENMASTID char(21)
''

STMASTNM char(31)
''

ENMASTNM char(31)
''

SORTBY smallint
0

CBINACTS tinyint
0

PSTNGACT smallint
0

UNITACCT smallint
0

RPRTSHOW smallint
0

PRRPTFOR smallint
0

PRVYRCMB char(5)
''

RPTDETAL smallint
0

INDIVDUL_1 tinyint
0

INDIVDUL_2 tinyint
0

INDIVDUL_3 tinyint
0

INDIVDUL_4 tinyint
0

INDIVDUL_5 tinyint
0

INDIVDUL_6 tinyint
0

INDIVDUL_7 tinyint
0

INDIVDUL_8 tinyint
0

INDIVDUL_9 tinyint
0

INDIVDUL_10 tinyint
0

INDIVDUL_11 tinyint
0

INDIVDUL_12 tinyint
0

INDIVDUL_13 tinyint
0

INDIVDUL_14 tinyint
0

INDIVDUL_15 tinyint
0

INDIVDUL_16 tinyint
0

INDIVDUL_17 tinyint
0

INDIVDUL_18 tinyint
0

INDIVDUL_19 tinyint
0

INDIVDUL_20 tinyint
0

INDIVDUL_21 tinyint
0

INDIVDUL_22 tinyint
0

INDIVDUL_23 tinyint
0

INDIVDUL_24 tinyint
0

INDIVDUL_25 tinyint
0

INDIVDUL_26 tinyint
0

INDIVDUL_27 tinyint
0

INDIVDUL_28 tinyint
0

INDIVDUL_29 tinyint
0

INDIVDUL_30 tinyint
0

INDIVDUL_31 tinyint
0

INDIVDUL_32 tinyint
0

INDIVDUL_33 tinyint
0

INDIVDUL_34 tinyint
0

INDIVDUL_35 tinyint
0

INDIVDUL_36 tinyint
0

INDIVDUL_37 tinyint
0

INDIVDUL_38 tinyint
0

INDIVDUL_39 tinyint
0

INDIVDUL_40 tinyint
0

INDIVDUL_41 tinyint
0

PRNTDSCR smallint
0

PRZROBAL tinyint
0

CLCRATIO smallint
0

INCLGNDS tinyint
0

GLSTTKDT smallint
0

GLENTKDT smallint
0

PRUNTACT tinyint
0

STACCNUM_1 char(5)
''

STACCNUM_2 char(5)
''

STACCNUM_3 char(5)
''

STACCNUM_4 char(5)
''

STACCNUM_5 char(5)
''

STACCNUM_6 char
''

EDGACNUM_1 char(5)
''

EDGACNUM_2 char(5)
''

STACCNUM_7 char
''

STACCNUM_8 char
''

EDGACNUM_3 char(5)
''

EDGACNUM_4 char(5)
''

STACCNUM_9 char
''

STACCNUM_10 char
''

EDGACNUM_5 char(5)
''

SEGSRTBY smallint
0

RANGEBY smallint
0

ACCLSTAT smallint
0

USEACCEL tinyint
0

CBZBNA tinyint
0

Accounts_Included smallint
0

EDGACNUM_6 char
''

EDGACNUM_7 char
''

Start_Position_String char(89)
''

EDGACNUM_8 char
''

End_Position_String char(89)
''

EDGACNUM_9 char
''

RPTXRATE numeric(19,7)
0.00
Reporting ...(more) Join Now MC40000.RPTXRATE
RPRTCLMD smallint
0
Reporting ...(more) Join Now MC40000.RPRTCLMD
EDGACNUM_10 char
''

PRTCURIN smallint
0

Checkbook_Date datetime
'1/1/1900'

End_Month smallint
0

Start_Month smallint
0

YEAR1 smallint
0
Year fisca...(more) Join Now
INCMCINF tinyint
0

STCURRID char(15)
''

ENDCURID char(15)
''

Include_Voided_Trx tinyint
0

UseLedgersForAcctBalance binary(4)
0

DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3