GL_OptionsListingWrk GL Options Listing Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_Options_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_OptionsListingWrk"+%S$+".M4T"
KPRIMARY: ModuleCode+BudgetCode
Fld Column Name M/L TUR Description/Notes Class
1 ModuleCode. . . . . . . . . . 3 SYY Module Code . . . . . . . . . .MODULECODE
2 BudgetCode. . . . . . . . . . 10 SNN Budget Code . . . . . . . . . .BUDGETCODE
3 BudgetDesc. . . . . . . . . . 40 SNN Budget Description. . . . . . .
4 DefaultBudgetCode . . . . . . 10 SNN Default Budget Code . . . . . .BUDGETCODE
5 CopyActualToBudget. . . . . . 1 SYY Copy Actual To Default Budget aYESNO
DfltVal:N Valid:Y,N
6 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).
7 CurrentFiscalYr . . . . . . . 4 SNY Current Fiscal Year . . . . . .YEAR
8 CurrentPeriod . . . . . . . . 2 SNY Current Accounting Period . . .
Mask:00 FmtType:ZEROFILL
9 RetainedEarningsAccountKey. . 9 SNY Retained Earnings Account NumbeACCOUNT
Notes: Validated against
GL_Account
10 RetainedEarningsAccount . . . 41 SNN Retained Earnings Account . . .
11 AutoCreateAccounts. . . . . . 1 SYY Auto Create Accounts. . . . . .
DfltVal:N Valid:Y,N,P Notes:
Y=Yes, P=Prompt, N=No*
12 AllowOTFMainAccounts. . . . . 1 SYY Allow OTF of Main Account . . .
13 AllowOTFSubAccounts . . . . . 1 SYY Allow OTF of Sub Accounts . . .
14 TrackAdditionsInDetail. . . . 1 SYY Track Additions In Detail . . .YESNO
DfltVal:N Valid:Y,N
15 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
16 YearsRetainGLHist . . . . . . 2 SNY Years To Retain GL History. . .
Mask:00 FmtType:ZEROFILL
17 BatchType1. . . . . . . . . . 2 SNN Batch Type 1. . . . . . . . . .
18 BatchDesc1. . . . . . . . . . 40 SNN Batch Description 1 . . . . . .
19 EnableBatchEntry1 . . . . . . 1 SYY Enable Batch Entry 1. . . . . .YESNO
DfltVal:N Valid:Y,N
20 NextBatchNo1. . . . . . . . . 5 SYN Next Batch Number 1 . . . . . .
FmtType:ALPHANUM
21 BatchType2. . . . . . . . . . 2 SNN Batch Type 2. . . . . . . . . .
22 BatchDesc2. . . . . . . . . . 40 SNN Batch Description 2 . . . . . .
23 EnableBatchEntry2 . . . . . . 1 SYY Enable Batch Entry 2. . . . . .YESNO
DfltVal:N Valid:Y,N
24 NextBatchNo2. . . . . . . . . 5 SYN Next Batch Number 2 . . . . . .BATCHNO
FmtType:ALPHANUM
25 ResetJournal. . . . . . . . . 1 SYY Reset Journal Nos At Year End .
DfltVal:N Valid:Y,N,P Notes:
Y=Year end, N=Never,
P=Period end
26 ResetRegister . . . . . . . . 1 SYY Reset Register Nos At Year End.
DfltVal:N Valid:Y,N,P Notes:
Y=Year end, N=Never,
P=Period end
27 TrackDeletedJournals. . . . . 1 SYY Track Deleted Journals. . . . .YESNO
DfltVal:N Valid:Y,N
28 NextAllocNo . . . . . . . . . 7 SYY Next Allocation Number. . . . .
29 IntegrateBankRec. . . . . . . 1 SYY Integrate To Bank Rec . . . . .YESNO
DfltVal:N Valid:Y,N
30 RollupType1 . . . . . . . . . 20 SNN Rollup Type 1 . . . . . . . . .
31 RollupType2 . . . . . . . . . 20 SNN Rollup Type 2 . . . . . . . . .
32 RollupType3 . . . . . . . . . 20 SNN Rollup Type 3 . . . . . . . . .
33 RollupType4 . . . . . . . . . 20 SNN Rollup Type 4 . . . . . . . . .
34 FinancialTermDesc001000 . . . 40 SNN Financial Terminology Descripti
35 FinancialTermDesc002000 . . . 40 SNN Financial Terminology Descripti
36 FinancialTermDesc003000 . . . 40 SNN Financial Terminology Descripti
37 FinancialTermDesc004000 . . . 40 SNN Financial Terminology Descripti
38 FinancialTermDesc005000 . . . 40 SNN Financial Terminology Descripti
39 FinancialTermDesc006000 . . . 40 SNN Financial Terminology Descripti
40 FinancialTermDesc007000 . . . 40 SNN Financial Terminology Descripti
41 FinancialTermDesc008000 . . . 40 SNN Financial Terminology Descripti
42 FinancialTermDesc009000 . . . 40 SNN Financial Terminology Descripti
43 FinancialTermDesc010000 . . . 40 SNN Financial Terminology Descripti
44 FinancialTermDesc011000 . . . 40 SNN Financial Terminology Descripti
45 FinancialTermDesc012000 . . . 40 SNN Financial Terminology Descripti
46 FinancialTermDesc013000 . . . 40 SNN Financial Terminology Descripti