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-