GL_SourceJournal GL Source Journal Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_SourceJournal_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_SourceJournal.M4T"
KPRIMARY: SourceJournal
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SNY Source Journal. . . . . . . . .SOURCEJOURNAL
2 SourceJournalDesc . . . . . . 40 SNN Source Journal Description. . .
3 JournalType . . . . . . . . . 1 SYY Journal Type. . . . . . . . . .
DfltVal:F Valid:F,N Notes:
F=Financial, N=Non-financial
4 NextJournalNo . . . . . . . . 6 SNY Next Journal Number . . . . . .
DfltVal:000001 Mask:000000
FmtType:ZEROFILL
5 NextRegisterNo. . . . . . . . 6 SNY Next Register Number. . . . . .
DfltVal:000001 Mask:000000
FmtType:ZEROFILL
6 OffsetAccountKey. . . . . . . 9 SNN Offset G/L Acct Key . . . . . .ACCOUNT
Notes: Validated against
GL_Account
7 Offset. . . . . . . . . . . . 1 SYN Orientation for Offset Account.
DfltVal:D Valid:D,C Notes:
D=Debit, C=Credit
8 EnterBatchTotForTransJrnlDE . 1 SYN Enter Batch Tot For Trans Jrl DYESNO
DfltVal:N Valid:Y,N
9 TransactionType . . . . . . . 1 SYN Transaction Type. . . . . . . .
DfltVal:R Valid:A,B,C,D,R
DepVal:REQUIRED Notes:
A=Adjustment, B=Bank
transfer, C=Check number,
D=Deposit, R=document
Reference
10 AutoIncrementCheck. . . . . . 1 SYN Auto Increment Check Number . .YESNO
DfltVal:N Valid:Y,N
DepVal:REQUIRED
11 PostBRDepositInSummary. . . . 1 SYN Post Bank Rec Deposit In SummarYESNO
DfltVal:N Valid:Y,N
DepVal:REQUIRED
12 BankCode. . . . . . . . . . . 1 SNN Bank Code . . . . . . . . . . .BANKCODE
DepVal:REQUIRED
13 TransferFundsToBankCode . . . 1 SYN Transfer Funds to Bank Code . .
DepVal:REQUIRED