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. . . . . . . . .