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