     GL_DetailPosting                       GL Detail Posting              Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: GL_GeneralJournal_upd,GL_RecurringJournal_upd,GL_AllocationJournal_upd,GL_TransactionJournal_u
     SQL Def: Y  SysDB: N                                      "MAS_"+%C$+"/GL"+%C$+"/GL_DetailPosting.M4T"

     KPRIMARY: AccountKey+PostingDate+SourceJournal+JournalRegisterNo+SequenceNo
     KSOURCEJOURNAL: SourceJournal+JournalRegisterNo+PostingDate+SequenceNo
     KSEQNO: SequenceNo(u)
     KPOSTINGDATE: PostingDate(d)+AccountKey+SourceJournal+JournalRegisterNo+SequenceNo
     KSOURCEMODULE: SourceModule+AccountKey+PostingDate+SourceJournal+JournalRegisterNo(**)+SequenceNo  **=C
                    ase Sensitive

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  AccountKey. . . . . . . . . .     9 SNY  Account Number. . . . . . . . .ACCOUNT
                                                    Notes: Validated against
                                                    GL_Account
       2  PostingDate . . . . . . . . .     8 SNY  Posting Date. . . . . . . . . .DATE
                                                    Notes: YYYYMMDD
       3  SourceJournal . . . . . . . .     2 SNY  Source Journal. . . . . . . . .SOURCEJOURNAL
                                                    Notes: Validated against
                                                    GL_SourceJournal
       4  JournalRegisterNo . . . . . .     6 SNY  Journal/Register Number . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: This can also be a
                                                    Journal Number from GL Data
                                                    Entry tables.
       5  SequenceNo. . . . . . . . . .    14 SNY  Sequence Number . . . . . . . .
                                                    Mask:00000000000000
                                                    FmtType:ZEROFILL
       6  SourceModule. . . . . . . . .     2 SYY  Source Module . . . . . . . . .
                                                    Notes: GL, AP, AR...
       7  DocumentType. . . . . . . . .     1 SNY  Document Type . . . . . . . . .
                                                    Valid:I,C,R,S Notes:
                                                    I=Invoice, C=Check,
                                                    R=Receipt, S=Summary
       8  DocumentNo. . . . . . . . . .    15 SNY  Document Number . . . . . . . .
       9  DocSequenceNo . . . . . . . .    14 SNY  Document Sequence Number. . . .
                                                    Mask:00000000000000
                                                    FmtType:ZEROFILL
      10  ReceiptNo . . . . . . . . . .     7 SNY  Receipt Number. . . . . . . . .
      11  BatchType . . . . . . . . . .     2 SYY  Batch Type. . . . . . . . . . .
      12  BatchNo . . . . . . . . . . .     5 SYY  Batch Number. . . . . . . . . .BATCHNO
                                                    FmtType:ALPHANUM
      13  PostingComment. . . . . . . .  2048 SNY  Posting Detail Comment. . . . .COMMENT
      14  HeaderRec . . . . . . . . . .     1 SYN  Header Record . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      15  LineBankCode. . . . . . . . .     1 SNN  Line Bank Code. . . . . . . . .BANKCODE
      16  LineDocRefer. . . . . . . . .    10 SNN  Line Document Reference . . . .
      17  LineDate. . . . . . . . . . .     8 SNN  Line Date . . . . . . . . . . .DATE
      18  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      19  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      20  UserCreatedKey. . . . . . . .    10 SNY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL
      21  DebitAmount . . . . . . . . . 16.2  NNY  Debit Amount. . . . . . . . . .TRANSACTIONAMT
                                                    Mask:###,###,###.00-
      22  CreditAmount. . . . . . . . . 16.2  NNY  Credit Amount . . . . . . . . .TRANSACTIONAMT
                                                    Mask:###,###,###.00-