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