GL_AllocationJournalWrk GL Allocation Journal Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: GL_AllocationJournal_upd,GL_AllocationListing_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_AllocationJournalWrk"+%S$+".M4T"
KPRIMARY: AllocationNo+LineSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 AllocationNo. . . . . . . . . 7 SYY Allocation Number . . . . . . .ALLOCATIONNO FmtType:CHARNUM 2 LineSeqNo . . . . . . . . . . 14 SNN LineSeqNo . . . . . . . . . . . Mask:00000000000000 3 SourceAccount . . . . . . . . 41 SYN Source Account Fully Formatted. 4 SourceAccountDesc . . . . . . 50 SNN Source Account Description. . . 5 AllocationMethod. . . . . . . 1 SYY Allocation Method . . . . . . . DfltVal:P Valid:P,Q,B Notes: P=Percent*, Q=Quantity, B=Basis 6 AllocationCycle . . . . . . . 1 SYY Allocation Cycle. . . . . . . . DfltVal:M Valid:P,Q,A,M Notes: P=Period, Q=Quarter, A=Annual, M=Manual* 7 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 8 AmountToAllocate. . . . . . . 1 SYY Amount To Allocate. . . . . . . DfltVal:A Valid:A,B,M Notes: A=Activity*, B=Balance, M=Manual 9 JournalNo . . . . . . . . . . 6 SYY Journal Number. . . . . . . . . Mask:000000 FmtType:ZEROFILL Notes: Assigned during Journal Entry 10 JournalType . . . . . . . . . 1 SYY Journal Type. . . . . . . . . . Notes: F=Financial, N=Non-Financial 11 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL Notes: Validated against GL_SourceJournal 12 SourceJournalDesc . . . . . . 40 SNN Source Journal Description. . . 13 JournalComment. . . . . . . . 2048 SNN Journal Comment . . . . . . . .COMMENT 14 LastPostingDate . . . . . . . 8 SNN Last Posting Date . . . . . . .DATE 15 BudgetCode. . . . . . . . . . 10 SYN Budget Code . . . . . . . . . . Notes: Validated against GL_Budget 16 BudgetDesc. . . . . . . . . . 40 SNN Budget Description. . . . . . . 17 Account . . . . . . . . . . . 41 SYN Account Fully Formatted . . . . 18 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 19 LinkedValue . . . . . . . . . 1 SYY Linked Value. . . . . . . . . .YESNO DfltVal:N Valid:Y,N 20 LinkedAccount . . . . . . . . 41 SYN Linked Account Fully Formatted. 21 PostingComment. . . . . . . . 2048 SNN Posting Comment . . . . . . . .COMMENT 22 UserUpdatedLogon. . . . . . . 60 SNN User Updated Logon. . . . . . . 23 SourceAmount. . . . . . . . . 16.2 NNN Source Amount . . . . . . . . .BALANCEAMT Mask:#,###,###,###.00- 24 Quantity. . . . . . . . . . . 13.2 NNN Quantity. . . . . . . . . . . . Mask:###,###,###.00- 25 AllocationPercent . . . . . . 10.4 NNN Allocation Percent. . . . . . . Mask:-###.0000% 26 PostingAmount . . . . . . . . 16.2 NNY Posting Amount. . . . . . . . .BALANCEAMT Mask:#,###,###,###.00- 27 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00- 28 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00-