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_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 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'].USERID2 IFFILXST If File Existing Integer GB 0 3 FILEXPNM File Export Name String STR255 255 4 EXPTTYPE Export Type Integer INT 0 5 ASKECHTM Ask Each Time Boolean CB_Ask_Each_Time 0 6 PRNTOFIL Print to File Boolean CB_Print_to_File 0 7 PRTOPRTR Print to Printer Boolean CB_Print_to_Printer 0 8 PRTOSCRN Print to Screen Boolean CB_Print_to_Screen 0 9 PRNTTYPE Print Type Integer GB 0 10 RPTGRIND Report Group Index Integer INT 0 11 RTPACHIN Report Palette Choice Index Integer INT 0 12 RTGRSBIN Report Group Sub Index Currency DLR14 14 13 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 14 REPORTID Report ID Integer INT_STORAGE 0 15 FINRPTNM Financial Report Name String STR30 30 16 STTUDEF1 Start User Defined 1 String STR20 20 17 ENUSRDF1 End User Defined 1 String STR20 20 18 STGENINT1 Start Generic Integer1 Integer INT 0 19 ENDGENINT1 End Generic Integer1 Integer INT 0 20 STGENINT2 Start Generic Integer2 Integer INT 0 21 ENDGENINT2 End Generic Integer2 Integer INT 0 22 STRTNGDT Starting Date Date DT 8 23 ENDINGDT Ending Date Date DT 8 24 STTCATEG Start Category Integer INT2_U0 2 25 ENDCATEG End Category Integer INT2_U0 2 26 STTCATNM Start Category Name String STR40_Category 40 27 ENDCATNM End Category Name String STR40_Category 40 28 STRTJRNL Start Journal Long Integer LI8_U0 8 29 ENDJRNAL End Journal Long Integer LI8_U0 8 30 STRXSRC Start TRX Source String STR13 13 31 ENTRXSRC End TRX Source String STR13 13 32 STRTCMTRXNUM Start CM Trx Number String STR20_Document_Number 20 33 ENDCMTRXNUM End CM Trx Number String STR20_Document_Number 20 34 SSRCEDOC Start Source Document String STR10_Source_Document 10 35 ENDSRCDC End Source Document String STR10_Source_Document 10 36 STTACDSC Start Account Description String STR50 50 37 ENDACDSC End Account Description String STR50 50 38 STBDBSID Start Budget Business ID String STR15 15 39 ENBDBSID End Budget Business ID String STR15 15 40 STBDBSDS Start Budget Business Description String STR30 30 41 ENBDBSDS End Budget Business Description String STR30 30 42 STCHBKID Start Checkbook ID String STR15_LBU 15 43 ENCHBKID End Checkbook ID String STR15_LBU 15 44 STRTDSCR Start Description String STR50 50 45 ENDDESCR End Description String STR50 50 46 STTSEGID Start Segment ID String STR10 10 47 ENDSEGID End Segment ID String STR10 10 48 STCTRNUM Start Control Number String STR20 20 49 ENCNTNUM End Control Number String STR20 20 50 STDOCNUM Start Document Number String STR20 20 51 ENDOCNUM End Document Number String STR20 20 52 STMASTID Start Master ID String STR20 20 53 ENMASTID End Master ID String STR20 20 54 STMASTNM Start Master Name String STR30 30 55 ENMASTNM End Master Name String STR30 30 56 SORTBY Sort By Integer DDL_Sort_By 0 57 CBINACTS CB Inactive Accounts Boolean CB_Inactive_Accounts 0 58 PSTNGACT Posting Account Integer INT1 1 59 UNITACCT Unit Account Integer INT1 1 60 RPRTSHOW Reports Show Integer DDL 0 61 PRRPTFOR Print Report For Integer GB 0 62 PRVYRCMB Previous Year CMB String CMB 4 63 RPTDETAL Report Detail Integer Report Detail 0 64 INDIVDUL_1 Individual[1] Boolean CB 0 65 INDIVDUL_2 Individual[2] Boolean CB 0 66 INDIVDUL_3 Individual[3] Boolean CB 0 67 INDIVDUL_4 Individual[4] Boolean CB 0 68 INDIVDUL_5 Individual[5] Boolean CB 0 69 INDIVDUL_6 Individual[6] Boolean CB 0 70 INDIVDUL_7 Individual[7] Boolean CB 0 71 INDIVDUL_8 Individual[8] Boolean CB 0 72 INDIVDUL_9 Individual[9] Boolean CB 0 73 INDIVDUL_10 Individual[10] Boolean CB 0 74 INDIVDUL_11 Individual[11] Boolean CB 0 75 INDIVDUL_12 Individual[12] Boolean CB 0 76 INDIVDUL_13 Individual[13] Boolean CB 0 77 INDIVDUL_14 Individual[14] Boolean CB 0 78 INDIVDUL_15 Individual[15] Boolean CB 0 79 INDIVDUL_16 Individual[16] Boolean CB 0 80 INDIVDUL_17 Individual[17] Boolean CB 0 81 INDIVDUL_18 Individual[18] Boolean CB 0 82 INDIVDUL_19 Individual[19] Boolean CB 0 83 INDIVDUL_20 Individual[20] Boolean CB 0 84 INDIVDUL_21 Individual[21] Boolean CB 0 85 INDIVDUL_22 Individual[22] Boolean CB 0 86 INDIVDUL_23 Individual[23] Boolean CB 0 87 INDIVDUL_24 Individual[24] Boolean CB 0 88 INDIVDUL_25 Individual[25] Boolean CB 0 89 INDIVDUL_26 Individual[26] Boolean CB 0 90 INDIVDUL_27 Individual[27] Boolean CB 0 91 INDIVDUL_28 Individual[28] Boolean CB 0 92 INDIVDUL_29 Individual[29] Boolean CB 0 93 INDIVDUL_30 Individual[30] Boolean CB 0 94 INDIVDUL_31 Individual[31] Boolean CB 0 95 INDIVDUL_32 Individual[32] Boolean CB 0 96 INDIVDUL_33 Individual[33] Boolean CB 0 97 INDIVDUL_34 Individual[34] Boolean CB 0 98 INDIVDUL_35 Individual[35] Boolean CB 0 99 INDIVDUL_36 Individual[36] Boolean CB 0 100 INDIVDUL_37 Individual[37] Boolean CB 0 101 INDIVDUL_38 Individual[38] Boolean CB 0 102 INDIVDUL_39 Individual[39] Boolean CB 0 103 INDIVDUL_40 Individual[40] Boolean CB 0 104 INDIVDUL_41 Individual[41] Boolean CB 0 105 PRNTDSCR Print Description Integer GB 0 106 PRZROBAL Print Zero Balances Boolean YN 0 107 CLCRATIO Calculate Ratio Integer GB 0 108 INCLGNDS Include Legends Boolean CB_Include_Legends 0 109 GLSTTKDT GL Start Token Date Integer DDL_GL_Token_Dates 0 110 GLENTKDT GL End Token Date Integer DDL_GL_Token_Dates 0 111 PRUNTACT Print Unit Accounts Boolean CB_Print_Unit_Accounts 0 112 STACCNUM_1 Starting Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 113 STACCNUM_2 Starting Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 114 STACCNUM_3 Starting Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 115 STACCNUM_4 Starting Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 116 STACCNUM_5 Starting Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 117 STACCNUM_6 Starting Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 118 STACCNUM_7 Starting Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 119 STACCNUM_8 Starting Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 120 STACCNUM_9 Starting Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 121 STACCNUM_10 Starting Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6 122 EDGACNUM_1 Ending Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 123 EDGACNUM_2 Ending Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 124 EDGACNUM_3 Ending Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 125 EDGACNUM_4 Ending Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 126 EDGACNUM_5 Ending Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 127 EDGACNUM_6 Ending Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 128 EDGACNUM_7 Ending Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 129 EDGACNUM_8 Ending Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 130 EDGACNUM_9 Ending Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 131 EDGACNUM_10 Ending Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6 132 SEGSRTBY Segment Sort By Integer INT1 1 133 RANGEBY Range By Integer INT 0 134 CBZBNA Zero Balance And No Activity Boolean CB_Zero_Accounts 0 135 Accounts_Included Accounts Included Integer GB 0 136 Start_Position_String Start Position String String STR89 89 137 End_Position_String End Position String String STR89 89 138 RPTXRATE Reporting Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 139 RPRTCLMD Reporting Rate Calculation Method Integer DDL_Rate_Calculation_Method 0 140 PRTCURIN Print Currency In Integer GB 0 141 INCMCINF Include Multicurrency Info Boolean CB_Include_Multicurrency_Info 0 142 STCURRID Start Currency ID String STR15_Currency_ID 15 143 ENDCURID End Currency ID String STR15_Currency_ID 15 144 UseLedgersForAcctBalance Use Ledgers For Account Balance Long Integer ML_MultiSelectListBox 0