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 TypeLength
1USERID SearchUser IDSTR15_User_IDString15
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 ExistingGBInteger0
3FILEXPNM SearchFile Export NameSTR255String255
4EXPTTYPE SearchExport TypeINTInteger0
5ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
6PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
7PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
8PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
9PRNTTYPE SearchPrint TypeGBInteger0
10RPTGRIND SearchReport Group IndexINTInteger0
11RTPACHIN SearchReport Palette Choice IndexINTInteger0
12RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
13SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
14REPORTID SearchReport IDINT_STORAGEInteger0
15FINRPTNM SearchFinancial Report NameSTR30String30
16STTUDEF1 SearchStart User Defined 1STR20String20
17ENUSRDF1 SearchEnd User Defined 1STR20String20
18STGENINT1 SearchStart Generic Integer1INTInteger0
19ENDGENINT1 SearchEnd Generic Integer1INTInteger0
20STGENINT2 SearchStart Generic Integer2INTInteger0
21ENDGENINT2 SearchEnd Generic Integer2INTInteger0
22STRTNGDT SearchStarting DateDTDate8
23ENDINGDT SearchEnding DateDTDate8
24STTCATEG SearchStart CategoryINT2_U0Integer2
25ENDCATEG SearchEnd CategoryINT2_U0Integer2
26STTCATNM SearchStart Category NameSTR40_CategoryString40
27ENDCATNM SearchEnd Category NameSTR40_CategoryString40
28STRTJRNL SearchStart JournalLI8_U0Long Integer8
29ENDJRNAL SearchEnd JournalLI8_U0Long Integer8
30STRXSRC SearchStart TRX SourceSTR13String13
31ENTRXSRC SearchEnd TRX SourceSTR13String13
32STRTCMTRXNUM SearchStart CM Trx NumberSTR20_Document_NumberString20
33ENDCMTRXNUM SearchEnd CM Trx NumberSTR20_Document_NumberString20
34SSRCEDOC SearchStart Source DocumentSTR10_Source_DocumentString10
35ENDSRCDC SearchEnd Source DocumentSTR10_Source_DocumentString10
36STTACDSC SearchStart Account DescriptionSTR50String50
37ENDACDSC SearchEnd Account DescriptionSTR50String50
38STBDBSID SearchStart Budget Business IDSTR15String15
39ENBDBSID SearchEnd Budget Business IDSTR15String15
40STBDBSDS SearchStart Budget Business DescriptionSTR30String30
41ENBDBSDS SearchEnd Budget Business DescriptionSTR30String30
42STCHBKID SearchStart Checkbook IDSTR15_LBUString15
43ENCHBKID SearchEnd Checkbook IDSTR15_LBUString15
44STRTDSCR SearchStart DescriptionSTR50String50
45ENDDESCR SearchEnd DescriptionSTR50String50
46STTSEGID SearchStart Segment IDSTR10String10
47ENDSEGID SearchEnd Segment IDSTR10String10
48STCTRNUM SearchStart Control NumberSTR20String20
49ENCNTNUM SearchEnd Control NumberSTR20String20
50STDOCNUM SearchStart Document NumberSTR20String20
51ENDOCNUM SearchEnd Document NumberSTR20String20
52STMASTID SearchStart Master IDSTR20String20
53ENMASTID SearchEnd Master IDSTR20String20
54STMASTNM SearchStart Master NameSTR30String30
55ENMASTNM SearchEnd Master NameSTR30String30
56SORTBY SearchSort ByDDL_Sort_ByInteger0
57CBINACTS SearchCB Inactive AccountsCB_Inactive_AccountsBoolean0
58PSTNGACT SearchPosting AccountINT1Integer1
59UNITACCT SearchUnit AccountINT1Integer1
60RPRTSHOW SearchReports ShowDDLInteger0
61PRRPTFOR SearchPrint Report ForGBInteger0
62PRVYRCMB SearchPrevious Year CMBCMBString4
63RPTDETAL SearchReport DetailReport DetailInteger0
64INDIVDUL_1 SearchIndividual[1]CBBoolean0
65INDIVDUL_2 SearchIndividual[2]CBBoolean0
66INDIVDUL_3 SearchIndividual[3]CBBoolean0
67INDIVDUL_4 SearchIndividual[4]CBBoolean0
68INDIVDUL_5 SearchIndividual[5]CBBoolean0
69INDIVDUL_6 SearchIndividual[6]CBBoolean0
70INDIVDUL_7 SearchIndividual[7]CBBoolean0
71INDIVDUL_8 SearchIndividual[8]CBBoolean0
72INDIVDUL_9 SearchIndividual[9]CBBoolean0
73INDIVDUL_10 SearchIndividual[10]CBBoolean0
74INDIVDUL_11 SearchIndividual[11]CBBoolean0
75INDIVDUL_12 SearchIndividual[12]CBBoolean0
76INDIVDUL_13 SearchIndividual[13]CBBoolean0
77INDIVDUL_14 SearchIndividual[14]CBBoolean0
78INDIVDUL_15 SearchIndividual[15]CBBoolean0
79INDIVDUL_16 SearchIndividual[16]CBBoolean0
80INDIVDUL_17 SearchIndividual[17]CBBoolean0
81INDIVDUL_18 SearchIndividual[18]CBBoolean0
82INDIVDUL_19 SearchIndividual[19]CBBoolean0
83INDIVDUL_20 SearchIndividual[20]CBBoolean0
84INDIVDUL_21 SearchIndividual[21]CBBoolean0
85INDIVDUL_22 SearchIndividual[22]CBBoolean0
86INDIVDUL_23 SearchIndividual[23]CBBoolean0
87INDIVDUL_24 SearchIndividual[24]CBBoolean0
88INDIVDUL_25 SearchIndividual[25]CBBoolean0
89INDIVDUL_26 SearchIndividual[26]CBBoolean0
90INDIVDUL_27 SearchIndividual[27]CBBoolean0
91INDIVDUL_28 SearchIndividual[28]CBBoolean0
92INDIVDUL_29 SearchIndividual[29]CBBoolean0
93INDIVDUL_30 SearchIndividual[30]CBBoolean0
94INDIVDUL_31 SearchIndividual[31]CBBoolean0
95INDIVDUL_32 SearchIndividual[32]CBBoolean0
96INDIVDUL_33 SearchIndividual[33]CBBoolean0
97INDIVDUL_34 SearchIndividual[34]CBBoolean0
98INDIVDUL_35 SearchIndividual[35]CBBoolean0
99INDIVDUL_36 SearchIndividual[36]CBBoolean0
100INDIVDUL_37 SearchIndividual[37]CBBoolean0
101INDIVDUL_38 SearchIndividual[38]CBBoolean0
102INDIVDUL_39 SearchIndividual[39]CBBoolean0
103INDIVDUL_40 SearchIndividual[40]CBBoolean0
104INDIVDUL_41 SearchIndividual[41]CBBoolean0
105PRNTDSCR SearchPrint DescriptionGBInteger0
106PRZROBAL SearchPrint Zero BalancesYNBoolean0
107CLCRATIO SearchCalculate RatioGBInteger0
108INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
109GLSTTKDT SearchGL Start Token DateDDL_GL_Token_DatesInteger0
110GLENTKDT SearchGL End Token DateDDL_GL_Token_DatesInteger0
111PRUNTACT SearchPrint Unit AccountsCB_Print_Unit_AccountsBoolean0
112STACCNUM_1 SearchStarting Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
113STACCNUM_2 SearchStarting Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
114STACCNUM_3 SearchStarting Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
115STACCNUM_4 SearchStarting Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
116STACCNUM_5 SearchStarting Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
117STACCNUM_6 SearchStarting Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
118STACCNUM_7 SearchStarting Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
119STACCNUM_8 SearchStarting Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
120STACCNUM_9 SearchStarting Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
121STACCNUM_10 SearchStarting Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
122EDGACNUM_1 SearchEnding Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
123EDGACNUM_2 SearchEnding Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
124EDGACNUM_3 SearchEnding Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
125EDGACNUM_4 SearchEnding Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
126EDGACNUM_5 SearchEnding Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
127EDGACNUM_6 SearchEnding Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
128EDGACNUM_7 SearchEnding Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
129EDGACNUM_8 SearchEnding Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
130EDGACNUM_9 SearchEnding Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
131EDGACNUM_10 SearchEnding Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
132SEGSRTBY SearchSegment Sort ByINT1Integer1
133RANGEBY SearchRange ByINTInteger0
134CBZBNA SearchZero Balance And No ActivityCB_Zero_AccountsBoolean0
135Accounts_Included SearchAccounts IncludedGBInteger0
136Start_Position_String SearchStart Position StringSTR89String89
137End_Position_String SearchEnd Position StringSTR89String89
138RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)14
139RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger0
140PRTCURIN SearchPrint Currency InGBInteger0
141INCMCINF SearchInclude Multicurrency InfoCB_Include_Multicurrency_InfoBoolean0
142STCURRID SearchStart Currency IDSTR15_Currency_IDString15
143ENDCURID SearchEnd Currency IDSTR15_Currency_IDString15
144UseLedgersForAcctBalance SearchUse Ledgers For Account BalanceML_MultiSelectListBoxLong Integer0
145DEX_ROW_ID Searchintint10

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 *