     PO_PurchasesClearingWrk               PO Purchases Clearing Work      Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: PO_PurchasesClearingReport_rpt,PO_PurchasesClearingOpenPO_rpt
     SQL Def: Y  SysDB: N                        "MAS_"+%C$+"/PO"+%C$+"/PO_PurchasesClearingWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
       3  PurchaseOrderNo . . . . . . .     7 SNN  Purchase Order Number . . . . .
       4  PurchaseOrderDate . . . . . .     8 SNN  Purchase Order Date . . . . . .DATE
       5  OrderType . . . . . . . . . .     1 SNN  Order Type. . . . . . . . . . .
       6  MasterRepeatingOrderNo. . . .     7 SNN  Master Repeating Order Number .
       7  RequiredExpireDate. . . . . .     8 SNN  Required/Expire Date. . . . . .DATE
       8  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .
       9  APDivisionDesc. . . . . . . .    30 SNN  AP Division Description . . . .
      10  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .
      11  PurchaseName. . . . . . . . .    30 SNN  Purchase Name . . . . . . . . .
      12  ShipToCode. . . . . . . . . .     4 SNN  Ship To Code. . . . . . . . . .
      13  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .
      14  OrderStatus . . . . . . . . .     1 SNN  Order Status. . . . . . . . . .
      15  OnHold. . . . . . . . . . . .     1 SNN  On Hold . . . . . . . . . . . .
      16  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
      17  LastInvoiceDate . . . . . . .     8 SNN  Last Invoice Date . . . . . . .DATE
      18  LastInvoiceNo . . . . . . . .    10 SNN  Last AP Invoice Number. . . . .
      19  LastReceiptDate . . . . . . .     8 SNN  Last Receipt Date . . . . . . .DATE
      20  LastIssueDate . . . . . . . .     8 SNN  Last Issue Date . . . . . . . .DATE
      21  LastPurchaseOrderDate . . . .     8 SNN  Last Purchase Order Date. . . .DATE
      22  LastReceiptNo . . . . . . . .     7 SNN  Last Receipt Number . . . . . .
      23  LastIssueNo . . . . . . . . .     7 SNN  Last Issue Number . . . . . . .
      24  LastPurchaseOrderNo . . . . .     7 SNN  Last Purchase Order Number. . .
      25  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .
      26  InvalidTaxCalc. . . . . . . .     1 SNN  Invalid Tax Calculation . . . .
      27  LineKey . . . . . . . . . . .     6 SNN  Line Key. . . . . . . . . . . .
      28  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
      29  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
      30  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
      31  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
      32  UseTax. . . . . . . . . . . .     1 SNN  Use Tax . . . . . . . . . . . .
      33  RequiredDate. . . . . . . . .     8 SNN  Required Date . . . . . . . . .DATE
      34  PurchasesAcctKey. . . . . . .     9 SNN  Purchases Account Key . . . . .
      35  PurchasesAccount. . . . . . .    41 SNN  Fully Formatted Purchases Accou
      36  UnitOfMeasure . . . . . . . .     4 SNN  Unit Of Measure . . . . . . . .
      37  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .
      38  ProductLine . . . . . . . . .     4 SNN  Product line. . . . . . . . . .
      39  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .
      40  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
      41  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .
      42  CostCodeFormatted . . . . . .    11 SNN  Cost Code Formatted . . . . . .
      43  CostType. . . . . . . . . . .     1 SNN  Cost Type . . . . . . . . . . .
      44  WorkOrderNo . . . . . . . . .     7 SNN  Work Order Number . . . . . . .
      45  StepNo. . . . . . . . . . . .     4 SNN  Step Number . . . . . . . . . .
      46  SubStepPrefix . . . . . . . .     1 SNN  Sub-Step Prefix . . . . . . . .
      47  SubStepSuffix . . . . . . . .     4 SNN  Sub-Step Suffix . . . . . . . .
      48  WorkOrderType . . . . . . . .     1 SNN  Work Order Type . . . . . . . .
      49  VendorAliasItemNo . . . . . .    30 SNN  Vendor Alias Item Number. . . .
      50  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .
      51  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .
      52  PrepaidAmt. . . . . . . . . . 13.2  NNN  Prepaid Amount. . . . . . . . .
      53  TaxableAmt. . . . . . . . . . 13.2  NNN  Taxable Amount. . . . . . . . .
      54  NonTaxableAmt . . . . . . . . 13.2  NNN  Non-Taxable Amount. . . . . . .
      55  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .
      56  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .
      57  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .
      58  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .
      59  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .
      60  MasterOriginalQty . . . . . . 16.6  NNN  Master Original Quantity. . . .
      61  MasterQtyBalance. . . . . . . 16.6  NNN  Master Quantity Balance . . . .
      62  MasterQtyOrderedToDate. . . . 16.6  NNN  Master Quantity Ordered To Date
      63  QuantityInvoiced. . . . . . . 16.6  NNN  Quantity Invoiced . . . . . . .
      64  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .
      65  OriginalUnitCost. . . . . . . 16.6  NNN  Original Unit Cost. . . . . . .
      66  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
      67  InvoicedAmt . . . . . . . . . 12.2  NNN  Invoiced Amount . . . . . . . .
      68  ReceivedAllocatedAmt. . . . . 12.2  NNN  Received Allocated Amount . . .
      69  InvoicedAllocatedAmt. . . . . 12.2  NNN  Invoiced Allocated Amount . . .
      70  UseTaxAmt . . . . . . . . . . 12.2  NNN  Use Tax Amount. . . . . . . . .