PO_ReceiptInvoiceVarianceWrk          PO Receipt Invoice Variance WorkRel: 4.40  Bld: 398  8/28/2009
 Bus Obj: PO_ReceiptRegister_upd
 SQL Def: Y  SysDB: N                   "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptInvoiceVarianceWrk"+%S$+".M4T"

 KPRIMARY: SortField

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
   2  PurchaseOrderNo . . . . . . .     7 SNN  Purchase Order Number . . . . .
   3  PurchaseOrderDate . . . . . .     8 SNN  Purchase Order Date . . . . . .DATE
   4  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .
   5  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .
   6  VendorName. . . . . . . . . .    30 SNN  Vendor Name . . . . . . . . . .
   7  LastInvoiceDate . . . . . . .     8 SNN  Last Invoice Date . . . . . . .DATE
   8  LastInvoiceNo . . . . . . . .    10 SNN  Last Invoice Number . . . . . .
   9  LineKey . . . . . . . . . . .     6 SNN  Line Key. . . . . . . . . . . .
  10  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
  11  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
  12  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
  13  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
  14  UnitOfMeasure . . . . . . . .     4 SNN  Unit of Measure . . . . . . . .
  15  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .
  16  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
  17  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .
  18  CostCodeFormatted . . . . . .    11 SNN  Cost Code Formatted . . . . . .
  19  CostType. . . . . . . . . . .     1 SNN  Cost Type . . . . . . . . . . .
  20  WorkOrderNo . . . . . . . . .     7 SNN  Work Order Number . . . . . . .
  21  StepNo. . . . . . . . . . . .     4 SNN  Step Number . . . . . . . . . .
  22  SubStepPrefix . . . . . . . .     1 SNN  Sub Step-Prefix . . . . . . . .
  23  SubStepSuffix . . . . . . . .     4 SNN  Sub Step-Suffix . . . . . . . .
  24  WorkOrderType . . . . . . . .     1 SNN  Work Order Type . . . . . . . .
  25  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .
  26  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .
  27  QuantityInvoiced. . . . . . . 16.6  NNN  Quantity Invoiced . . . . . . .
  28  ReceivedAmt . . . . . . . . . 12.2  NNN  Received Amount . . . . . . . .
  29  InvoicedAmt . . . . . . . . . 12.2  NNN  Invoice Amount. . . . . . . . .
  30  ReceivedAllocatedAmt. . . . . 12.2  NNN  Received Allocated Amount . . .
  31  InvoicedAllocatedAmt. . . . . 12.2  NNN  Invoiced Allocated Amount . . .