GL_RecurringJournalHeader GL Recurring Journal Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_RecurringJournal_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_RecurringJournalHeader.M4T"
KPRIMARY: SourceJournal+Reference
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL
2 Reference . . . . . . . . . . 6 SYY Reference Number. . . . . . . .
FmtType:CHARNUM
3 SelectCycle . . . . . . . . . 2 SYN Select Cycle. . . . . . . . . .
FmtType:CHARNUM
4 SelectStartDate . . . . . . . 8 SNN Select Start Date . . . . . . .DATE
Notes: YYYYMMDD
5 SelectStopDate. . . . . . . . 8 SNN Select Stop Date. . . . . . . .DATE
Notes: YYYYMMDD
6 JournalComment. . . . . . . . 2048 SNN Journal Comment . . . . . . . .COMMENT
7 AcceptOutofBalance. . . . . . 1 SYY Out Of Balance Accepted . . . .YESNO
DfltVal:N Valid:Y,N
8 JournalDeleted. . . . . . . . 1 SYY Journal Deleted . . . . . . . .YESNO
DfltVal:N Valid:Y,N
9 JournalNo . . . . . . . . . . 6 SNN Journal Number. . . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: Assign During Journal
10 PeriodUpdated . . . . . . . . 2 SNN Last Period Updated . . . . . .FISCALPERIOD
Mask:00 FmtType:ZEROFILL
11 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
12 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
13 UserCreatedKey. . . . . . . . 10 SNY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
14 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y
15 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
16 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL