GL_AllocationSelectionHeader GL Allocation Selection Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_AllocationSelectionHeader.M4T"
KPRIMARY: AllocationNo
KSOURCEJOURNAL: SourceJournal+AllocationNo
Fld Column Name M/L TUR Description/Notes Class
1 AllocationNo. . . . . . . . . 7 SYY Allocation Number . . . . . . .ALLOCATIONNO
FmtType:CHARNUM Next:Allocati
onNo$
2 AllocationDesc. . . . . . . . 40 SNN Allocation Description. . . . .
3 SourceAccountKey. . . . . . . 9 SYY Source Account Number . . . . .ACCOUNT
Notes: Validated against
GL_Account
4 AllocationMethod. . . . . . . 1 SYY Allocation Method . . . . . . .
DfltVal:P Valid:P,Q,B Notes:
P=Percentage, Q=Quantity,
B=Basis
5 AllocationBasis . . . . . . . 1 SYN Allocation Basis. . . . . . . .
DfltVal:N Valid:N,C,P,B,E,Y,
D Notes: N=N/A, C=Current
activity, P=Prior year,
B=Beginning balance,
E=Ending balance, Y=prior
Year activity, D=buDget
6 BudgetCode. . . . . . . . . . 10 SYN Budget Code . . . . . . . . . .
Notes: Validated against
GL_Budget
7 AllocationCycle . . . . . . . 1 SYY Allocation Cycle. . . . . . . .
Valid:P,Q,A,M Notes:
P=Period, Q=Quarter,
A=Annual, M=Manual
8 AmountToAllocate. . . . . . . 1 SYY Amount to Allocate. . . . . . .
Valid:A,B,M Notes: A=Activity
, B=Balance, M=Manual
9 JournalComment. . . . . . . . 2048 SNN Journal Comment . . . . . . . .COMMENT
10 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL
11 JournalNo . . . . . . . . . . 6 SNY Journal Number. . . . . . . . .
Mask:000000 FmtType:ZEROFILL
12 JournalType . . . . . . . . . 1 SYN Journal Type. . . . . . . . . .
Valid:F,N Notes: F=Financial,
N=Non-Financial
13 AccountLinesExist . . . . . . 1 SYY Account Lines Exist . . . . . .YESNO
DfltVal:N Valid:Y,N
14 LastPostingDate . . . . . . . 8 SNN Last Posting Date . . . . . . .DATE
15 LastAllocationPer . . . . . . 2 SNN Last Allocation Period. . . . .
Mask:00 FmtType:ZEROFILL
16 LastAllocationYear. . . . . . 4 SNN Last Allocation Year. . . . . .YEAR
Mask:0000 FmtType:ZEROFILL
17 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE
Read Only:Y
18 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . .
Read Only:Y
19 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
20 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE
Read Only:Y
21 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . .
Read Only:Y
22 UserUpdatedKey. . . . . . . . 10 SYN User. . . . . . . . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
23 SourceAmount. . . . . . . . . 16.2 NNY Source Amount . . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
24 PostingAmount . . . . . . . . 16.2 NNY Posting Amount. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-