GL_TransactionJournalWrk GL Transaction Journal Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_TransactionJournal_upd,GL_ReprintJournals_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_TransactionJournalWrk"+%S$+".M4T"
KPRIMARY: SourceJournal+EntryNo+LineSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL
2 EntryNo . . . . . . . . . . . 6 SYY Entry Number. . . . . . . . . .
Mask:000000 FmtType:ZEROFILL
3 LineSeqNo . . . . . . . . . . 14 SYY Line Sequence Number. . . . . .
Mask:00000000000000
FmtType:ZEROFILL
4 BatchFlag . . . . . . . . . . 1 SYY Batch Flag. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
5 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO
FmtType:ALPHANUM
6 JournalType . . . . . . . . . 1 SYY Journal Type. . . . . . . . . .
DfltVal:F Valid:F,N
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 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE
Notes: YYYYMMDD
9 JournalComment. . . . . . . . 2048 SNN Journal Comment . . . . . . . .COMMENT
10 TransferNo. . . . . . . . . . 10 SNN Transfer Number . . . . . . . .
11 TransferBankCode. . . . . . . 1 SYN Transfer Bank Code. . . . . . .BANKCODE
12 DepositNo . . . . . . . . . . 10 SNN Deposit Number. . . . . . . . .
13 DepositComment. . . . . . . . 2048 SNN Deposit Comment . . . . . . . .COMMENT
14 PostBRDepositInSummary. . . . 1 SYN Post Bank Rec. Deposit In SummaYESNO
DfltVal:N Valid:Y,N
15 OffsetAccountKey. . . . . . . 9 SNY Offset Account Number . . . . .
16 OffsetAccount . . . . . . . . 41 SYN Offset Account. . . . . . . . .
17 Offset. . . . . . . . . . . . 1 SYY Offset Orientation. . . . . . .
Valid:D,C Notes: D=Debit,
C=Credit
18 JournalDeleted. . . . . . . . 1 SYY Journal Deleted . . . . . . . .YESNO
DfltVal:N Valid:Y,N
19 BankCode. . . . . . . . . . . 1 SYY Bank Code . . . . . . . . . . .BANKCODE
20 EnterBatchTotForTransJrnlDE . 1 SYN Enter Batch Total for TransactiYESNO
DfltVal:N Valid:Y,N
21 UserUpdatedLogon. . . . . . . 60 SNN User Updated Logon. . . . . . .
22 CheckNo . . . . . . . . . . . 10 SYY Check Number. . . . . . . . . .
23 DocRefer. . . . . . . . . . . 10 SNN Document Reference. . . . . . .
24 Date. . . . . . . . . . . . . 8 SYY Date. . . . . . . . . . . . . .DATE
Notes: YYYYMMDD
25 PostingComment. . . . . . . . 2048 SNN Posting Comment . . . . . . . .COMMENT
26 AccountKey. . . . . . . . . . 9 SYY Account Number. . . . . . . . .ACCOUNT
Notes: Validated against
GL_Account
27 Account . . . . . . . . . . . 41 SYY Fully Formatted Account Number.
28 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . .
29 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-
30 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-
31 JournalTotal. . . . . . . . . 16.2 NNN Journal Total . . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-