GL_SourceJournalHistory GL Source Journal History Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_GeneralJournal_upd,GL_RecurringJournal_upd,GL_AllocationJournal_upd,GL_TransactionJournal_u
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_SourceJournalHistory.M4T"
KPRIMARY: SourceJournal+JournalRegisterNo+PostingDate+SourceModule
KSOURCEJOURNAL: SourceJournal+PostingDate
KPOSTINGDATE: PostingDate(d)+SourceJournal+JournalRegisterNo+SourceModule
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SNY Source Journal. . . . . . . . .SOURCEJOURNAL
Notes: Validated against
GL_SourceJournal
2 JournalRegisterNo . . . . . . 6 SNY Journal/Register Number . . . .
Mask:000000 FmtType:ZEROFILL
3 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE
4 SourceModule. . . . . . . . . 2 SNY Source Module . . . . . . . . .
5 Deleted . . . . . . . . . . . 1 SYY Deleted . . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
6 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y
7 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
8 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
9 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-
10 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-