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-