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