GL_Options GL Options Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_Options.M4T"
KPRIMARY: ModuleCode
Fld Column Name M/L TUR Description/Notes Class
1 ModuleCode. . . . . . . . . . 3 SYY Module Code . . . . . . . . . .MODULECODE 2 NewSystem . . . . . . . . . . 1 SYY New System. . . . . . . . . . . DfltVal:N Valid:Y,N,S Notes: Y=Yes, N=No, S=Setup in process (reset to Y, if cancelled) 3 AccountFormat . . . . . . . . 31 SYY Acct Number Format. . . . . . . Notes: Default format is: -A03A03A03 1st Char=seg delimiter. Remainder is in 3 Char blocks for each seg. defined in GL_Account_Structu re.M4T 1st Char=(A)lpha or (N)umeric. 2nd & 3rd Chars=Seg Length (01-15). 4 CurrentFiscalYr . . . . . . . 4 SNY Current Fiscal Year . . . . . .YEAR 5 CurrentPeriod . . . . . . . . 2 SNY Current Accounting Period . . .FISCALPERIOD Mask:00 FmtType:ZEROFILL 6 AccountMaskDelim. . . . . . . 1 SNY GL Account Mask Delimiter . . . 7 AccountDescDelim1 . . . . . . 1 SNY First GL Account Description De 8 AccountDescDelim2 . . . . . . 1 SNY Secondary GL Account Desc Delim 9 RetainEarningsAccountKey. . . 9 SNY Retained Earnings Account NumbeACCOUNT Notes: Validated against GL_Account 10 AutoCreateAccounts. . . . . . 1 SYY Auto Create Accounts. . . . . . DfltVal:Y Valid:Y,N,P Notes: Y=Yes, P=Prompt, N=No* 11 AllowOTFMainAccounts. . . . . 1 SYY Allow OTF of Main Account . . . 12 AllowOTFSubAccounts . . . . . 1 SYY Allow OTF of Sub Accounts . . . 13 TrackAdditionsInDetail. . . . 1 SYY Track Additions In Detail . . .YESNO DfltVal:N Valid:Y,N 14 TrackChangesToAcct. . . . . . 1 SYY Track Changes Made To Acct Mstr Valid:Y,N,A,C,D Notes: Y=All, N=None, D=Deletes, A=Additions, C=Changes 15 YearsRetainGLHist . . . . . . 2 SNY Years To Retain GL History. . . Mask:00 FmtType:ZEROFILL 16 ResetJournal. . . . . . . . . 1 SYY Reset Journal Nos At Year End . DfltVal:N Valid:Y,N,P Notes: Y=Year end, N=Never, P=Period end 17 ResetRegister . . . . . . . . 1 SYY Reset Register Nos At Year End. DfltVal:N Valid:Y,N,P Notes: Y=Year end, N=Never, P=Period end 18 TrackDeletedJournals. . . . . 1 SYY Track Deleted Journals. . . . .YESNO DfltVal:Y Valid:Y,N 19 NextAllocNo . . . . . . . . . 7 SYY Next Allocation Number. . . . . FmtType:CHARNUM 20 IntegrateBankRec. . . . . . . 1 SYY Integrate To Bank Rec . . . . .YESNO DfltVal:N Valid:Y,N 21 DefaultBudget . . . . . . . . 10 SYY Default Budget. . . . . . . . . Notes: Validated against GL_Budget 22 CopyActualToBudget. . . . . . 1 SYY Copy Actual To Default Budget aYESNO DfltVal:N Valid:Y,N 23 ChangeBudgetAmt . . . . . . . 1 SYY Changed Budget Amounts. . . . .YESNO DfltVal:N Valid:Y,N 24 ReverseBudVarSignsOnCustomFS. 1 SYY Reverse Bud Var Signs On Custom DfltVal:C Valid:Y,N,D,C Notes: Y=Yes, N=No, D=Debit lines, C=Credit lines 25 ReversePYVarSignsOnFS . . . . 1 SYY Reverse Prior Year Variance Sig DfltVal:D Valid:Y,N,D,C Notes: Y=Yes, N=No, D=Debit lines, C=-Credit Lines 26 UpdateNeeded. . . . . . . . . 1 SYY F/S Update Needed . . . . . . .YESNO DfltVal:N Valid:Y,N 27 PeriodUpdated . . . . . . . . 2 SNN Last FS Period Updated. . . . .FISCALPERIOD Mask:00 FmtType:ZEROFILL 28 CurrentFiscalYrPeriods. . . . 2 SNY Accounting Periods in Current FFISCALPERIOD Mask:00 FmtType:ZEROFILL 29 CurrentCalendarYr . . . . . . 4 SNY Current Calendar Year . . . . .YEAR Mask:0000 FmtType:ZEROFILL 30 CurrFiscalYearUpdatedToFS . . 4 SNN Curr Fisc Yr Updated To Fin StmYEAR Mask:0000 FmtType:ZEROFILL 31 TranJrnlPostOption. . . . . . 1 SYY Tran Jrnl Post Option Summ/Deta 32 RollupType1 . . . . . . . . . 20 SNN Rollup Type 1 . . . . . . . . . DepVal:REQUIRED 33 RollupType2 . . . . . . . . . 20 SNN Rollup Type 2 . . . . . . . . . DepVal:REQUIRED 34 RollupType3 . . . . . . . . . 20 SNN Rollup Type 3 . . . . . . . . . DepVal:REQUIRED 35 RollupType4 . . . . . . . . . 20 SNN Rollup Type 4 . . . . . . . . . DepVal:REQUIRED 36 CompanyCode . . . . . . . . . 3 SYY Company Code. . . . . . . . . . DfltVal: Notes: Used to "join" Crystal Tables. 37 DataVersion . . . . . . . . . 5.2 NNY Data Version. . . . . . . . . . Mask:#0.00 38 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y 39 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 40 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL