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-