General Ledger Report Options Temporary (GL70501)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialGeneral Ledger Report Options Temporary (GL70501)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL70501

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: General Ledger Report Options Temporary
Physical Name: GL70501
Technical Name: GL_Options_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['General Ledger Report Options Temporary'].USERID AS 'General Ledger Report Options Temporary-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL70501 AS ['General Ledger Report Options Temporary']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['General Ledger Report Options Temporary'].USERID = ['Users Master'].USERID
2IFFILXST SearchIf File ExistingGBInteger20
3FILEXPNM SearchFile Export NameSTR255String256255
4EXPTTYPE SearchExport TypeINTInteger20
5ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
6PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
7PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
8PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
9PRNTTYPE SearchPrint TypeGBInteger20
10RPTGRIND SearchReport Group IndexINTInteger20
11RTPACHIN SearchReport Palette Choice IndexINTInteger20
12RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
13SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
14REPORTID SearchReport IDINT_STORAGEInteger20
15FINRPTNM SearchFinancial Report NameSTR30String3230
16STTUDEF1 SearchStart User Defined 1STR20String2220
17ENUSRDF1 SearchEnd User Defined 1STR20String2220
18STGENINT1 SearchStart Generic Integer1INTInteger20
19ENDGENINT1 SearchEnd Generic Integer1INTInteger20
20STGENINT2 SearchStart Generic Integer2INTInteger20
21ENDGENINT2 SearchEnd Generic Integer2INTInteger20
22STRTNGDT SearchStarting DateDTDate48
23ENDINGDT SearchEnding DateDTDate48
24STTCATEG SearchStart CategoryINT2_U0Integer22
25ENDCATEG SearchEnd CategoryINT2_U0Integer22
26STTCATNM SearchStart Category NameSTR40_CategoryString4240
27ENDCATNM SearchEnd Category NameSTR40_CategoryString4240
28STRTJRNL SearchStart JournalLI8_U0Long Integer48
29ENDJRNAL SearchEnd JournalLI8_U0Long Integer48
30STRXSRC SearchStart TRX SourceSTR13String1413
31ENTRXSRC SearchEnd TRX SourceSTR13String1413
32STRTCMTRXNUM SearchStart CM Trx NumberSTR20_Document_NumberString2220
33ENDCMTRXNUM SearchEnd CM Trx NumberSTR20_Document_NumberString2220
34SSRCEDOC SearchStart Source DocumentSTR10_Source_DocumentString1210
35ENDSRCDC SearchEnd Source DocumentSTR10_Source_DocumentString1210
36STTACDSC SearchStart Account DescriptionSTR50String5250
37ENDACDSC SearchEnd Account DescriptionSTR50String5250
38STBDBSID SearchStart Budget Business IDSTR15String1615
39ENBDBSID SearchEnd Budget Business IDSTR15String1615
40STBDBSDS SearchStart Budget Business DescriptionSTR30String3230
41ENBDBSDS SearchEnd Budget Business DescriptionSTR30String3230
42STCHBKID SearchStart Checkbook IDSTR15_LBUString1615
43ENCHBKID SearchEnd Checkbook IDSTR15_LBUString1615
44STRTDSCR SearchStart DescriptionSTR50String5250
45ENDDESCR SearchEnd DescriptionSTR50String5250
46STTSEGID SearchStart Segment IDSTR10String1210
47ENDSEGID SearchEnd Segment IDSTR10String1210
48STCTRNUM SearchStart Control NumberSTR20String2220
49ENCNTNUM SearchEnd Control NumberSTR20String2220
50STDOCNUM SearchStart Document NumberSTR20String2220
51ENDOCNUM SearchEnd Document NumberSTR20String2220
52STMASTID SearchStart Master IDSTR20String2220
53ENMASTID SearchEnd Master IDSTR20String2220
54STMASTNM SearchStart Master NameSTR30String3230
55ENMASTNM SearchEnd Master NameSTR30String3230
56SORTBY SearchSort ByDDL_Sort_ByInteger20
57CBINACTS SearchCB Inactive AccountsCB_Inactive_AccountsBoolean20
58PSTNGACT SearchPosting AccountINT1Integer21
59UNITACCT SearchUnit AccountINT1Integer21
60RPRTSHOW SearchReports ShowDDLInteger20
61PRRPTFOR SearchPrint Report ForGBInteger20
62PRVYRCMB SearchPrevious Year CMBCMBString64
63RPTDETAL SearchReport DetailReport DetailInteger20
64INDIVDUL_1 SearchIndividual[1]CBBoolean20
65INDIVDUL_2 SearchIndividual[2]CBBoolean20
66INDIVDUL_3 SearchIndividual[3]CBBoolean20
67INDIVDUL_4 SearchIndividual[4]CBBoolean20
68INDIVDUL_5 SearchIndividual[5]CBBoolean20
69INDIVDUL_6 SearchIndividual[6]CBBoolean20
70INDIVDUL_7 SearchIndividual[7]CBBoolean20
71INDIVDUL_8 SearchIndividual[8]CBBoolean20
72INDIVDUL_9 SearchIndividual[9]CBBoolean20
73INDIVDUL_10 SearchIndividual[10]CBBoolean20
74INDIVDUL_11 SearchIndividual[11]CBBoolean20
75INDIVDUL_12 SearchIndividual[12]CBBoolean20
76INDIVDUL_13 SearchIndividual[13]CBBoolean20
77INDIVDUL_14 SearchIndividual[14]CBBoolean20
78INDIVDUL_15 SearchIndividual[15]CBBoolean20
79INDIVDUL_16 SearchIndividual[16]CBBoolean20
80INDIVDUL_17 SearchIndividual[17]CBBoolean20
81INDIVDUL_18 SearchIndividual[18]CBBoolean20
82INDIVDUL_19 SearchIndividual[19]CBBoolean20
83INDIVDUL_20 SearchIndividual[20]CBBoolean20
84INDIVDUL_21 SearchIndividual[21]CBBoolean20
85INDIVDUL_22 SearchIndividual[22]CBBoolean20
86INDIVDUL_23 SearchIndividual[23]CBBoolean20
87INDIVDUL_24 SearchIndividual[24]CBBoolean20
88INDIVDUL_25 SearchIndividual[25]CBBoolean20
89INDIVDUL_26 SearchIndividual[26]CBBoolean20
90INDIVDUL_27 SearchIndividual[27]CBBoolean20
91INDIVDUL_28 SearchIndividual[28]CBBoolean20
92INDIVDUL_29 SearchIndividual[29]CBBoolean20
93INDIVDUL_30 SearchIndividual[30]CBBoolean20
94INDIVDUL_31 SearchIndividual[31]CBBoolean20
95INDIVDUL_32 SearchIndividual[32]CBBoolean20
96INDIVDUL_33 SearchIndividual[33]CBBoolean20
97INDIVDUL_34 SearchIndividual[34]CBBoolean20
98INDIVDUL_35 SearchIndividual[35]CBBoolean20
99INDIVDUL_36 SearchIndividual[36]CBBoolean20
100INDIVDUL_37 SearchIndividual[37]CBBoolean20
101INDIVDUL_38 SearchIndividual[38]CBBoolean20
102INDIVDUL_39 SearchIndividual[39]CBBoolean20
103INDIVDUL_40 SearchIndividual[40]CBBoolean20
104INDIVDUL_41 SearchIndividual[41]CBBoolean20
105PRNTDSCR SearchPrint DescriptionGBInteger20
106PRZROBAL SearchPrint Zero BalancesYNBoolean20
107CLCRATIO SearchCalculate RatioGBInteger20
108INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
109GLSTTKDT SearchGL Start Token DateDDL_GL_Token_DatesInteger20
110GLENTKDT SearchGL End Token DateDDL_GL_Token_DatesInteger20
111PRUNTACT SearchPrint Unit AccountsCB_Print_Unit_AccountsBoolean20
112STACCNUM_1 SearchStarting Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
113STACCNUM_2 SearchStarting Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
114STACCNUM_3 SearchStarting Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
115STACCNUM_4 SearchStarting Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
116STACCNUM_5 SearchStarting Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
117STACCNUM_6 SearchStarting Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
118STACCNUM_7 SearchStarting Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
119STACCNUM_8 SearchStarting Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
120STACCNUM_9 SearchStarting Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
121STACCNUM_10 SearchStarting Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
122EDGACNUM_1 SearchEnding Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
123EDGACNUM_2 SearchEnding Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
124EDGACNUM_3 SearchEnding Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
125EDGACNUM_4 SearchEnding Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
126EDGACNUM_5 SearchEnding Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
127EDGACNUM_6 SearchEnding Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
128EDGACNUM_7 SearchEnding Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
129EDGACNUM_8 SearchEnding Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
130EDGACNUM_9 SearchEnding Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
131EDGACNUM_10 SearchEnding Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
132SEGSRTBY SearchSegment Sort ByINT1Integer21
133RANGEBY SearchRange ByINTInteger20
134CBZBNA SearchZero Balance And No ActivityCB_Zero_AccountsBoolean20
135Accounts_Included SearchAccounts IncludedGBInteger20
136Start_Position_String SearchStart Position StringSTR89String9089
137End_Position_String SearchEnd Position StringSTR89String9089
138RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
139RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger20
140PRTCURIN SearchPrint Currency InGBInteger20
141INCMCINF SearchInclude Multicurrency InfoCB_Include_Multicurrency_InfoBoolean20
142STCURRID SearchStart Currency IDSTR15_Currency_IDString1615
143ENDCURID SearchEnd Currency IDSTR15_Currency_IDString1615
144UseLedgersForAcctBalance SearchUse Ledgers For Account BalanceML_MultiSelectListBoxLong Integer40
145DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)FinancialGeneral Ledger Report Options Temporary (GL70501)

Leave a Reply

Your email address will not be published. Required fields are marked *