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