     AP_ARClearingRegisterWrk              AP AR Clearing Register Work    Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_ARClearingRegister_upd
     SQL Def: Y  SysDB: N                       "MAS_"+%C$+"/AP"+%C$+"/AP_ARClearingRegisterWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  RecordType. . . . . . . . . .     1 SNN  Record Type . . . . . . . . . .
       3  SystemDate. . . . . . . . . .     8 SNN  System Date . . . . . . . . . .DATE
       4  Clear . . . . . . . . . . . .     5 SNN  Clear . . . . . . . . . . . . .
       5  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
       6  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
       7  CheckNo . . . . . . . . . . .    10 SNN  Check Number. . . . . . . . . .
       8  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
       9  OpenItemCustomer. . . . . . .     1 SNN  Open Item Customer. . . . . . .
      10  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
      11  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .
      12  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
      13  InvoiceDiscountDate . . . . .     8 SNN  Invoice Discount Date . . . . .DATE
      14  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
      15  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .
      16  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .
      17  VendorName. . . . . . . . . .    30 SNN  Vendor Name . . . . . . . . . .
      18  DiscountAmt . . . . . . . . . 13.2  NNN  Discount Amount . . . . . . . .
      19  AmountPosted. . . . . . . . . 13.2  NNN  Amount Posted . . . . . . . . .
      20  InvoiceBalance. . . . . . . . 13.2  NNN  Invoice Balance . . . . . . . .
      21  ClearedAmt. . . . . . . . . . 13.2  NNN  Cleared Amount. . . . . . . . .
      22  ARBalance . . . . . . . . . . 13.2  NNN  AR Balance. . . . . . . . . . .
      23  RetentionAppliedAmt . . . . . 13.2  NNN  Retention Applied Amount. . . .