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-