     SO_DailyDepositRecapWrk               SO Daily Deposit Recap Work     Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_SalesJournal_upd
     SQL Def: Y  SysDB: N                        "MAS_"+%C$+"/SO"+%C$+"/SO_DailyDepositRecapWrk"+%S$+".M4T"

     KPRIMARY: ARDivisionNo+PaymentType+InvoiceNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  GroupField. . . . . . . . . .     6 SNN  Group Field . . . . . . . . . .
       2  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00
       3  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .DESCRIPTION
       4  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
       5  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .
       6  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
       7  PaymentType . . . . . . . . .     6 SNN  Payment Type. . . . . . . . . .
       8  PaymentDesc . . . . . . . . .    30 SNN  Payment Description . . . . . .
       9  PaymentMethod . . . . . . . .     1 SNN  Payment Method. . . . . . . . .
      10  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
      11  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .
      12  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .
      13  ExpirationDateMonth . . . . .     2 SNN  Expiration Date Month . . . . .
      14  ExpirationDateYear. . . . . .     2 SNN  Expiration Date Year. . . . . .YEAR2
      15  OtherPaymentTypeRefNo . . . .    24 SNN  Other Payment Type Reference Nu
      16  CheckNoForDeposit . . . . . .    10 SNN  Check Number For Deposit. . . .CHECKNO
      17  AuthorizationCodeForDeposit .    16 SNN  Authorization CodeFor Deposit .
      18  Last4UnencryptedCreditCardNos     4 SNN  Last 4 Unencrypted Credit Card
      19  CreditCardAuthorizationNo . .    16 SNN  Credit Card Authorization Numbe
      20  InvoiceAmt. . . . . . . . . . 13.2  NNN  InvoiceAmount . . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00
      21  DepositApplied. . . . . . . . 13.2  NNN  Deposit Applied . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00
      22  PaymentApplied. . . . . . . . 13.2  NNN  Payment Applied . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00