     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