GL_TransactionJournalHeader GL Transaction Journal Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_TransactionJournal_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_TransactionJournalHeader.M4T"
KPRIMARY: SourceJournal+EntryNo
KBATCH: BatchNo+SourceJournal+EntryNo
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL
2 EntryNo . . . . . . . . . . . 6 SYY Entry Number. . . . . . . . . .
FmtType:ZEROFILL Next:SourceJ
ournal$,EntryNo$
3 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE
4 JournalComment. . . . . . . . 2048 SNN Journal Comment . . . . . . . .COMMENT
5 OffsetAccountKey. . . . . . . 9 SYY Offset Account Number . . . . .ACCOUNT
Notes: Validated against
GL_Account
6 Offset. . . . . . . . . . . . 1 SYY Orientation for Offset Account.
Valid:D,C Notes: D=Debit,
C=Credit
7 TransactionType . . . . . . . 1 SYY Transaction Type. . . . . . . .
Valid:A,B,C,D,R Notes:
A=Adjustment, B=Bank
transfer, C=Check number,
D=Deposit, R=document
Reference
8 JournalType . . . . . . . . . 1 SYY Journal Type. . . . . . . . . .
Valid:F,N Notes: F=Financial,
N=Non-financial
9 AcceptOutofBalance. . . . . . 1 SYY Out Of Balance Accepted . . . .YESNO
DfltVal:N Valid:Y,N
10 JournalDeleted. . . . . . . . 1 SYY Journal Deleted . . . . . . . .YESNO
DfltVal:N Valid:Y,N
11 TransferNo. . . . . . . . . . 10 SNN Transfer Number . . . . . . . .
DepVal:REQUIRED
12 DepositNo . . . . . . . . . . 10 SNN Deposit Number. . . . . . . . .
DepVal:REQUIRED
13 DepositComment. . . . . . . . 2048 SNN Deposit Comment . . . . . . . .COMMENT
14 BankCode. . . . . . . . . . . 1 SYN Bank Code . . . . . . . . . . .BANKCODE
DepVal:REQUIRED
15 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO
FmtType:ALPHANUM
16 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE
Read Only:Y
17 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . .
Read Only:Y
18 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
19 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE
Read Only:Y
20 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . .
Read Only:Y
21 UserUpdatedKey. . . . . . . . 10 SYN User Updated Key. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
22 JournalTotal. . . . . . . . . 16.2 NNY Journal Total . . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-