GL_DailyPosting                        GL Daily 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_DailyPosting.M4T"

 KPRIMARY: PostingDate+SourceJournal+RegisterNo+AccountKey+SequenceNo
 KBATCHNO: BatchNo+PostingDate+SourceJournal+RegisterNo+AccountKey+SequenceNo
 KSEQUENCENO: SequenceNo(u)
 KACCOUNTKEY: AccountKey+PostingDate+SourceJournal+RegisterNo+SequenceNo
 KVENDORNO: APDivisionNo+VendorNo+DocumentNo+PostingDate+SourceJournal+RegisterNo+AccountKey+SequenceNo

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  PostingDate . . . . . . . . .     8 SNY  Posting Date. . . . . . . . . .DATE
                                                Notes: YYYYMMDD
   2  SourceJournal . . . . . . . .     2 SNY  Source Journal. . . . . . . . .SOURCEJOURNAL
                                                Notes: Validated against
                                                GL_SourceJournal
   3  RegisterNo. . . . . . . . . .     6 SNY  Register Number . . . . . . . .
                                                Mask:000000 FmtType:ZEROFILL
   4  AccountKey. . . . . . . . . .     9 SNY  Account Number. . . . . . . . .ACCOUNT
                                                Notes: Validated against
                                                GL_Account
   5  SequenceNo. . . . . . . . . .    14 SYY  Sequence Number . . . . . . . .
                                                Mask:00000000000000
                                                FmtType:ZEROFILL
   6  SourceModule. . . . . . . . .     2 SYY  Source Module . . . . . . . . .
                                                Notes: GL, AP, AR...
   7  PostingComment. . . . . . . .  2048 SNY  Posting Comment . . . . . . . .COMMENT
   8  DocumentType. . . . . . . . .     1 SYY  Document Type . . . . . . . . .
                                                Valid:I,C,R,S Notes:
                                                I=Invoice, C=Check,
                                                R=Receipt, S=Summary
   9  DocumentNo. . . . . . . . . .    10 SNY  Document Number . . . . . . . .
  10  DocSequenceNo . . . . . . . .    14 SNY  Document Sequence Number. . . .
                                                Mask:00000000000000
                                                FmtType:ZEROFILL
  11  ReceiptNo . . . . . . . . . .     7 SNY  Receipt Number. . . . . . . . .
  12  BatchType . . . . . . . . . .     2 SYY  Batch Type. . . . . . . . . . .
  13  BatchNo . . . . . . . . . . .     5 SYY  Batch Number. . . . . . . . . .BATCHNO
                                                FmtType:ALPHANUM
  14  LineSeqNo . . . . . . . . . .    14 SNY  Data Entry Line Sequence Number
  15  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .APDIVISION
                                                Mask:00
  16  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .VENDORNO
  17  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  18  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                Read Only:Y
  19  UserCreatedKey. . . . . . . .    10 SNY  Creation User ID. . . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL
  20  DebitAmount . . . . . . . . . 16.2  NNY  Debit Amount. . . . . . . . . .TRANSACTIONAMT
                                                Mask:###,###,###.00-
  21  CreditAmount. . . . . . . . . 16.2  NNY  Credit Amount . . . . . . . . .TRANSACTIONAMT
                                                Mask:###,###,###.00-