     AR_CashExpectationReportWrk           AR Cash Expectation Report Work Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_CashExpectationReport_rpt
     SQL Def: Y  SysDB: N                    "MAS_"+%C$+"/AR"+%C$+"/AR_CashExpectationReportWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00
       3  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .
       4  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
       5  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
       6  OpenItemCustomer. . . . . . .     1 SNN  Open Item Customer. . . . . . .
       7  ContactName . . . . . . . . .    30 SNN  Contact Name. . . . . . . . . .
       8  TelephoneNo . . . . . . . . .    17 SNN  Telephone No. . . . . . . . . .TELEPHONENO
       9  InvoiceDate . . . . . . . . .     8 SNN  InvoiceDate . . . . . . . . . .DATE
      10  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .INVOICE
      11  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
      12  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
      13  InvoiceDiscountDate . . . . .     8 SNN  Invoice Discount Date . . . . .DATE
      14  CreditLimitExceeded . . . . .     1 SNN  Credit Limit Exceeded . . . . .
      15  CreditHold. . . . . . . . . .     1 SNN  Credit Hold . . . . . . . . . .
      16  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .JOBNO
      17  PaymentAmt1 . . . . . . . . . 14.2  NNN  Payment Amount 1. . . . . . . .
      18  PaymentAmt2 . . . . . . . . . 14.2  NNN  Payment Amount 2. . . . . . . .
      19  PaymentAmt3 . . . . . . . . . 14.2  NNN  Payment Amount 3. . . . . . . .
      20  PaymentAmt4 . . . . . . . . . 14.2  NNN  Payment Amount 4. . . . . . . .
      21  FuturePaymentAmt. . . . . . . 14.2  NNN  Future Payment Amount . . . . .
      22  DiscountAmt . . . . . . . . . 14.2  NNN  Discount Amount . . . . . . . .
      23  Balance . . . . . . . . . . . 14.2  NNN  Balance . . . . . . . . . . . .
      24  RetentionAmt. . . . . . . . . 14.2  NNN  Retention Amount. . . . . . . .
      25  CreditLimit . . . . . . . . . 14.2  NNN  Credit Limit. . . . . . . . . .