GL_RecurringJournalWrk GL Recurring Journal Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_RecurringJournal_upd,GL_ReprintJournals_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_RecurringJournalWrk"+%S$+".M4T"
KPRIMARY: SourceJournal+Reference+LineSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .
2 Reference . . . . . . . . . . 6 SYY Reference . . . . . . . . . . .
3 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . .
Mask:00000000000000
FmtType:ZEROFILL
4 SelectCycle . . . . . . . . . 2 SYY Select Cycle. . . . . . . . . .
5 SelectStartDate . . . . . . . 8 SNY Select Start Date . . . . . . .DATE
6 SelectStopDate. . . . . . . . 8 SNY Select Stop Date. . . . . . . .DATE
7 JournalNo . . . . . . . . . . 6 SNY Journal Number. . . . . . . . .
Mask:000000 FmtType:ZEROFILL
8 JournalType . . . . . . . . . 1 SYN Journal Type. . . . . . . . . .
Valid:F,N
9 JournalComment. . . . . . . . 2048 SNN Journal Comment . . . . . . . .COMMENT
10 PostingComment. . . . . . . . 2048 SNN Posting Comment . . . . . . . .COMMENT
11 PostingDate . . . . . . . . . 8 SNN Posting Date. . . . . . . . . .DATE
12 AccountKey. . . . . . . . . . 9 SNY Account Number. . . . . . . . .ACCOUNT
13 Account . . . . . . . . . . . 41 SYY Fully Formatted Account Number.
14 AccountDesc . . . . . . . . . 40 SNN Account Description . . . . . .
15 JournalUpdatedCP. . . . . . . 1 SYY Journal Updated for Current PerYESNO
DfltVal:N Valid:Y,N
16 JournalDeleted. . . . . . . . 1 SYY Journal Deleted . . . . . . . .YESNO
DfltVal:N Valid:Y,N
17 UserUpdatedLogon. . . . . . . 60 SNN User Updated Logon. . . . . . .
18 DebitAmount . . . . . . . . . 16.2 NNN Debit Amount. . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-
19 CreditAmount. . . . . . . . . 16.2 NNN Credit Amount . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-