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
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Module List > Module GL tables > GL70501
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change

COMPANY..GL70501 Table Definition

(COMPANY..General Ledger Report Options Temporary)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
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

SEQNUMBR int
0
Sequence N...(more) Join Now DTA10200.SEQNUMBR
REPORTID smallint
0

FINRPTNM char(31)
''

STTUDEF1 char(21)
''

ENUSRDF1 char(21)
''

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

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

CBZBNA tinyint
0

Accounts_Included smallint
0

Start_Position_String char(89)
''

EDGACNUM_6 char
''

End_Position_String char(89)
''

EDGACNUM_7 char
''

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

EDGACNUM_9 char
''

PRTCURIN smallint
0

EDGACNUM_10 char
''

INCMCINF tinyint
0

STCURRID char(15)
''

ENDCURID char(15)
''

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