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 IDStringSTR15_User_ID15
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 ExistingIntegerGB0
3FILEXPNM SearchFile Export NameStringSTR255255
4EXPTTYPE SearchExport TypeIntegerINT0
5ASKECHTM SearchAsk Each TimeBooleanCB_Ask_Each_Time0
6PRNTOFIL SearchPrint to FileBooleanCB_Print_to_File0
7PRTOPRTR SearchPrint to PrinterBooleanCB_Print_to_Printer0
8PRTOSCRN SearchPrint to ScreenBooleanCB_Print_to_Screen0
9PRNTTYPE SearchPrint TypeIntegerGB0
10RPTGRIND SearchReport Group IndexIntegerINT0
11RTPACHIN SearchReport Palette Choice IndexIntegerINT0
12RTGRSBIN SearchReport Group Sub IndexCurrencyDLR1414
13SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
14REPORTID SearchReport IDIntegerINT_STORAGE0
15FINRPTNM SearchFinancial Report NameStringSTR3030
16STTUDEF1 SearchStart User Defined 1StringSTR2020
17ENUSRDF1 SearchEnd User Defined 1StringSTR2020
18STGENINT1 SearchStart Generic Integer1IntegerINT0
19ENDGENINT1 SearchEnd Generic Integer1IntegerINT0
20STGENINT2 SearchStart Generic Integer2IntegerINT0
21ENDGENINT2 SearchEnd Generic Integer2IntegerINT0
22STRTNGDT SearchStarting DateDateDT8
23ENDINGDT SearchEnding DateDateDT8
24STTCATEG SearchStart CategoryIntegerINT2_U02
25ENDCATEG SearchEnd CategoryIntegerINT2_U02
26STTCATNM SearchStart Category NameStringSTR40_Category40
27ENDCATNM SearchEnd Category NameStringSTR40_Category40
28STRTJRNL SearchStart JournalLong IntegerLI8_U08
29ENDJRNAL SearchEnd JournalLong IntegerLI8_U08
30STRXSRC SearchStart TRX SourceStringSTR1313
31ENTRXSRC SearchEnd TRX SourceStringSTR1313
32STRTCMTRXNUM SearchStart CM Trx NumberStringSTR20_Document_Number20
33ENDCMTRXNUM SearchEnd CM Trx NumberStringSTR20_Document_Number20
34SSRCEDOC SearchStart Source DocumentStringSTR10_Source_Document10
35ENDSRCDC SearchEnd Source DocumentStringSTR10_Source_Document10
36STTACDSC SearchStart Account DescriptionStringSTR5050
37ENDACDSC SearchEnd Account DescriptionStringSTR5050
38STBDBSID SearchStart Budget Business IDStringSTR1515
39ENBDBSID SearchEnd Budget Business IDStringSTR1515
40STBDBSDS SearchStart Budget Business DescriptionStringSTR3030
41ENBDBSDS SearchEnd Budget Business DescriptionStringSTR3030
42STCHBKID SearchStart Checkbook IDStringSTR15_LBU15
43ENCHBKID SearchEnd Checkbook IDStringSTR15_LBU15
44STRTDSCR SearchStart DescriptionStringSTR5050
45ENDDESCR SearchEnd DescriptionStringSTR5050
46STTSEGID SearchStart Segment IDStringSTR1010
47ENDSEGID SearchEnd Segment IDStringSTR1010
48STCTRNUM SearchStart Control NumberStringSTR2020
49ENCNTNUM SearchEnd Control NumberStringSTR2020
50STDOCNUM SearchStart Document NumberStringSTR2020
51ENDOCNUM SearchEnd Document NumberStringSTR2020
52STMASTID SearchStart Master IDStringSTR2020
53ENMASTID SearchEnd Master IDStringSTR2020
54STMASTNM SearchStart Master NameStringSTR3030
55ENMASTNM SearchEnd Master NameStringSTR3030
56SORTBY SearchSort ByIntegerDDL_Sort_By0
57CBINACTS SearchCB Inactive AccountsBooleanCB_Inactive_Accounts0
58PSTNGACT SearchPosting AccountIntegerINT11
59UNITACCT SearchUnit AccountIntegerINT11
60RPRTSHOW SearchReports ShowIntegerDDL0
61PRRPTFOR SearchPrint Report ForIntegerGB0
62PRVYRCMB SearchPrevious Year CMBStringCMB4
63RPTDETAL SearchReport DetailIntegerReport Detail0
64INDIVDUL_1 SearchIndividual[1]BooleanCB0
65INDIVDUL_2 SearchIndividual[2]BooleanCB0
66INDIVDUL_3 SearchIndividual[3]BooleanCB0
67INDIVDUL_4 SearchIndividual[4]BooleanCB0
68INDIVDUL_5 SearchIndividual[5]BooleanCB0
69INDIVDUL_6 SearchIndividual[6]BooleanCB0
70INDIVDUL_7 SearchIndividual[7]BooleanCB0
71INDIVDUL_8 SearchIndividual[8]BooleanCB0
72INDIVDUL_9 SearchIndividual[9]BooleanCB0
73INDIVDUL_10 SearchIndividual[10]BooleanCB0
74INDIVDUL_11 SearchIndividual[11]BooleanCB0
75INDIVDUL_12 SearchIndividual[12]BooleanCB0
76INDIVDUL_13 SearchIndividual[13]BooleanCB0
77INDIVDUL_14 SearchIndividual[14]BooleanCB0
78INDIVDUL_15 SearchIndividual[15]BooleanCB0
79INDIVDUL_16 SearchIndividual[16]BooleanCB0
80INDIVDUL_17 SearchIndividual[17]BooleanCB0
81INDIVDUL_18 SearchIndividual[18]BooleanCB0
82INDIVDUL_19 SearchIndividual[19]BooleanCB0
83INDIVDUL_20 SearchIndividual[20]BooleanCB0
84INDIVDUL_21 SearchIndividual[21]BooleanCB0
85INDIVDUL_22 SearchIndividual[22]BooleanCB0
86INDIVDUL_23 SearchIndividual[23]BooleanCB0
87INDIVDUL_24 SearchIndividual[24]BooleanCB0
88INDIVDUL_25 SearchIndividual[25]BooleanCB0
89INDIVDUL_26 SearchIndividual[26]BooleanCB0
90INDIVDUL_27 SearchIndividual[27]BooleanCB0
91INDIVDUL_28 SearchIndividual[28]BooleanCB0
92INDIVDUL_29 SearchIndividual[29]BooleanCB0
93INDIVDUL_30 SearchIndividual[30]BooleanCB0
94INDIVDUL_31 SearchIndividual[31]BooleanCB0
95INDIVDUL_32 SearchIndividual[32]BooleanCB0
96INDIVDUL_33 SearchIndividual[33]BooleanCB0
97INDIVDUL_34 SearchIndividual[34]BooleanCB0
98INDIVDUL_35 SearchIndividual[35]BooleanCB0
99INDIVDUL_36 SearchIndividual[36]BooleanCB0
100INDIVDUL_37 SearchIndividual[37]BooleanCB0
101INDIVDUL_38 SearchIndividual[38]BooleanCB0
102INDIVDUL_39 SearchIndividual[39]BooleanCB0
103INDIVDUL_40 SearchIndividual[40]BooleanCB0
104INDIVDUL_41 SearchIndividual[41]BooleanCB0
105PRNTDSCR SearchPrint DescriptionIntegerGB0
106PRZROBAL SearchPrint Zero BalancesBooleanYN0
107CLCRATIO SearchCalculate RatioIntegerGB0
108INCLGNDS SearchInclude LegendsBooleanCB_Include_Legends0
109GLSTTKDT SearchGL Start Token DateIntegerDDL_GL_Token_Dates0
110GLENTKDT SearchGL End Token DateIntegerDDL_GL_Token_Dates0
111PRUNTACT SearchPrint Unit AccountsBooleanCB_Print_Unit_Accounts0
112STACCNUM_1 SearchStarting Account Number:Account_Segment_Pool1StringAccount_Segment_Pool16
113STACCNUM_2 SearchStarting Account Number:Account_Segment_Pool2StringAccount_Segment_Pool26
114STACCNUM_3 SearchStarting Account Number:Account_Segment_Pool3StringAccount_Segment_Pool36
115STACCNUM_4 SearchStarting Account Number:Account_Segment_Pool4StringAccount_Segment_Pool46
116STACCNUM_5 SearchStarting Account Number:Account_Segment_Pool5StringAccount_Segment_Pool56
117STACCNUM_6 SearchStarting Account Number:Account_Segment_Pool6StringAccount_Segment_Pool66
118STACCNUM_7 SearchStarting Account Number:Account_Segment_Pool7StringAccount_Segment_Pool76
119STACCNUM_8 SearchStarting Account Number:Account_Segment_Pool8StringAccount_Segment_Pool86
120STACCNUM_9 SearchStarting Account Number:Account_Segment_Pool9StringAccount_Segment_Pool96
121STACCNUM_10 SearchStarting Account Number:Account_Segment_Pool10StringAccount_Segment_Pool106
122EDGACNUM_1 SearchEnding Account Number:Account_Segment_Pool1StringAccount_Segment_Pool16
123EDGACNUM_2 SearchEnding Account Number:Account_Segment_Pool2StringAccount_Segment_Pool26
124EDGACNUM_3 SearchEnding Account Number:Account_Segment_Pool3StringAccount_Segment_Pool36
125EDGACNUM_4 SearchEnding Account Number:Account_Segment_Pool4StringAccount_Segment_Pool46
126EDGACNUM_5 SearchEnding Account Number:Account_Segment_Pool5StringAccount_Segment_Pool56
127EDGACNUM_6 SearchEnding Account Number:Account_Segment_Pool6StringAccount_Segment_Pool66
128EDGACNUM_7 SearchEnding Account Number:Account_Segment_Pool7StringAccount_Segment_Pool76
129EDGACNUM_8 SearchEnding Account Number:Account_Segment_Pool8StringAccount_Segment_Pool86
130EDGACNUM_9 SearchEnding Account Number:Account_Segment_Pool9StringAccount_Segment_Pool96
131EDGACNUM_10 SearchEnding Account Number:Account_Segment_Pool10StringAccount_Segment_Pool106
132SEGSRTBY SearchSegment Sort ByIntegerINT11
133RANGEBY SearchRange ByIntegerINT0
134CBZBNA SearchZero Balance And No ActivityBooleanCB_Zero_Accounts0
135Accounts_Included SearchAccounts IncludedIntegerGB0
136Start_Position_String SearchStart Position StringStringSTR8989
137End_Position_String SearchEnd Position StringStringSTR8989
138RPTXRATE SearchReporting Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
139RPRTCLMD SearchReporting Rate Calculation MethodIntegerDDL_Rate_Calculation_Method0
140PRTCURIN SearchPrint Currency InIntegerGB0
141INCMCINF SearchInclude Multicurrency InfoBooleanCB_Include_Multicurrency_Info0
142STCURRID SearchStart Currency IDStringSTR15_Currency_ID15
143ENDCURID SearchEnd Currency IDStringSTR15_Currency_ID15
144UseLedgersForAcctBalance SearchUse Ledgers For Account BalanceLong IntegerML_MultiSelectListBox0
azurecurveProductsMicrosoft Dynamics GP (0)FinancialGeneral Ledger Report Options Temporary (GL70501)

Leave a Reply

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