GL_AllocationHeader GL Allocation Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_Allocation_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_AllocationHeader.M4T"
KPRIMARY: AllocationNo
KJOURNALTYPE: JournalType+AllocationNo
KSOURCEACCOUNT: SourceAccountKey+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=Percent*, Q=Quantity,
B=Basis
5 AllocationBasis . . . . . . . 1 SYY 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 . . . . . . . . . .BUDGETCODE
Notes: Validated against
GL_Budget
7 AllocationCycle . . . . . . . 1 SYY Allocation Cycle. . . . . . . .
DfltVal:M Valid:P,Q,A,M
Notes: P=Period, Q=Quarter,
A=Annual, M=Manual*
8 AmountToAllocate. . . . . . . 1 SYY Amount To Allocate. . . . . . .
DfltVal:A Valid:A,B,M Notes:
A=Activity*, B=Balance,
M=Manual
9 JournalComment. . . . . . . . 2048 SNN Journal Comment . . . . . . . .COMMENT
10 SourceJournal . . . . . . . . 2 SYN Source Journal. . . . . . . . .SOURCEJOURNAL
Notes: Validated against
GL_SourceJournal
11 JournalNo . . . . . . . . . . 6 SYN Journal Number. . . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: Assigned during
Journal Entry
12 JournalType . . . . . . . . . 1 SYY Journal Type. . . . . . . . . .
Notes: F=Financial,
N=Non-Financial
13 AccountLinesExist . . . . . . 1 SYY Any Account Lines Exist . . . .YESNO
DfltVal:N Valid:Y,N
14 LastPostingDate . . . . . . . 8 SNN Last Posting Date . . . . . . .DATE
Notes: YYYYMMDD
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 Creation Date . . . . . . . . .DATE
Read Only:Y
18 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
19 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
20 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y
21 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
22 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
23 SourceAmount. . . . . . . . . 16.2 NNN Source Amount . . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
24 PostingAmount . . . . . . . . 16.2 NNN Posting Amount. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-